This is a homegrown set of speakers from the User Group and Cardiff SQLRelay. Please come along and show your support for these first time speakers!
19:00 Doors open
19:30 Peter Malherbe on Resource Governor
20:30 Andy Wride on 10 steps to great reports
Resource Governor was released in SQL Server 2008 and got me really excited until I released it didn’t help my IO problems. So why do I care now? Simple. Per Core Licensing.
Before SQL Server 2012, servers had lots of processing power and CPU usage was seldom an issue. We had lots of CPU to spare. Now everything has changed and Microsoft wants to license us by the core. What hasn’t changed is that DBA’s are expected to get the best bang for the CIO’s buck, the new dimension to this challenge is doing so with the minimum licensing requirements. In this session we will focus on what types of challenges can be met using the Resource Governor feature and how to identify them using solid metrics.
I’ll share some implementation experiences about virtual and physical server platforms, and some real world implementations where the implementation has made a difference.
Measure twice and cut once. This session is about measuring.
10 steps to great reports
Simple, high level presentation on things to consider when creating reports.
20 years in IT. Started career working for a software house in Reading, providing reports for the motor industry.
Currently working for Finance Wales in Cardiff, concentrating on web front ends, SQL and reporting.
I started my IT career as a C developer working on 16bit banking applications in South Africa. My first serious introduction to enterprise database platforms was Oracle 8i, shortly followed by SQL Server 2000. I have worked on all SQL Server versions from SQL Server 2000 upwards both as a developer and DBA. I am very fortunate to work for an organisation that as part of their commercial offering, builds and hosts SQL Server databases and platforms. Over the last seven years I have been involved in and lead on about 30 solutions, encompassing all aspects of SQL Server, with the notable exception of Analysis Services. I currently head up the DBA team and I am responsible for about forty production Servers and numerous UAT, test and development environments.