Microsoft TechNet has many e-books available to download for free. The topics include ASP.Net, Office, SQL Server, Windows Azure, SharePoint and other technologies. There are several white papers and community& partner content also available for free. See the following linkMore…
Author Archives: admin

Creating Analysis Services Project Using an Existing Analysis Services Database
onCreating Analysis Services Project Using an Existing Analysis Services Database
Last week, I was waiting for somebody to provide me Analysis Services solution files to update some SSAS cubes. I updated those cubes when I got solution files but later I found out a simple way to reverse engineer andMore…

Maximum Degree of Parallelism in T-SQL Queries
onMaximum Degree of Parallelism in T-SQL Queries
Few days ago, we got complaint from a client that one of their SQL query is taking too long to execute. Query was long and complicated with several joins and sub queries. The indexes and joins were already optimized butMore…

Using Joins in Update and Delete statements
onUsing Joins in Update and Delete statements
Sometimes you need to update or delete records based on matching records in another table. You may use sub-query for this but there is a better approach by using Joins in your update and delete statements. Following is an exampleMore…

Best Practices for T-SQL
onBest Practices for T-SQL
As a developer or DBA, we write T-SQL queries all the time. We should always make sure that our queries are optimized for better performance. Query performance is measured by looking at the query execution time. In this blog, IMore…
SQL Saturday # 308 (Houston,TX)
onSQL Saturday # 308 (Houston,TX)
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held May 10, 2014 at San Jacinto College – South Campus 13735 Beamer Rd. – Building 1 More…
Analyst Developer (C2C,W2,1099)
onAnalyst Developer (C2C,W2,1099)
The Analyst Developer will work closely with the business users across all the business domains of FrontOffice, MiddleOffice and BackOffice to develop and support applications and tools within a customer-focused global environment (Trading Environment). A high degree of expertise isMore…
Testing Case Study
onTesting Case Study
Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy Continue reading
This is the white paper haeading
onThis is the white paper haeading
Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy Continue reading