SQL Server

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, PostGreSQL, MongoDB, Redis to omes more confidential like Hazelcast…


SQL Server installation with powershell dbatools

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 library. To do this, we’ll need to set up an active directory and install SQL Server on a domain…


SQL Server Cumulative Updates Dashboard

SQL ServerSince the version 2017 Microsoft does not use Service Packs anymore : only Cumulative Updates. Thanks to Microsoft SQL Server Team, they provide Excel summary and details about fixes included in each cumulative updates. Theses data allow…


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. His issue was that sometimes he had to insert 1 billion of them ! Hopefully there is SQL Server…


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 OpenAI text embedding model « text-embedding-ada-002 ». We also have seen how the dimensional…


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 » natively available in sql server since SQL Server 2016 is not wildly spread and honestly…


TPCH SF10 MSSQL 2022

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 Hyper on my own machine, I ask to myselft : « hey, why not testing using the official SMP Databases…


SQL Server Extended Events Dashboard

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 within the server. Extended Events provides a lightweight and customizable infrastructure that can…


MSSQL Features Comparison and Evolution

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 dashboard. Click elsewhere to release filter or change it. On the…


SQL Server editions comparison dashboard by domains features and scale capacities

The article allow you to direct use the sql server editions comparison dashboard You can select the version of SQL Server You can select a group of features to adapt the details with your selection Multi-selections is also…


excel data injection

Insert data from SQL Server into Excel crosstab

Insert data from SQL Server into Excel crosstabIn this article, I will show you how to insert data into an Excel spreadsheet and safely keep your content. Indeed, if you try to insert data into Excel, which contains a crosstab, you will corrupt your…


SQL Server Edition features Comparison history

SQL Server Standard vs Enterprise Edition Features History

SQL ServerAlong the time Microsoft improve performance and add features to the SQL Server Database. The two principals editions are Enterprise and Standard edition (EE and SE) but there are also others versions like the web edition or the free one :…


SQL Server Trace Flags Classification

SQL Server Trace flags are used to set specific server characteristics or to alter a particular behavior. For example, trace flag 3226 is a commonly used startup trace flag which suppresses successful backup messages in the error log. Trace flags…


Compression des données XML dans SQL Server

SQL ServerAlexandre Blois Problème : 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 un peu de place de stockage pour éviter que la table…


T-SQL Bad Practices

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. They can be deprecated faster than you think and they can be a good advice in one case and very bad advise for another case. T-SQL Bad…


SQL Server CLR Functions vs SQL 2019 Function Inlining

Booster vos performances SQL Server en utilisant des fonctions compilées CLR C# à l'intérieur même de votre SGBDR préféré à la place des fonctions SQL classiques ! Ce tutorial montre toutes les étapes pour : écrire une…