Our pre-conference sessions are now available for purchase! Each session is a full-day, in-depth session on that topic, taught by an experienced instructor. This year, we're proud to present two sessions for you to choose from:
Developing SQL Server Applications that Perform - 31 August 2018 by Greg Low
So many SQL Server applications today are so slow, even simple ones, yet the product is capable of amazing performance, even in tier-1 organizations. Greg spends his life working with SQL Server developers (from the smallest startup software houses to many large tier-1 organizations), working with them to get their applications flying.
In this one-day workshop, you'll learn:
* How SQL Server indexes work
* How data type choices affect index performance
* How to design appropriate table structures and indexes
* How indexing issues appear in query plans
* How to use query plans and other tools to find out why your queries aren't performing as expected
* Where columnstores fit into this picture (where you should and shouldn't use them)
* Where in-memory OLTP fits into this picture (where you can and can't use memory-optimized tables and native compilation)
* How to avoid common application performance design mistakes and anti-patterns that Greg sees regularly
This session is for developers, DBAs, and consultants who need to know how to build better SQL Server applications, and to understand why SQL Server applications are slow.
Register from Here
Creating a Database Deployment Pipeline Using DevOps Processes - 31 August by Hamish Watson
DevOps has revolutionised software development and deployment, where companies have utilised Continuous Integration and Continuous Delivery to improve the speed and quality of their deployed applications in production.DevOps does not just relate to Application Developers. For too long Database Developers and Database Administrators have thought that the efficiencies and gains of implementing DevOps and agile principles are too hard for databases. Data is a key component of any application, changes in a database can affect the whole system, if the database is neglected this can result in it being the weakest link in a deployment pipeline. Because application changes are not being synchronised with the database and the lack of automated versioned changes the efficiencies gained in application deployments can be lost when it comes to deploying to the database.
In this all day training session you will learn the importance of getting your database code into version control, how various tools can be used for automated continuous integration processes that will then feed into an automated release & deployment process for your database.
The demonstrations will take a database based application and deploy it in a Continuous Delivery pipeline utilising industry tools, such as SQL Server Data Tools (SSDT), Visual Studio Team Services (VSTS), Git source control, Octopus Deploy, Docker and the Azure platform. The demonstrations will also showcase some alternative tools that can also help achieve a Continuous Delivery deployment pipeline.
- Module 1 Introduce DevOps principles.
- Module 2 Database Lifecycle Management, source control and connecting a database to it.
- Module 3 Infrastructure as Code, Test Driven Development & Continuous Integration – building databases from code and automating builds using source control.
- Module 4 How to implement Continuous Delivery across multiple staging environments.
- Module 5 Using Containers and Azure in a database deployment pipeline.
- Module 6 Creating a Database Deployment Pipeline with various DevOps tools.
* Understand what DevOps is and how it can improve the quality of your software.
* Understand the challenges of database development using DevOps.
* Understand Test Driven Development and it can be applied to database code.
* Understand how to implement a Continuous Delivery process for databases using industry standard tools.
* Understand how to build a fully automated deployment pipeline with containers.
Register from Here