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

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

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

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

Standardize Table Aliases

What’s wrong with the following code?
SELECT
a.[BusinessEntityID]
, b.[FirstName]
, b.[LastName]
FROM [HumanResources].[Employee] a
INNER JOIN [Person].[Person] b
ON b.[BusinessEntityID] = a.[BusinessEntityID]Nothing – except for my...

Standardize Table Aliases

What's wrong with the following code?
tsqlLine number Off | Hide | Select allSELECT    a.[BusinessEntityID]    , b.[FirstName]    , b.[LastName]FROM[HumanResources].[Employee] a    INNER JOIN [Person].[Person] b    ON...

The end of the Internet, data and the PC

The Big Data revolution will be more important than the PC or the Internet. While there were many...

The end of the Internet, data and the PC

The Big Data revolution will be more important than the PC or the Internet. While there were many interesting conversations last week at Strata, two new publications captured my...

Come Learn at SQL Intersection, Get a Surface Tablet

This spring I’m speaking at the SQL Intersection conference. It’s a new conference, managed by SQLskills founders Kimberly Tripp and...