Category: sql server

Another reason that T-SQL beats the GUI

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 DBAs find themselves under a metaphorical bus.  Nobody likes the underside of that bus. It’s […]

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

Rat Sues Corn! Rather, rat accuses corn of thought-theft! Or something!

Final Update: We covered this entire saga in last week’s DBAs@Midnight webshow, entitled Slightly Used Interview. We also had some serious fun to poke at the company in question. Easily offended audience members: Read, don’t go and watch. We’ve had our fair share of plagiarists, and even one or two accidental plagiarists (see Rats in […]