Once a month, on the 2nd Tuesday, the SQL Server online community has a virtual party of sorts called T-SQL Tuesday. T-SQL Tuesday was started by Adam Mechanic (blog|twitter) back in 2009 and has been going strong ever since. This month, I decided to crash the party with a submission of my own. The topic-du-jour […]
One of the most important, if not the most important tasks of the DBA is backing up your database. The database backup is the most basic disaster recovery plan you can have in place. It’s certainly the easiest to implement. Today I’m going to go over the basics of backups, including the different types of […]
In previous versions of SQL Server, there were a number of methods for auditing activity within an instance or database. You could use DDL triggers to track any DDL changes, login auditing to write login successes or failures to the error log, Profiler tracing, and even C2/Common Criteria Compliance Auditing. But each of these methods […]
Doh! A while back I posted a Powershell script that would script out a SQL Server database. Well, a reader pointed out to me yesterday that it wasn’t quite working for him. And wouldn’t you know, it wasn’t working for me either. The problem was that when I created the script I had a specific […]
Most people set goals in January. It’s a brand new calendar year full of possibilities. They join gyms. They quit smoking. I’ve never been one for New Year’s resolutions, personally. And I don’t think goal-setting should be confined to January. For me, in my professional life, July makes more sense. I’ve had my annual review […]
