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 …
Find Text in Stored Procedure, Function, View, or Trigger
The post Find Text in Stored Procedure, Function, View, or Trigger appeared first on SQLServerCentral.
Fun with PowerShell Asynchronous
The post Fun with PowerShell Asynchronous 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 how to implement a vector database using Azure SQL Server. Azure SQL Server recently introduced vector data type support …
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 used data structures to facilitate faster access to data when we search for exact matches of data using the WHERE clause (or partial matches that can …