You are trying to automate your monitoring and...

Dump SQL Permissions

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.

You are trying to audit your SQL Servers...

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.