Many people use sp_cycle_errorlog to rollover to a new SQL error log periodically. Please make sure this is necessary and/or that you are not doing it too frequently. The more often you roll over the log the greater the chance you will not have troubleshooting...

Thanks to everyone who attended my session today! I think the 740 or so of you overloaded the audio. :-) Sorry everything wasn't clear on the voice delivery, hopefully the slides (below) provide enough information for you to know what to download. Then...

I have put together some general guidelines for how you want a server to be delivered to the DBA team for a new SQL Server install. You won't necessarily use all of them, but consider it a starting point for your SQL Server install standards. Places where...

Power Saving Options on SQL Server Windows 2008 and Windows 2008 R2 have settings for “Power Options”. Windows 2008 R2 has additional power improvements related to “core parking” (temporarily suspending certain cores) and...

My database is 10GB, how big should my log be? .... I don't know. J That's not enough information to decide. You might find the best answer for your particular system is 10MB or 10GB or 100GB. It really depends on the amount of activity in the database...

I occasionally hear the question of whether you can create a one node SQL Server cluster. That basically means you have a virtualized instance of SQL Server with a virtual IP and virtual name that are differerent from the host box, but that there is only...