Monthly Archives: June 2007

Improvements to Clustering in Windows Server 2008

Posted on June 7, 2007 by Glenn Berry

Techlog has a nice summary of improvements in fail-over clustering in Windows Server 2008. Rodney Fournier lists some more details below: No service account – now uses a local system account No support for Parallel Attached SCSI (PAS), this allows … Continue reading →

Posted in Windows Server 2008 | Leave a comment

Microsoft Certified Architect:Database

Posted on June 7, 2007 by Glenn Berry

Microsoft recently rolled out a new, top-tier certification program that is quite different than any of their previous offerings. Really, this certification is pretty insane! The prerequisites are listed here. You must either be a Microsoft employee or work for … Continue reading →

Posted in SQL Server 2005 | 4 Comments

How to Disable Parameter Sniffing in SQL Server 2005

Posted on June 7, 2007 by Glenn Berry

I have seen several questions in the MSDN SQL Server Database Engine Forum recently about problems people are having with statistics not staying up-to-date in some cases in SQL Server 2005. This can also manifest itself as problems with queries suddenly … Continue reading →

Posted in SQL Server 2005 | 7 Comments

Database Mirroring Questions from TechEd 2007

Posted on June 6, 2007 by Glenn Berry

Microsoft’s Paul Randal has a new blog post about some of the questions that have come up about database mirroring at TechEd. At NewsGator, we have had very good results with asynchronous database mirroring, both by itself and combined with … Continue reading →

Posted in SQL Server 2005 | Leave a comment

Querying a Database Snapshot in SQL Server 2005

Posted on June 6, 2007 by Glenn Berry

Here is a nice post from the Microsoft SQLCAT team on the performance implications of querying a database snapshot in SQL Server 2005. Very informative. Technorati Tags: SQL Server 2005, Database Snapshots

Posted in SQL Server 2005 | Leave a comment

MSDN Nuggets

Posted on June 5, 2007 by Glenn Berry

MSDN has a neat little site where you can view short (5-10 minute) how-to videos on various products and technologies. Very nice for getting a quick overview of something new.

Posted in Microsoft | Leave a comment

Slideshow from Saumur Tank Museum in France

Posted on June 5, 2007 by Glenn Berry

Here is a slideshow that I found, covering the Musee des Blindes, which has one of the largest tank collections in the world.

Posted in Tanks | Leave a comment

MERGE Statement in SQL Server 2008

Posted on June 4, 2007 by Glenn Berry

Here is a sample of a MERGE statement (copied from BOL): MERGE FactBuyingHabits AS fbhUSING (SELECT CustomerID, ProductID, PurchaseDate FROM PurchaseRecords) AS srcON (fbh.ProductID = src.ProductID AND fbh.CustomerID = src.CustomerID)WHEN MATCHED THEN UPDATE SET fbh.LastPurchaseDate = src.PurchaseDateWHEN NOT MATCHED THEN … Continue reading →

Posted in SQL Server 2008 | 17 Comments

More about SQL Server 2008 June CTP

Posted on June 4, 2007 by Glenn Berry

Since Microsoft has officially announced that SQL Server "Katmai" will be SQL Server 2008, and they have released the June CTP of SQL Server 2008. I can talk a little more about it without getting into trouble. Microsoft has a … Continue reading →

Posted in SQL Server 2008 | Leave a comment

Katmai Becomes SQL Server 2008

Posted on June 4, 2007 by Glenn Berry

Microsoft finally made it official. The next version of SQL Server, which is code-named Katmai, will be called SQL Server 2008. More importantly, they have released the first CTP build, which you can get here. Microsoft also announced that Visual … Continue reading →

Posted in SQL Server 2008 | Leave a comment