Backups, DAX, and more in Database Weekly (2021-11-20)

PASS Data Community Summit 2021 Report

The 2021 virtual PASS Data Community Summit was held from November 8th through the 12th. PASS Summit has always been the biggest yearly conference for database professionals, and this year’s virtual conference had over 18,000 individuals registered!

If you signed up for the event, you may now stream the sessions on-demand. This is an exclusive benefit for six months. After that, the sessions will be available on the PASS TV channel on YouTube for everyone. The keynote sessions are available now on YouTube. With a record number of sessions from which to choose, there is something for everyone.

This year, the Lightning Talks were given by speakers new to PASS Summit. New speakers delivered several general sessions as well, which was an excellent opportunity to get some experience with a wider audience. The 10-minute Lightning Talks cover a broad range of topics, Synapse to security to getting things done. If you have a few minutes to spare, you’ll probably find something of interest.

Learning Pathway sessions were curated to introduce a particular area of interest. The Learning Pathways provide an excellent way to get up to speed on a topic or improve your skills. The Learning Pathways are

Microsoft announced SQL Server 2022 at Ignite the week before but saved all the deep-dive sessions for PASS Summit. You can catch a summary at the Day One Keynote. I’m especially excited about the Parameter Sensitive Plan Optimization feature. This feature allows more than one plan for a query and switches plans depending on the number of rows. Many customers fight parameter sniffing issues, and while there are many ways to solve them currently, none are optimal. This feature is a real game changer!

The star of Summit was undoubtedly the networking feature, Spatial Chat, which we use internally at Redgate. We knew this would be a fantastic platform for those hallway conversations and fun meetups like SQL Karaoke. Spatial Chat lets the organizers set up virtual rooms. Once entering a room, you can move closer to a group to join in the conversation. We’ve heard lots of positive feedback and, while it’s not as good as being in person, it was the next best thing.

Redgate has announced that next year, Summit will be held in Seattle with a virtual option. The data community members have genuinely missed being back together in person, so I can’t wait for the event. If you would like to be informed about details, sign up to receive news.

Kathi Kellenberger

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

The 'ShouldExecute' script configuration option in Flyway Teams simplifies 'conditional execution' of SQL migration files. This makes it easier to support multiple application versions from the same Flyway project, to deal with different cultural or legislative requirements. It also helps developers handle environmental differences between development, test and staging, such as the need to support multiple versions or releases of the RDBMS.

How Dry Run scripts work, and how they can be used to deliver a single-script release artifact to Staging, verify placeholder substitutions in SQL migration scripts, and simply team code reviews.

SQL Monitor v12.0 has added a new Query Text Search feature to allow users to search the text of the most expensive queries that executed on a SQL Server instance over a period. Here's what it does, and how it works.

Most of these signs have to do with wait stats. One could venture out and say that if you have way less memory than data, you need more memory, but… If the server is sitting around bored, who cares?...

SSMS - Run as different user through GUI and command line

Let’s talk about cost threshold for parallelism....

In this article we look at how to prevent SQL Server logins from being deleted if the login is a database user as well by using a DDL Trigger.

This is the third article in the series of Migrating SQL Server Objects using SSDT 2017. In the second article, we learned how we can transfer the stored procedure...

Last week I presented a session, Demystifying Statistics in SQL Server, at the PASS Community Summit, and I had a lot of great questions; so many that I’m creating...

But Postgres Is So Much Cheaper There’s a lot of cool stuff in Enterprise Edition of SQL Server, which is probably why it costs $7000 a core. When’s the last the...

This article aims to provide some beneficial tips about SQL Server extended events that make it easier to create and use event sessions. Introduction SQL Server extended events is...

I am working on a big update to Database Health Monitor that I expect to release near the end of the year. So far I am sharing the beta...

In this article, we will learn how to configure the Azure Search instance to import data from Azure Cosmos DB. Introduction Azure Cosmos DB is a multi-model type database...

Azure SQL database is Database as a Service offering under the PaaS model in the Azure cloud. It is a fully managed SQL Server database engine that uses the...

Learn about data ingestion and the steps to load data into Synapse Analytics using the copy data tool in Synapse Analytics Studio.

Learn how to use the SSMS GUI and T-SQL to create SQL Server full, differential and transaction log backups.

Customers often ask for guidance on choosing the...

As Simon Sabin (SQL Bits co-founder) pointed out recently, the 2022 SQL Bits conference is looking to get 40% of their sessions to be 20 minute talks. He did... The...

I attended the three main days this year and wrote...

Redgate is a proud sponsor of this year’s Accelerate State of DevOps Report, by the DevOps Research and Assessment (DORA) team at Google Cloud. Watch our lastest webinar to find out how the future of DevOps will effect you.

Four years ago (I know, where did the time go?), I wrote about Table Column Differences with T-SQL and PowerShell...

I want to cover one way you can do CI/CD for Azure Synapse Analytics serverless SQL pools using GitHub Actions in this post. For various reasons....

Customers often ask for guidance on choosing the r...

CONTAINS: Returns TRUE if there exists at least one row where all columns have specified values. https://dax.guide/contains/ CONTAINSROW: Returns TRUE if there exists at least one row where all...

HASONEVALUE: Returns true when there’s only one ...

SSRS reports can be built using DAX. In this article, Adam Aspin explains how to get started using DAX to build the reports.… The post Introduction to DAX for paginated...

In this article we look at how to create a scale-out SQL Server PolyBase solution on AWS.

PostgreSQL is a hugely popular database and the leading example of how an open-source database can operate successfully for its community and for companies. It has been named database of the...

Curious about how to accomplish real-time reports?...

Over the past few years I’ve blogged and present...

In this tip we'll introduce you to Power Query, th...

Video by: Reid Havens Learn how to customize a shadow to provide a one sided border to a button in Power BI. This design process can give provide some extra...

What I find I wanted to do with a new PPU Dataset with incremental partitions is I did not want to wait for the PBI Service to complete this....

Power BI can get data from Google Sheet now. This functionality is released just yesterday and announced in both Power BI and Power Query blogs. The feature is still...

The Azure Data Community Team is dedicated to work...

After resisting learning Python for years, assuming it was just another object-oriented programming language, Andy Brown now gets what the fuss was about: Python really does make coding quicker....

Hello and welcome back… It has been a few months since I have published a blog post. More like 126 days, to be exact. Unfortunately, I have been dealing... The...

I was honored to speak at Pass Summit last week (Thanks again Redgate), and if you’ve ever been to one ... Continue reading The post Quiz & answers for my...

In this article we continue our series on installing SQL Server 2019 on Linux and walk through the installation steps of installing SQL Server 2019.

SQL Server sequence objects have several properties that control how they behave. Greg Larson explains the options of using SQL Server sequence objects.… The post Using SQL Server sequence objects...

Behold, a simple MAX query: But wait, where did that Top operator come from? Oh, SQL Server, you clever rascal… Simple and extremely effective – a solid query transformation....

In this article learn how to build a SQL Server query using 3 tables along with different examples.

This is part two in a series on window functions in SQL Server. Last Time on 36 Chambers In the prior post, we looked at the anatomy of a...