Free SQL 2012 hands on learning!

Tech Ed 2013 is over, and now the fun begins for those who could not attend. Dozens of Hands-On labs are available online for us to learn new technologies! Here’s a list of the SQL 2012 Hands-On Labs I’m starting with the Hekaton lab!

My First PowerShell Script

Presenting tonight for Florida PowerShell User Group.  “A DBA’s first PowerShell script: lessons learned” Edit* It went great! Slides here Would love any feedback or questions.

SQL Alert when you’re low on disk space

I found this gem while troubleshooting a SQL Server with a backup drive that filled up often. It uses the WMI provider will alert when ANY drive on the server goes below 10GB. You can change the value ‘10000000000’ below to adjust this. You’ll also want to change your operator from ‘Support’ to your operator […]

Copying indexes from Oracle to SQL Server

I’m working with a client that has access to an Oracle 10g database containing transactional data that they copy to their new SQL Server 2012 as a data warehouse. (We recently migrated the straight from SQL 2000 into SQL 2012, but that’s another story.) They already had scripts to copy the tables and data to […]




All Rights Reserved Theme by 404 THEME.