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
1,152 reads
Learn how to recover a database from a missing or corrupt transaction log file.
2025-02-19
1,152 reads
Accelerated Database Recovery (ADR) is a database-level feature that makes transaction rollbacks nearly instantaneous. Here’s how it works.
2025-02-19
Learn how to use bit manipulation functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022's. Learn practical examples and common errors to simplify binary data management.
2025-02-17
1,527 reads
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
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
1,205 reads
2025-02-14 (first published: 2018-12-20)
11,491 reads
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
In this next article in the Data Engineering with Fabric series, learn the different ways to develop schemas inside of Fabric.
2025-02-12
1,454 reads
In this tip, we will look at how group Managed Service Accounts (gMSA)
2025-02-12
Learn how to create and modify a database project in Azure Data Studio.
2025-02-10
1,283 reads
By Steve Jones
I needed to back up a PostgreSQL database as a part of the repro...
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
Hi all, First I want to ask just a generic question. Does RLS in...
Reading the Microsoft documentation it says SQL2019 STANDARD EDITION has a max memory of...
I have installed the SSIS extension for VS 2022 community. When I go into...
I have this data in a table?
CatIDCatName 3MonitorsWhat is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS cSee possible answers