Tips
Applying SQL Server Service Packs
As with most applications there are hot fixes, updates and/or service packs that are often released. Some of these updates are automatic while others require you to take action and apply the update. SQL Server is one of those applications that requires you to take action versus having the updates automatically applied. This is a good thing, but it requires the DBA to take some type of action. In addition, applying the service packs to the database engine is pretty much understood, but did you also know that these updates also need to be applied on the clients as well?
Energy Policy Act of 2005 for SQL Server Notification Services
In an earlier tip "Energy Policy Act of 2005 Implications on SQL Server" we outlined how SQL Server leverage Windows for their date and time needs. As such, applying patches to Windows would properly support the overall SQL Server date and time needs for the Energy Policy Act of 2005. Unfortunately, that is the not the case with SQL Server Notification Services, additional steps must be taken for proper compliance by March 11, 2007 at 2:00 AM.
Energy Policy Act of 2005 Implications on SQL Server
In the United States, the Energy Policy Act of 2005 (http://webexhibits.org/daylightsaving/b.html) was approved by President Bush on August 8, 2005. Due to this legislation, the day light savings start and end times in the United States will change in the spring of 2007? As such, what patches will I need to apply to my SQL Servers? Do I need to apply different patches for SQL Server 2000 versus 2005?
How to Recover from a SQL Server Service Pack 3 Install Error
I have a production SQL Server with multiple instances. We are working through the SQL Server 2005 Service Pack 3 installation. Unfortunately, we have run into Error: 29565 SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete. Where can I find out which SQL Server instance had the issue and the resolution? Do I need to reinstall SQL Server or do I have another option?
Issue with SQL Server 2005 SP2
If you haven't heard already, there was a problem identified with service pack 2 for SQL Server 2005. The problem has to do with the "History Cleanup" tasks and the "Maintenance Cleanup" tasks. The issue is that the interval that these tasks runs is not based on what you think when you set this interval. Based on this, your backup files or other files that are cleaned up by these tasks may be prematurely deleted or these files may stay around longer then intended and therefore possibly cause disk space issues.
Microsoft SQL Server 2008 Service Pack 2 Now Available
Service Pack 2 for SQL Server 2008 is now available for download.
Post SQL Server 2000 Service Pack 4 Performance Issues
My company has recently upgraded to SQL Server 2000 Service Pack 4 and we have experienced significant performance issues. Overall our performance baseline has dropped significantly (more than 50%) immediately after the service pack installation. We need to correct our performance issue, determine the problematic symptoms and the root cause in the service pack. How should we do so?
Slipstream Service Packs and Cumulative Updates on a SQL Server 2008 Installation
I need to install SQL Server 2008 Failover Cluster on a Windows Server 2008 R2 operating system. As per Microsoft KB article 955725, you would need to install SQL Server 2008 together with SQL Server 2008 Service Pack 1 or a later update as a minimum requirement. How do I proceed with a successful installation and not encounter the listed issues? In this tip I will show you how to create a slipstreamed version.
SQL Server 2005 Service Pack 2
As with past versions of SQL Server, Microsoft is releasing service pack updates for SQL Server 2005. The product officially launched in November 2005 and there has already been one service pack release on March 18, 2006 and service pack 2 is in the works. Microsoft is making these pre-releases available with their CTP version or Community Technology Preview. The problem comes into play as to who should test these versions and how should they be tested?
SQL Server 2008 R2 Service Pack 1 Now Available for Download
SQL Server 2008 R2 Service Pack 1 is now available for download.
Steps to Install SQL Server 2008 Service Pack 1 (SP1)
The company where I work is planning to install SQL Server 2008 Service Pack 1 (SP1). I have heard that the installation process for SQL Server 2008 Service Pack is different from previous SQL Server Editions. How much different is the installation process? In this tip, we will review the SQL Server 2008 Service Pack installation process, which differs quite a bit from SQL Server 2000 and SQL Server 2005 installations.
Updates for SQL Server 2005 Books Online
In a recent tip (Applying SQL Server Service Packs) you have talked about updates to the server side components of SQL Server as well as the client side components. One item that I have had an issue with is related to updates for SQL Server 2005 Books Online. Can you please confirm that this portion of the product is updated or not as a portion of those processes? I am concerned that I have outdated Books Online and do not even know it.
Top 10
Steps to Install SQL Server 2008 Service Pack 1 (SP1)
The company where I work is planning to install SQL Server 2008 Service Pack 1 (SP1). I have heard that the installation process for SQL Server 2008 Service Pack is different from previous SQL Server Editions. How much different is the installation process? In this tip, we will review the SQL Server 2008 Service Pack installation process, which differs quite a bit from SQL Server 2000 and SQL Server 2005 installations.
Slipstream Service Packs and Cumulative Updates on a SQL Server 2008 Installation
I need to install SQL Server 2008 Failover Cluster on a Windows Server 2008 R2 operating system. As per Microsoft KB article 955725, you would need to install SQL Server 2008 together with SQL Server 2008 Service Pack 1 or a later update as a minimum requirement. How do I proceed with a successful installation and not encounter the listed issues? In this tip I will show you how to create a slipstreamed version.
Issue with SQL Server 2005 SP2
If you haven't heard already, there was a problem identified with service pack 2 for SQL Server 2005. The problem has to do with the "History Cleanup" tasks and the "Maintenance Cleanup" tasks. The issue is that the interval that these tasks runs is not based on what you think when you set this interval. Based on this, your backup files or other files that are cleaned up by these tasks may be prematurely deleted or these files may stay around longer then intended and therefore possibly cause disk space issues.
How to Recover from a SQL Server Service Pack 3 Install Error
I have a production SQL Server with multiple instances. We are working through the SQL Server 2005 Service Pack 3 installation. Unfortunately, we have run into Error: 29565 SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete. Where can I find out which SQL Server instance had the issue and the resolution? Do I need to reinstall SQL Server or do I have another option?
Applying SQL Server Service Packs
As with most applications there are hot fixes, updates and/or service packs that are often released. Some of these updates are automatic while others require you to take action and apply the update. SQL Server is one of those applications that requires you to take action versus having the updates automatically applied. This is a good thing, but it requires the DBA to take some type of action. In addition, applying the service packs to the database engine is pretty much understood, but did you also know that these updates also need to be applied on the clients as well?
Post SQL Server 2000 Service Pack 4 Performance Issues
My company has recently upgraded to SQL Server 2000 Service Pack 4 and we have experienced significant performance issues. Overall our performance baseline has dropped significantly (more than 50%) immediately after the service pack installation. We need to correct our performance issue, determine the problematic symptoms and the root cause in the service pack. How should we do so?
SQL Server 2008 R2 Service Pack 1 Now Available for Download
SQL Server 2008 R2 Service Pack 1 is now available for download.
SQL Server 2005 Service Pack 2
As with past versions of SQL Server, Microsoft is releasing service pack updates for SQL Server 2005. The product officially launched in November 2005 and there has already been one service pack release on March 18, 2006 and service pack 2 is in the works. Microsoft is making these pre-releases available with their CTP version or Community Technology Preview. The problem comes into play as to who should test these versions and how should they be tested?
Microsoft SQL Server 2008 Service Pack 2 Now Available
Service Pack 2 for SQL Server 2008 is now available for download.
Updates for SQL Server 2005 Books Online
In a recent tip (Applying SQL Server Service Packs) you have talked about updates to the server side components of SQL Server as well as the client side components. One item that I have had an issue with is related to updates for SQL Server 2005 Books Online. Can you please confirm that this portion of the product is updated or not as a portion of those processes? I am concerned that I have outdated Books Online and do not even know it.
Last 10
SQL Server 2008 R2 Service Pack 1 Now Available for Download
SQL Server 2008 R2 Service Pack 1 is now available for download.
Microsoft SQL Server 2008 Service Pack 2 Now Available
Service Pack 2 for SQL Server 2008 is now available for download.
Slipstream Service Packs and Cumulative Updates on a SQL Server 2008 Installation
I need to install SQL Server 2008 Failover Cluster on a Windows Server 2008 R2 operating system. As per Microsoft KB article 955725, you would need to install SQL Server 2008 together with SQL Server 2008 Service Pack 1 or a later update as a minimum requirement. How do I proceed with a successful installation and not encounter the listed issues? In this tip I will show you how to create a slipstreamed version.
How to Recover from a SQL Server Service Pack 3 Install Error
I have a production SQL Server with multiple instances. We are working through the SQL Server 2005 Service Pack 3 installation. Unfortunately, we have run into Error: 29565 SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete. Where can I find out which SQL Server instance had the issue and the resolution? Do I need to reinstall SQL Server or do I have another option?
Steps to Install SQL Server 2008 Service Pack 1 (SP1)
The company where I work is planning to install SQL Server 2008 Service Pack 1 (SP1). I have heard that the installation process for SQL Server 2008 Service Pack is different from previous SQL Server Editions. How much different is the installation process? In this tip, we will review the SQL Server 2008 Service Pack installation process, which differs quite a bit from SQL Server 2000 and SQL Server 2005 installations.
Updates for SQL Server 2005 Books Online
In a recent tip (Applying SQL Server Service Packs) you have talked about updates to the server side components of SQL Server as well as the client side components. One item that I have had an issue with is related to updates for SQL Server 2005 Books Online. Can you please confirm that this portion of the product is updated or not as a portion of those processes? I am concerned that I have outdated Books Online and do not even know it.
Applying SQL Server Service Packs
As with most applications there are hot fixes, updates and/or service packs that are often released. Some of these updates are automatic while others require you to take action and apply the update. SQL Server is one of those applications that requires you to take action versus having the updates automatically applied. This is a good thing, but it requires the DBA to take some type of action. In addition, applying the service packs to the database engine is pretty much understood, but did you also know that these updates also need to be applied on the clients as well?
Post SQL Server 2000 Service Pack 4 Performance Issues
My company has recently upgraded to SQL Server 2000 Service Pack 4 and we have experienced significant performance issues. Overall our performance baseline has dropped significantly (more than 50%) immediately after the service pack installation. We need to correct our performance issue, determine the problematic symptoms and the root cause in the service pack. How should we do so?
Issue with SQL Server 2005 SP2
If you haven't heard already, there was a problem identified with service pack 2 for SQL Server 2005. The problem has to do with the "History Cleanup" tasks and the "Maintenance Cleanup" tasks. The issue is that the interval that these tasks runs is not based on what you think when you set this interval. Based on this, your backup files or other files that are cleaned up by these tasks may be prematurely deleted or these files may stay around longer then intended and therefore possibly cause disk space issues.
Energy Policy Act of 2005 for SQL Server Notification Services
In an earlier tip "Energy Policy Act of 2005 Implications on SQL Server" we outlined how SQL Server leverage Windows for their date and time needs. As such, applying patches to Windows would properly support the overall SQL Server date and time needs for the Energy Policy Act of 2005. Unfortunately, that is the not the case with SQL Server Notification Services, additional steps must be taken for proper compliance by March 11, 2007 at 2:00 AM.