Blog – SQL Server | Architecture & Performance

Databaseen13 Jul 2026

Fast Geographic Data Extraction from SQL Server to Parquet with FastBCP

SQL Server holds spatial data in geography and geometry columns.

#FastBCP#ArrowTDS#SQL Server

SQL Serveren26 May 2026

PerformanceStudio: Better Query Store Analysis for SQL Server

PerformanceStudio is an open-source GUI for SQL Server performance troubleshooting.

#SQL Server

SQL Serveren1 May 2026

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…

#database#Dataviz#Tableau

SQL Serveren31 Jan 2026

Improve SQL Server Performance with sp_UpdateStats2 Statistics Maintenance

Updating statistics is an important aspects of SQL Server performance tuning.

#SQL Server#dba

SQL Serveren18 Jan 2026

SQL Server Cumulative Updates Dashboard

Since the version 2017 Microsoft does not use Service Packs anymore: only Cumulative Updates.

#SQL Server

SQL Serveren27 Nov 2025

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.

#Embeddings#SQL Server#vector

SQL Serveren10 Nov 2025

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#data quality

SQL Serveren1 Jul 2025

SQL Server Features Comparison and Evolution

Let's concentrate on the last 3 versions to see features evolution and comparison between edition.

#database#SQL Server#Dataviz

SQL Serveren25 Jun 2025

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…

#SQL Server#dba

SQL Serveren25 Apr 2025

FastTransfer VS BCP

In data engineering and database administration, efficiently transferring large volumes of data between SQL Server instances is a common and critical…

#FastTransfer#dba#SQL Server

SQL Serveren2 Apr 2025

Licence to sp_kill on SQL Server

When it comes to administering SQL Server, you sometimes need to terminate (“kill”) an active session or process.

#SQL Server

SQL Serveren6 Nov 2024

Beyond LAST_VALUE IGNORE NULLS: Efficient Alternatives for Handling Missing Data in SQL Server

When working with SQL Server, managing missing data efficiently is crucial, especially in large datasets.

#SQL Server#Performance#SQL

SQL Serveren23 Oct 2024

LAST_VALUE performance issue on SQL Server

The story begins after migrating table structures and data from Netezza to SQL Server.

#database#SQL Server

SQL Serveren22 Dec 2023

SQL Server AlwaysOn Feature Tutorial : Part 3 - install SQL Server on a domain VM

In these articles, we’ll look at how to set up high availability on one or more databases with the AlwaysOn feature, using the « dbatools » PowerShell…

#SQL Server

SQL Serveren19 Oct 2023

How minimal is SQL Server Minimal Logging

One day, one of my clients complained about the size of his SQL Server log. He mentioned that it had reached 1GB for just 1 million inserted rows.

#database#SQL Server

SQL Serveren24 Jun 2023

Semantic Vector Search with SQL Server and the help of KMeans indexing

In the previous article Semantic Vector Search with SQL Server we discuss about the possibility to make semantic search with vectors that comes from…

#SQL Server#semantic search#vector

SQL Serveren19 Jun 2023

SQL Server vector search

Some time ago i read a blog article from a senior Microsoft azure programmer Davide Mauri: The article interest me because the current "semantic search"…

#Performance#SQL Server#SQL

SQL Serveren23 Mar 2023

TPCH SF10 : Query 13 and SQL Server Collations Performance Impact

After benchmarking several cloud databases (Snowflake, BigQuery, SingleStore, Databricks) using TPCH SF10 data, after benchmarking DuckDB and Tableau…

#TPC-H#SQL Server#SQL

SQL Serveren8 Mar 2023

SQL Server Extended Events Dashboard

SQL Server Extended Events is a powerful feature in Microsoft SQL Server that enables database administrators to capture and analyze events that occur…

#database#SQL Server#Performance

SQL Serveren18 Feb 2023

SQL Server editions comparison dashboard by domains features and scale capacities

The article allow you to direct use the sql server editions comparison dashboardYou can select the version of SQL ServerYou can select a group of features…

#database#SQL Server

SQL Serveren13 Jun 2022

Insert data from SQL Server into Excel crosstab

In this article, I will show you how to insert data into an Excel spreadsheet and safely keep your content.

#SQL Server#Excel#powershell

SQL Serveren28 May 2022

SQL Server Standard vs Enterprise Edition Features History

Along the time Microsoft improve performance and add features to the SQL Server Database.

#SQL Server

SQL Serveren25 Mar 2022

SQL Server Trace Flags Classification

_Trace flags are used to set specific server characteristics or to alter a particular behavior.

#database#Performance#SQL Server

SQL Serverfr16 Mar 2022

Compression des données XML dans SQL Server

On stocke des données XML dans une table qui commence à grossir sérieusement et il devient important de réfléchir à des solutions pour essayer de gagner…

#SQL Server#database#Performance

SQL Serveren3 Jan 2022

150 T-SQL Bad Practices

Many times i was asking for given best practices for T-SQL code but I don't like best practices advices.

#database#SQL#SQL Server

SQL Serverfr9 Feb 2021

SQL Server CLR Functions vs SQL 2019 Function Inlining

Ce tutorial montre toutes les étapes pour: Découvrez également la nouvelle fonctionnalité SQL Server 2019: le "function inlining" et comment l'activer.

#SQL#Performance#SQL Server

Our services

#SQL Server

All articles

Fast Geographic Data Extraction from SQL Server to Parquet with FastBCP

PerformanceStudio: Better Query Store Analysis for SQL Server

Database Engines Trends Dashboard

Improve SQL Server Performance with sp_UpdateStats2 Statistics Maintenance

SQL Server Cumulative Updates Dashboard

Get your embeddings on SQL Server 2025 with AI_GENERATE_EMBEDDINGS and EXTERNAL MODEL using OLLAMA local and your GPU

sp_CompareTables : compare tables at column level in SQL Server

SQL Server Features Comparison and Evolution

SQL Server Schema Restore : structures and data

FastTransfer VS BCP

Licence to sp_kill on SQL Server

Beyond LAST_VALUE IGNORE NULLS: Efficient Alternatives for Handling Missing Data in SQL Server

LAST_VALUE performance issue on SQL Server

SQL Server AlwaysOn Feature Tutorial : Part 3 - install SQL Server on a domain VM

How minimal is SQL Server Minimal Logging

Semantic Vector Search with SQL Server and the help of KMeans indexing

SQL Server vector search

TPCH SF10 : Query 13 and SQL Server Collations Performance Impact

SQL Server Extended Events Dashboard

SQL Server editions comparison dashboard by domains features and scale capacities

Insert data from SQL Server into Excel crosstab

SQL Server Standard vs Enterprise Edition Features History

SQL Server Trace Flags Classification

Compression des données XML dans SQL Server

150 T-SQL Bad Practices

SQL Server CLR Functions vs SQL 2019 Function Inlining

Need expertise on your project?