Category Archives: SQL Server Administration

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

The Many Skills Needed to Succeed

Recently, I had a problem to solve for a customer. I was surprised at how many different skills I had to use just to accomplish what seemed to be a simple task. I needed to get a file from one server … Continue reading

Posted in Life in IT, SQL Server Administration | Leave a comment