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

Invitation to T-SQL Tuesday #040: File and Filegroup Wisdom

Hello and welcome to the third T-SQL Tuesday of 2013!
Over three years ago, Adam Machanic (Twitter) dreamed up the idea...

Microsoft Data Explorer

Data Explorer (download), which I first mentioned in my blog about PASS Summit 2011 (SQL Server 2012 and other PASS...

On Trends And Proportions

Assuming you’ve been on earth lately, you probably heard the terms “Big Data”, “Hadoop”, “NoSQL” and so on.
Companies want to...

Picking a Conference Venue

I was reading about the American Association of Woodturners annual symposium that will be held in Tampa this year (and...

Remove Local Administrators SSAS Admin Access

Recently while changing some production security around on a new server I needed to modify the SQL Server Analysis Services...

SQL Server 2012 on Microsoft Surface Pro

I received my long-awaited Microsoft Surface Pro 128GB yesterday! The first thing I did was to promptly install SQL Server...