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

Data Modeling for Self-Service BI @ Techorama 2018

I’m delighted to announce I’ll be giving a session about data modeling in a self-service BI environment at Techorama 2018...

SQL Server and Evil Greedy Data Types

In a recent post, I talked about SQL Server reads and how the data is stored in pages. One of...