In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.   Read more...

If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem.   Read more...

In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion.   Read more...

This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5   Read more...

If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem.   Read more...

We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO.   Read more...

In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.   Read more...

The second part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...

In this article by Neil Weicher, he talks about encryption of data and files for SQL Server.   Read more...

In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion.   Read more...

Have you ever worked with an application that forgot to close its connections? Ever run out of connections on your SQL Server and had to manually go remove the ones that are not in use? This article will present a technique for keeping the database clean.   Read more...

This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5   Read more...

How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here.   Read more...

The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...

This article shows you in a step-by-step manner how to restore the master database.   Read more...

The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...

The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...

The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...

The third part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...

It is not always possible to run a process on a set schedule. This article by Steve Jones looks at a technique for ensuring that your processes can run on whenever you need them to without any loss of data.   Read more...