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 maybe 10-20, but over the years, people kept gradually adding one column after another. Now, this behemoth is causing you problems bec …
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 to how to effectively use it to drive business growth and innovation. Having recognized the power of the cloud in terms of agility, scalab …
Crazy number of Parameters… and a challenge
The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on X: So I replied: “Challenge Accepted”, well, actually I replied with a gif of Neo saying it, but the effect was the same. So, I decided to …
How to use the Azure Emulator to create blob containers, queues and tables
Introduction Sometimes, we need to test our apps in Azure and we do not have time to connect and work with Azure directly. We want a simple free offline solution to test our Azure without connecting to the real Azure Storage. This article will show how …
Upgrade and Migrate SSIS Catalog and SSISDB to a New Server
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 locally. Maintenance Plans are used in SQL Server to easily configure and automate tasks that keep the database instance in shape. Today’s demo is …
[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. Here’s what we covered: 00:00 Start 02:17 Pro: Are sessions sleeping during transactions harmful, and do they prevent …
Fabric Databases Connection Secrets
Fabric Database was a great announcement during Ignite Conference. The announcement spread all around, a great new feature. This feature seems simple, especially for everyone who already knows about Azure SQL. However, we don’t need to dig too de …
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. I hope you’ll forgive me for talking a little about it today. I promise not to make it a habit. A friend of mine recently asked me priv …
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 State
Introduction In this article, we will learn how to restore a database which is stuck in the Recovery Pending State. Recently, due to power failures, the disk which contains the transaction log file was failed. Due to that, some of the development datab …
I’m Doing Free SQL Server Spring Training Live Webcasts. Register Now.
Starting next month, I’m doing absolutely free 90-minute live training webcasts to help y’all get your learn on: March 11: Fundamentals of Index Tuning March 18: Fundamentals of Query Tuning April 1: Fundamentals of TempDB April 8: Fundamen …
AI in SQL Server 2025: Embeddings
One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for text, video, or audio, uses something related to embeddings. Starting with SQL Server 2025, this is a term you’ll be hearing a lot, as its potenti …
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 installations. Azure leaves file locations out of my control, but I recently had a client upgrading an on-prem server to SQL 2022.It was a fresh installation on a new …
Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022
Introduction SQL Server 2022 introduces powerful bit manipulation functions that allow for efficient handling of binary data. These functions BIT_COUNT, GET_BIT, and SET_BIT provide direct manipulation of individual bits, which is useful for tasks such …