A Fine Slice Of SQL Server
Tomaz Kastrun wants an easy date:
It is a rare thing that a date can be a palindrome. But it happens.
And the idea is the following, to cover all different date formats and for the given period
Click through for palindrome analysis in the most common 6- and 8-digit date formats.
Leave a CommentThomas Williams messes with the command line:
This post is part 1 of quality-of-life changes I make when I first log in to a new Linux server. I primarily use
bash(though I also havezshset up on some machines):
.hushlogin.inputrc.vimrc.bashrc
Click through for some examples of customization. I’m not sure if Thomas will get to this in the series, but I like using powerline for more advanced customization.
Leave a CommentUmair Shahid explains that you need more:
When AWS stumbled – twice – in October 2025, many teams discovered that “we are in the cloud” is not the same as “we have disaster recovery”.
Applications went offline, customer-facing portals returned errors, and internal dashboards that teams rely on every morning failed to load.
Most of those systems were already running on managed cloud services. They had multi-AZ databases, auto scaling groups, and health checks. What they did not have was a clear answer to three simple questions:
Read on for those questions, which are critical to ensuring business continuity.
Leave a CommentReitse Eskens digs into some results:
I’ve been working for quite some time on a fun solution in Fabric Realtime Intelligence. We’re processing XML files into a structured table. As you’re probably aware, XML has its own… well, let’s be nice and call them challenges.
One thing I ran into was that an element contained several other elements. Usually, you’ll see them in an array, but in this case, it wasn’t. Since these elements within the main element contain the information we need for the table, I started thinking about how to extract this data.
Read on for an example of the type of Data Reitse was looking to process, as well as how the problem ended up being a lot easier to solve than first appearances would indicate.
Leave a CommentJonathan had a client issue recently where SQL Server’s buffer pool had been forced down to a ridiculously small size, only a few hundred MB, but the OS also showed basically no free memory. Page Life Expectancy was zero! What was going on?
From investigating SQL Server’s memory usage, the memory manager showed that target and total memory were the same, at only 1.2GB, and lock pages in memory was correctly set.
Read on for Jonathan’s troubleshooting steps and what he discovered.
Leave a CommentSean Gallardy digs into an issue:
Someone asked if I’ve ever had a CU install where you run it and it goes through the extraction process, then right as it hits 100% just exists and nothing happens. Well, that’s pretty weird, and no, I hadn’t. I was, however, intrigued! Since I love my readers, I made a repro of what the person this was occurring to, saw.
Click through for the expectations and what it actually turned out to be.
Leave a Comment