The ‘Microsoft.Ace.OLEDB.12.0' Provider Is Not Registered on the Local Machine

If you have used SSIS to move data from something like Access or more commonly Excel, it is a good...

T-SQL Tuesday #25 – T-SQL Tricks

It’s time for T-SQL Tuesday again, and this time Allen White (@SQLRunr | blog) is asking for your tricks. If you...

View execution plan for a sproc in the wild

Got stored procedure problems?  I feel sorry for you son.

Here's a quick query to pull the cached execution plan out...

Why Am I Amazed By a 2000 Page Word Doc?

It’s not uncommon to have information shared in a Word doc, but I was surprised recently to open one up...

Why did I start blogging?

This post is in response to #meme15 started by Jason Strate (b|t). Two questions were asked in the first assignment....

#meme15 – Why Do You Blog?

Jason Strate (blog|@StrateSQL) is starting a new blog meme: #meme15.  The overall topic of #meme15 will be social networking, obviously...

Execute Permissions

Written by Ian Treasure
Gethyn posted on the use of execute permissions a while ago (db_executor at http://www.gethynellis.com/2010/04/dbexecutor-role.html). Briefly, this approach...

How to change the SQL Server service account

It’s easy. First you click here:

Then you find the SQL Server 2008 or 2008 R2 program group

Open those and then...

PASS Board of Directors – Who I’m Voting For

I was inspired by fellow blogger and all around good guy Nic Cain (Twitter, blog) to write about the PASS BoD...

PASS Summit 2011 Session Evaluations

Session evaluations from the 2011 PASS Summit have been entered, calculated, and officially released to speakers. While I didn't make...