You are a database manager who is trying...

Monitoring Failed Job Steps

New Author! We've run a couple articles on similar topics, this one takes a slightly different approach. It's a short article and has two scripts included.

Review of Lumigent Entegra

We've been trying to catch up on reviews lately, Hai was kind enough to give Entegra a try and report back on it. The basic concept is that it lets you do extensive auditing without having to add triggers. If you're trying to find an auditing solution, this is worth considering.

The drive where you've installed your SQL Server...

The disk where SQL is saving the ERRORLOG...

Worst Practice - Adding a Column Without Thinking!

Adding a column is one of the simpler tasks you'll ever do as a DBA, yet danger lurks! All too often we add columns without going through some type of check list to make sure we're safe. What could adding a column break? You might be surprised!

Review of ApexSQL Log

Brian has been busy lately helping us with content for our magazine (you have checked out www.sqlserverstandard.com haven't you?) but he's back this week with a great write up a new product that let's you read from the transaction log.

You need to create a test database on...

DBCC showcontig gives information about fragmentation. What does...

Review of Lumigent Log Explorer v4

Chris (one of our regulars!) installed Log Explorer and took it for a test drive. Written up in our standard review format this will give you a very quick overview of what the product does.