-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2016

Easy SQL mistakes: Accidental Correlated Subquery

Just a fun note, because it was a moment of pure puzzlement for me. I’m writing a new SP for Minion Backup (you knew it had to be Minion related, didn’t you?) and I just got the oddest error. Here’s how it went. First, I got a list of backups…

Read more

2 comments, 2,841 reads

Posted in SQL Awesomesauce on 18 April 2016

XP_CmdShell isn’t Evil

Bonus summary: xp_cmdshell is limited to admins, unless you specifically grant permissions to users. And if you’re an admin, you have the power to turn on and use xp_cmdshell anyway.  Xp_cmdshell is not a security hole. This is a reprint of Sean McCown’s original post on DBARant. You know, reprinted…

Read more

6 comments, 1,647 reads

Posted in SQL Awesomesauce on 9 April 2016

Announcement: Backup(n.) vs Back Up(v.)

Let it be known that the word “backup” is a noun (it refers to a thing), and “back up” is a verb (it refers to an action. I’m going to back up the database. It will produce a backup. I’ll save that backup until we back up the database three…

Read more

6 comments, 405 reads

Posted in SQL Awesomesauce on 7 April 2016