Sheffield Data Analytics User Group - Meeting #7

Meetup #7 at Electric Works (in front of the coach station and just up the road from the central train station).
Doors open from 5:30 to give you time to grab a drink and chat to fellow attendees. Talks running from 6 and a break for food provided by sponsors Simpsons Associates.

Session 1: Chris Johnson - Visual Studio database projects more than just source control

Visual Studio database projects (or SSDT projects) are often compared to other source control systems, and usually found wanting. They are a bit clunkier, and require a developer to jump through more hoops to achieve the same results as they could with another product.

However, this is largely because they are not just designed as a source control tool. In fact, I would argue that this is not even their primary purpose in a development lifecycle.
In this session I will take you through some of the additional benefits you get from using Visual Studio database projects to manage your code base. These include: easy refactoring, code validation, adding comments to objects like tables, and the ability to componentise or modularise your databases.

Session 2: Andrew Edge & Barney Lawrence - One SKU, Two SKU, Old SKU, New SKU. Fabric Capacities and You!

Those guys from Seattle made a service called Fabric.
It does lots with data and we all think it's magic.
But there are some aspects where people get lost.
For example when asking "How much will it cost?"
Will your dev and production teams keep up their smile,
If you buy your compute in one great big pile.
Perhaps you will find there's a comfier fit,
if every department's service is split?
If I start off with one and then buy a new SKU,
Do I have one lake or do I have two?
Can you save lots of money get a round of applause?
If at the weekends your compute you do pause?
Do I need F2 or will I need more?
What is so special about F64?
Should we share it with others will performance be hit,
When someone writes code that's a little bit...
sub-optimal?
There's no one solution for a Fabric adoptions,
but once we are finished you'll know all the options.
When we've shared with our demos and shared with our voice,
you can all head for home set to make a good choice.

Close by 8:30 with a chance to continue conversations at the Sheffield Tab by the train station.