An introduction to the principles that underpin DevOps and the practices that are derived from those principles. This session is mostly theoretical, although it finishes with a brief overview of an Azure DevOps pipeline.
Unit testing with databases is fairly new and is not yet embraced within database development. We'll learn how we can implement setup a database project, implement basic unit testing with tSQLt
This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR).
Tabular Editor is an open source offline editor experience for SSAS Tabular, which offers lots of features in a simple UI that can vastly improve your productivity when developing Tabular Models at compatibility level 1200+
Using SSDT and VSTS to reliably build, test, and deploy SQL Server databases in the cloud and in the datacentre.
DevOps and continuous integration provide huge benefits to data warehouse development. John will be showing how you can use VSTS and Octopus Deploy to build, test and deploy your data warehouse
Ever wondered if you can optimize your sql projects so you don't have to do unnecessary work? Take a look at how I've optimized SSDT Deployments by use case.
In this session, I'm going to show you six amazing tools that must be in your developer/consultant toolbelt. These tools help you develop, manage, monitor and optimize your Tabular model, in other words, it makes your day to day job easier.
Continuous Integration is not normally associated with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply Continuous Integration techniques to data warehouse projects
Join us in this session to learn about recent improvements and the ongoing work made to SSDT. This session gives you a chance to directly connect with the product team and get their insights.
Have you managed to implement, or are you struggling to implement, automated deployments for your databases, but keep hitting problems? Database deployments are complex - we look at the common problems.
Ever wondered if you can optimize your sql projects so you don't have to do unnecessary work? Take a look at how I've optimized SSDT Deployments by use case.
T4 templating will be a first class citizen in SSDT for SQL Server 2014. This session will show why you should use this technology for SQL code generation and how you can automate the process. The session will be demo rich.
So you have heard of SQL Server Data Tools (SSDT), you have started using it but not entirely sure how to use it to it's full potential. This session is perfect for adopters of SSDT and how to get the most out of it.
SQL Server Data Tools (SSDT) provide a new declarative model for building SQL Server databases. Come and learn more from Craig and Jamie who have both been using SSDT to do that for many months.
Declare how you want your schema to look like, not how you want to implement it. Using the SQL Server Data Tools, you define your database schema in a declarative form and deploy it as such!
This demo intensive session will show off the new features and enhancements designed to ease adoption for new users and increase productivity for experienced SSIS developers
Learn how the SQL Server Data Tools can help you migrate your on-premise SQL Server databases to SQL Azure