SQLSaturday 754

Auckland, New Zealand

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on Sep 01 2018 at Unitec Institute of Technology, 139 Carrington Rd, Mount Albert, Auckland, Auckland, 1025, New Zealand

Register Now

 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:

First Preconference

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

Second Preconference

Creating a Database Deployment Pipeline Using DevOps Processes - 31 August by Hamish Watson

In this all day training session you will learn the importance of getting both your application and 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), Redgate SQL Toolbelt, Visual Studio Team Services (VSTS), Git source control, Octopus Deploy, Docker and the Azure platform. The demonstrations will showcase alternative methods that can help achieve a Continuous Delivery deployment pipeline.

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.


  • 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

Event Location

Event news

No Event News entered. Please come back later and check again


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids