This Can Be the Best Thing in SQL Server 2014

New versions have bombastic and catchy features. But a lot of times, the little, hidden features are the ones that...

Natural Born Killers (The series) – Day 7 Table Variables vs Temp Tables

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...

Non-Clustered Indexes on Table Variables in SQL Server 2014

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Earlier today I...

SQL Server 2014 CTP1 Now Available!

Sweet! SQL Server 2014 CTP1 is now available for download at Microsoft.com! Get it while it is hot, and start...

Terminate a SSIS package after specific time interval.

Terminate a SSIS package after specific time interval.
 
There are several ways you can execute scheduled SSIS package/job they are: 

A)     SQL...

Installing SQL Server 2014 CTP1 – Step by Step

Great news !!! SQL Server 2014 CTP1 is out and the wait is over. Drop everything(Except the databases !) and download your...

VMware vSphere Storage Performance - Thick vs Thin Provisioning

Industry experts will tell you that virtualization of your environment is not done to improve performance, it's done to make...

SQL Server: Part1 : All About SQL Server Statistics :Density Vector

In our daily life, we use the statistics to take the decision. In the same way SQL server optimizer  use...

My Thoughts about SQL Server 2014

SQL Server 2014 is coming. Go ahead and download the public CTP.
I’ve just started getting my hands dirty with the...

SQL Server 2012 AlwaysOn Availability Groups setup scripts - Part 3

4. Setup 2 nodes alwayson availability group 
    a) Enable alwayson on both 2 nodes
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-01\DEFAULT"
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-02\DEFAULT"

    b) Restore...