Category Archives: SQL Server Administration

My First Look at SQL Monitor

I’ve used other tools for monitoring SQL Server, but this was my first look at SQL Monitor made by Redgate Software. The first step was just to download the software and install it. It comes as part of the Redgate … Continue reading

Posted in Database Administration, SQL Server Administration | Leave a comment

Memory is the Air that SQL Server Breathes

Many, many companies that are using SQL Server don’t have anyone on staff who really understands SQL Server. They often think of SQL Server as just the place where the data is stored and don’t understand how it should be … Continue reading

Posted in Database Administration, SQL Server Administration | 3 Comments

What’s the difference between reorganizing and rebuilding an index?

I was teaching a group of women in St. Louis about database maintenance. When I began talking about index maintenance, I used an interesting analogy to explain the difference between reorganizing and rebuilding of an index. The technical answer is that … Continue reading

Posted in SQL Server Administration | Leave a comment