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
25 reads
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
25 reads
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)
315 reads
Here's how we used WordPress Components and Tailwind CSS to build our local development app, Studio.
2024-07-31
22 reads
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)
153 reads
The short answer is: You’ll be eligible for a piece of the pie, plus increased traffic to your website.
2024-07-30
11 reads
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)
493 reads
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
11 reads
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)
230 reads
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
8 reads
vicarous – adj. curious to know what someone else would do if they were in your shoes, eager to watch another actor put their own spin on the character...
2024-07-26
8 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;