What we're about
Upcoming events (5)
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.
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.
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
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?