Free

SQL Soton UG Meeting - July 5th, 2017

Event Information

Share this event

Date and Time

Location

Location

2 Venture Road

Chilworth

Southampton

SO16 7NP

United Kingdom

View Map

Friends Who Are Going
Event description

Description

Welcome to Southampton SQL Server User Group, this event is hosted at 2 Venture Road, Southampton Science Park near Chilworth. When entering the Science Park, turn off the A27 onto Univeristy Parkway. Not Manor Road.

Please be aware that in order to attend we need you to register in advance as there is limited space and we need to know how many people to order pizza for, thanks :-)

We have a couple of great speakers covering different SQL Server based topics along with a number of prizes to give away and free pizza during the break.

Agenda

18:15 - Doors Open

18:30 - Introductions

18:45 - James Anderson - SQL Server & Continuous Integration

How do you know your database change won’t affect something you haven’t thought of?

Database objects can have many dependant objects in the database and in the application. Keeping track of these dependencies can be difficult, especially if the database is used by multiple applications or services.

The first step is to have a project for the database and get it into source control.

Source control is the single source of truth that all deployments should be kept in sync with. Source controlling the database also acts as the foundation for automation of:
Builds
Tests
Coverage Reports
This automation is key to the Continuous Integration methodology. After every commit, builds and tests will run in the background and only alert if there is a problem. Builds test the deployment of the change and tests check that everything affected still works. Coverage reports indicate any gaps in the testing suite.

The tools I use to make this possible with SQL Server are:

Redgate’s ReadyRoll plugin for Visual Studio to build migration scripts
GitLab for source control and project management
tSQLt for unit tests
SQL Cover for unit test coverage reports
By the end of this session I hope you will see how a CI approach to database development can remove the unknowns from deploying database changes.

19:45 - Break

20:15- Callum Green - Power BI: Performance Tips & Tricks

Thanks to the rapid, community-driven release cycle, Microsoft Power BI has caught and overtaken many visualisation tools and now sits alongside Tableau at the top of the Gartner Magic Quadrant for 2017. It is fast becoming the first-choice reporting tool for both small and large organisations.

However, as with all reporting tools, if the underlying data model is badly designed or custom measures/calculations are poorly written, performance can really suffer. Whether you are designing the front-end for a carefully crafted warehouse, or performing an ad-hoc analysis exercise, you can follow some best practice advice to ensure you’re getting the best out of your reports.

This 1 hour session will introduce and demonstrate several design tips and tricks to produce slick, fast dashboards. These will range from quick development wins to more strategic, enterprise considerations. The session also aims to explain ad-hoc transformations within the Query Editor and demonstrates best practices for encouraging Query Folding. This session is designed for all levels of Power BI expertise.

21:15 - Prize Draw & Close

Sponsors

A massive thanks to our sponsors, without them we would not be able to host this event for free.

SpectrumIT

Pluralsight

Redgate

SpectrumIT kindly provide funding for the room pizza and a £20 Amazon Voucher.

Pluralsight kindly provide two one month free passess to their Excellent training content.

Redgate kindly provide swag, licenses and help source speakers.

Share with friends

Date and Time

Location

2 Venture Road

Chilworth

Southampton

SO16 7NP

United Kingdom

View Map

Save This Event

Event Saved