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.
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....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Comments posted to this topic are about the item Is Ransomware Fading?
Comments posted to this topic are about the item How to Resolve SQL Server...
Comments posted to this topic are about the item A Simple Choice
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