Nottingham SQL Server user group March Meeting

Details

This months speakers and sessions are:

Rich Benner will be talking about Scrapeing Reddit for Testing Data using SQL Server and Python:

You’re lucky enough to have Test environments but you don’t want to spend forever creating test data to use (because you’re not using live data right?). Let’s use SQL Server with Python to scrape data from Reddit to fill those tables.

We’ll go through;

1. What you’ll need installed to use Python with SQL Server.
2. Basics of the Python language (You don’t need to know Python in advance)
3. The python libraries we’ll use
4. I’ll give you the code and walk through it
5. I’ll then show you how you can apply this in your environment.

And our second speaker is Phil Grayson with "Standardise, optimise and streamline your SQL Server estate"

Summary

The Community Edition of Aireforge Studio is a free tool that focuses on making estate management simple. Learn how to compare configurations, users, settings, jobs and more, between 2 or 2000+ instances of SQL Server and Azure SQL Database. Also learn how to quickly document the configuration of your estate and how this process can be used to store point in time snapshots with reports and tests that can be viewed or compared against later. Finally, the talk will cover how these tasks can be automated for alerting and integrated into build or deployment pipelines.

Bio

After spending 14 years creating one of the world’s largest central healthcare systems, Phil Grayson (@databoffin) now works as a consultant for xTEN, where his varied but in-depth experience has helped to transform IT systems worldwide. Phil is a proud Friend of Redgate, Chief Ticket Creator at Aireforge, organiser of Data & Gravy, Leeds SQL User Group and a frequent volunteer at SQLBits.

We'll be in the Golding Room, which is down at the left end of the bar. If you want to grab dinner feel free to order at the bar and they'll bring it in when it's ready

We'll be kicking off at 18:30 with Speaker 1, quick break about 19:30 to grab snacks and drinks, and then speaker 2 starting about 19:45. Times may move around but we aim to be done by 21:00.

More details to follow