MS Certifications & SQL Server 2008

I have been wondering if there are going to be any certification (MCP) changes when Katmai ships next year.  Fortunately it looks like a similar structure i.e. TS, MCITP levels.  There is a good blog entry on this here  Hopefully the beta MCP exams will start soon. There are two certification webcasts scheduled but…


SQL Server Power Tools

I have just gone through the process of having to build a stable Vista x64 OS on my new Lenovo T61p laptop – which I must say is very impressive.  Apart from the issues with Groove not completely supporting 64-bit (arghh), I installed SQL Server 2005 Developer Edition (SP2 + hotfix package) and then began…


SQL Server 2005 Books Online (September 2007) Update

..should be appearing very soon for download.  I can see it in Windows Update so it will hopefully be appearing here shortly. 


Support for SQL Server 2005 Service Pack 1…

…ends on April 8th 2008 so I would recommend upgrading to service pack 2 (and the latest cumulative hotfix package) as soon as possible.  SQL Server service pack support is documented on the lifecycle website here


Why can’t I backup the mirror database?

I’m currently working with a customer who had a requirement to backup the mirror database.  You may wonder why they want to do this – there are a number of reasons which I won’t go into right now.  The simple answer is that it is not possible to backup the mirror database as it is…


Eight reasons to migrate to SQL Server 2008

I haven’t blogged for quite a while now… and my excuse?  – there is not enough time in the day!  One thing that I have managed to do is schedule a trip to Manchester this Thursday (29th November) to talk to anyone interested about SQL Server 2008 It should be good as I haven’t…


New cumulative update++

Just noticed that the a new cumulative update for SQL Server 2005 service pack 2 has been released.  The KB is here  The incremental servicing model has also been clearly defined in the following knowledge base article


SQL 2000 Books Online Update June 2007

I’ve just noticed that the SQL Server 2000 BOL has been updated and can be downloaded here I find it useful to have a copy of the SQL 2000 BOL installed as I’m constantly referencing the material (and it works on Vista). 


Katmai whitepapers

There are some good katmai whitepapers appearing on the the katmai site.  The list is available here  Performance and Scale  Manageability Delivering location intelligence with spatial data SQL Server 2008 Reporting Services What’s new for XML in SQL Server 2008 Managing unstructured data Server consolidation Data warehousing…