There’s a widespread misconception that SQL Server’s columnstore indexes are like an index on every column.
The post Columnstore Indexes are Finally Sorted in SQL Server 2022 appeared first on SQLServerCentral.

This wizard migrates SSIS Catalog from one server to another in just a few clicks.
The post Migrate the SSIS Catalog in Just a Few Clicks appeared first on SQLServerCentral.

Learn how you can use Windows Performance Monitor and the PAL to gather metrics from your SQL Server instances.
The post PerfMon: Using SQL Server Performance Counters appeared first on SQLServerCentral.

A brief history of the DevOps movement and a discussion of the pivotal role of a tool like Flyway in the DevOps toolchain, when developing and delivering database changes.
The post DevOps Collaboration and Process Visibility in Flyway Developments appeared first on SQLServerCentral.

PostgreSQL database performance is critical for application performance. EzzEddin Abdullah shows how to get information about a query’s performance from the execution plan.
The post How to troubleshoot and fix PostgreSQL performance issues appeared first on SQLServerCentral.

Learn how to work with SSAS data in Power BI in this article.
The post How to Connect to an Analysis Services Database in Power BI appeared first on SQLServerCentral.

Database object documentation is essential for explaining to busy developers, and the wider business, the purpose of each object and how to use it. The solution presented in this article consists of a SQL script to allow developers to add comments to MySQL database objects, without affecting the database version, and a simple way to generate a documentation report, in JSON. The SQL script will execute automatically as a callback, during any Flyway Teams migration run, and the report will allow the team to spot any gaps quickly.
The post Taming Database Documentation with Flyway and MySQL appeared first on SQLServerCentral.

Learn different ways to add comments to your T-SQL code when working with SQL Server along with several examples.
The post T-SQL Comment Best Practices for SQL Server appeared first on SQLServerCentral.