Category Archives: Uncategorized

Auditing Failed Logins – SQL Server 2008

I wrote about setting up a basic server audit recently. That showed about how a server level audit is set up, but that’s a just a shell. The audit itself is just a container in which you can store various … Continue reading

Posted in Uncategorized | 2 Comments

Adding Space to a Home Server

I got new drives for my Windows Home Server the other day and decided to add some space to the box. I don’t need the space so much as I’d like to be sure that I’m protected with some extra … Continue reading

Posted in Uncategorized | Comments Off on Adding Space to a Home Server

Reporting Services – Building the first report

One of my goals this year was to spend some time learning Reporting Services. Not necessarily do the 10,000 hours to become an expert, but perhaps the 100 hours or so Andy Warren mentioned in his Professional Development presentation. I’ve … Continue reading

Posted in Uncategorized | Comments Off on Reporting Services – Building the first report

Quick Audits of Schema Changes

I saw someone post a question recently about tracking down who deleted a stored procedure. I suggested the default trace, and linked to a beginner article on it. However there was another post that had a better way to track … Continue reading

Posted in Uncategorized | Comments Off on Quick Audits of Schema Changes