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

Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works. Database ...

One of the most useful features in Microsoft's System Center Operations Manager (SCOM) product is its reporting engine. Even though there is nothing overly difficult about its installation process, ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target. Logging is an essential feature for any application, as it is ...

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

At PASS Summit 2017, Microsoft announced SQL Operations Studio to help devs and admins monitor database performance and boost efficiency while Azure picked up a new "compute-optimized" service tier.