Reporting Services Changes in SQL 2016
SQL Server reporting services hasn’t changed in what seems like 10 years. The rest of the reporting environment at Microsoft has seen some MEGA changes and it seems like we could use a few updates to the environment. Our guest this episode is Jessica Moss, a data architect and Microsoft MVP. She brings us up to speed on what we can expect in the new version of SSRS and how this ties into the other changes Microsoft is making.
Steve and I also answer a question we got from Episode 49 about when a table variable might actually be a good choice to use over a temp table.
Jessica M Moss is an architect with New Market Corporation in Richmond, Virginia. She is a Microsoft SQL Server MVP and well-known practitioner, author, and speaker in Microsoft SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in the retail, internet, health services, finance, and energy industries. She’s also written technical content for multiple magazines, websites, and technical books. Jessica enjoys working with the Central Virginia community and speaks regularly at user groups, code camps, and conferences.
So those four different groups that we have Microsoft has aligned the four reporting tools with each of those. So your paginated reports will be your Reporting Services. Your interactive reports will be PowerBI and that new product that we have that you were mentioning. We have our mobile reports which will be our SSRS Mobile or also known as DataZen in the past. And then analytical reports and charts will be Excel.
Meet the Hosts
With more than 10 years of working with SQL Server, Carlos helps businesses ensure their SQL Server environments meet their users’ expectations. He can provide insights on performance, migrations, and disaster recovery. He is also active in the SQL Server community and regularly speaks at user group meetings and conferences. He helps support the free database monitoring tool found at databasehealth.com and provides training through SQL Trail events.
Eugene works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.
Kevin is a Microsoft Data Platform MVP and proprietor of Catallaxy Services, LLC, where he specializes in T-SQL development, machine learning, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL, president of the Triangle Area SQL Server Users Group, and author of the books PolyBase Revealed (Apress, 2020) and Finding Ghosts in Your Data: Anomaly Detection Techniques with Examples in Python (Apress, 2022). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.