SQL 2012 and PowerShell 3 talk at Florida.Net UG

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

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

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

Free hands-on SQL 2008 training from Microsoft!

While the folks at Microsoft have offered these for a long time, I’m sure most people don’t know about it. Technet Virtual Labs offers focuses 90 minute virtual labs so you can play with new features in the latest Microsoft technologies just using Internet Explorer. Check out the SQL Server 2008 section to learn about features […]

SQL Saturday #79 at Devry

Speaking on DIY Active Active SQL Cluster with Hyper-V and iSCSI again at SQL Saturday #79 at Devry. Hope to see you there!  Trying to twit… I’m dave000777, anyone out there?     DIY SQL Clustering with Hyper-V and iSCSI    

SQL cluster on the cheap with Hyper-V and iSCSI

Speaking on how to set up SQL clustering in a virtual environment, for development and testing. Discuss options for production deployment. Now, how to compress 9 hours of setup into a session… Expect some smoke and mirrors along with some neat technology. Does anyone have some SSDs I can borrow? 🙂 July 23rd http://itcampsaturday.com/southflorida/ Tentative […]

Social

Content

Speaking

All Rights Reserved Theme by 404 THEME.