Category Archives: TSQL

SELECT GetDate() – 30 AS [This actually works??];

Posted on December 19, 2011 by Jen McCown

I just ran across this in a piece of code (that I didn’t write): … WHERE Thing >GETDATE()- 30 Aaaand it works. If you run the title of this blog post, you’ll get the date 30 days ago. I had … Continue reading →

Posted in sql server, sqlserverpedia-syndication, SSC, TSQL | 4 Comments

Another reason that T-SQL beats the GUI

Posted on November 14, 2011 by Jen McCown

In IT, we have a few very solid and universal principles that no one ever argues with.  The first of these is Cover Your Ass (CYA). CYA is so universal and popular because things go wrong, blame gets thrown, and … Continue reading →

Posted in sql server, sqlserverpedia-syndication, SSC, Tips, TSQL | 4 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