Don’t believe everything you read: Reconfigure flushes the plan cache

I’ve been doing a fair bit of research and investigation into the behavior of the plan cache recently. So I was concerned...

Free Training: Performance Tuning with Free Tools!

This week I have two presentations on my schedule. I get to give my Performance Tuning for Pirates presentation twice...

Generating Surrogate Keys With SSIS

A surrogate key is an auto generated value, usually integer, in the dimension table. It is made the primary key...

Speaker Selection for SQLSaturday Orlando-Group #1

Today we’re starting to announce speakers that will have at least one session on the schedule for SQLSaturday #151 in...

Speaker Selection for SQLSaturday Orlando-Group #2

Four more speakers we’re pleased to have joining us at SQLSaturday #151 this fall in Orlando!

Paul Waters
Mike Antonovich
David Liebman
Bradley Schacht

SQL 2000 TIPS AND TRICKS DECK AND DEMOS

Hello Dear Reader today I'm going to be presenting on SQL 2000 Upgrade tips and tricks for Pragmatic Works Training...

Troubleshooting Database Mirroring Error 1418 Updated

Troubleshooting Database Mirroring Error 1418 Updated
Last night I was helping someone with a database mirroring setup problem via email. It...

Guest Post – DBAvolution

One of my favourite things about the SQL community is the exquisite diversity of talent of it’s members. Today for the “What’s it...

How Local Variable or Optimize for Unknown Resolve Parameter Sniffing

In my last post , we have gone through the parameter sniffing  and possible solutions for parameter sniffing. In the possible...

How to Create Reporting Services 2012 Report Templates

When I started writing this blog I realized it has been several months since my last post.  I guess that...