Category Archives: SQL Server Administration

My First Look at SQL Monitor

Posted on 2017/12/19 by Kathi Kellenberger

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 | 2 Comments

Memory is the Air that SQL Server Breathes

Posted on 2016/05/24 by Kathi Kellenberger

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?

Posted on 2015/10/22 by Kathi Kellenberger

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