Category: Beginner

24 Hours of PASS Spring 2011 Code Sins

Post author By Jen McCown
Post date March 15, 2011
Categories In 24HOP, 24HOP, Beginner, Intermediate, sql server, SQLPASS, sqlserverpedia-syndication, SSC, Tips, TSQL
5 Comments on 24 Hours of PASS Spring 2011 Code Sins

Here is all the things related to the most awesome Code Sins session I gave at 24 Hours of PASS Spring 2011. Thanks to the 750+ of you that attended, and the many who commented!! I will be updating this blog post with links and answers to questions for a few days yet. The 24HOP recorded sessions […]

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

Post author By Jen McCown
Post date March 8, 2011
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, TSQL
4 Comments on 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 […]

Beginning Powershell Companion PDF

Post author By Jen McCown
Post date January 3, 2011
Categories In Beginner, Powershell, sqlserverpedia-syndication, SSC
1 Comment on Beginning Powershell Companion PDF

Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help me in my early days of near-ignorance. So I’ve made myself a reference sheet! In Sean’s first two Powershell videos – Powershell Basics, and Scripting DB Objects in PowerShell – we’re introduced to […]