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 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 [...]
Feb 15 2012
Traffic Circles, Honey Badgers, and Handicapped Banthas This morning while dropping my son off at school as I do every day before heading back home to the office I encountered not one, or two, but four different parents who bypassed the traffic circle dedicated to dropping off students and instead utilized handicapped parking spots in [...]
Dec 24 2011
On the Eleventh day of Christmas I Give Some Tips to Thee…11 SQL Never Not Dos! Ten Quick Hit Thumbscripts A Nine Hour Work Day I FORGOT WHAT EIGHT WAS FOR… Seven Reports to Start My Day Six Gb of RAM Five Volumes Minimum… Four Words to Live By… Three Training Events… Two Twitter Handles… [...]
Jun 18 2010
Last week while I at TechEd I had a conversation with one of my Application Analysts back in the shop about a problem database from an ISV that we have been dealing with for over a month. A patch had been put in place and I was reviewing the results of some queries against the sys.dm_os_wait_stats [...]
