Mar 6 2009
A Line in the Sand
What are your practices when it comes to dealing with commercially developed database performance issues in your environment?
Feb 26 2009
I Was In The Pool! Dealing With SQL Shrinkage.
Sure, we tell you not to do stupid things to your SQL instances: never turn on auto shrink, never turn on auto close, never NOT back up your databases, never use sa for anything – ever. Those things we still stand by. However, there are times you may need to shrink a database or not backup a database: the important thing is to know when it’s appropriate to do inappropriate things in SQL Server.
Feb 23 2009
My First Computer (Or Another Reason Why I Did Not Have A Girlfriend Until I Was 16.)
I was recently tagged to blog about my first computer. Which one?
Feb 20 2009
Index-Index-Index-Index-GOOSE! (Part One)
Overview of the statistical indexing DMVs and DMFs for SQL Server. sys.dm_db_index_operational_stats, sys.dm_db_index_usage_stats, and sys.dm_db_index_phyisical_stats.
Feb 17 2009
DMV Wish List
Just today, Tony Davis editorialized at Simple-Talk.com on the topic of SQL Server Dynamic Management Views (and Functions) and the complexity that lies within. His opinion, and those of many of others that commented to date are that the DMVs/DMFs, while valuable, are overly-complex, incomplete, and inconsistent in their current state. I for one, am one of [...]
Feb 8 2009
“You Got me WHAT?” a Valentine’s Day Love Story for the Ages
Valentine’s Day. Time to take down the Christmas tree and follow the Fail Trail to some lousy gift for the one you love. May I suggest NOT buying that special someone home mechanical equipment unless that someone is a man. We love that sh**.
Feb 6 2009
Database Administration with a Side of Irony
Isn’t it ironic that you encounter database errors on a site devoted to answering database questions?
Feb 3 2009
Micro-Managed by a Herd of 9-Year-Olds. New and Improved Bacon Flavor!
Want to be micro-managed on a level like no other? Then use your DBA skills at a Cub Scout event.
