#35 - OSLO - Data Saturday

Pre-conference workshop

We are delighted to present our world class precon speakers. We are planning for 3 different precons and the two first is now open for registration.

The workshops will be held on Friday preceding our main event on Saturday and will have the affordable cost of NOK 3000, including lunch, for a full day of high quality learning.

For the precons where we use Eventbrite for ticketing a small fee will be added to the ticket price.

Check out the workshop descriptions below and reserve your seat today.

Mastering Query Tuning with Brent Ozar
The DBA in a hybrid environment with Jess Pomfret and Rob Sewell

Mastering Query Tuning

with Brent Ozar

You need to speed up an existing app, and you’re allowed to change both queries & indexes, but you can’t throw hardware at it. Let’s tackle it together in a fast-paced 1-day version of my full 3-day class, and because we can’t cover everything, attendees get a year’s access to the full 3-day recorded class too.

Query tuning pre-con registration

The DBA in a hybrid environment

with Jess Pomfret Rob Sewell

The role of a DBA is evolving in today's hybrid computing landscape, where applications are deployed on both on-premises and cloud platforms. This training day is specifically designed for DBAs who are required to work in a hybrid environment, where some applications use Platform as a Service databases while others are supported on-premises or on Azure VMs.

We will provide you with a hands-on experience in using automation tooling including PowerShell and community-developed modules such as dbatools, dbachecks, and ImportExcel, to automate many everyday tasks in your estate, whether it is totally on-prem, hybrid, or 100% cloud. You will learn from Jess Pomfret and Rob Sewell, two of the dbatools in a Month of Lunches authors, how to take your Data Platform skills to the next level.

We will also cover the basic concept of infrastructure as code. You will learn how to manage your infrastructure through code, allowing you to automate the provisioning, configuration, and management of your SQL Server instances and PaaS services. You will also see how this approach can improve the reliability and consistency of your environment, reduce errors, and increase the efficiency of your operations.

Finally, we will touch on how you can use GitHub Actions or Azure Functions to automate your workflows and integrate with other tools in your environment. You will learn how to create workflows that trigger when specific events occur, such as a new pull request or a database schema change and automate the execution of scripts or the deployment of changes to your SQL Server instances. This approach will help you streamline your operations, reduce manual intervention, and improve the overall quality of your work.

Overall, this training day will provide you with a comprehensive set of skills to manage your hybrid SQL Server estate. There are many tools for you to add to your toolbox and we’ll show you how to get the most out of your available time and effort by utilising PowerShell, a collection of community-written modules with some CI\CD tools mixed in.

Whether you are a senior or junior DBA, a developer who interacts with SQL Server, an accidental DBA, or someone with DevOps in your job title, this training is for you. You will improve your PowerShell skills for SQL Server and reduce the time you and your team spend administering SQL Server. You do not need any specific equipment or tools for this training, but we recommend bringing something to take notes with. All scripts and slides will be provided to you, and you will have the opportunity to follow along with most of the demos on a machine that can run Docker or with PowerShell v5 or above and a SQL Server 2012 or above instance.

Join us for a wonderful day of PowerShell and SQL, full of demos and useful solutions that you will be able to take back to your workplace.

Hybrid DBA pre-con registration

Code of Conduct

All attendees, speakers, sponsors and volunteers at our conference are required to adhere with the following code of conduct. Organizers will enforce this code throughout the event. We are expecting cooperation from all participants to help ensuring a safe environment for everybody.

The Short Version

Our conference is dedicated to providing an enjoyable environment for everyone involved. Thus providing a harassment-free experience for everyone, regardless of gender, gender identity and expression, age, sexual orientation, disability, physical appearance, body size, race, ethnicity, religion (or lack thereof), or technology choices. We do not tolerate harassment of conference participants in any form. Sexual language and imagery is not appropriate for any conference venue, including talks, workshops, parties, Twitter and other online media. Conference participants violating these rules may be sanctioned or expelled from the conference without a refund at the discretion of the conference organizers.

The organizer of this event will prioritize marginalized people's safety over privileged people's comfort.

The Less Short Version

Harassment includes offensive verbal comments related to gender, gender identity and expression, age, sexual orientation, disability, physical appearance, body size, race, ethnicity, religion, technology choices, sexual images in public spaces, deliberate intimidation, stalking, following, harassing photography or recording, sustained disruption of talks or other events, inappropriate physical contact, and unwelcome sexual attention.

Participants asked to stop any harassing behavior are expected to comply immediately.

Sponsors are also subject to the anti-harassment policy. In particular, sponsors should not use sexualized images, activities, or other material. Booth staff (including volunteers) should not use sexualized clothing/uniforms/costumes, or otherwise create a sexualized environment.

If a participant engages in harassing behavior, the conference organizers may take any action they deem appropriate, including warning the offender or expulsion from the conference with no refund.

If you are being harassed, notice that someone else is being harassed, or have any other concerns, please contact a member of conference staff immediately. Conference staff can be identified as they'll be wearing branded shirts.

Conference staff will be happy to help participants contact local law enforcement, provide escorts, or otherwise assist those experiencing harassment to feel safe for the duration of the conference. We value your attendance.

We expect participants to follow these rules at conference and workshop venues and conference-related social events.

Original source and credit: http://2012.jsconf.us/#/about & The Ada Initiative
Please help by translating or improving: on github.com
This work is licensed under a Creative Commons Attribution 3.0 Unported License

Milestones

Pre-conference workshop

Venue

Schedule

Sponsorship Benefits

Sponsors

Speakers

Volunteers

Code of Conduct

The Short Version

The Less Short Version

Contact