Monthly Archives: May 2015

Naming Confusion

When I first worked in a corporation that had many servers, I had to learn the encoding of our systems. We had SUIS01, SUIS02, NAIS01, NAOP01, etc. Each name designated a location and department, but no information as to what … Continue reading

Posted in Editorial | Tagged , | Comments Off on Naming Confusion

Controlling Alerts

None of us likes to be on call for our organizations. Late night phone calls, especially for something silly like adding a new user to a system or rebooting a machine, can make for irritable employees in the morning. Too … Continue reading

Posted in Editorial | Tagged , | Comments Off on Controlling Alerts

Refactoring Mistakes Are Why We Write Tests

I wrote a short piece the other day trying to show how one can use tSQLt to test code. It’s a simple test built against a user defined function. It works well and when the test is run, it passes. … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Refactoring Mistakes Are Why We Write Tests

VMs are not VMs

I was at VMWare recently. One of the main things that all of the SQL Server professionals that were there tried to emphasize is that SQL Server workloads are not like other workloads. The impact on the various host resources, … Continue reading

Posted in Editorial | Tagged | Comments Off on VMs are not VMs