Impact of manipulating SSRS parameter inside dataset

Recently I had to convert a report’s dataset, which was using Stored Procedure, into inline T-SQL commands. The dataset had 4...

Have the Time? Get in the Game.

This year there's a two step process for electing members to the Professional Association for SQL Server (PASS) Board of Directors...

PowerPivot – Commonly Used DAX Expressions

Today I will be presenting in a webinar, which by the way is recorded for later viewing, on Commonly used...

Reset Identity Column in SQL

I’ll be honest, I am partially writing this because I always forget how to reset the identity column on a...

SQL MCM Training – Day 3

Nothing to say about today, Jonathan did really a great job describing Extended Events
and Baselining/Benchmarking to us, and his boss...

T-SQL Tuesday #21 – Bringing Ugly Back

T-SQL Tuesday #21 – Bringing Ugly Back
T-SQL Tuesday #21 - I'm Bringing Ugly Back

This blog entry is participating in T-SQL Tuesday #21,...

SQL Server “Denali”: Distributed Replay

Replaying multiple threads of a captured trace in SQL Profiler is difficult, and you are limited to replaying the workload from...

What It Means To Me To Be A Volunteer

Hi my name is Wes, and I am a volunteer
I am not unique. There are others like me, who give...

TSQL Tuesday 21 – FAIL FAIL FAIL

It is TSQL Tuesda… err Wedn… err Tuesday for August 2011.  This month the party is a day later and bringing us oodles of failure. Adam Machanic is hosting...

TSQL Tuesday 21 – FAIL FAIL FAIL

It is TSQL Tuesda… err Wedn… err Tuesday for August 2011.  This month the party is a day later and...