Microsoft announced today that SQL Server 2008 R2 is released to manufacturing just 20 months after SQL Server 2008, the platform on which it is built. SQL Server 2008 R2 (codenamed Kilimanjaro) ...

Unlocking the mystery behind MDS Unlocking the secrets around Microsoft’s Master Data Services is proving to be very challenging. The underlying data model is fairly straightforward, but actually ...

Hierarchy ID data types, used only by SQL Server trainers and writers, are an example. I frequently ask myself whether a feature that's not quite useful today is actually a down payment on something ...

In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools have ...

Take advantage of the mission-critical capabilities in SQL Server 2016 for real time operational analytics, rich data visualizations and improved data security SQL Server is Microsoft’s flagship ...