SQL Server Reporting Services

SQL Server 2019 reporting services (SSRS)

What are SQL reporting services?

SQL reporting services is a platform created by Microsoft that offers a collection of on-premises tools and services that install, create, and manage paginated reports. These reports are paginated because they’re formatted to fit perfectly on a page and can be consumed in web browser on your computer, mobile device or through email.

SQL Server 2019 reporting services: History

Reporting Services was released back in 2004 and was added to SQL Server 2000. After the release of the first version several others have been released in line with the release of new SQL Server versions:

  1. Second version was released in November 2005 when SQL Server 2005 was released.
  2. Third version was released in April 2010 when SQL Server 2008 R2 was released.
  3. Fourth version was released in March 2012 when SQL Server 2012 was released.
  4. Fifth version was released in March 2014 when SQL Server 2014 was released.
  5. Sixth version was released in March 2016 when SQL Server 2016 was released.
  6. Seventh version was released in October 2017 when SQL Server 2017 was released.
  7. Eighth version was released in November 2019 when SQL Server 2019 was released.

SQL Server 2019 reporting services: features

  1. Power BI Premium dataset support: by using SQL Server Data Tools (SSDT) or Microsoft Report Builder users can connect to Power BI datasets. By using SQL Server Analysis Services connectivity users can publish theses reports.
  2. AltText support for report elements: when writing reports, users can apply tooltips so each element that’s on the report comes with specific texts.
  3. Azure SQL Managed Instance support: hosting a database catalog in Azure SQL Managed Instance (MI) through your datacenter or a VM is now possible.
  4. Custom headers: 

SQL Server 2019 reporting services: Security

SSRS comes with extensive authentication protection for your device. Indeed, the use of channel and/or service binding channels to enhance device authentication supported here.