Microsoft's latest relational database management system contains a host of new features, but are they enough to make you migrate? The wait is over. Microsoft has finally released SQL Server 2008, the ...

There are many strategies for this process that can be employed but Microsoft has given us the new MERGE statement which helps simplify things. Let’s take a look… One way of applying incremental ...

SQL Server, Microsoft's flagship operational database, has been around for over a quarter century now. That has meant successive waves of innovation for the platform, but has also made for ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage discusses the architectural ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

It's not 2008 anymore. Joey details the ins and outs of upgrading these aging Microsoft servers, including licensing changes, support options and potential pitfalls. It was a simpler time. A decade ...

SQL Server 2008, aka “Katmai,” gives SQL Server shops plenty of reasons to get excited. The best SQL Server release to date, it sports more nice new features than you can count, and the improvements ...

Microsoft is offering users on Windows Server 2008 and 2008 R2 and SQL Server 2008 and 2008 R2 a way to keep getting security updates for free after the official support period ends. Read also: Here's ...