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
34 reads
Blog Posts
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
31 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)
326 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
27 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)
162 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
15 reads
Calling a REST Endpoint from Azure SQL DB
External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas before, we might have needed an intermediate technology to make a REST call to an...
2024-07-29 (first published: 2024-07-23)
507 reads
DevOps Days Minneapolis
Once again, I’m off to a conference next week. This time it is DevOps Days Minneapolis. I haven’t been to a DevOps Days event, though I always enjoy DevOps...
2024-07-29
19 reads
The Importance of Patch Management to Avoid Downtime
A recent Microsoft outage caused by a bad patch pushed out to Windows instances managed by CrowdStrike has thrown a spotlight on the critical importance of effective patch management....
2024-07-29 (first published: 2024-07-19)
231 reads
SQL Saturday Baton Rouge 2024–Resources
For my talk at SQL Saturday Baton Rouge 2024, here are the resources. Slides: Architecting Zero Downtime.pptx GitHub: https://github.com/way0utwest/ZeroDowntime If you have questions, reach out.
2024-07-27
11 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers