Chapter 7. Increasing availability through testing

 

Allan Hirt

As a DBA, your sphere of influence is often limited to instances of SQL Server and their databases. Influence may or may not extend to the underlying servers hosting those instances and databases because those components are often managed by other groups within your organization. For DBAs, this can be a potential problem. Why? Consider this example: on Friday night, the SAN administrator decides to update the firmware on the storage unit that has all of your mission-critical databases. The SAN administrator doesn’t tell you this is going to happen, because it should be no big deal and happens at a layer that’s not exposed to the databases.

Testing—it’s not just for application functionality

The missing link

Knowledge is power

Test early, test often

Automated versus manual testing

What needs to be tested?

First things first

Remember the big picture, too

Summary

About the author