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 [...]
Aug 17 2010
Today marks the start of my second week on the job with a new company in almost 11 years. I severely underestimated what that means: new connection methods, new software, new communication tools, new naming conventions, processes, and workplace methodologies. Heck, I have yet to even get exposed to new personnel/HR policies – I was [...]
Jul 12 2010
The service accounts for SQL Server have undergone expansion in the past few releases of Microsoft SQL Server. Back in the days of SQL Server 2000 and earlier you only had to deal with configuring a service account for the SQL and the SQL Agent services. Now you have to contend with those in addition [...]
Jun 20 2010
OK, Hive Mind I have an assignment for you. As I plod through the edit phase of my Performance Tuning with SQL Server DMVs book I’ve been asked by my Overlord PITA Task Master Editor to explain what I mean by Transaction when used in discussing the sys.dm_tran_ … Dynamic Management Objects. Of course we’ve [...]
May 25 2010
Thank you Portland, Oregon and all those associated with puting together and participating in SQL Saturday #27 on 5/22/2010. I would personally like to thank the anonymous, but freakishly tall gentleman who attended my last session of the day and was somehow able to reach the projector on the ceiling in order to restart it after [...]
