Past Meetup

Always Encrypted and the SQL PowerShell Module

This Meetup is past

11 people went

Location image of event venue


Midlands SQL Server User Group - 10th November 2016, 6:15pm

Session 1: Duncan Greaves - Always Encrypted In Transit & At Rest

Session 2: Rob Sewell - PowerShell Loves SQL Server - Community Modules for All


6.15pm – 6:30pm Meet & Greet

6:30pm - 7:30pm Duncan Greaves - Always Encrypted In Transit & At Rest

One of the key features of SQL Server 2016 is the introduction of the Always Encrypted functionality, which allows data to remain encrypted in transit and at rest. This presentation will demonstrate the functionality and explain how this will assist organisations to protect their most sensitive data assets.

7:30pm - 8:00pm Break & Pizza

8:00pm – 9:00pm Rob Sewell - PowerShell Loves SQL Server - Community Modules for All

Prior to June 28th 2016 there were 46 official PowerShell Cmdlets. Then the sqlserver module was released and more come with every release of SSMS every month Lets take a tour through the new sqlserver module and see the new cmdlets in action We will also look at the SQL Server Community Collaborative - an organisation on Github providing superb resources for DBAs. Join me for a demo heavy fun filled tour of PowerShell and SQL Server.

Event Sponsors

Rullion - A big thank you to Rullion ( for providing the catering for this event.


This session will be held at Aston Manor Academy NOT the Midlands Art Centre.


Aston Manor Academy
Phillips Street
B6 4PZ

Parking on site is available through the main gates but is limited. There is also on street parking available opposite.

We will be hiring the main hall ( which located through the entrance doors and to the left.

Other Details

We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know.

Dress code: relaxed

Event Organiser Contact Details

If you need any further details or have any requests for this or future Midlands SSUG events, please contact get in touch.

Alex Whittles
Twitter: @PurpleFrogSys (
Email: [masked]

Paul Andrew
Twitter: @mrpaulandrew (
Email: [masked]

Twitter: @SQLMidlands (

Speaker Profiles

Duncan Greaves was a Leeds based business Intelligence consultant with over 20 years experience in the Banking, Utilities and Healthcare sectors but has decided to give it all up to study for a PhD in Business Resilience and Cybersecurity in the fair city of Coventry. He has a special gift in presenting the finer points of Business Intelligence, Security and Architecture in an engaging and business relevant way.

Rob Sewell aka SQL DBA with a Beard, loves automation and is a big PowerShell evangelist. Many years experience working with SQL Server and a very active member of the community. South West user group organiser, player of cricket for the Bridgetown Exmoor league and all round good egg. Also be warned.... he's a hugger!