Category: Tech and Learning

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

T-SQL: CASE Statement

Post author By Jen McCown
Post date December 28, 2010
Categories In Beginner, sql server, sqlserverpedia-syndication, SSC, TSQL
4 Comments on T-SQL: CASE Statement

This is a companion piece to the MidnightDBA video T-SQL: CASE Statement. In short, a CASE statement is a simplified set of IF statements. Instead of using several IF statements, you can have a single statement that evaluates several criteria against a piece of data. Simple CASE Let’s take a simple example. We want to […]

RTFM365, Week 1

Post author By Jen McCown
Post date December 10, 2010
Categories In Advanced, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, SSRS, Tips
2 Comments on RTFM365, Week 1

Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t stop the server side trace, it stops SQL Server itself. Be warned. Boilerplate: For the next year (-10 days now), I will read from SQL Server Books Online a little every day, and blog about […]