How to Protect Against Ransomware as a DBA
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
26 reads
Tim Radney
SQL Server Error 9002 – Full Transaction Log
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
44 reads
SQL Best Practices
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
79 reads
It is Work to Live not Live to Work
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
13 reads
Msg 3140 – Could Not Adjust the Space Allocation for File
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
253 reads
Why You Need a SQL DBA or Consultant
Many organizations do not have in-house DBAs. This can be due to a number of reasons. Most commonly it is smaller organizations that cannot justify a full time DBA....
2024-09-16
10 reads
Your SQL Server is Slow, What To Look At
As a data professional, you’ll often get a phone call, email, or trouble ticket that says “SQL Server is slow, my query is slow, or things are slow”. This...
2024-08-12
15 reads
Risk with Not Patching and Upgrading SQL Server
Working with SQL Server over the past 25 years for various organizations all over the world, I usually always find a database server that is well outside of support....
2024-07-15
39 reads
Purging SQL Server Backup History
It seems like every few weeks I come across a database server with a very large msdb. After a small amount of investigation work, I determine that the largest...
2024-06-10
20 reads
Getting Error 64 When Trying To Connect to SQL Server or Azure
Often times when working with a client, I’ll run into issues or get emails from a client with a message like the following: A connection was successfully established with...
2024-05-14
19 reads
Blogs
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Forums
Troubleshooting WQL in custom PBM conditions?
Hi, I'm currently trying to implement policy based mgmt with a condition to query...
Analysis of Locking Issues on Secondary Replicas in AlwaysOn Availability Groups
We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers