Category Archives: Beginner

SQL Server is Smarter Than You

Posted on December 8, 2011 by Jen McCown

I had a brief email discussion recently, which could be effectively be boiled down to: Them: “Are foreign key constraints more performant than referential integrity triggers?” Me: “Yes.” *stomp*stomp*stomp*stomp* “Yes, they are.” Let’s start with a generic statement, and get … Continue reading →

Posted in Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC | 2 Comments

Applied SQL: Demonstrate Simple Backup and Restore

Posted on October 26, 2011 by Jen McCown

Let’s apply a little backup and restore knowledge, eh wot? I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page. Prerequisites: basic T-SQL, create objects/data, basic understanding of recovery models and … Continue reading →

Posted in Applied SQL, Beginner, sqlserverpedia-syndication, SSC, TSQL | 2 Comments

Start daily programs – More n00bz fun with #Powershell!

Posted on September 27, 2011 by Jen McCown

When I get in to work in the morning, I like a good cup of coffee waiting for me, a neck rub, and all my favorite programs open and waiting for me.  Since the first two seem out of the … Continue reading →

Posted in Beginner, Powershell, sqlserverpedia-syndication, SSC | Tagged | 5 Comments