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

Archives: May 2013

We’re speaking at PASS Summit 2013!

PASS liked our “Mouth Wide Shut” interviewing session from last year so much that they’ve decided to have us back for part two: Mouth Wide Shut: Interviews from the Other Side of the Table. This is our brand-spanking-new session for the interviewERs…those who question, vet, and rant about it afterward.…

Read more

0 comments, 600 reads

Posted in SQL Awesomesauce on 22 May 2013

My 2013 SQL Saturday Schedule!

I’ve finally gotten my gear together for (what I consider) the “speaking season”. Here are the SQL Saturdays that I’m speaking at, or that I’ve submitted to, or are considering submitting to! I’ll update this list as plans solidify: 5/18/2013 – Atlanta - Scheduled to speak. 8/3/2013 – Baton Rouge…

Read more

0 comments, 610 reads

Posted in SQL Awesomesauce on 16 May 2013

Use Powershell to find and punish – er, delete – rogue files

I like to know what’s on the drives that are supposed to be dedicated to data and log files. So I run a quick check of sys.master_files: SELECT LEFT(physical_name, 1) as Drive, SUM(size)*8/1024 as SizeMb FROM sys.master_files GROUP BY LEFT(physical_name, 1) ORDER BY Drive; And then I compare the numbers…

Read more

0 comments, 1,067 reads

Posted in SQL Awesomesauce on 13 May 2013

Quick Tip: Navigating to a UNC within SQLPS

I’ve been getting a funky error with a new Powershell script, running as a SQL Agent job step. Let’s pretend for the moment that the script is simply “cd \\backup\SQL; dir *.bak” The error information returned by PowerShell is: ‘Cannot find path ‘\\backup\SQL’ because it does not exist. The script…

Read more

1 comments, 750 reads

Posted in SQL Awesomesauce on 6 May 2013