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 ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

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. Prevent AI-generated tech debt with Skeleton ...

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 ...

With Extended Support for SQL Server 2008 and SQL Server 2008 R2 ending in July 2019, to be followed six months later by the end of Extended Support for Windows Server 2008 and 2008 R2 in January 2020 ...

SQL Server 2008 R2, which ships this month, allows end users to tap into the powerful business intelligence features of SQL Server via tight integration with popular Microsoft applications like Excel.