How Does Disabling an Index Affect the Index Usage DMV Counters

A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the...

NodeXL – Accessible Network Graph Analysis, part 3 (Twitter)

This is the third blog post in the series dedicated to the Network Graph Analysis Tool – NodeXL.

If you are interested,...

How Much Value Would a SQLSaturday Certificate of Completion Have?

Note: Posted May 27, 2014, additions posted May 28, 2014 further down.
I think it’s been discussed a time or two,...

Webcast Follow-Up: 5 SQL Server Indexing Myths

Similar to yesterday’s post, I have a follow-up for another Pragmatic WorksTraining on the T’s session that I delivered last month....

Attaching All Databases with PowerShell–Checking All Databases

I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...

Building The SQLSaturday Orlando Marketing Plan-Part 13

Here is the second of the two flyers I ordered from fiverr.com (see the first one here). The center image...

Get User In Reporting Services-Question of the Day

Get User In Reporting Services is my newest question to be published at SQLServerCentral.com as a “Question of the Day”....

SQL Server 2014 Launch Party Mississauga Ontario (Toronto) June 21, 2014

This event promises to be a highlight of the Canadian SQL Server calendar year.

The presenters are all 'first class'.

All...

NodeXL – Accessible Network Graph Analysis, part 2

This is the second blog post in the series dedicated to the Network Graph Analysis Tool – NodeXL.

If you are interested,...

Useful Links for learning & using in Data Quality Projects in SQL Server

Data Quality Services in SQL Server is a component that is based around the concept of knowledge-driven quality.
Here comes a...