Featured Article(s)
Troubleshooting SQL Server 2008 Log Shipping
In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2008 log shipping. He also tells how you can resolve these problems.
Free Webcast: Best practices for Analysis Services administration
This session takes you on a end-to-end tour of management features for Analysis Services. Along the way, you’ll learn important best practices direct from the product team about how to configure, optimize and manage your Analysis Server. We expect this to be an essential session for new and experienced Analysis Services administrators alike.
Presented by: Donald Farmer
> Register Now (it’s free!)
> Live date: 6/23/2010 at 12:00 Pacific
SQL Server Versions in Use – Feedback
It’s unanimous! All sorts of different versions of SQL Server are in use – very rare is the case where you’re able to normalize the versions.
Victor: "Where I work we support the last three versions ( 2000, 2005, 2008). Like most other folks we don’t have the resources (budget) to purchase new hardware, licenses and labor to migrate to newer versions. Most clients don’t care as long as the application works and performs decently. I don’t really worry about MS support for 2000 as it been years and no big issues. Usually it is our OS guys who forces us to upgrade."
Roy: "My biggest issue with multiple versions is software vendors that do not yet support the newer versions of the OS, much less newer versions of SQL server. We push them, but with out limited resources and their propriatary functions, we have to wait on them."
Dave: "I’m the dissenting vote because as of this year we are completely SQL Server 2008. We are also a small player, only 3 SQL instances."
Carol: "I still have one database on SQL 7!! I also support SQL 2000, SQL 2005, and SQL 2008, along with a couple Sybase 12 databases. Our management has decided not to upgrade the SQL 7 database & application, to let it die a natural death. Once it stops working there is a DNR order on it. We have tried to upgrade the SQL 2000 databases, but newer projects always seem to take precedence over upgrades. There are a couple databases on SQL 2005, but it looks like we may be skipping right to SQL 2008."
Karen: "SQL 7 – All Mission Critical Applications are on SQL 7 – the replacement environ has just been built! The Cuban Server Embargo has been lifted!!
SQL2000 – production only
SQL2005 – dev/beta/prod
SQL2008R2 – the future test environment"
Adrian: "Well my company brings support to many companies here in Costa Rica, right now we’re facing to what I call “A Sql Server Salad”, cause we work with clients who have Sql Server 2000, Sql Server 2005 and Sql Server 2008, and all of them, Production Environments. Last week we receive a user request saying “Guys I need help with my Sql Server Database, I have Sql Server 6.5 installed” You can imagine my surprise. Here in Costa Rica is “normal” to have variety of Sql Server Versions."