Configure Read only routing for an always on availability group

One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary...

SQL Saturday 723, March 24, 2018 in Rochester, NY. Join us and kick your SQL Server knowledge up a notch!

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...

Using the Analysis Services Execute DDL Task

My grandfather used to say, “There’s more than one way to skin a cat.”  I always thought it was a...

YouTube Channel Update

Hey! Here’s the latest on my YouTube Channel. Click on through and subscribe. I’ll be doing lots of stuff on...

Reporting services error: User XXXX does not have required permissions

If you encounter the following error trying to access reporting services:

User XXXX does not have required permissions. Verify that sufficient...

Data Masker for SQL Server–Syncing Values Across Rows

I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it...

What is the CXPACKET Wait Type?

This wait type indicates that parallel plans execute on the server. This wait type doesn’t necessarily means there is a...

Using SWITCH On A Single Partition

Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding...

Using SWITCH On A Single Partition

Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding...

Use Filtered Statistics to Improve Performance on Very Large Tables

Let’s say you have a very large table on a SQL Server 2012 Standard Edition instance. This means: old cardinality...