The 8 Worst Things Microsoft Ever Did to SQL Server
Last week I wrote about the 6 best things Microsoft ever did to SQL Server, but now we […]
Sites anglophones
SQL Database Project in Azure Data Studio
Introduction This article teaches how to use the Azure Data Studio extension to handle SQL Database projects. It […]
SQL Server BIT_COUNT and an Alternative
I was editing an article the other day that uses the BIT_COUNT function that was added to […]
Understanding Data Type Conversion Functions in SQL Server with PARSE, ...
Introduction SQL Server provides robust tools for data type conversion, such as PARSE, TRY_PARSE, and TRY_CONVERT. These functions […]
How to use @@ROWCOUNT in SQL Server
The post How to use @@ROWCOUNT in SQL Server appeared first on SQLServerCentral.
SQL ConstantCare® Population Report: Winter 2025
Every quarter, we publish adoption rate data showing how quickly people are adopting new versions of SQL Server. […]
Who’s Hiring in the Microsoft Data Platform Community? February 2025 ...
Is your company hiring for a database position as of February 2025? Do you wanna work with the […]
The 6 Best Things Microsoft Ever Did to SQL Server
This entire blog post is driven by the #1 feature in this list. I think about the #1 […]
An Effective Approach for High Volume Data in Azure Synapse
Introduction Azure Synapse Analytics, previously known as Azure SQL Data Warehouse, is a widely utilized platform for storing […]
SSMS Export to Excel
The post SSMS Export to Excel appeared first on SQLServerCentral.
Dark Mode in SSMS 21 and overall first impressions
Let me cut to the chase. If you are like me, you may have been searching for: […]
Frappe and Laravel: Database Management and Migrations
In this second installment of our series comparing Frappe and Laravel, we probe into critical aspects of […]
JSON in Microsoft SQL Server: A Comprehensive Guide
Introduction JSON (JavaScript Object Notation) has become a popular data format for storing and exchanging information. Microsoft SQL […]
How to rename a SQL Server database
The post How to rename a SQL Server database appeared first on SQLServerCentral.
Accessibility, and the Need for Ingenious Simplicity in Computer Scripts, ...
I’m very keen on accessibility in computer systems. Nowadays we tend to take a rather superior attitude […]
[Video] Office Hours and an AI-Generated Sweatshirt
I originally took these questions from https://pollgab.com/room/brento poolside at the Trixie Motel (really), but I forgot to use […]
SQL Endpoint Secrets you need to know
Recently I had a severe problem with SQL endpoints and I was required to build a quick […]
Index Rebuilds Make Even Less Sense with ADR & RCSI.
Accelerated Database Recovery (ADR) is a database-level feature that makes transaction rollbacks nearly instantaneous. Here’s how it works. […]
Creating a Linked Server in Amazon RDS for SQL Server: ...
A common requirement for database professionals working with SQL Server is the capability to connect seamlessly to other […]
A Practical Guide to Using Azure Key Vault in Enterprise ...
The post A Practical Guide to Using Azure Key Vault in Enterprise Deployments appeared first on SQLServerCentral.
What If You Need to Index a Lot of Duplicate ...
Let’s get a little nerdy and look at database internals. Create two tables: one with a million unique […]
Creating Time Series Collections in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Weekly Blogging
I spent a few weeks away from the office in early January, just like last year, mostly […]
Add and Subtract Dates using DATEADD in SQL Server
The post Add and Subtract Dates using DATEADD in SQL Server appeared first on SQLServerCentral.
Attaching Multiple SQL Server Databases with DBCC CHECKPRIMARYFILE
Introduction Attaching databases in SQL Server can be a routine yet sometimes time-consuming task for Database Administrators (DBAs). […]
Temporary Tables
There is a feature of SQL I have not seen used much and probably with good reason. […]
Boosting Data Accuracy: Resolving Common Data Quality Issues Using SQL
Project Context and Data Presentation Challenges In our projects we have seen, data quality issues manifest in various […]
[Video] Office Hours in My Vegas Backyard
I took 5 of your top-voted questions from https://pollgab.com/room/brento while hanging out in the backyard on my second […]
Azure SQL Serverless: Discover What’s new and Increase Your Savings
Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure […]
Navigating the Database Landscape in 2025 Livestream on Feb 12
The post Navigating the Database Landscape in 2025 Livestream on Feb 12 appeared first on SQLServerCentral.
Can AI Rewrite Bad Queries in Seconds? Kinda.
When I see horrific code, stuff that would take a lot of manual labor to fix, I like […]
How to Install SSIS in Visual Studio 2019
The post How to Install SSIS in Visual Studio 2019 appeared first on SQLServerCentral.
Why Standards are Important
Throughout my career I have seen arguments as to which IT standard in a particular area, is the […]
Pop Quiz, 2025 Edition: What Do These Things Cost Today?
Price check on Aisle 2025. My main consulting job is a 2-day SQL Critical Care® where I help […]
Nostalgic Memory Loss
Today’s topic pertains to 99.999% of all people, young, old, and all age ranges . I am […]
Loading Models from Source Data with dbt
The data transformation tool dbt (data build tool) has become more and more popular over the past […]
Influencing a Local AI
I set up a local AI LLM to run and then conducted some experiments. This post shows a […]
Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real ...
The post Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD appeared […]
MySQL Shell and Basic Configuration Management (Part 2 – Memory ...
Part 2 in the series: A Comprehensive Beginners Guide to Configuration with MySQL Shell. In the first […]
Vector DB implementation using FAISS
Searching for relevant information in vast repositories of unstructured text can be a challenge. This article explains a […]
Using Snyk for CI/CD Security Scanning
Security is important regardless of your industry, whether it’s finance, retail, e-commerce, or the broader world of […]
I’m Coming to Croatia!
A few things lined up perfectly for a European trip this summer. I’m on a European cruise in […]
Fabric Copy Job: What’s new in it
At first sight, the new Copy Job may seem only one more redundancy: Why do we need […]
Does Separating Data and Log Files Make Your Server Faster?
I’ve already explained that no, it doesn’t make your database server more reliable – and in fact, it’s […]
Announcing the 2025 Data Professional Salary Survey Results.
We’ve been running our annual Data Professional Salary Survey for almost a decade, and I was really curious […]
FinOps pour Microsoft Fabric
Version de l’article en Anglais sur LinkedIn : Le FinOps et Microsoft Fabric, deux sujets qui m’intéressent […]
VIEW Objects
A view is a virtual table, created when it’s invoked by the < view name>. The goal […]
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions ...
Introduction When working with T-SQL trigonometric functions in SQL Server, it’s important to be aware of potential pitfalls […]
Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, ...
The post Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, Warehouses, and Pipelines appeared first on […]
I Wrote a Book on How You Broke Your Database ...
Preface If you are a frequent reader of Simple-Talk, it’s possible that you’ve come across blogs about […]