The objective of this course is to provide senior database analysts, developers or database administrators with a good understanding of SQL Server Architecture and Query Performance so that applications and their supporting environment can be tuned for optimal performance. The course will provide delegates with the knowledge required to size, plan, monitor, tune and troubleshoot a SQL Server application for either a OLTP live environment or a OLAP data warehousing environment. Everything from Operating System and SQL Server service tuning through to query and index tuning will be covered. It is a hands on course with performance and analysis tools being put to use throughout. Delegates will learn how to capture and analyse performance data to enable troubleshooting of performance problems using tools such as Performance Monitor, SQL Profiler, Extended Events and Dynamic Management Views. They will learn how to interpret query execution plans to determine where the cause of bottlenecks lies and how to tune the queries for best performance.
Covers SQL Server 2005, SQL Server 2008, SQL Server 2012 and SQL Server 2014.
Introducing SQL Reporting Services (SSRS)
Who Uses SSRS?
Dashboards, Reports and Applications
Business Intelligence Reporting Solutions
Reporting Services Installation & Architecture
The Basic Installation
The Enterprise Deployment
The Reporting Lifecycle
SSRS Tools: Report Designer, Power View, Report Builder, Report manager, SharePoint Libraries, Reporting Services Configuration Manager, SQL Server Management Applications