How to use the Azure Emulator to create blob containers, queues and tables
Learn how to emulate Azure storage for files, blogs, and queues.
2025-02-24
1,489 reads
Articles
What If You Need to Index a Lot of Duplicate Data?
Let’s get a little nerdy and look at database internals.
2025-02-24
Configuring Maintenance Plans in SQL Server
See a walkthrough of setting up a maintenance plan in SQL Server.
2025-02-21
2,466 reads
Upgrade and Migrate SSIS Catalog and SSISDB to a New Server
There will come as time when you need to upgrade the host operating system and SQL Server to a newer version. If you are using SQL Server Integration Services (SSIS), one of the things you may need to do is to move the SSIS catalog (SSISDB database) to the new server. We will cover the steps in this tutorial to migrate the SSISDB from one server to another.
2025-02-21
How to Resolve SQL Server Database Stuck in Recovery Pending State
Learn how to recover a database from a missing or corrupt transaction log file.
2025-02-19
5,929 reads
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.
2025-02-19
Find Text in Stored Procedure, Function, View, or Trigger
How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or any string that is part of the code?
2025-02-17
Implementing Vector Datatype with Azure SQL Server
This article shows how to insert data into a database, create embeddings, and then use this data to search the data with a natural language interface.
2025-02-14
2,286 reads
Fun with PowerShell Asynchronous
Imagine a candle that is lit and takes 1 hour to burn out. Now imagine one hundred candles. How many hours will it last? That depends. If they are lit simultaneously, it will take 1 hour. That is the basic idea of running in the background or asynchronously. Of course, the 100 candles can execute independently of one another, unlike if you try to run 100 processes on a computer with 2 cores. PowerShell has some ways to manage that, as PowerShell job – which we will see in this article – runspaces – needs to add programmable using .net.
2025-02-14
How to Develop Solutions with Fabric Data Warehouse: Data Engineering with Fabric
In this next article in the Data Engineering with Fabric series, learn the different ways to develop schemas inside of Fabric.
2025-02-12
2,188 reads
Blogs
Come See Me at the PASS Data Community Summit
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
SQL Clone at Scale with Striped Backups
By Steve Jones
I had a customer recently reach out to ask if SQL Clone would work...
How to Set Up SQL Server 2025, Ollama and NGINX in Docker Without the Headaches
Ollama SQL FastStart kit just works out of the box. It makes it easy...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Connecting to SQL express 2019 server
Hello, Our old server is on its last legs, and I'm transitioning to a...
Question of the Day
Striped Backup File Limits
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers