SQL Server Best Practices Analyzer

The following screenshot will give a DBA severe indigestion (although I have to imagine it is not entirely uncommon on unmanaged installations of SQL, especially those where SQL is just the black box that is installed as a prerequisite). A SQL installation with the database files, logs, and backups on the same volume, all with…


SQL Server 2008 Migration White Papers

Just noticed these pop up on the Microsoft Download Center… some guides on migrating from various databases to SQL Server 2008. Guide to Migrating from MySQL to SQL Server 2008 In this migration guide you will learn the differences between the MySQL and SQL Server 2008 database platforms, and the steps necessary to convert a…

Masters of the (Reading) Universe.

Unless you are Uber-l33t, you are probably not working on your Microsoft Certified Master certification.  This is  where the best-of-the-best come visit the better-of-the-best on the Redmond Campus to learn everything there is to know about Active Directory Services, SharePoint, OCS, SQL Server, or Exchange. Seriously… take a look at the instructors. Anyhoo, just because…

April TechNet Magazine is up!

Internet Explorer: What’s New in Internet Explorer 8 Everyone expects something different from their browser. Some users are most concerned with security and privacy while others are more focused on customizability. Some want full standards compatibility, and others just desire ease of use. Explore the numerous new features and enhancements in Internet Explorer 8 that…


Web Application Installer

Wow… not sure how I missed this (especially as Scott covered it recently)!  A perfect companion to the Microsoft Web Platform Installer is the Web Application Installer.  Whereas the former installs and configures all of the plumbing (SQL, IIS, .Net, etc), the  Web Application Installer installs the web applications that run on top.  From the…

SQL Server 2008 Upgrade Technical Reference Guide

Just released, and only weighing in at 490 pages.  You didn’t have anything better to do over the Thanksgiving weekend, did you? 😉 Get it here. Brief Description This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices….

SQL Server 2008 Governance, Risk, and Compliance

I was just reading through the SQL Server 2008 Compliance Guide that was just released, and it actually has some great information on taking advantage of the new features as part of your GRC program.  Transparent encryption, policy-based management, auditing reports… good stuff! Get it here.

Introducing Microsoft SQL Server 2008

Free eBook available here: http://csna01.libredigital.com/?urss1q2we6 Learn about major new features in SQL Server 2008 including security, administration, and performance. Introducing Microsoft SQL Server 2008: Chapter 1: Security and Administration Chapter 2: Performance Chapter 3: Type System Chapter 4: Programmability Chapter 5: Storage Chapter 6: Enhancements for High Availability Chapter 7: Business Intelligence Enhancements

SQL Server Best Practices

In my last post, I lauded the SharePoint team for putting up a site covering their Best Practices, and mentioned that the other Product Groups should do the same. Ask and you shall receive… SQL Server Best Practices here: http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx

Installing SQL Server 2005 on Windows Server 2008

I am in the process of installing SQL Server 2005 on a new Windows 2008 Server, and ran into the following warning about missing some required components of IIS: – IIS Feature Requirement (Warning) Messages IIS Feature Requirement Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some…