Featured post

SQL South West User Group

SQL South West is a chapter of the Professional Association for SQL Server (PASS)

PASS Chapter

If you are using SQL Server in any way and are interested in meeting other SQL professionals in the South West then please contact us.

We are a group of DBAs and developers from Cornwall, Devon and Somerset who get together in Exeter once a month to talk about anything related to SQL. If you live or work in the South West of the UK or are in the area on business or holiday then we’d be happy to see you; scroll down or contact us for details of upcoming meetings.

The group is for anyone working with SQL Server or anyone interested in starting to work with it. You may be a full time DBA or developer or someone looking to understand SQL Server things more clearly or maybe you are the guy that didn’t run fast enough when the last DBA left.

March meeting – Tuesday 10th

Our March 2015 meeting is on a changed date – TUESDAY 10th.

We are very pleased to be hosting two American speakers in Exeter at our next meeting. On Tuesday March 10th Sean and Jen McCown will be our guest speakers. Sean and Jen, collectively known as The Midnight DBAs are having a tour of the UK (and its SQL user groups!) and have included us in their route.

We hope to see you there!

February meeting – Thursday 19th

The group is back to its regularly scheduled time slot of the 3rd Thursday (19/02/2015) at 17:30.

This month we have 2 sessions from our group members! As always we will have pizza, followed by drinks in the bar when sessions have finished.

Session 1

Our first session will be from Terry McCann. He will be presenting on reporting on Reporting Services. This session explores some of the ways that you can monitor how your SSRS environment is being used.

Abstract: 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.

Session 2

Then on to a session from another group member Simon Stride. Simon is a senior analyst and will be presenting a session on an introduction to BIML. BIML or Business Intelligence Mark-up Language combines SSIS knowledge with C#/VB coding to enable you to quickly create SSIS packages on they fly. AWESOME!