Traveling and Talking to Wrap Up 2013

I am writing this blog post en route to New York City for SQL Saturday #235. This begins a fairly...

Azure and Your MSDN Account

I’ve heard over and over again that the reason people don’t want to learn Azure, to explore it, to understand...

Distribution setup SQL Server Agent error: "RegCreateKeyEx() returned error 5, 'Access is denied.'"

In the Configure Distribution Wizard, the step "Configuring SQL Server Agent to start automatically" errors with the following text:

TITLE: Configure...

Quick tip: WMI alerts and SQL Server Agent permissions.

I came across an issue today while trying to create a WMI alert for a mirroring state change. The error...

SQL Server 2014: AlwaysOn

AlwaysOn was introduced in SQL Server 2012, and there are some enhancements in SQL Server 2014:
Now support up to 8 secondary...

Workload Tuning: Finding Top Offenders in SQL Server 2012

I have to give credit where credit is due. Microsoft has definitely made performance tuning easier in SQL Server 2012. Performance...

Be The Connector

Few things are more satisfying than to introduce two people when you think they have common interests. Often it’s driven...

Configuring BIDS 2008 / 2008 R2 and Visual Studio 2008 to work with Database & Business Intelligence Projects and Team Foundation Server (TFS)

Working with the SSIS, SSAS, and SSRS Business Intelligence projects along with Database projects in the same Visual Studio 2008...

Get the Backup History in your Central Management Server for SQL Server

I have a setup of Central Management Servers in my SQL Server and it’s been a big help to me...

It’s the small things that count

Sometimes it’s the small things that count.
I just noticed two small enhancements to SQL Server 2014's BOL, and I can...