After some tuning I re-presented my talk on SQL 2012 and PowerShell 3 for the Florida.Net user group. They let me ramble on much longer, so I had the chance to do more demos and step through the code more thoroughly. Recieved some really great feedback, and saw more than a few people may have […]
Year: 2012
SQL 2012 and Powershell 3 SFSSUG Talk
Spoke last night on SQL 2012 and Powershell 3 at South Florida SQL Server User Group today. Thanks guys for having me! I had lots of content, and was ready to dive into changes from PowerShell 2 to 3, new SQL 2012 Cmdlets, and coding with SQL Management Objects. However most of the group was just […]
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 […]
Windows 8 is released to manufacturing
They just posted the release of Windows 8 20 minutes ago. http://blogs.msdn.com/b/b8/archive/2012/08/01/releasing-windows-8-august-1-2012.aspx I’m officially on the lookout for a reliable howto for setting up dual boot on my Win7 Ultimate laptop. I DO NOT have the time to learn by trial and error. 🙂 Anyone?
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 […]
The great adventure: Migrating from SQL 2000 to 2012
I worked with a client that migrated from SQL 2000 32 bit database straight up to SQL 2012 64 bit! Quite a challenge, and quite the journey over 12 years and 5 releases (2000,2005,2008,2008R2,2012) of SQL. Some of the complicating factors include: Backup and Restore It is not possible to restore a SQL 2000 backup […]
The SQL Saturday experience!
This weekend I attended and volunteered at SQL Saturday #141, hosted by the awesome folks at Nova University. I didn’t speak this year, but helped out with parking, food, and giving directions to the attendees throughout the day. It was a great experience. If you’ve enjoyed SQL Saturdays, I highly encourage you to volunteer for […]
What I’ve been up to
Haven’t posted in a while. Been working on a few different projects, taking care of clients, staying busy. I’ve been asked by some SQL students to post sites with useful SQL scripts I’ve found. There have been so many over the years.. but I’ve started my Useful SQL Scripts page, and will add to it […]
On the road!
I’m on the road, training this week in Tempe, AZ. It’s cold, but it’s a dry cold! Have 3 client projects in the works, plus learning SQL 2012 ins and outs. Looks like it’s going to be a busy year.