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

As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

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

A default locked-down configuration, data encryption, and other new features strengthen security. Analysis Services, Reporting Services, and Data Mining are now fully integrated and mature. DTS (Data ...

The daily routine of an IT professional remains largely reactive. A lot of time and budget is spent responding to tickets, limiting the time that we spend creating systems that drive growth and ...