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.
Database Engines Trends Dashboard
DB-Engines.com is a website that reference and rank hundreds of database engines, threw the most famous ones likes Oracle, MySQL, SQL Server, PostGreSQL…
Improve SQL Server Performance with sp_UpdateStats2 Statistics Maintenance
Updating statistics is an important aspects of SQL Server performance tuning.
SQL Server Cumulative Updates Dashboard
Since the version 2017 Microsoft does not use Service Packs anymore: only Cumulative Updates.
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.
sp_CompareTables : compare tables at column level in SQL Server
sp_CompareTables is a stored procedure for SQL Server that compares two tables (or views) defined in the configuration table T_COMPARE_CONFIG.
SQL Server Features Comparison and Evolution
Let's concentrate on the last 3 versions to see features evolution and comparison between edition.
SQL Server Schema Restore : structures and data
on github: (https://github.com/aetperf/dbatoolsScripts/blob/main/DBA/Restore/restoreSchema.ps1) All objects within a specific schema in a target database…
FastTransfer VS BCP
In data engineering and database administration, efficiently transferring large volumes of data between SQL Server instances is a common and critical…
