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-04-28
27 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
1 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
1 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
5 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
1 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
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
5 reads
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
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
1 reads
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
5 reads
By Steve Jones
SQL Saturday Austin 2025 is in just a few days. I am honored to...
By Steve Jones
I’ve been using the SSMS preview for v21. This is the next evolution of...
In the blog post Call a Fabric REST API from Azure Data Factory I...
I finally got the PowerQuery source to "show" in SSIS (so I can see...
Hi Team, Can you someone suggest a few good third part backup tools, with...
Recently I upgraded my ssis package from 2016 to 2022, but package format version...
What does the monitor server do in log shipping?
See possible answers