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.

"Does SSDT for Visual Studio 2012 support BI project templates?" asked James V. Serra in a TechNet forum last September. Some six months later, the answer was yes: "Hi James, the download to add the ...

An opportunity to speak with Sabrena McBride, Senior Product Manager for SQL Server, provided a lot of insight into what's new in R2. Some of the highlights: Among other things, SQL Server 2008 R2 is ...

Microsoft, apparently trying to enhance every product it has with an AI-powered Copilot, announced a new one for the latest release of SQL Server Developer Tools (SSDT) in Visual Studio. SSDT is a ...

Microsoft on Tuesday is releasing the first service pack for the SQL Server 2000 Reporting Services business intelligence platform. Reporting Services is intended to boost business insight by offering ...

On Monday, Microsoft announced availability of the much-anticipated beta two version of Visual Studio 2005 and the .Net Compact Framework 2.0, as well as a community technology preview of SQL Server ...

Microsoft complements its relational database engine, SQL Server, with several add-on services that manage different aspects of enterprise business intelligence and information processing such as data ...

Microsoft Corp.s long-awaited SQL Server 2005 represents significant change for administrators—the database server includes several new features that add capability and improve performance, but they ...

Note – This book abbreviates SQL Server 2008 Reporting Services as SSRS and SQL Server 2005 Reporting Services as SSRS2K5. New features available in SSRS and not in SSRS2K5 are labeled with “New in ...

Every business intelligence solution needs data, which might come from a variety of sources and in different formats. Microsoft SQL Server Integration Services, or SSIS, allows you to extract data ...

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