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.
Learn how to recover a database from a missing or corrupt transaction log file.
There is a report that less ransomware ransom is being paid. Perhaps that's a good sign for all of us.
Accelerated Database Recovery (ADR) is a database-level feature that makes transaction rollbacks nearly instantaneous. Here’s how it works.
The number of times that you have a failure when deploying changes is a good metric to watch.
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.
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?
I just saw one of "those" questions. You know the ones: 'We're hitting an error with a stored procedure. What is the maximum number of parameters you can have?" <sigh> Look, I get it. Breaking the land speed record is cool. Getting the most people into a phone booth (look it up), also cool. Fastest, […]
With SQL Server on Linux becoming more popular, Steve asks if you think you need to know much about that OS.
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.
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...
Introduction Do you remember the effort of tidying up your BI and reporting systems,...
By Steve Jones
I needed to back up a PostgreSQL database as a part of the repro...
Last week I downloaded and applied the newest CU31 patch to our lower environment...
Hi All, I can see many tables under MasterDataServices like below in an...
I need some guidance on choosing data types and lengths for columns in my...
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