Filling in Data Potholes Redux: Tally Tables vs CTEs

In A Previous Installment
Re-Ducks
… our heroine (that’s me) rediscovered CTEs, specifically in the recursive style. That was in my post...

Why I’m All For 24HOP Showcasing 24 Women Speakers

This is not the HOP you are looking for.
I’ve been thinking about the upcoming 24HOP event planned for March 15...

Filling in Data Potholes with Recursive CTEs

Data: it can break your foot.
Imagine that you are writing a script that looks at data grouped by the minute....

The 9th Day of SQL: Things Aren't as Simple as They Seem

The 12 days of SQL
Brent Ozar (blog | twitter) had an idea: a group of people should blog about writing which...

Select * from dbo.FAIL: invalid metadata in views and user defined functions

This week a question on the Twitter #sqlhelp hash tag reminded me of a detail of SQL Server that I...

Introduction to Partitioning: Resources!

This past Saturday I presented my shiny new Introduction to SQL Server Partitioning session at SQL Saturday 61.
There were two...

TSQL Tuesday #11: Messages and the Clammy Seduction of the Print Statement

Note: Updated 10/28 based on conversation in the comments, and 12/10 with Denali info.

TSQL Tuesday #11: Misconceptions in SQL Server
This...

Automation: Granting Read Perms for Developers

Yeah, you heard me.
Do you like to read?
“But Kendra, why would we want to grant developers read  permissions? And why...

Learning that Presenting is Worth Doing (T-SQL Tuesday #008: Gettin’ Schooled)

This month’s T-SQL Tuesday topic is hosted by Robert Davis and the topic is “How do you learn? How do you teach?...

Error Configuring DataCollector: A collection set cannot start without a schedule

Data Collection, Puppy Style
Update: Based on Bill Ramos’ comment below and a note on Twitter (thanks!!) I have added some...