Unable to recycle SQL Agent log: SQLServerAgent Error: 32.

Today the maintenance job that recycles the SQL Agent error log failed on one of our production SQL Server with...

Detecting Database Option Changes with DDL Triggers

One of the keys to managing a large production SQL Server environment is being aware of changes that are taking...

Download: Consolidated Denali a Day – May 2012

Download: Consolidated Denali a Day – May 2012 If you like what’s New in Denali (Sql server 2012) a day, for...

Guest Blog

I was given the opportunity to put together a guest blog post for the MVP blog. I did a little...

New SSIS 2012 Expressions

SSIS 2012 has added a few new expression functions and I thought I’d spend a short time detailing each.

LEFT
The LEFT...

Parallel Processing For Pros

Hi,

Yesterday I delivered a session on Parallel Processing at the Israeli User Group.
I had a great time and hope you...

Review of “Start Here! Learn Microsoft Visual C# 2010?

Disclaimer: I wrote this review as a participant to O’Reilly Blogger Review Program.
If you’ve never seen a programming code in...

“Green” Database Administration

For the past few years, I have seen tens of sql server boxes added in my work environment every year,...

Back to Pensacola and SQL Saturday #132

This will be my fourth trip to Pensacola for SQL Saturday #132. I’ve enjoyed going every time and I usually...

Database In Recovery

What do we do?
Have you ever run into a database that is in the “In Recovery” state?
If that has happened,...