Seeking Volunteers for the Nomination Committee

We have a few changes in the election process for PASS this year, one of them is that we have...

Re-blog – August 5-August 11

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Oddly enough,...

[OT] On Community

Last fall, and winter, and spring I was part of the PASS Election Review Committee. It was interesting, sometimes fun,...

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