Microsoft 365 Security and Compliance for Administrators, a Book Review
I was asked to review the following book by the publisher, and I must say that it was a good experience for me. I used the book to help...
2024-07-22
30 reads
Latest Update for Undercover Catalogue Powershell Interrogation Script
We’ve been hearing of a few people getting errors from the latest Undercover Catalogue, Powershell interrogation script. The issue seems to be happening when the scripts tries downloading automatic...
2024-07-22
39 reads
How I implemented database migration on AWS using AWS DMS
As a Software Engineer, I would like to replicate a copy of my database from on-premise infrastructure to AWS. This will require me to look for a perfect tool...
2024-07-24 (first published: 2024-07-20)
379 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)
226 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)
175 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)
248 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)
109 reads
A New Word: Solysium
solysium – n. the unhinged delirium of being alone for an extended period of time – feeling the hours stretch into days until a weird little culture begins to...
2024-07-19
45 reads
The Annual SQL Saturday in Baton Rouge
I’ve been to quite a few of the SQL Saturday Baton Rouge events. There have been 10 with the 11th coming in a couple weeks. The crew down there...
2024-07-17
19 reads
25 Years of Redgate
I’m in Austin today, ready for the Redgate Software 25th Birthday celebration. The company started in 1999 and this is their 25th birthday. All of our offices are celebrating,...
2024-07-17
74 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers