How to Download and Restore AdventureWorks 2022 Database
Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is […]
Archives du mois : février 2025
SQL Server Backup or Restore using Network Share with SSMS
The post SQL Server Backup or Restore using Network Share with SSMS appeared first on SQLServerCentral.
MySQL Shell Basic Configuration Management (Part 3 – Disk I/O ...
This is part of a series of posts from Chisom Kanu about using MySQL Shell in the […]
Office Hours: Unusual Beach Chair Edition
When you think ‘beach chair’, this probably isn’t what you think. I’m at a black sand beach on […]
Finding Out What Changed in a Cumulative Update
Over the last several years, Microsoft has been putting less and less effort into Cumulative Update documentation. We […]
Why use Tally Tables in the Fabric Warehouse? Data Engineering ...
Did you know that Edgar F. Codd is considered the father of the relational model that is used […]
Engineering a Lakehouse with Azure Databricks with Spark Dataframes
The post Engineering a Lakehouse with Azure Databricks with Spark Dataframes appeared first on SQLServerCentral.
Vertical Partitioning Is Almost Never the Answer. Here’s Why.
You’re looking at a wide table with 100-200 columns. Years ago, it started as a “normal” table with […]
Beyond Single-Cloud: A Peek into Multi-Cloud
The digital landscape is rapidly evolving, and the question has progressed from whether to adopt cloud technology […]
Crazy number of Parameters… and a challenge
The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on […]
How to use the Azure Emulator to create blob containers, ...
Introduction Sometimes, we need to test our apps in Azure and we do not have time to connect […]
Upgrade and Migrate SSIS Catalog and SSISDB to a New ...
The post Upgrade and Migrate SSIS Catalog and SSISDB to a New Server appeared first on SQLServerCentral.
Configuring Maintenance Plans in SQL Server
In this article, we are going to configure a maintenance place on the SQL Server 2017 instance installed […]
[Video] Office Hours: We’ve Got the (Honda) Beat
Meet my latest toy, a 1991 Honda Beat! I introduce it, then take your top-voted questions from https://pollgab.com/room/brento. […]
Fabric Databases Connection Secrets
Fabric Database was a great announcement during Ignite Conference. The announcement spread all around, a great new […]
Why I Mention My Sexuality and Gender
I certainly don’t discuss it often, and it’s been a few years since I wrote about my pansexuality. […]
Index Rebuilds Make Even Less Sense with ADR & RCSI
The post Index Rebuilds Make Even Less Sense with ADR & RCSI appeared first on SQLServerCentral.
How to Resolve SQL Server Database Stuck in Recovery Pending ...
Introduction In this article, we will learn how to restore a database which is stuck in the Recovery […]
I’m Doing Free SQL Server Spring Training Live Webcasts. Register ...
Starting next month, I’m doing absolutely free 90-minute live training webcasts to help y’all get your learn on: […]
MinIO : sauvegarde et tables externes SQL Server
À la suite de mon dernier article en lien avec l’externalisation des données SQL Server sur un stockage […]
AI in SQL Server 2025: Embeddings
One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for […]
SQL Server 2022 CU Updates and Error Code 0x851A0043
I’ve been working in the Azure space for the last few years and less with full server […]
Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL ...
Introduction SQL Server 2022 introduces powerful bit manipulation functions that allow for efficient handling of binary data. These […]
Find Text in Stored Procedure, Function, View, or Trigger
The post Find Text in Stored Procedure, Function, View, or Trigger appeared first on SQLServerCentral.
Implementing Vector Datatype with Azure SQL Server
Overview Searching for relevant information in vast repositories of unstructured text can be a challenge. This article demonstrates […]
Fun with PowerShell Asynchronous
The post Fun with PowerShell Asynchronous appeared first on SQLServerCentral.
MySQL Index Overviews: Descending B-Tree Indexes
Most anyone who works with indexes should be familiar with B-tree indexes. These are the most commonly […]
SQL Server External Tables : archivage et externalisation
L’archivage des données devrait être prévu dès le début des projets. Mais, il faut bien avouer que c’est […]
[Video] Office Hours: Hawaiian Edition
I took your top-voted questions from https://pollgab.com/room/brento and answered ’em from my balcony at Disney’s Aulani Resort in […]
I’m coming to Jacksonville and Raleigh for SQL Saturday! Register ...
I’m coming to Jacksonville, FL on May 2-3 and Raleigh, NC on May 16-17 for SQL Saturdays! In […]
Exploring Scalar Solutions to Complex Data Math
There are many functions and tools available to database professionals that can solve data math challenges, regardless […]
Using Group Managed Service Accounts with SQL Server
The post Using Group Managed Service Accounts with SQL Server appeared first on SQLServerCentral.
How to Develop Solutions with Fabric Data Warehouse: Data Engineering ...
The SQL endpoint of the Fabric Data Warehouse allows programs to read from and write to tables. The […]
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 […]
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 […]