What we're about

This user group is a meeting place for everyone interested in or working with Azure Data and the Microsoft Data Platform. Topics span from the core SQL Server engine, to Power BI, to cloud services in Azure - and everything in between! Our goals are to share knowledge, present new technologies, discuss and socialize. Whether you are a database administrator or database developer, a business intelligence professional, or a student: you're welcome to join us! :)

Code of Conduct

All attendees, speakers, sponsors and volunteers are required to agree with the following code of conduct. Organizers will enforce this code throughout all meetups. We expect cooperation from all participants to help ensure a safe environment for everybody.

The Quick Version

Our meetups are dedicated to providing a harassment-free meetup 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 meetup participants in any form. Sexual language and imagery is not appropriate for any meetup venue, including talks, workshops, parties, Twitter and other online media. Meetup participants violating these rules may be sanctioned or expelled from meetups without a refund at the discretion of the organizers.

The Less Quick 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. Staff (including volunteers) should not use sexualized clothing/uniforms/costumes, or otherwise create a sexualized environment.

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

If you are being harassed, notice that someone else is being harassed, or have any other concerns, please contact a meetup organizer immediately.

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

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

Upcoming events (5)

SQLSaturday Precon: "Speed up DB performance with Service Broker" by Allen White

Please note: You must register for this event via Eventbrite: Registration (https://sqlsatoslo2019servicebrokermagic.eventbrite.com/?aff=mdpugmu) Speed up database performance with the magic of Service Broker with Allen White Description Level 300 - Intermediate Remember when your application was new and shiny? All queries finished execution instantly and not a single performance issue in sight. All was well with the world. Roll forward to today, your application has a lot more users than you started with and you experience concurrency issues due to resource contention. Just as common you have a few of those “problem”-tables. Yeah, you know them. The now very large tables which have historic data where maybe only 5-10% is actually used on a daily basis and you have exhausted the possibilities to performance tune more with indexes, but management says that we cannot purge the historic data. What to do? Enter the magic of Service Broker! With Service Broker it gives you the ability to architect near real-time solutions to archive production data to a repository database, or to a data warehouse, allowing you to purge older data from your critical database and keep performance at its peak. For resource contention scenarios you can, without redesigning your database architecture, offload non-critical updates to run asynchronously. Service Broker provides the means to send the necessary data in messages to a separate process, which can run the updates as when resources are available. In this full day of training we will: Look at real-time solutions for archiving production data See how you can reduce resource contention by offloading non-critical updates Configure Service Broker for high availability using Availability Groups Using Microsoft’s External Activator service to automatically run .NET programs when Service Broker messages are sent. Are you ready to open up your eyes for the magic of Service Broker? Come and join me on Thursday 29th August in Oslo.

SQLSaturday Precon: "Azure Data Factory Deep Dive" by Cathrine Wilhelmsen

Please note: You must register for this event via Eventbrite: Registration (https://sqlsatoslo2019adfdeepdive.eventbrite.com/?aff=mdpugmu) Azure Data Factory Deep Dive with Cathrine Wilhelmsen Description Level 300 - Intermediate With the ever-increasing volume, variety, and velocity of data, it can feel like a daunting task to create and maintain modern data integration solutions. This full-day workshop will arm you with the skills you need to build and orchestrate hybrid, complex and scalable data pipelines using Azure Data Factory (ADF). We will start with a conceptual overview and cover the fundamentals of Azure Data Factory, including source control, security, and pricing. Then, we will build a metadata-driven solution to move data between on-premises and cloud sources. As we evaluate different design patterns and architectures for big data pipelines and modern data warehouses, we will continue to improve on our solution to make it more robust, dynamic and reusable. We will dive deep into the newly released Mapping Data Flows capability, and look at how to leverage SSIS lift and shift to gradually modernize existing solutions while retaining investments already made. Finally, we will configure monitoring, logging, and alerting, as well as review options for CI/CD using Azure DevOps. If that's not enough content for one day, you will also get access to a set of hands-on labs that you can work through at your own pace. Whether you are new to Azure Data Factory or have some experience, you will leave this workshop with new skills and ideas for your projects.

SQLSaturday Precon: "BI in the cloud [...]" by Alexander Klein & Gabi Münster

Please note: You must register for this event via Eventbrite: Registration (https://sqlsatoslo2019biinthecloud.eventbrite.com/?aff=mdpugmu) BI in the cloud on the menu – Select your dish of the day with Alexander Klein & Gabi Münster Description Level 300 - Intermediate You are already using a BI solution and are interested in moving into the cloud? Or a BI solution is on your roadmap and you are not sure if cloud or on-prem is the right strategy for you? Then choose this session to gather new ideas and real-life experiences. We will cover possibilities and challenges of the following topics: Overview of the current services in Azure and why you might need to rethink your solution ETL in Azure with Azure Data Factory, Logic Apps, Stream Analytics and Data Gateway for on-prem data sources Data Warehouse in Azure MPP, Polybase and the Analysis Services Data Mining / AI with Cognitive Services and Azure ML Reporting in Azure with Power BI + Reporting Services Look into possibilities for maintenance and automation Prerequisites Basic knowledge in databases, analysis services (tabular model), ETL process A prior knowledge of traditional data warehousing is assumed, but not strictly necessary

SQLSaturday Precon: "Succeed with DevOps as a DBA" by Grant Fritchey

Please note: You must register for this event via Eventbrite: Registration (https://sqlsatoslo2019devopsdba.eventbrite.com/?aff=mdpugmu) Succeed with DevOps as a DBA with Grant Fritchey Description Level 300 - Intermediate I love DevOps. I love DevOps the most because of its focus on automation. The key to understand DevOps is to grasp that it is your communication and environment that is important, not tooling alone, though tooling plays a factor. One of the reasons I love DevOps so much is because I’ve done it successfully. I’ve worked on teams that built fully automated deployment mechanisms to get code from Dev to Production. Further, we automated the creation of dev & test servers. We automated the creation of production servers too. We automated the heck out of everything. Automation frees you from drudgery. Instead of having to do dull work, you automate it. Now, your time frees up to do other things and those other things will absolutely fill your time. You’ll be tuning, designing, troubleshooting, all new and better databases. Automation removes thoughtless, repetitive tasks. It replaces them with tasks that require thought, that aren’t repetitive, that are more challenging and more interesting. Moving from manual processes for development and deployment to a more automated approach requires a great deal of work and knowledge. In this all day seminar we will go through the steps to help you along this journey. We will start with understanding how source control works and end with automated deployments across environments You’ll learn about processes and tools that not only make it easier and faster to move database changes, but add protection to your production information. We will discuss tools, process and the fundamental changes in culture necessary to take your database development and deployment into a high functioning DevOps team. So, wanna join me and learn how to get your databases into a DevOps process?

Past events (64)

DataGrillen vorspiel with Jeroen Bosems and Rune Ovlien Rakeie

Photos (52)