Mar 6 2009
What are your practices when it comes to dealing with commercially developed database performance issues in your environment?
Feb 26 2009
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 20 2009
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
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
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 3 2009
Want to be micro-managed on a level like no other? Then use your DBA skills at a Cub Scout event.