Search results matching tags 'Education' and 'SQL 2000'

September 12 in San Fran

RickHeiges — Wed, 12 Sep 2012 02:04:00 GMT

Just a reminder that I will be speaking at the SF UG SQL Server User Group on Sep 12. Here is a link with all of the details. If you are in the area, It would be great to see you!

Rick Review: SQLTeach - SQL345 - 10-Mar-2010 - Kimberly Tripp

RickHeiges — Wed, 15 Feb 2012 05:17:00 GMT

SQLTeach (Part of the DevTeach Conferences in Canada) has enjoyed success for many years. I enjoyed the opportunity to speak at and attend SQLTeach at various times over the years. Since SQLTeach is part of DevTeach, the "feel" of the event is very different from PASS or SQLRally or even a SQL Saturday where SQL is the primary focus. It does however afford an opportunity for me to understand the challenges of those who need to work with SQL either in a direct or indirect manner. SQLTeach / DevTeach records sessions and post them on the web for anyone to consume (login required, but a login may be created for FREE). Here is where I found this video: http://www.devteach.com/DevTeachVideo.aspx?NoVideo=45

The session that I selected to review is by one of my favorite speakers, Kimberly Tripp. In this session, Kimberly once again simplifies a concept that is often treated as black magic. The session is entitled "Optimizing Procedural Code". This demo-heavy session covers many different options that are available to impact optimization. Do you know the various options to force out a cached plan? Is recompiling bad? What else can I control to help optimization?

Check this session out and consider attending the next SQLTeach/DevTeach (especially if you are already in Canada).

Enjoy!

Turning the corner on Upgrading from SQL Server 2000

RickHeiges — Thu, 12 Feb 2009 13:46:00 GMT

Last month, I spoke at a SQL Server Firestarter event in Charlotte. With just about every session that I speak at or webcast that I do since 2006, I always ask for a show of hands on two questions. The first is "How many people here are running SQL Server 2000 in production?", and the follow-up question that I ask is "How many people here have SQL Server 2000 running in production for a majority of your servers?". This isn't scientific. People can interpret the questions/terminology differently (Does server mean physical box, instance, database, etc?), but something has changed - at least anecdotally. The responses for this particular audience were about 70% were still running SQL Server 2000 and of those about a little less than 50% had SQL Server 2000 as their major daa platform in their production environments. There was one guy there running 7.0 still (yikes!) and only 2 people in this audience running SQL Server 2008 in production.

This may only be a blip on the screen, but I find more and more organizations that are totally on SQL Server 2005. There is still a lot of 2000 out there and it will take time to make those a distant memory. But from this unscientific data point, it looks like SQL Server 2005 is on the verge of becoming the main version out there for SQL Server. There are all sorts of reasons why SQL Server 2000 is still in use such as a large investment in DTS packages, third-party apps, hassle of upgrading other components/applications/utilities. At some point, an upgrade will become necessary.

If you are in the process of upgrading from SQL Server 2000 to 2005 and can't (for whatever reason) upgrade to 2008 instead, go ahead and run the Upgrade Advisor for SQL Server 2008 too. Chances are that there will be little (if any) additional changes taht need to be made and you will for once be ahead of the game. :-)