SQL Server

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 Fixes and cumulative Updates Dashboard

SQL Server Fixes by Components and 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…


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 :…


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 Trace Flags dashboard

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…