Louisville SQL Server and Power BI User Group

Welcome to the Louisville SQL Server & Power BI Users Group!

Our group is generally made up of folks that hail from the Derby City and surrounding Ohio River Valley area, who all have a passion for Microsoft SQL Server and the technologies that surround it. 

We are a diverse group with skills ranging from "accidental DBA's" to senior administrators, seasoned developers to big data analysts and all of the other backgrounds that fall in between.

Do you love to learn? 

Do you love sharing what you know about the complex challenges of working with SQL Server?

Then come join us, and make yourself at home.  

 

Next Meeting

Thursday,

September

14

Getting CI right for SQL Server

This isn’t the dark ages any more. You’ve learned that you need to put your database in source control and you’re competent with source control systems like TFS or Git. You’ve also learned how to express your database in script form using a tool like SSDT, Flyway or Redgate.

However, you haven’t really looked at the build functionality in VSTS yet or gotten to grips with build servers like TeamCity or Jenkins. You still haven’t written as many automated tests as you know you should. Even if you have you aren’t sure how the process should work for SQL Server builds and tests.

In this session I’ll talk through the two most common ways to automate your database builds/deploys and the pros and cons of each. Then I’ll show you how to use tSQLt to build a suite of tests that can be run as part of your build process, giving you confidence in the quality of your code.

Featured Presentation:

Getting CI right for SQL Server

Alex Yates, Director DLM Consultants

This isn’t the dark ages any more. You’ve learned that you need to put your database in source control and you’re competent with source control systems like TFS or Git. You’ve also learned how to express your database in script form using a tool like SSDT, Flyway or Redgate. However, you haven’t really looked at the build functionality in VSTS yet or gotten to grips with build servers like TeamCity or Jenkins. You still haven’t written as many automated tests as you know you should. Even if you have you aren’t sure how the process should work for SQL Server builds and tests. In this session I’ll talk through the two most common ways to automate your database builds/deploys and the pros and cons of each. Then I’ll show you how to use tSQLt to build a suite of tests that can be run as part of your build process, giving you confidence in the quality of your code.

About Alex:
Alex Yates has been helping organisations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins. A keen community member, he co-organises SQL Relay, is the founder of www.SpeakingMentors.com and has been recognised as a Microsoft Data Platform MVP since 2017.

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids