Latest updates available are…

Hello all, Because in the last 30 days some major updates were released for several versions of SQL Server (from which the last two listed here were released just last night), this serves as a quick gather of the ones available. Remember that CUs (Cumulative Updates) include all fixes since the last RTM or SP,…


Latest Cumulative Updates for SQL Server

Hi all, These are the latest Cumulative Updates available for SQL Server – based on the actual date 18/11/2009: SQL Server 2008 Supported Build Latest Cumulative Update Link RTM(*) 8 http://support.microsoft.com/kb/975976 SP1 5 http://support.microsoft.com/kb/975977 SQL Server 2005 Supported Build Latest Cumulative Update Link SP2(*) 16 http://support.microsoft.com/kb/974647 SP3 6 http://support.microsoft.com/kb/974648 (*) – Review the following link…


Information about the SNAC package and Cumulative Updates

Hello, When you follow the steps to download a SQL Server 2005 (SP2/SP3) or SQL Server 2008 (RTM/SP1) cumulative update, you see a list of packages where you need to chose which ones you want to download and, normally, you have doubts about which one or ones you need to select. Should I download SNAC…


SQL Server 2005 – Performance Dashboard installation steps

Hi, To get the Performance Dashboard for SQL Server 2005 installed you must follow these steps: 1. Download the installation package from Microsoft Web Site: http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en 2. Install the MSI where you have the SQL Server Management Studio installed 3. Locate the Performance Dashboard folder, normally you should find it here: C:\Program Files\Microsoft SQL Server\90\Tools\PerformanceDashboard…


SQL Server 2005/2008 – How to know which are the latest builds available?

Hi, It is very common to have doubts about the last build or the latest Cumulative Update available for SQL Server 2005 and 2008. These two tables represent the actual situation (1/7/2009): SQL Server 2005  Supported Build Last Cumulative Update KB article  Support Lifecycle SP2 14 http://support.microsoft.com/kb/970278/  http://support.microsoft.com/lifecycle/?p1=2855 SP3 4 http://support.microsoft.com/kb/970279/ http://support.microsoft.com/lifecycle/?p1=2855   SQL Server…


New Cumulative Updates in SQL Server 2005

Hello everyone,  Just wanted to leave a quick note about some new releases in SQL Server 2005. On the 16th February, it was released the second cumulative update for SQL Server 2005 SP3 and twelveth cumulative update for SQL Server 2005 SP2. Have a read in the official post at: Microsoft SQL Server Release Services…

1

SQL Server 2005 and 2008 System Views Posters

  Use the following links to download the official posters with the map of the System Views for SQL Server 2005/2008: SQL Server 2005 http://www.microsoft.com/downloads/details.aspx?familyid=2EC9E842-40BE-4321-9B56-92FD3860FB32&displaylang=en and for SQL Server 2008 http://www.microsoft.com/downloads/details.aspx?FamilyID=531c53e7-8a2a-4375-8f2f-5d799aa67b5c&displaylang=en For SQL Server 2000 you can download a zip file with a more interactive presentation: http://download.microsoft.com/download/5/e/8/5e86d6da-99a6-4949-99c2-0c9b9edc189a/systbl_rev.zip   Cheers,


SQL Server 2005 – SP2/SP3 and Cumulative Updates

The SP3 of SQL Server 2005, It was released last month: Microsoft SQL Server Release Services – SQL Server 2005 SP3 And at the same time Microsoft released a new cumulative update, the Cumulative Update 1 for SQL Server 2005 SP3: Microsoft SQL Server Release Services – Cumulative Update #1 for SQL Server 2005 SP3…


Cumulative update package 11 for SQL Server 2005 Service Pack 2

Hi everyone,   Our great SQL Server Releases Services Team, just release what I think it will be the last Cumulative Update for SQL Server 2005 SP2:  http://blogs.msdn.com/sqlreleaseservices/archive/2008/12/15/cumulative-update-11-for-sql-server-2005-service-pack-2.aspx This CU includes corrections for a good set of problems. Check the details in the KB Article: http://support.microsoft.com/kb/958735/en-us We’ll be waiting for the Service Pack 3! Greetings…

0

How to script all my database objects? Here is the answer.

One question that sometimes arises is “How can we script all database objects throught some kind of automation?” You have several ways to do it.For both SQL 2000 and SQL 2005 you have Microsoft SQL Server Database Publishing Wizard that generates a single SQL script file which can be used to recreate a database (both…

2