A Learning Experiment

I’ve been looking for ways to improve the way I do my job, which is mostly writing and editing, but...

A Rickety Stairway to SQL Server Data Mining, Algorithm 1: Not-So-Naïve Bayes

            Thankfully, the simplest of SQL Server’s algorithms is not quite as naïve about data mining as I am.

            As mentioned...

Day 9 of 31 Days of Disaster Recovery: Use All the Checksums

31 Days of Disaster Recovery
Welcome to day 9 of my 31 Days of Disaster Recovery series. Today, I want...

Determining Default Trace Location

While working on some scripts against SQL Server’s default trace, I wanted to develop a sure fire way to find...

January S3OLV 2013

I hope you are ready for some free SQL learning.  Coming up on Thursday January 10th at 6:30 PM Pacific...

January S3OLV 2013

I hope you are ready for some free SQL learning.  Coming up on Thursday January 10th at 6:30 PM Pacific (GMT – 8 ) we will have a stellar...

Plans for 2013

I have lists. Lots of lists. I even have them in different locations sometimes. Some of them are carefully written...

SQL Saturday #198 Feb 16, 2013

SQL Saturday 198, http://www.sqlsaturday.com/198/ ; is coming to Vancouver Feb 16 this year.  As of now, 56 sessions are collected from...

The EXECUTE permission was denied on the object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’.

Issue : Today I have read one issue over one forum, One user is having below 3 DB roles on MSDB...

The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.

Reblogged from MSSQLFUN:
Issue : Today I have read one issue over one forum, One user is having below 3 DB roles...