I started working with SQL Server with version 6.0 as well. It has certainly evolved from SQL7 to 2000 to 2008R2 for sure.
The New Kid in Town: SQL Server DenaliCommented on: 3 years ago
(July 25, 2011)
We still have a mix of SQL 2000 (40%), SQL 2005(30%) and some SQL 2008(10%) and one SQL 2008R2 (20%). In looking at all of the new features about the only one I saw that was interesting was the...
Microsoft Expects Q2 RTM for SQL Server 2008Commented on: 7 years ago
(August 9, 2007)
Interesting article. I would expect us to hold off until SQL 2008 now. We are not on software assurance so spending the big $$ for 2005 and with the new release on the horizon is not such a good move.
Too Soon for SQL Server 2008?Commented on: 7 years ago
(July 20, 2007)
We have only one SQL 2005 install here. The rest (20 Prod servers) are on SQL 2000.... about half on Win2000. We are in a budget crunch so we cannot come up with the 250k or so to upgrade. At this...
Leapfrogging to KatmaiCommented on: 7 years ago
(June 21, 2007)
We are in a budget crunch here. We have 20 Production SQL 2000 and 1 SQL 2005. At this point I cannot justify the $250,000+ in monies, nor do we have the app. staff to upgrade all of these and then...
In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....More
When setting up HA or HA+DR solutions with SQL Server AlwaysOn Availability Groups, it's critical to remember that the basic unit of failover in these scenarios is the availability group (or the group of user-defined databases)....More