PASS DBA Virtual Chapter Trimming Indexes, Getting Your Database in Shape

Hello Dear Reader!  Tomorrow at 12 noon eastern I’ll be presenting for the PASS DBA Virtual chapter, click here to...

DBA Study Guide

http://www.flickr.com/photos/caledonia09/4999119065/
 Hello Dear Reader, over here at Pragmatic Works we’ve been growing like weeds.  For the most part we are looking...

SQL Saturday 151 Interview: Stacia Misner

Hello Dear Reader SQL Saturday 151 is just around the corner.  If you haven't registerd there is still time to...

Please VOTE for Me: PASS Summit 2012 Lightening Talks

http://www.flickr.com/photos/cyndydoty/2087680308/Hello Dear Reader the PASS Summit is approaching and with that the program committee sent out a request for Lightening...

SQL Saturday 151 BI Pre-con: Stacia Misner

Hello Dear Reader, SQL Saturday 151 Orlando is picking up steam.  The Pre-Con’s have been named and they are fantastic. ...

Database Certificates and the X.509 Standard

 Hello Dear Reader, I came across an interesting discovery about a year ago and realized I’d never written about it. ...

Database Corruption, Transparent Data Encryption, and Trace Flag 5004

This one comes straight from the email bag.  A friend recently had a problem, they were placing TDE on a...

How to Data Compress Varchar(MAX)

I talk a lot about compression.  I’ve blogged a pretty decent amount on it as well.  One of the things...

Book Review: On Writing A Memoir of the Craft by Stephen King

I just finished this book.  Literally.  Sitting on an airplane in route from Orlando to Charlotte NC.  I got up...

How to Find Bad Page Splits

http://www.flickr.com/photos/brickapolis/5474835288/

I was working with a friend last week, doing SQL related teaching and tune ups.  Earlier this week I had...