Dec 4 2012
You’re Doing It Wrong: The sa Password
Let’s just say you should put some thought into it…
Best Practices
Jul 12 2012
Scripts are Like a Loaded Gun
Everything Looks Like a Target When You Have a Gun Congratulations! Through ingenuity or skill with using your programming language of choice or your favorite search engine you are now in possession of a script that you can use to make all your performance tuning problems vanish in an instant. Be sure to kick it [...]
Jun 15 2012
Steal This Letter
Sometimes the Pen is Mightier than the Query It’s review time here at Day Job Central and it’s a reminder that I’m in a position where I find more and more of my time being spent inside of Outlook, Excel, and Microsoft Word more than I do with SQL Server Management Studio. Just today I [...]
Mar 21 2012
Server-Side Traces in SQL Server: No Voodoo Required
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
Top 13 SQL Server Mistakes and Missteps – #10 Default Database File Autogrowth Settings
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
Top 13 Mistakes And Missteps In SQL Server – #6 File Placement
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
Top 13 Mistakes And Missteps In SQL Server – #7 db_owner: There is More to it than What You Think
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
Top 13 SQL Server Mistakes and Missteps – #8 – Failing to Configure for 64-Bit Systems Properly.
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 [...]
1 2
