SQLSaturday 754

Auckland, New Zealand

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. 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

Description:

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

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.

Modules:

  • 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. 

Goals: 

* 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

Contact

Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us


What is SQLSaturday?

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, and most costs are covered by donations and sponsorships. At some events you will have the option to pay for lunch at the time of registration. Please register soon as seating is limited, and let friends and colleagues know about the event.

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