A New Word: Mottleheaded
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family, or friends and colleagues, or colleagues and family – mixing a medley of ingredients that...
2024-09-20
8 reads
Blog Posts
Redgate Clone Graduating Images
I wanted my own custom image in our internal Redgate Clone cluster, so I decided to make one. This is an overview of how this works. This is a...
2024-09-20 (first published: 2024-09-09)
129 reads
SQL Server Quickie #47 – Azure SQL Database
Today I have uploaded SQL Server Quickie #47 to YouTube. This time I’m talking about Azure SQL Database. If you are interested in learning more about this very interestingh...
2024-09-20 (first published: 2024-09-05)
217 reads
Missing Columns in Extended Events Live Data Explorer
Let me be extremely clear up front, this is not my original work. I saw this post on DBA.StackExchange.com and I wanted to share and promote it. Nice work...
2024-09-18 (first published: 2024-09-02)
120 reads
Using T-SQL Snapshot Backup - Point in Time Recovery
Introduction In this post, the second in our series, I will guide you through using the new T-SQL Snapshot Backup feature in SQL Server 2022 to take a snapshot...
2024-09-18 (first published: 2024-09-01)
272 reads
Comparing Power BI Core Visual and Deneb Stacked Column Chart
One of the new features in the August Power BI Desktop release is the updated legends that are styled to more accurately reflect the per-series formatting on the visual....
2024-09-16 (first published: 2024-08-26)
146 reads
Connect With More Clients: Our Partner Directory Has Arrived
The partner directory connects your agency with new customers.
2024-09-16
18 reads
Spatial Databases & Geospatial Data: A Beginner’s Guide
Ever used Google Maps to find the fastest route home? That's geospatial data in action, turning physical locations into digital info so you can navigate efficiently. Spatial databases take...
2024-09-16 (first published: 2024-08-27)
302 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
6 reads
A New Word: Fensiveness
fensiveness – n. a knee-jerk territorial reaction when a friend displays a casual interest in one of your obsessions. I think that some of us have some fensiveness about...
2024-09-13
14 reads
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
Columnstore index question
Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...
Transactional Replication
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Member was not found in the cube when the string
Hey, I've not done a cube for many years but I find myself supporting...
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers