SQL Server Virtualization

This past summer I have been working on a new course for Learning Tree 2109 SQL Server Virtualization and Consolidation:...

SQL Server: Understanding GAM and SGAM Pages

We know that SQL server stores the data in 8 KB pages. An extent is made up of 8 physically contiguous...

Why do you attend sessions?

Many of you have attended sessions by technical speakers at conferences and mini-conferences like SQL Saturday, SQL Rally, 24 Hours...

Find Skew in Distributed Tables

The SQL Server PDW (Parallel Data Warehouse) is a beast of a machine. Spreading workload across multiple nodes inside the...

Going to San Diego (#SQLSat157)

It appears that I signed up to speak at the San Diego SQL Saturday coming up this weekend.  I knew...

Quick tip: Querying database metadata with DBCC DBINFO

Page 9 in file 1 (of the primary filegroup) in a SQL Server database is the header page and contains...

Talking Career and Unstructured Data

The Denver SQL Saturday is coming in less than two weeks, SQL Saturday #169 is our second event in Denver,...

T-SQL Tuesday – Help! I Need Somebody

By Jennifer Salvo
Today is T-SQL Tuesday #34 hosted by Rob Volk (B, T). This month’s topic is ‘Help! I Need...

T-SQL Tuesday #34 – Help! I Need Somebody

I couldn’t resist, so here goes….
Help, I need some data,
Help, not just any data,
Help, I was told you...

Colorado SQL - September 2012

COLORADO SPRINGS SQL
September 19, 2012 at 5:30 p.m.

Meeting Location:  Hyatt Place - Garden of the Gods, 503 West Garden of the Gods...