Bearded wonders are descending on Cardiff to allow you to bask in the awesome glow of their knowledge and luxurious face warmers. Come along to find about powershell, SSRS, and azure sql databases!
6:30 - Doors open / Pizza
7:00 - Tobiasz Koprowski: Windows Azure SQL Database - Tips and Tricks for beginners
8:00 - Break
8:15 - Terry McCann: SSRS Inception
8:45 - Rob Sewell: Powershell for your team
SSRS Inception: Reporting on Reporting services.
Still using Reporting Services? Yeah me too! Does this scenario sound familiar? You already have a large SSRS environment but the users still want more reports. You create a new, all singing, all dancing dashboard that removes the need for a bunch of reports, awesome. You launch it and explain to the business that you are deprecating the old reports. "WAIT! We still need that for Jill in HR to do her end-of-month", or "We might still need that" - these types of comments are what leads to having a load of reports that are not being used.
Wouldn’t it be great if you could see who is viewing a report, in what format and how often, all inside your current SSRS environment? With this data wouldn’t it then be even better if we could automate a process to email the owner of that report to say "HA! I told you no one looked at this report!". In this session we will look at how we can do all of this and more by mining the SSRS DB.
Making PowerShell useful for your team
You have heard about PowerShell and may be spent a little bit of time exploring some of the ways in which it will benefit you at work. You want to be able to perform tasks more specific to your organisation and need to share them with your team. I will show you how you can achieve this by demonstrating
- An easy way to learn the syntax
- How to explore SQL Server with Powershell
- How to turn your one off scripts into shareable functions
- How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions
- Where else to go for help