addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1linklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Resource Governor and 10 steps to great reports

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:15 Pizza

20:30 Andy Wride on 10 steps to great reports

 

Resource Governor

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.

 

Andy

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.

 

Peter

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.

Join or login to comment.

  • Andy W.

    Enjoyed the evening...well looked after and as always learnt something new.

    November 1, 2013

  • Peter D.

    Most informative - am looking forward to reviewing the presentation at leisure.

    November 1, 2013

  • Peter M.

    The Reporting presentation provided surprising and interesting depth as to the consideration that is required by a developer in an environment that necessitates prescription for the information worker. Good presentation by a first time speaker.

    The resource governance presentation could have used a code implementation piece or two in order to demonstrate how resource governance is implemented and the management views could have used a mention. The introduction was a little unbalanced and rushed, however not a bad first attempt. Well done me.

    1 · November 1, 2013

  • Stuart M.

    Think I should probably say I'm coming.....

    June 19, 2013

9 went

Our Sponsors

  • O'Reilly

    Book discounts - use DSUG at the checkout for up to 50% off

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy