PASS Data Community Summit Pre-cons

This year PASS Data Community Summit is a free virtual event, and I encourage you to register even if you are interested in just a handful of sessions. One of the Learning Pathways might be just what you are looking for, from Query Basics to Power BI to DevOps.

What I’m most excited about this year are the pre-cons. Because they are virtual, there are no costs for session rooms, lunch, etc. The price for each is a low $200. It’s a ton of work building an all-day class, so I’m thrilled that the speakers will get all the proceeds.

Whether you are starting your career, switching to a new one, or building advanced skills that can help you today, there is something for everyone.

As a trainer of quite a few new DBAs over the years, I am really excited about Denny Cherry’s Database Administration for the Non Database Administrator. So many of us – myself included – started out as “accidental” DBAs. No one knows more about getting the most out of SQL Server than Denny, so this should be a wonderful session for new DBAs or anyone who wants to be a DBA.

If you can attend both days, some pre-cons go together nicely. Bob Ward and Ajay Jagannathan from Microsoft are giving Migrate SQL Server to Azure. Bob and Ajay have the inside story about what tools to use and the best way to migrate. The next day, Tracy Boggiano is presenting Azure SQL Fundamentals. Tracy has real-world experience migrating to Azure. She knows what can go wrong and how to avoid the issues. These sessions complement each other well, and you will gain all the tools you need to migrate to Azure after attending these two days!

Suppose you have already migrated but have some issues with deployments. In that case, Rob Sewell has the answers for you in his Control your Cloud Data Deployments - Deploy your Azure Data Solutions with Bicep and Azure DevOps session.

Monica Rathbun’s SQL Server Performance Tuning and Optimization pre-con will take you from identifying performance problems to how to solve them. The next day, Erin Stellato’s Finding Problems and Stabilizing Performance with Query Store will take your skills to the next level as you learn how to take advantage of tools and features that are part of SQL Server like Query Store and Intelligent Query Processing.

On Monday, Itzik Ben-Gan is presenting Advanced T-SQL Querying and Query Tuning. Itzik will cover the many T-SQL features added over the past few versions that have made querying easier and perform better. On Tuesday, Kimberly L. Tripp will give Solving Query Performance Problems with Statistics. This is an excellent session for anyone with query performance issues that are difficult to figure out!

If you are interested in analytics, there are several pre-cons from which to choose:

• Ginger Grant is presenting Developing Data Solutions with Python and Apache Spark in Azure Synapse Analytics
• Steph Locke is giving The Latest Data Science Workflow in Azure
• Learn Power BI with Angela Henry’s Zero To Dashboard

There’s one more that I’d like to mention. Blythe Morrow will give Master Communication and Influencing Skills. We can all benefit from this pre-con from better emails, getting your ideas heard in meetings, and negotiating a pay raise.

There is something for everyone at PASS Data Community Summit. Register today, and be sure to find the pre-con that is right for you!

Kathi Kellenberger

Join the debate, and respond to the editorial on the forums

This post is a reference post for retrieving IO st...

Understanding SQL Server database compatibility le...

Link Up This post is links to a series of articles that it’s a shame more people haven’t seen, because they describe why some index builds/rebuilds take a lot longer...

This article covers an overview of SQL Server logs...

What happens if you have a SQL Server that was ini...

In my last post, we created a DACPAC in SSMS. Now,...

These are my SQL Server Diagnostic Information Queries for October 2021, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a short amount of time. These are my SQL Server Diagnostic Information Queries for October 2021...

How to deal with connect to remote SQL Servers wit...

In this tip we provide queries you can use to get ...

It’s not difficult to set up an extended event session, but reviewing and saving the data can be complex. In this article, Edward Pollack demonstrates how to collect extended...

Here are some really common questions I get: How many CPUs does ServerA have? How much memory does ServerA have? ... Continue reading

Use SSMS to quickly find errors in your T-SQL code by double clicking on the error message and SSMS will bring you right to that line of code.

This article gives an insight into the configuration of Min and Max memory for SQL Server Database instances. Introduction The server performance depends on various factors such as CPU,...

In this article, we will learn how to establish su...

Azure Purview lets you govern Azure SQL Databases ...

Today and every Wednesday Data Exposed goes live at 9AM PT on LearnTV. Every 4 weeks, we’ll do a News Update. We’ll include product updates, videos, blogs, etc. as...

Now that we have a Managed Instance built, the nex...

We are launching an official repository for the Az...

In this series I will discuss common challenges of...

This article will drive you through the way to create alerts on an Azure Synapse instance to receive notifications based on various monitoring criteria that are met. Introduction Data...

In 2013, the big data headline was the incredible statistic that 90% of all data in the history of the entire human race had been created in the previous two years...

In this article, we are going to learn in detail a...

I sincerely hope this isn’t the first time you?...

Introduction In my previous post, Fun With PowerSh...

Many of us have a lot to do. And we have short delivery cycles, sprints, and a lot of peers to share data models with. In search of something lightweight, which is quick and easy, and may be produced (or consumed) by other programs?

In this post I want to cover a couple of ways you can update a Database Project within the GitHub website. Because both ways can be useful...

This article compares the SSIS OLE DB Destination SQL command with the “Table or View” data access mode. In a previously published article, SSIS OLE DB Destination vs SQL...

Tomorrow, Microsoft is officially launching Windows 11, the next installment of their operating system which underpins the majority of PCs in use today. Windows 10 has an install base...

Quatro Enemigos This post is really four different posts. Maybe five...

In this blog post I am going to show you how to us...

I’m not an expert on Power BI report accessibili...

Another question from the comments... MrTavelBlog ...

Under business conditions, narrowly specialized tasks often come across, which require a special approach because they do not fit into the standard data processing flow and constructing models. One of these tasks is the classification of new products in master data management process (MDM).

Deleting rows from a table is a pretty simple task...

Today Microsoft release the following SQL Server update. SQL Server 2019 CU 13 (KB 5005679) 10/05/2021 At Stedman Solutions, LLC we do help with SQL maintenance and administration. If...

Will your backup and recovery strategy cover you? So what about ransomware?  A lot of people are getting hit with ransomware lately. I’ve seen more people lose their systems...

Syniverse hasn't revealed whether text messages were exposed.

This tip compares four time series models using SQ...

Last week, I found myself with a T-SQL problem. A ...

In this tip, I use specific examples to counter as...

An index of over a decade's worth of posts and vid...

In this article we look at how to concatenate SQL Server data using various methods using concatenation operator, functions CONCAT and CONCAT_WS.

In this article we look at more ways to create a new SQL Server table using SELECT INTO as well as some specific nuances you should be aware of.

Learn how to write recursive queries in SQL Server by using a Common Table Expression also know as a CTE.

Learn how to turn on and turn off seeing line numb...