Subject: Microsoft SQL Server 2016 for DBA & BI – part 1
For: IT management, SQL Server experts, IBM or Oracle users and all other database savvies …
How do you optimize your SQL Server Queries? Have you ever had issues with queries after executing a plan? Not sure how to fix these problems? Query Store is a game changer when it comes to detecting and identifying query performance problems. It is the new trouble shooting tool for SQL Server 2016 which analyses your SQL Server queries and their performances. Query Store is a database inside SQL Server 2016 which stores all information on your queries’ performance. It gives you a unique view into the history of all your queries, making it very accessible to thoroughly analyse your query performance. Find out how to use Query Store for your SQL Server 2016 in our webinar replay.
What’s new in SQL Server 2016 for BI? With the 2016 version of Integration Services we have a number of new features, including better debugging thanks to more enhanced column identification, a wider range of components on the level of Connectors/Tasks and easier deployment to a centralised SSIS catalogue when using Always On. Highly requested and now available in SQL 2016 for BI is the support of previous SQL Server versions. HTML5 rendering engine, customized parameter pane and the Mobile Report Publisher are just some of the new elements incorporated into the Reporting Services. Explore all new features in our webinar replay.