Filtered indexes, Azure AD authentication, and more in Database Weekly (2021-12-11)

One to many SQL Server books

Back in the late 90s, I had one large book on my desk with everything I needed – or thought I needed -- to know about SQL Server. It covered T-SQL, installation, backups, security, and more. Over the years, Microsoft has added components like SQL Server Integration Services and features like windowing functions and improved functionality and behavior. Instead of one book, you now need dozens, and it’s likely impossible to become skilled in everything SQL Server has to offer.

There are many database engine features, for example, that I’ve never used in a production environment, such as graph database, hierarchy ID, and in-memory OLTP. They are helpful for the right projects and scenarios, but I just haven’t had the opportunity to work on any of them. Even though I haven’t used them in an actual project, I have “played” with many features by following an article or tutorial and watching webinars. If I ever get the opportunity, I’ll know where to start and have some idea of the capabilities.

Knowing everything about the platform is not possible, so focusing on specific areas of SQL Server is not a bad idea. Some database professionals have built lucrative careers by specializing in a subset of SQL Server functionality, especially in the analytics space. Many folks specialize in ETL or performance tuning, for example. A few Microsoft data platform community members started with database administration, eventually became business intelligence developers, and ultimately moved to data science. I wonder what’s next!

Keeping up with the enhancements and new features in SQL Server is a big challenge, especially as upgrading to new versions is slow for many shops. Throw in Azure SQL, and there’s even more to learn. I like to keep up in my interest areas by writing articles and books or giving presentations. Not everyone wants to do those activities, but maybe organizing a weekly team lunch-and-learn to cover the latest features is doable.

Kathi Kellenberger

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

How to auto-generate first-cut undo scripts for every Flyway migration. For every new version of a database created by a Flyway versioned migration, we compare it to a 'source' directory containing object-level build scripts for the previous version. The SQL Compare engine does the rest, producing the associated undo script that will revert the database to the previous version, if required.

This article will get you started with Spawn, a hosted database cloning service running entirely on Amazons AWS.

Want an insight into how your fellow DBAs work? This episode features Kevin Davis, Manager of Database Administration at Tower Loan, a consumer finance company with 250 branches across the US.

A new feature now available in general availability includes Manage Azure Machine Learning resource using Hashicorp Terraform

This article explains configuring a linked server ...

I’ve had quite a bit of luck with filtered indexes over the years. When they work well, they’re absolute aces.

We just made it through Thanksgiving dinner and th...

This week’s blog post will help you check your S...

Is it possible to check the SQL Server password co...

Third blog post in a quick series about potential ...

You’ve heard these terms thrown around about storage, and you’re not sure what they mean, and how they relate to each other. Let’s make it simpler by using an...

How do I fix the Oldest_page wait type desc

Series of Apache Spark posts: Dec 01: What is Apa...

Some time ago I wrote a blog about the just releas...

In this article we look at various ways you can mi...

Data Exposed streams live regularly to LearnTV. Every 4 weeks, we’ll do a News Update. We’ll include product updates, videos, blogs, etc. as well as upcoming events and things...

Learn about the options to add users to Azure SQL Databases including SQL authentication logins, contained SQL users, contained Azure Active Directory users, mapped logins to users - including...

This is our current setup shown below. There is no...

Lets summarise some important learnings about SQL MI and failover groups. when you add a database to a failover group the secondary database has the same edition / compute... The...

Learn how to perform data deduplication for Azure ...

Security Center is an excellent tool for detecting...

In a matter of days, a large-scale outage of cloud and other online services could cause $15 billion in losses.

Imagine getting SA (sysadmin) access to your RDS SQL Server Instance! Well, that was not possible in the past, but during AWS re:Invent 2021, Amazon RDS Custom for SQL... The...

It almost seems like the headline could have been “AWS Outage Cancels Christmas”. Underlining the pervasive reliance that so many businesses and services have on cloud computing resources like...

In the articles, Deploying Azure Container Instanc...

Developers can work with multiple range values at once using sp_sequence_get_range. Greg Larsen explains how to return multiple sequence numbers with sp_sequence_get_range.

The SQL update statement is used to modify an exis...

When teaching people about how to use SQL Server E...

SQL Server 2022 introduces new ground-breaking query performance enhancements under the Intelligent Query Processing family. These make up the latest on Microsoft’s mission to make critical parallel workloads improve...

Why Power BI refreshes time out after two or five ...

CONVERT: Convert an expression to the specified da...

In this article, we are going to talk about Power ...

There are two options to model many-to-many relati...

Something I’ve been thinking about recently is t...

In this article we look at some examples of why a data professional would want to use Python instead of other tools like Azure Data Factory or Power BI.

These functions aren't brand new, but they're in Azure SQL Database and Azure SQL Managed Instance, and they're coming to SQL Server 2022 soon.

In this article we look at different T-SQL approaches to get the maximum value from multiple columns in a table.

Learn about joining SQL Server tables together for a query when there is a need to join on multiple columns.

Hyper-V admins should focus on four key areas to r...

Take multi-disk consistent point in time snapshots...