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...

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...

Last Week to Enter the Exceptional DBA Contest

Just a reminder: you have until this Friday to enter the 2012 Exceptional DBA awards. I’m judging, and looking forward...

Microsoft Data Quality Services in SQL Server 2012

SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product that is new to SQL Server 2012.  The...

Rebuild index with "Alter Index Rebuild" or "DBCC DBREINDEX"

You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" .

First, in BOL, for "DBCC...

Super SQLSaturday #158 Summer Spectacular Event Update & Speaker Schedule!

 
When we first announced the return of SQLSaturday to NYC (after 2 long years), we knew we'd get a decent...