SQLBits Report

Last week I attended my first in-person event in over two years. SQLBits, the largest data platform conference in Europe, was a hybrid event and marked the first time many of us met in person in ages. It was a huge success as folks from around the world gathered to learn...and celebrate! I heard several people say, while it seemed like more than two years, it also felt like they were apart from their data community friends for just a few days when seeing them again.

The community’s favorite Microsoft speakers were there in full force giving us the latest news about SQL Server 2022, database migrations to Azure, Power BI, and more. I was especially interested in hearing about features of SQL Server 2022 that make queries run faster – without changing code. This set of features is called Intelligent Query Processing (IQP). You may have heard me talk about the IQP features available with SQL Server 2017, 2019, and Azure SQL Database at many virtual events the past two years. I’m most looking forward to the IQP feature called Parameter Sensitive Plan Optimization. This feature allows more than one plan to be saved in cache so that the plan can be switched based on the number of rows!

There were many Microsoft sessions, but the community speakers were also on hand or speaking virtually. Sessions ranged from beginner to advanced and covered everything from query tuning to data science. There was really something for everyone. (By the way, the PASS Data Community Summit call for speakers is open now!)

While there was a lot of learning at SQL Bits, there were also many fun activities, including game and trivia nights. SQL Bits would not be complete without the theme-based costume party. This year, the theme was eighties video games, and the party featured life-sized games and dancing.

Overall, SQL Bits was just what many of us needed after the past two years. I look forward to many more chances to present sessions in person, networking, and meeting up with old friends.

Kathi Kellenberger

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

Explaining some of the 'gotchas' that can trip up the unwary Flyway user, and how to avoid them. One or two of these you'll encounter quickly, such as the case-sensitivity of parameters and arguments. Others, such as potential problems with undo scripts or running scripted callbacks, only when you are tackling more complex development processes.

So you want to start using AI at your company. Now...

There is an old DBA joke, that goes something like...

Another post for me that is simple and hopefully s...

With the server overview page you can keep close t...

In the past, the main namespace for connecting SQL server is System.Data.Sqlclient for both .NET framework app and.NET Core app. However, when it comes to AAD authentication, it makes...

The Azure SQL Database provides high performance, secure and reliable managed relational database service. Security is the prime focus area in both on-premises and cloud infrastructure while designing the...

Wouldn't it be great if there was a way to learn i...

We are excited to announce the GA release of maint...

Evaluate SQL Server on Azure Virtual Machines for configuration best practices using the SQL best practices assessment feature on the SQL virtual machine blade in the Azure portal.

Public preview enhancements and updates released for Azure SQL.

In the previous article Managed Instance link – connecting SQL Server to Azure reimagined, we've introduced the link feature for Azure SQL Managed Instance as our best hybrid solution for Managed Instance, allowing...

Using the on-prem Active Directory machines, users...

In this video, you will learn how to setup a...

Quickly build new visuals by simply pinning an ana...

Learn about AWS Data Migration Services to migrate...

Configuring AWS Managed AD services with on-premis...

Do you know there are 2 key types of Data masking, and what each offers? In this 30-minute webinar SQLServerCentral Editor, Steve Jones, talks through the capabilities, use cases, benefits, and problems of both static and dynamic data masking.

In our latest DevOps 101 Series live webinar Grant Fritchey discusses why the key to successful DevOps implementation is gaining buy-in, and how you can achieve this in your organization.

Call Center data is some of the most interesting, ...

If you are new to Git, understanding how Git commands...

I streamed about even more updates to the SSIS Framework Manager. Enjoy!

Azure Data Factory is a cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. In this...

VAR.P: Calculates variance based on the entire pop...

How to return BLANK instead of zero in a DAX measu...

A lot of videos and articles teach you how to writ...

Are you interested in guest posting? Publish at DataScience+ via your RStudio editor. Category Regression Models Tags Linear Regression Logistic Regression Machine Learning Python As you search about ML.Net on Google, you’d find much content about...

Microsoft Azure is now the most widely used enterp...

Install timescaleDB, pg_repack and orafce on newly created Flexible Servers on Azure Database for PostgreSQL, a managed service running the open source Postgres database.

After getting a new database in place, the next step is to create tables. In this article, Robert Sheldon walks you through creating tables with SQL Workbench and with scripts.

PostgreSQL has an unusually large number of data types. Grant Fritchey reviews each data type and discusses the good and bad points of each.

Remember way back when maps were on pa...

Today, I worked on a very interesting performance ...

Costs are okay for figuring out why SQL S...

This is part of a series on my preparation for the...

In this article, we will learn how to add natural ...

In this series of blog posts, I am going to show y...

In this article we will look at how to combine files in Power BI when column names or the number of columns can change at any time.

What's up with the wait time in Power BI Dataflows? Do we just live with it? What's going on and what can we do about? Adam, has you covered!...

The main gist of this article is that if you are starting any project where you want to both teach a subject or benchmark algorithms, the cleaner the machine...

I wrote a post a couple weeks ago about not changing port 1433 for security reasons. I received this comment, which is not visible on that page because it... The...

Learn about SQL Server triggers, their use and how to create a simple trigger to track data changes in a table.

A few years back I learned about temporary stored ...

In this article we look at how to use variables with SQL Server to allow you to make code more dynamic. We look at scripts, functions, stored procedures, sqlcmd...

To avoid deadlocks when implementing the upsert pattern, make sure the index on the key column is unique. It’s not sufficient that all the values in that particular column...

This is a follow up post to the previous one about...

In this article we cover an introduction to the CR...

One of the more interesting jobs I’ve had over t...

Similar to my article regarding the SQL Server STU...

In this article we cover how to get started using SSMS and how to connect to a SQL Server, navigate using the tool and run a query.

It's been a while since I've had the opportunity to write and share a blog post about SQL Server containers and Linux. Today, I'd like to show you how...

Containers have emerged as the standard for cloud-native application development, and Kubernetes, also known as K8s, is arguably the most popular container orchestration tool. A survey from the Cloud Native...

If you want to use Hyper-V on Windows Server Core,...