RSS

Monthly Archives: February 2013

SQL Agent and the case of the missing job owner…

SQL Agent and the case of the missing job owner…

One fine morning as I’m sitting at my desk doing my work I review some emails about cleaning out some old data from a table that stored webpage session information. I’m given hints about first checking out a job that supposedly purges the data automatically. With my first clue, the wheels were turning on this investigation. To my astonishment, I would fine something terrifying… almost unspeakable…

It was a SQL Server job with no owner!

Read the rest of this entry »

Advertisements
 
5 Comments

Posted by on February 20, 2013 in Database Administration

 

Tags: , ,

SQL Server Backup and Recovery Fundamentals Presentation

SQL Server Backup and Recovery Fundamentals Presentation

SQL Server Backup and Recovery Fundamentals – February 5th, 2013

A copy of the recording is available here. Code and slides are under the Presentations section of this website.

Correction:Compression on Backups is available on the Standard Edition of SQL 2008R2 and SQL 2012 but not SQL 2008. Thanks to Mark Harrison for pointing that out to me.

http://www.techrepublic.com/blog/datacenter/configure-compressed-backups-with-sql-server-2008-r2-standard-edition/2788

 

 

 

Tags: , , ,

 
%d bloggers like this: