Let’s Pick Up Where We Left Off Last Month with MDX Applications
Last month, Paul introduced fundamental Analysis Services solution concepts, briefly explored the cube space and then moved to a progressive demonstration showing creative query techniques using MDX. But what will you do with this learning in the next month? You can get started and apply this knowledge today. In this session, we learn to solve real problems and apply MDX query techniques to real business reporting needs that everyone can use right away. I will show you how to build an analytic report in SSRS with parameters and drill-through actions.
I’ll also show you how to transform a working MDX query into an interactive mobile dashboard using Microsoft DataZen.
Paul (Blog | LinkedIn | Twitter) is a Mentor with SolidQ and a Microsoft SQL Server MVP. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to visualize and deliver critical information to make informed business decisions. He is a Director of the Oregon SQL PASS chapter & user group, the lead author of Professional SQL Server 2012 Reporting Services and 13 other titles from Wrox, Packt & Microsoft Press.
Auditing in SQL Server
The flexible auditing built into SQL Server can be at the instance level or database level, and the audit events can be written to the event logs or audit files. In this session Rob will give an introduction to auditing, explain the hierarchical structure of SQL Server auditing, and demonstrate it by creating an audit (or two).
Rob (LinkedIn | Twitter) is a Database Administrator, Developer, Consultant and Microsoft Certified Trainer. Rob has very broad knowledge that spans from software development to systems administration, and has a deep knowledge of SQL Server. Rob has worked with SQL Server since version 6.5, and has supported environments with hundreds of SQL Servers, and databases as large as 100 TB.
Refreshments graciously provided.
Featured Sponsor: Redgate
Visit our website for more details.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.