AWS RDS PostgreSQL Restore to a Point in Time
One of the single biggest reasons to go with a Platform as a Service (PaaS) offering like AWS RDS are the things it does for you, like making it...
2024-09-13 (first published: 2024-08-26)
108 reads
Blog Posts
Finding nested references
I originally planned this post just as an answer to DBA Stack Overflow question: How can I get the list of tables in all the stored procedure? After preparing...
2024-09-13 (first published: 2024-08-26)
258 reads
How to Connect Your WordPress Site to the Fediverse
Make it easier for your audience to engage with you by connecting your site to the fediverse.
2024-09-13
14 reads
Undercover Catalogue 0.4.5 Released – Database Module Bug Fix
Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in the Databases module where an unprintable ASCII character was being inserted at the beginning of...
2024-09-12
39 reads
Creating a Synapse Workspace
As part of my job, I needed to research how a few things work with Synapse and Fabric. The latter includes the former, mostly. I decided to setup a...
2024-09-11 (first published: 2024-08-26)
146 reads
Microsoft Fabric AI Skill
Are you ready to have conversations with your data? Announced in public preview within Microsoft Fabric is AI Skill, a new capability in Fabric that allows you to build...
2024-09-11 (first published: 2024-08-26)
353 reads
Saving Emergency Space on my Laptop
With my new laptop, one of the things I realized I’d forgotten to do in setup is reserve some space. I wrote about this years ago, but I wanted...
2024-09-11
21 reads
T-SQL Tuesday #178–A Recent Technical Problem
This month we have a good invitation from Deepthi Goguri, where she asks us about a technical problem. I think most of are technical people and we solve problems...
2024-09-10
29 reads
2024-09-10
17 reads
T-SQL Tuesday 177 roundup: Managing database code
I was privileged to host yet another T-SQL Tuesday, for the month of August, 2024. My topic was on Managing database code. I was worried about getting responses, given...
2024-09-09 (first published: 2024-08-18)
316 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
How do you approach engineering services consulting?
I’ve been thinking a lot about the role of consulting in engineering projects. Having...
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...
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