Tag Archives: administration

Disabling Resource Governor

I had known that the Resource Governor is always running in modern versions of SQL Server. It’s core to the operation of the SQLOS, though it can’t be used to do anything unless it is enabled. You can read more … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Disabling Resource Governor

Development, Operations, or Accounting

I think the idea of a platform of services, such as Windows Azure provides, is a great idea. I’d love to be able to stop worrying about hardware in many cases, and even skip some of the infrastructure of networking … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Development, Operations, or Accounting

The Command Shell

Recently I heard a few people arguing over the use of xp_cmdshell in a particular situation. One person was adamant that there was a security risk in using this feature. Many of you probably feel the same way, and even the SQL … Continue reading

Posted in Editorial | Tagged , , | 2 Comments

Toggle Switches

When SQL Server 7 was released, it was touted as a self-tuning, self optimizing database platform requiring much less attention from a DBA. The product had relatively few tuning options and limited information available about how it processed queries. DBAs … Continue reading

Posted in Editorial | Tagged , | Comments Off on Toggle Switches