SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: November 2009

SQL Job Ownership Article on SSC.Com

Today, Please see my featured article appearing on SQLServerCentral.com discussing SQL Agent Job Ownership.

Have you ever had a situation where a DBA or admin leaves the company, his login is disabled, only to discover that his years of service, and of creating sql jobs to run under his account,… Read more

0 comments, 614 reads

Posted in Pearl Knows on 19 November 2009

And the Winner is........

DB Audit  Challenge #1  

And the Winner is….

First, I want to thank everyone that participated in the DB Audit Challenge, and appreciate your positive comments and feedback.  One reader thanked me for running this challenge.  Another was happy to stay engaged b/c he could not attend… Read more

0 comments, 792 reads

Posted in Pearl Knows on 10 November 2009

Thoughts on a PASSing Scene...

Well it certainly has been a busy and exciting week at PASS.  I couldn't go this year, but through the magic of SSC.com, the blogosphere and personal email from Seattle, I was there in spirit.  You might say I was virtually there. 

Speaking of virtual, one of the sessions I've… Read more

0 comments, 512 reads

Posted in Pearl Knows on 5 November 2009

Reference to PASS Session - T-LOG

Hey, just caught wind of some timely stuff going on at PASS.  Had my trusty 'Google alert' email me, set to ring on anything about the function fn_dblog.

Kalen Delaney, the sql internals extraordinaire, who brought us the book called Inside Microsoft SQL Server 2005: The Storage Engine, was… Read more

0 comments, 797 reads

Posted in Pearl Knows on 3 November 2009

DB Audit Challenge #1 - Part II - Get a Clue

In the spirit of my Who DID IT and RAN SQL Caper presentation..... 

OK, I was hoping to get the creative juices stirring, and now I will provide some clues and direction on how to solve the T-log puzzle.  It's actually very simple (easy for me to say :-).  One just… Read more

1 comments, 731 reads

Posted in Pearl Knows on 3 November 2009

DB Audit Challenge #1

Take the DB Audit Challenge - Intermediate   - DB Audit Challenge #1

For those of you who have been following my recent blogs, as well as those who attended the SQLSaturday October 24 event in NJ, know that my presentation covered several topics with respect to database forensics.  I… Read more

1 comments, 1,181 reads

Posted in Pearl Knows on 1 November 2009