Katmai details announced..

If you haven’t heard, we have just published some information about the next release of SQL Server codenamed Katmai – you can read more here http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx.  I will post more details as soon as I get a spare half hour. 


SQL Server 2005 Dashboard Reports

This is a really nice feature … “The Microsoft SQL Server 2005 Performance Dashboard Reports are used to monitor and resolve performance problems on your SQL Server 2005 database server. The SQL Server instance being monitored and the Management Studio client used to run the reports must both be running SP2 or later” http://www.microsoft.com/downloads/details.aspx?FamilyId=1D3A4A0D-7E0C-4730-8204-E419218C1EFC&displaylang=en


Critical Update for SQL Server 2005 Service Pack 2

As mentioned perviously, we identified a problem with the maintenance plan clean-up task that was introduced in SQL Server 2005 Service Pack 2.  Well, the good news is that we have now released a hotfix to correct the problem which can be downloaded from here http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en.  The corresponding knowlege base article is available here http://support.microsoft.com/kb/933508 Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup…


SQL Server 2005 SP2 and Maintenance Plans

FYI You should be aware of this issue if you intend to deploy SQL Server 2005 SP2: http://blogs.msdn.com/sqlrem/archive/2007/02/24/Maintenance-Plan-Changes-in-SQL-Server-2005-SP2.aspx

1

SQL Server 2005 Hidden Gems

There are some really great entries appearing on the SQL Server 2005 Best Practices website.  I just noticed this web page which discusses, amongs other things, some new features in SP2 like the vardecimal storage format and LOGON triggers.  Take a look: Top 10 Hidden Gems in SQL Server 2005 http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx.  I also like the…


SQL Server 2005 SP2 is finally here…

Service pack 2 for SQL Server 2005 is now available – all the details are here http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx. 


SQL Server 2005 SP2 is almost here…

We can expect the RTM release of Service Pack 2 for SQL Server 2005 very very soon.  In the meantime, please take a look at the updated readme file (dated 9th Jan 2007) ‘Whats new in SQL Server 2005 SP2’ which is available here: http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/WhatsNewSQL2005SP2.htm (this has continually been updated in line with the fixes and changes which…

1

Management Studio Add-in

I haven’t posted for a while (please forgive me) as I’ve been quite busy over the past few weeks.  I should really try to post more frequently.  Anyway, I am not going to talk about Microsoft software but instead talk about the release of SQL Prompt 3 from Red Gate http://www.red-gate.com/products/SQL_Prompt/index.htm.  I recently received the ‘we…

1