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 […]
Author: dave
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.
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 […]
Too busy to blog
SO….. Despite my best intentions, I haven’t kept up with blogging. The reason why is actually good news… I’ve been crazy busy. Since I’ve last blogged I have: Trained a few SQL classes (MOC 6232B and 2778A, 70-432 and 70-433 test prep.) Built my first WCF Restful web service prototype for a long time client. […]
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
DIY Hyper-V, Active/Active Clustering and SQL Server – Demo and Step by Step Instructions
Recently spoke at South Florida IT Camp Saturday on using Hyper-V, Windows Server 2008 R2 SP1 Enterprise, Microsoft iSCSI Target 3.3, and SQL Server 2008 R2 SP1 to create an Active-Active SQL Cluster. I actually managed to cover all the cool parts in an hour, and got some great feedback. If you’re interested in implementing this […]
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 […]
Catching up on blogging, new opportunities
So today I’m catching up after a year of no posts. While I can see the value in blogging, I’ve just had too many distractions to count. Recent events have convinced me it’s important to start up again. I recently attended the first PASS SQL Rally in Orlando, had a great time, met good people, and […]