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

Demystifying SQL Server Differential Database Backups

Odd Man Out
SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood.
Let’s...

EXECUTE AS USER = ‘Somebody else’

As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table,...