Hi Brent, What is your take on Hugo Kornelis’s explanation of execution plan naming. As her his explanation, estimated exec plan is simply an execution plan whereas actual execution plan = execution plan+run-time stats. Do you agree that the naming is flawed and confusing? – Yourbiggestfan
The post Estimated and Actual Plans Can Have Different Shapes. appeared first on SQLServerCentral.

Learn how to find all securable objects in SQL Server and the permissions for each securable object using the system function fn_builtin_permissions.
The post How to use fn_builtin_permissions SQL Server Security Function appeared first on SQLServerCentral.

SQL Server 2022 is in preview in August 2022. I assume this version will be released later this year, and I have been testing it with the idea that I will be looking at an upgrade sometime in the next year for a few servers. There are a lot of changes in the database platform, […]
The post T-SQL Language Changes in SQL Server 2022 appeared first on SQLServerCentral.

Performance tests are central to the quality of the database changes we deliver because they ensure that any business process that accesses the database continues to return its results in an acceptable time. When Flyway creates a new version of the database, it is the ideal time to run these performance checks.
The post Performance Testing Databases with Flyway and PowerShell appeared first on SQLServerCentral.

Accessibility ensures that everyone has a great experience on your site. Bikkani explains how to achieve web accessibility.
The post The ultimate guide to web accessibility appeared first on SQLServerCentral.

Learn how to use the DatabasePropertyEX() function to query your database for settings.
The post Understanding the Metadata Function DATABASEPROPERTYEX() appeared first on SQLServerCentral.

This article will focus on reading and profiling data with the pandas package when using Python as well as show how to build charts based on this data.
The post Getting Started with Python Pandas and Dataset Profiling appeared first on SQLServerCentral.

Learn the basics of using Terraform to declaratively specify how to configure resources in infrastructure.
The post Database Deployment with Terraform - The Basics appeared first on SQLServerCentral.