Getting locked out of a SQL Server instance can happen due to a number of situations. The most common scenario I’ve encountered is when a SQL Server is moved...
2025-09-15 (first published: 2025-08-27)
457 reads
Working with thousands of instances of Microsoft SQL Server, I often encounter users having issues. A common error is 18456 which indicates a login failure.
The post SQL Server error...
2025-06-18
44 reads
Can you restore multiple differential SQL Server backups
The post Can You Restore Multiple Differential Backup Files? appeared first on Tim Radney.
2025-05-07
35 reads
I have recently had the privilege of working with multiple clients who have been taking advantage of Change Data Capture “CDC”. Change Data Capture is a feature that utilizes...
2025-05-14 (first published: 2025-04-28)
679 reads
I’ve been working with SQL Server for a very long time. Out of the box, SQL Server works great, however there is regular care and feeding that needs to...
2025-03-17
8 reads
Over the years I’ve been called in to work with numerous clients that were hit with ransomware. Even the times that the customer paid the ransom to unlock their...
2025-02-10
8 reads
A full transaction log can occur for a number of reasons. Typically it is due to the log not being truncated with regular transaction log backups, or something else...
2025-01-15
19 reads
SQL Server has evolved a great deal since I first started working with SQL Server 6.5 in 1998. Unfortunately I continually come across newer systems that are configured with...
2024-12-10
14 reads
In the United States, we have our Thanksgiving this month. This is a time where families come together for a huge meal. For many, it is a time to...
2024-11-11
3 reads
I often need to shrink database files. I know, ‘shrinking is bad’, however there are situations where it is very much needed. In my line of work, I come...
2024-10-07
119 reads
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
SQL Server 2025 introduces native support for vector data types and external AI models....
hi everyone I am getting an error when I add a variable to a...
Comments posted to this topic are about the item How to Use SQL Server...
Comments posted to this topic are about the item Choosing an AI in Sept...
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers