Apr 19 2012
Tomorrow I’ll be packing up my youngest son, aka #SQLTrevor, and heading to the land of Milk and Honey Beer to present at SQL Saturday 118 being held in Madison. This is my first trip to Madison, but if it’s at all like just a portion of what I’ve heard it described as it sounds [...]
Mar 15 2012
The weather is unseasonably warm here in the Midwest and when that first bit of Spring hits we traditionally open the windows and let the fresh breeze tame the stale winter air that’s been locked in our homes the past 6 months. We try on our swimsuits. We cringe at the amount of muffin-topiness that [...]
Mar 14 2012
Just add another one on there somewhere Bubba… wherever you can find room. Default Behavior By default, new databases are created with the following basic file settings: Data File: 2 MB 1 MB unrestricted growth Log File 1Mb 10% unrestricted growth Just exactly why is this bad? It will assuredly increase the frequency at which files [...]
Feb 28 2012
What Brings a Good Looking DBA Like You to a Place Like This? You’ve most likely found this post because of one of the following reasons: You’ve got this shiny new server and are thinking about installing SQL Server on it. You’ve been following this series from the beginning (thank you by the way) and [...]
Feb 22 2012
The db_owner Database Role Has a Secret The right solution is not frequently the easiest to implement. Avoiding hyperbole as much as possible I’ll simply say that database security is a very fine example of that adage. It is by far easier to … grant all users in a database membership in the db_owner database [...]
Feb 17 2012
A Little Patience It’s been a long time since I rock and rolled since I addressed this series on common mistakes in SQL Server database administration. When it comes to this topic I’m glad I held off because the recommendations have changed from when I was originally working on this series when it comes to [...]
Jan 9 2012
Today marks the first day of a much needed vacation. It comes on the heels of a very successful SQL Saturday I was able to take part in at Colorado Springs, CO. Besides delivering a successful presentation for the locals of Colorado Springs, Denver, and the surrounding area I was able to help out a [...]
Jan 3 2012
This weekend I’ll be bringing my little roadshow to Colorado Springs for the first SQL Saturday of 2012. This will be the swan song for my Periodic Table of Dynamic Management Objects presentation as I revamp it for the changes coming with SQL Server 2012 (formerly code-name Denali). Please join me at 8:30AM Mountain Time [...]
