Microsoft Releases SQL Server 2005 Service Pack 2

SQL? I must me mad!


REDMOND, Wash. — Feb. 19, 2007 — Microsoft Corp. today released Microsoft® SQL Server™ 2005 SP2, an update to its award-winning data management and analysis platform. Customers can now take advantage of enhancements in the familiar and easy-to-use Windows Vista™ operating system and 2007 Microsoft Office system to easily connect and integrate with the power, security and reliability of SQL Server 2005. In addition, Microsoft announced that it is expanding virtualization use rights to allow unlimited virtual instances on servers that are fully licensed for SQL Server 2005 Enterprise Edition. For customers who want maximum flexibility in their use of virtualization technology, now or in the future, SQL Server 2005 Enterprise Edition is the ideal choice.

MM&M UG UK March Meeting (Tuesday 27th March 2007)

In london (thank god) .. sign up now! (

Here are the details of our March MMMUG meeting.

This event will be held in London at the MS SOHO offices. This is a very special event as we are being joined by Jason Langridge who is otherwise known as Mr Mobile! Check out Jason’s blog for all things mobile: –

The meeting will be held on Tuesday 27th March. Directions to the venue can be found below.

The meeting will be a mixture of PowerPoint, Demos and Discussions and perhaps most exciting, I have no doubt that Jason will be able to bring along some New Mobile Devices running Windows Mobile 6 to show us! There will also be a Q&A time at the end of the meeting.

The agenda for the meeting will be as follows: (although I may tweak the timings slightly)

18:00 – 18:30            Arrival
18:30 – 18:35            Introduction to speakers and the aims of the group
18:35 – 19:30            1st session; led by Jason Langridge, MS
An introduction to Windows Mobile 6.

19:30 – 19:50            Food!
19:50 – 20:45            2nd session; led by Jason Langridge, MS
General discussion around mobility, how people use it and where the technology is going in the next few years.

20:45 – 21:00            Summing up and suggestions for future meetings.
21:00                        The End! 


New OneNote 2007 PowerToys

I LOVE OneNote .. I use it all the time as my one shop note taker and with a tablet pc it is even better .. now look we have some new powertoys!


Word Count. We get asked by some people to be able to know how many words are on a page for articles and essays and so on. here you go.

Send to OneNote (from the file explorer/shell). Ever looked at a file in My Documents or elsewhere and thought, “I want to push that into OneNote so I can add it to my project, make some comments about it, etc? Now you can.

Export Outlook Notes to OneNote. Lots of people use Outlook’s Notes feature to keep track of little scraps of info

It looks like Dan is the man with the tools, so check out his blog

Windows Home Server

Two things about this … first off I have been accepted into Beta 2 .. yippy and they next one is the new Windows Home Server Drive Extender.  This rocks .. I wonder if this will be an update to Vista?  I suppose the only issue is space in your server to actually add more drived :-|


… Windows Home Server Drive Extender is a new technology incorporated into Windows Home Server that makes it easy for consumers to easily add more disk space to their home servers.  Users will no longer have worry about disk drive letters (C:, D:, E:, etc. etc.) as they had more hard drives to their home server, since Windows Home Server treats the disk space as a large pool of available space.  Remember this product is supposed to be easy to use, but also really cool …

Office 2003 with Office 2007 file types

Forgot that I Blogged this a while back, but what is cool is that I have just tried to open a docx in Word 2003 and it actually prompts me to download:

[Microsoft Offic Word]
This file was created by a newer version of Microsoft Word.  Do you want to download a compatibility pack so that you can work with this file?
[OK] [Cancel]

How does it know?  An update must have been applied or it’s in the docx.  Anyway it takes you to the download ( page to get the update … that is cool!

Exchange 2003 Backups

I was asked a question yesterday that I didn’t know the answer to, so I put some feelers out and found the answer. The final reference doc is this one (

What is new to me is 2. below.  I didn’t realise that when a backup is running, data is still accepted and written to the edb.  I thought the data stayed in memory as well as the logs.  As they say, every day is a school day!

Basically, when you start a Full Exchange 2003 Backup the following happens

  1. The backup agent establishes communication and initializes a backup with the MSExchangeIS service on the target Exchange server. (In Exchange 5.5, the backup was established with the Microsoft Exchange System Attendant (MSExchangeSA) service process.)
  2. The checkpoint is frozen. New changes will still be accepted and written to the database files, but the checkpoint will not move again until the backup ends.
  3. The first log that must be copied to tape with the backup is recorded in the database header in the Current Full Backup section. This might not be the current checkpoint log, depending on the backup status of other databases in the storage group.
  4. Copying the database files to tape begins. Page changes made to the database during backup that cannot be reconstructed fully from the log files are not flushed to the disk during backup. 

    If you run Eseutil /MH on a database that has been restored from an online backup, but on which recovery has not yet run, you will see the mini header information displayed as the Patch Current Full Backup section.

    The current Enn.log file is forced to roll over immediately after all database files have been copied to tape. This happens regardless of how full the log is.

    The reason that the log is forced to roll over is that log files cannot be backed up while they are open. The log needs to be on tape, because it contains operations applicable to the databases that were just backed up. Therefore, the log is closed so that it can be appended to the tape. You will never see a log file called Enn.log in an online backup set. Only closed, numbered log files are backed up.

  5. The range of logs needed to reliably recover the backup are copied to tape. These will include at least all the logs starting from the frozen checkpoint up through the log that was just forced to close.
  6. Log files that no database in the storage group needs to roll forward beyond the backup logs are truncated (deleted from disk). The headers of all the databases in a storage group keep track of the last backup time for each database, and also which logs were required. If any database in a storage group is dismounted, its header will not be read and Exchange will make no calculations about which log files can be safely deleted.
  7. There are two factors that affect which log files will be truncated after a backup:
    • Databases can be backed up individually.
    • Not all databases in the storage group may be mounted at the time the backup occurs.
      If you back up some databases but not others in a storage group, only the transaction logs not needed by the database least recently backed up will be truncated. This means that if you never back up one particular database in a storage group, no transaction logs will ever be deleted. If you have two databases in a storage group, and you back up one of them on Tuesday and the other on Thursday, the Thursday backup will truncate logs only up to Tuesday. If you then back up the Tuesday database on Friday, the logs from Thursday will be truncated.
  8. The Previous Full Backup section of the database header is updated to reflect the time and log range of the backup that just completed.

DST 2007: MSIT Guidance Published

Ohhh.  With the steady flow of DST information is starting to trickle down to more manageable levels.  MSIT has finally release some additional DST 2007 Guidance.

·         MSIT DST Assessment Checklist (5 page PDF)

·         MSIT DST Enterprise Response Plan (22 page PDF)

·         MSIT DST Patching Overview (1 page PDF flowchart)

·         MSIT DST Exchange TZ Update Tool Guidance (5 page PDF)

·         MSIT DST Outlook TZ Update Package Guidance (4 page PDF)

AD Infrastructure management with PowerShell

If you love Windows PowerShell then you must already read Marc Blog.  BUT this is just the dogs whatits!


Being able to query the AD with just a few PowerShell commands if just awesome.  Check it out and try it now .. hey you know, you could always “move” to Windows PowerShell for you AD automation ;-)

Support WebCast: DST 2007 Exchange Communication

You can download this WebCast now for “offline” viewing.

Go here ( stick in you name and then download the 4mb WMV file.

 It would be a great idea if MS made the available automatically via an RSS feed

Humm, can’t sync the wmv to my Zune! .. says that it cannot convert the file to the format required by my Zune Device  .. wonder why!