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 [...]
Apr 12 2012
I’m not sure what to make of the new SQL Server 2012 “Metro” GUI Plug-In for Microsoft SQL Server 2012. What do you think?
Mar 30 2012
Until yesterday I never heard of World Backup Day. I checked Target and I couldn’t find a single greeting card either. I was wondering if I was being Punk’d by Brent Ozar in his post that tomorrow (March 31, 2012) has that distinction. Then I figured what the heck, I’ve some scripts I use frequently [...]
Mar 21 2012
Tracing without SQL Profiler As a SQL Server DBA you’ll eventually find yourself trying to troubleshoot a performance issue that leads to you needing to capture the activity occurring on the SQL server itself. For many of us that means launching SQL Profiler and creating a trace to run against the server. When dealing with [...]
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 [...]
