Category: SSC

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 […]

SQL University – Teach Your Children Well

Post author By Jen McCown
Post date March 10, 2011
Categories In NonSQL, sqlserverpedia-syndication, SQLU, SSC, WIT
13 Comments on SQL University – Teach Your Children Well

“If you had a daughter, would you really encourage her to get into IT?” … “Yes, if she loved it.” – My Name Is Jes, and I’m a WIT, Jes Borland “Let the kids (your kids, any kid) know there are more career options than teacher, doctor, lawyer, fireman, police office and astronaut. Don’t force […]

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 […]