Blog
SQL Server
Discover our articles on IT performance, cloud, data science and industry best practices.
All articles
PerformanceStudio: Better Query Store Analysis for SQL Server
PerformanceStudio is an open source GUI for SQL Server performance troubleshooting. It helps DBAs and developers inspect execution plans, identify heavy queries, and move faster…
Database Engines Trends Dashboard
Database Engines Trends DashboardDB Engines.com is a website that reference and rank hundreds of database engines, threw the most famous ones likes Oracle, MySQL, SQL Server,…
Improve SQL Server Performance with sp_UpdateStats2 Statistics Maintenance
Why another statistics maintenance procedure? Updating statistics is an important aspects of SQL Server performance tuning. Poorly maintained statistics can lead to bad…
SQL Server Cumulative Updates Dashboard
Since the version 2017 Microsoft does not use Service Packs anymore : only Cumulative Updates. Thanks to Microsoft SQL Server Team, they…
Get your embeddings on SQL Server 2025 with AI_GENERATE_EMBEDDINGS and EXTERNAL MODEL using OLLAMA local and your GPU
SQL Server 2025 introduces a powerful new feature: native vector embeddings generation using the AI GENERATE EMBEDDINGS function. Behind this function lies a brand new SQL Server…
sp_CompareTables : compare tables at column level in SQL Server
Overview sp_CompareTables is a stored procedure for SQL Server that compares two tables (or views) defined in the configuration table T_COMPARE_CONFIG. It uses EXCEPT queries to…
SQL Server Features Comparison and Evolution
Let's concentrate on the last 3 versions to see features evolution and comparison between edition. Clic, Ctrl+Clic, or mouse maintain and select area to filter others on th…
SQL Server Schema Restore : structures and data
SQL Server Schema Restore PowerShell Script This PowerShell script ( restoreSchema.ps1 ) is designed to perform a full sql server schema restore : structures and data. Source on…
FastTransfer VS BCP
In data engineering and database administration, efficiently transferring large volumes of data between SQL Server instances is a common and critical task. Whether for database…