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 http://blogs.msdn.com/gerryo/archive/2007/12/11/sql-server-2008-and-certifications.aspx.  Hopefully the beta MCP exams will start soon. There are two certification webcasts scheduled but…

1

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…

1

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 http://technet.microsoft.com/en-gb/sqlserver/bb428874.aspx shortly. 

1

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 http://support.microsoft.com/gp/lifesupsps#Servers

0

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…

1

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 https://msevents.microsoft.com/cui/EventDetail.aspx?culture=en-GB&eventid=1032355918. It should be good as I haven’t…

1

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 http://support.microsoft.com/kb/943656.  The incremental servicing model has also been clearly defined in the following knowledge base article http://support.microsoft.com/kb/935897

3

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 http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en. 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). 

1

Katmai whitepapers

There are some good katmai whitepapers appearing on the the katmai site.  The list is available here http://www.microsoft.com/sql/2008/learning/whitepapers.mspx.  Performance and Scale http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_perfandscale.mspx  Manageability http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_manageability.mspx Delivering location intelligence with spatial data http://www.microsoft.com/sql/techinfo/whitepapers/spatialdata.mspx SQL Server 2008 Reporting Services http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_ssrs.mspx What’s new for XML in SQL Server 2008 http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_xml.mspx Managing unstructured data http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_unstructured.mspx Server consolidation http://www.microsoft.com/sql/techinfo/whitepapers/hosting_sql_srv_consol.mspx Data warehousing…

3