Category: Applied SQL

Clarity in T-SQL: Adjoining Socks

Post author By Jen McCown
Post date January 3, 2014
Categories In Applied SQL, sqlserverpedia-syndication, SSC, Tech and Learning

One of my children is very literal, a true pedantic. “Is there any homework you need to do?” “No.” “Really? Show me your homework sheet. … Why does it say ‘book report due’ for tomorrow?” “Because the report is due tomorrow.” [Deep breath.] “So why did you JUST tell me you don’t have any homework […]

SQL Server 2012 CU2 – Have a little fun (#AppliedSQL)

Post author By Jen McCown
Post date June 20, 2012
Categories In Applied SQL, sql server, sqlserverpedia-syndication, SSC
3 Comments on SQL Server 2012 CU2 – Have a little fun (#AppliedSQL)

SQL Server 2012 Cumulative Update (CU) 2 is out! If you’re like Me-from-10-years-ago, you couldn’t care less! But there are actually some good reasons for paying attention to new CUs. For example: it’s one good way to get to know the new version of SQL Server: play with the bugs before you install the updates! (You […]

Applied SQL: Demonstrate Simple Backup and Restore

Post author By Jen McCown
Post date October 26, 2011
Categories In Applied SQL, Beginner, sqlserverpedia-syndication, SSC, TSQL
2 Comments on Applied SQL: Demonstrate Simple Backup and Restore

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 backup types. Reading – SQL Server Books Online articles: Backup (Transact-SQL) Restore (Transact-SQL) ALTER DATABASE […]