SQL Server 2008 R2's self-service business intelligence capabilities are tied into Excel Services in a browser running in SharePoint. The new PowerPivot add-in for Excel 2010 is part of the SQL Server ...

SQL Server 2005/2000 are not supported by multi-server management. SQL Server 2008 R2 also introduces the SQL Server Master Data Services based on the MDM technology acquired in June 2007 when the ...

Unlocking the mystery behind MDS Unlocking the secrets around Microsoft’s Master Data Services is proving to be very challenging.

In short, deep pockets drive the middle ground features. Following middle ground features are fringe features, some of which make little sense at face value. Hierarchy ID data types, used only by SQL ...

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.

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

The acquisition of the data-quality company Zoomix would "help provide richer data-quality capabilities in future," Microsoft added. The new version of SQL Server is scheduled to ship in the first ...