Using Managed Identities with Azure SQL DB
We are trying to get apps and users off of using SQL accounts to access the Azure SQL DBs where I work. To make our lives easier, we are...
2024-08-05 (first published: 2024-07-25)
358 reads
Blog Posts
A New Word: Bareleveling
bareleveling – v. trying to improve yourself without anyone else knowing about it, afraid that they’ll think it’s silly or grandiose or unnecessary, or that they’’ll end up calling...
2024-08-02
18 reads
Friday Flyway Tips–Comparison Defaults
One of the little details that I find matter more and more in enterprises is understanding why a tool behaves a certain way. OSS/home-grown ones often have limited docs,...
2024-08-02 (first published: 2024-07-19)
91 reads
My personal experience dockerizing a Rust Application: Deploy to AWS ECR using Github Actions
I have heard about many interesting things about programming in Rust and I decided to use Rust for one of my applications. I enjoyed the programming experience in Rust...
2024-08-02 (first published: 2024-07-20)
194 reads
SQL Training: The Hidden Engine Driving Business Growth
In the digital age, data is the new gold, but it's worthless if you can't understand and use it. That's where SQL (Structured Query Language) comes in. SQL is...
2024-08-02
32 reads
Welcome to the Fediverse Files: What Is the Fediverse?
Have you heard the term "fediverse" and wondered what the heck it is? Doc Pop is here to explain. And no, it's not a cheese pun.
2024-08-02
27 reads
Are Your Secondary Availability Group Read Only Replicas Falling Behind? Are You Seeing PARALLEL_REDO_TRAN_TURN Waits?
Are you struggling with a laggy redo and a build up in the redo queue on your readonly secondaries? Are you suffering with high PARALLEL_REDO_TRAN_TURN waits? Then this magic...
2024-07-31 (first published: 2024-07-17)
318 reads
Building Studio in Public: Using WordPress Components and Tailwind CSS in our Local Development App
Here's how we used WordPress Components and Tailwind CSS to build our local development app, Studio.
2024-07-31
23 reads
Terraform Elastic Jobs
I did a couple of other posts on Elastic Jobs. But now I want to set them up with Terraform. This aligns with how we create infrastructure where I...
2024-07-31 (first published: 2024-07-19)
154 reads
Why We’re Partnering With Perplexity
The short answer is: You’ll be eligible for a piece of the pie, plus increased traffic to your website.
2024-07-30
12 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