However, the Compatibility Level property for that database remains at the release it was upgraded from. For instance, if you copy a SQL 2000 database to SQL Server 2008, the new copy is an upgrade to ...

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

Microsoft has released the second service pack for SQL Server, delivering enhancements in several key areas of the widely used database. Full compatibility with Windows Vista is an important change, ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

"It's really about choice," Rohan Kumar, Microsoft's General Manager, Database Systems, told me yesterday as he briefed me on the new offerings. Kumar further explained: "if you're a developer, you ...