You probably already know that SQL Server 2005 SP2 has been released. This is a good thing if you are in need of one of the changes that are included in this service pack. In a previous tip, SQL Server 2005 - Service Pack 2, we took a look at what was to be included in this second service pack for SQL Server 2005. The question that you often face is should I install this service pack. One thing to note before you install SP2 is that there is no way to uninstall it once it is installed.   Read more...

This article from shows how to prepare your SQL Server 2005 clustered environment for Service Pack 3 and avoid some common problems.  Read more...

This past week saw the release of Service Pack 1 for SQL Server 2008, and some interesting changes with it. Steve Jones comments.  Read more...

This past week saw the release of Service Pack 1 for SQL Server 2008, and some interesting changes with it. Steve Jones comments.  Read more...

This past week saw the release of Service Pack 1 for SQL Server 2008, and some interesting changes with it. Steve Jones comments.  Read more...

This past week saw the release of Service Pack 1 for SQL Server 2008, and some interesting changes with it. Steve Jones comments.  Read more...

Service Pack 1 for SQL Server 2008 has been released. Follow the link for more information.  Read more...

Dealing with a disaster is a trying experience for anyone, but having to then worry about having the proper software installed can make things much worse. Steve Jones talks a bit about the challenges of worrying about software versions.  Read more...

Dealing with a disaster is a trying experience for anyone, but having to then worry about having the proper software installed can make things much worse. Steve Jones talks a bit about the challenges of worrying about software versions.  Read more...

Dealing with a disaster is a trying experience for anyone, but having to then worry about having the proper software installed can make things much worse. Steve Jones talks a bit about the challenges of worrying about software versions.  Read more...

SP3 is released  Read more...

SQL version and service pack level  Read more...

Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.   Read more...

Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.   Read more...

There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.   Read more...

On Friday the 24th, a virus that preys on a SQL Server vulnerability began to attack networks, taking down many networks. This brief network describes the virus and how to protect yourself from it.   Read more...

If you're still on SQL Server 2000 SP2, beware! Microsoft has released a number of fixes that have now been rolled up into this cumulative patch to fix major security flaws in SQL Server.   Read more...

Microsoft has released a patch to fix two buffer overflow vulnerabilities in SQL Server 2000. No UserID or password is required by the attacker to exploit these issues. The problem is exacerbated by the fact the attack goes over UDP.  Read more...

Here we go again! Microsoft has released service pack 2 this week, which is much more tame than service pack 1. Read the summary of this service pack here.   Read more...

SQL Server 2000 has better replication capabilities than ever before! Do you have questions about using Replication on SQL Server? Whether it be transactional or merge replication, you can not find a better group of guys to answer your questions. Right from the development team, Matt Hollingsworth and Dean Kalanquin, replication program manager and test lead respectively are setting aside this time to take on your most challenging replication questions!   Read more...

This article from shows how to prepare your SQL Server 2005 clustered environment for Service Pack 3 and avoid some common problems.  Read more...

This past week saw the release of Service Pack 1 for SQL Server 2008, and some interesting changes with it. Steve Jones comments.  Read more...

Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.   Read more...