SQL Joins and Subqueries

A discussion about SQL joins and subqueries with information about how to format join statements properly.
In any non-trivial task, developers...

Find your Enabled SQL Server Network Protocols Using PowerShell

Another quick check I like to do when in 'discovery mode' on a client system is to see what network...

Forum Fun: Running Calculation SQL

A discussion about a forum post for handling a running subtraction in a SQL query.
For my first forum fun post,...

SQL Rally 2011 Recap

As I write this, I’m somewhere in the air over Florida, headed back home to Dallas from participating in the...

Busy is as Busy Does

I am, as they say, one busy little bee.
I just got back from SQLRally last week (here are my SQLRally...

Managing Data Change

Often DBAs receive requests to manually manipulate production data. Ideally, all data changes should be performed through the appropriate application...

MCITP 1 Down 3 To Go

Yesterday I posted a quick blurb about my certification plans this year.  Well, ok not full blown plans , but you get the gist.  I announced that I would...

MCITP 1 Down 3 To Go

Yesterday I posted a quick blurb about my certification plans this year.  Well, ok not full blown plans , but you...

Microsoft SQL Server 2008 R2 SP1

AdvertisementsMicrosoft SQL Server 2008 R2 SP1 CTP

SQL Server 2008 R2 SP1 10.50.2418.0 CTP is available now. You may download and test it.
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=15dcfec2-abb8-409d-91ff-c7c8e18c8409

Presentation Deck For Hardware 201 at Denver SQL Server User’s Group on May 19, 2011

I got the chance to give an updated version of Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance...