Jun 20 2011
For the first time in the 10 years I’ve been associated with The Professional Association for SQL Server (PASS) I’ll be presenting a regular session at the annual Summit. Sure, in the past I’ve presented on a panel discussion for Quest Software and make a fool out of myself for the sake of fun and games [...]
Jan 11 2011
While examining things you can do with the sys.dm_os_info Dynamic Management View I ran across an interesting outcome concerning SQL Server start time. Theorhetically, you can determine the last start time for your SQL Server services via any of the three methods: Create Date of tempdb (because tempdb is recreated each time the SQL services [...]
Dec 21 2010
In my preparations for all my presentations for 2011 regarding Dynamic Management Views and Functions as well as my consolidation efforts of instances at work, I found myself mulling over the easiest way to capture some of the metrics I would be using for determining current load on my SQL Server instances and capacity planning [...]
Apr 26 2009
What are the top 5 indexing best practices? That’s pretty subjective, but here you go. I’m sure the list would be different tomorrow or even five minutes from now.
