The SQL Server Data Tools (SSDT) are modern development tools for building SQL Server relational databases, Azure SQL databases, bases in Azure SQL, Analysis Services (AS) data models, Integration ...

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

An application that is based on Visual Studio for developing solutions for SSIS, SSAS, or SSRS is called Business Intelligence Development Studio, or BIDS. With SQL Server 2005, it was introduced. It ...

Many new features of SQL Server 2008 have grabbed the headlines in the past year or so but quietly Microsoft has been enhancing SQL Server Integration Services also.

Grzegorz Gogolowicz and Trent Swanson discuss how to work SQL Server Reporting Services and overlay data on report forms.

How to Start SQL in Single-User Mode. Organizations can use SQL Server to reduce downtime, manage and secure databases, and discover patterns in mission-critical information to improve business ...

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.