Connecting HyperV guests to the local network even before installing Integration Services

So, I have finally had my hands on Microsoft Hyper-V. I’ve installed Windows Server 2008 with Hyper-V role on my laptop for creating virtual machines. I’ve decided to virtualize my Windows XP work-machine so that I won’t have to worry about backups in case it got corrupted. What I had in mind was to simply […]

Blank space between startup parameters

I was trying to figure out why my startup trace flags don’t work. While it is mentioned in this Microsoft TechNet article about using semi-colons to separate one startup parameter from another, nothing was mentioned about the leading blank space in between defining the parameters. SQL Server MVP Erland Sommarskog recommended removing the leading blank […]

NT AUTHORITYNETWORK SERVICE account in SharePoint Content Database

I have had the opportunity to assist a WIndows SBS MVP migrating Windows SharePoint Services 3.0 databases from SQL Server 2005 to SQL Server 2008 in a Windows SBS 2008 environment. He was following the steps outlined in this Microsoft TechNet article to move the content databases and configure them from inside SharePoint Central Administration […]

SQL Server Deep Dives book now available

I have had an opportunity to be a part of a wonderful project that took almost a year in the making. SQL Server MVP Deep Dives is not your ordinary SQL Server book as it brings together the world’s most highly-regarded SQL Server experts to create a masterful collection of tips, techniques, and experience-driven best […]