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...

SQL Server 2012 AlwaysOn Availability Groups setup scripts - Part 2

3. Install SQL Instance
   a) Configure the firewall setting on both 2 nodes.
echo Default Instance
netsh advfirewall firewall add rule name="SQLServer"...

Exploring Excel 2013 for BI Tip #9: Adding Calculated Members

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

Share t-sql snippets to the team with SQL Prompt

Red-Gate SQL Prompt is a plugin for SQL Server Management Studio that makes the developers life easier when writing t-sql....