SQL Server 2012 Diagnostic Information Queries (October 2012)

Here is the October 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...

Virtualizing Your Business Critical SQL Servers – Free Boot Camp by House of Brick

Just before PASS Summit in November, House of Brick and I will be holding a free boot camp on Virtualizing...

Small Changes Can Make A World Of Difference

SQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended Events enhancements,...

VMware vCenter 5.1 ADSI quirk

I sat down this afternoon after being out of town for week to work on a few things in my...

Basics of Indexes in SQL Server

Querying Microsoft SQL Server : Basics of Indexes in SQL Server: Indexes in SQL Server: If you see a book, in...

Basics of Triggers in SQL Server

Querying Microsoft SQL Server : Basics of Triggers in SQL Server: SQL Triggers:  A trigger is a procedural code like stored...

Parallel Execution in SSIS 2008 and later version

SQL Server Integration Services (SSIS) execution is sequential by default. SQL Server Integration Services (SSIS) does allow parallel execution. Now question is how we can configure SSIS to run...

Parallel Execution in SSIS 2008 and later version

SQL Server Integration Services (SSIS) execution is sequential by default. SQL Server Integration Services (SSIS) does allow parallel execution. Now...

Check List for SQL Server Connectivity Issue !

SQL Server connectivity is the most common issue & below mention errors is also common at time of connectivity issue.
Error :
A...

I voted in the PASS Election - you should too!

If you are a member of PASS you have probably already received an email that looks like this:

--

From: <hq@sqlpass.org>
Date: Fri,...