Steps to Preload Data into Tables with SSDT

I am working as the data architect and developer on a modern app build with a the team from Modern...

That’s Actually A Duplicate Index

As I’ve worked with clients on performance tuning through index improvements, one of the common areas that I discuss with...

The End of SQLRally in the US

I saw it in the Connector, but just had time to read the minutes to see what was behind the...

Upgrading to SQL Server 2012?

Do you have any plans in place to upgrade to SQL Sever 2012 this year. We are now well into...

Visual Studio 2012 now supports BI!

My most popular blog has been Visual Studio 2012 does not support BI.  In short, this means VS 2012 does...

Building My Next Workstation–Part 3

With a case ordered and a CPU in mind I decided to focus on the power supply next. Remember that...

Career Growth and How You Can Achieve Explosive Results

Continued investment in your professional development for career growth is hard. It’s also essential to being a successful Data Professional.
You’ve...

Dealing with a Fragmented Heap

Just for the record, this happens to be one of my favorite interview questions to ask candidates.

At some point in...

DMV-1 : Who All Are connected ? …. sys.dm_exec_connections

The sys.dm_exec_connections DMV (Dynamic Management View) is represented by Books Online (BOL) as follows : http://msdn.microsoft.com/en-us/library/ms181509.aspx
Returns information about the connections established...

DROP and CREATE vs ALTER

When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic...