Category: sql server

T-SQL Tuesday #016: Aggregates and Windowing Functions and Ranking! Yum!

Let’s get this out of the way right now: I am SO going to take advantage of this T-SQL Tuesday on aggregates to talk about OVER() and PARTITION BY. Aggregates and OVER go together like french fries and catsup…sure, you can have them apart, but together they’re just magical. Note: If you’re not at all familiar […]

24 (Hours of SQL Training Delivered to Your Computer)

The Spring 24Hours of PASS: Celebrating Women in Technology will be broadcast live on the intertubez on March 15 and 16 starting at 12:00 GMT (UTC) each day! I and 23 of my awesome techie womenfolk will dazzle your SQL sesnses with two days of Business Intelligence, DBA, and Development sessions!  Be sure to register right now to reserve […]