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.

New: We’re now on Meetup!

September Meeting – 25th

Our September meeting saw our Chapter leader Jonathan away, so Annette took the reins for the evening.

Pavol Rovensky led off with a lightning talk on Mocking, telling us how this works in C# rather than SQL Server unit testing.

John Martin then did an impromptu lightning talk on Azure fault domains and availability sets using a pen and a whiteboard!

Rob Sewell then did a talk on the merits of Control-J for Powershell snippets.

Our main talk was from Steph Middleton

Bio:  Steph is a SQL Server and BI Developer working for a SaaS vendor based in Southampton, delivering enterprise class services that integrate with their customers systems. Currently Steph is leading the migration to SQLServer 2012 of a large scale solution using the whole Microsoft SQL Server Stack, making heavy use of Red Gate products to speed the build, test and deployment process.

Abstract:  At HTEC we had a large development team working – simultaneously – on many projects that used the same database back-end. Each project team had their own out-of-sync version of the dev database, and integrating the changes for frequent releases was agonising. We’ll walk through how we managed to get our databases into source control to painlessly manage changes and deployments – and explain the mistakes we made along the way. You’ll learn how to gradually bring your development databases under source control, as well as some of the pitfalls to avoid, and the benefits both in development and deployment.

Steph presenting

Steph presenting to the group

Annette Allen gave a lightning talk on Database Unit Testing.

Terry McCann closed the meeting with a lightning talk on SQL Certifications, bringing us up to date with the latest changes.

A great meeting, and a number of attendees finished off with a meal in Exeter to chew over any left over questions.