SQLNorthEast SQL Server User Group (@sqlne)

Next Meeting

Monday,

June

26

SQLNorthEast and R NorthEast UG, Monday 26th June with Steph Locke

  • In-Person @ Armstrong Building Newcastle, Tyne and Wear, United Kingdom (map)
  • 09:00 - 20:30 GMT Daylight Time
  • Language: English

Monday 26th June sees us doing something a bit different. A combined effort of the R North East and SQLNorthEast usergroups is bringing Steph Locke to Newcastle for both a full day (half day tickets can also be purchased) Introduction to R workshop followed by a combined Usergroup in the evening – both at Newcastle University.

Tickets for the full day workshop can be purchased on Eventbrite and will cost a measly sum of £90 which is ridiculously cheap when you think of what you are getting for your money! Half days are available for those that cannot make a full day and discounts are being offered to students and those working for a charity.

The evening brings us all together for a combined Usergroup with the session being “Data + Docker = Discombobulating?” - registration can be found at attending.io. A list of other upcoming R North East events can also be found at rnortheast.github.io

 

We are rapidly approaching the half way point in the year and we are currently finalising the speakers for the rest of the year and will be providing updates hopefully in the next few weeks but below is the proposed schedule. Due to sqlpass website restrictions we cannot display all the dates for 2017 but a quick search on Eventbrite will give you the relevant details for future events

 

The dates are as follows:

Date

Speaker(s)

Session

Wed 25th January

Alex Yates

Database version control and deployment: model or migration scripts?

Alex Yates

Database DevOps anti-patterns rant

Tue 7th March

Rob Sewell

Green is good, Red is bad – Turning your Checklists into Pester Tests

Rob Sewell

PowerShell dbatools / SQL Server module

Thur 25th May

 

Malcolm Smith

Getting “dirty” with the Data Science Professional Project

Chris Taylor

Emil Glownia

Introduction to Containers

Is Power BI a replacement of a Data Warehouse?

Mon 26th June

(R-North-East joint venture)

Steph Locke

Intro to R - Full day workshop

Steph Locke

 

Data + Docker = Discombobulating? (UG)

 

Tue 11th July

Stuart Moore

Indexing Nightmare - Cut through the clutter

Stuart Moore

Automating SQL Server Restores with PowerShell

Tue 12th September

Tobiasz Koprowski

TBC – Likely to be SQL Azure for Dummies

Tobiasz Koprowski

TBC – Likely to be How to use Azure Service for increasing security for your platform

Tue 21st November

Chris Adkin

TBC – Likely to be something brain melting

Chris Adkin

TBC - Likely to be something brain melting

Featured Presentation:

Intro to R (Full Day Workshop)

Stephanie Locke, Lead Data Scientist CensorNet

This hands-on day is designed to get people up to speed with some of the fundamentals of R. Split into two halves you can learn the very basics in the morning and then progress into working with databases and making your code reusable in the afternoon. Attend one or both halves of the day, depending on your current experience with R and what you'd like to learn. • R objects • R coding – traditional and pipelines • Table wrangling • Producing charts • Working with statistical functions • Read and writing from databases • Writing R functions • Writing R packages

About Stephanie:
Steph Locke (@SteffLocke) does a lot of stuff in BI and analytics, from building snazzy Azure 6NF data warehouses to developing R web services. On top of the cool day job, in her spare time she runs user groups, organises conferences, and she speaks wherever people will let her. For all that craziness she was awarded an MVP.

Data + Docker = Discombobulating? (Evening Usergroup)

Stephanie Locke, Lead Data Scientist CensorNet

If you’re like me, you like your data to stick around for a long time and most importantly you want to know it’s safe. In the Docker world, there’s the maxim of “never patch”, always make a new container with the latest version of the application. If we’re sticking in our database in a container like Microsoft are doing with SQL Server now, what happens when we need to apply the latest patches? Will we lose our data? In this talk, we’ll look at the sorts of data we need to think about (it’s not just databases!) and how Docker containers work. We’ll then look at how we can save our data from disappearing when we load a new version of our Docker container. Once we know how to safeguard ourselves, we’ll look at some of the architectural options you have when working with data and Docker.

About Stephanie:
Steph Locke (@SteffLocke) does a lot of stuff in BI and analytics, from building snazzy Azure 6NF data warehouses to developing R web services. On top of the cool day job, in her spare time she runs user groups, organises conferences, and she speaks wherever people will let her. For all that craziness she was awarded an MVP.