Developer Q&A: Dika Fei of Jelly Pixel Studio
"Let me know where you get your magic pixie dust from!"
2024-08-30
43 reads
Blog Posts
Friday Flyway Tips: Git Integration in Community Edition
Redgate added Git integration to the free, Community edition of Flyway Desktop. I saw the announcement and decided to make this post to show how this can work for...
2024-08-30
47 reads
Python: How to use secrets stored in azure key vault in your Pulumi project
Software Engineers are excited to create Infrastructures just like DevOps Engineers. However, other IaC tools like Terraform and CloudFormation, relies on domain-specific Languages (DSLs) or JSON/YAML templates to create...
2024-08-30 (first published: 2024-08-15)
304 reads
Migrate Your Azure Data Studio Connection List
I wanted to migrate some connections without recreating them and wondered how to do that in Azure Data Studio. It turns out to be easy. I post about whatever...
2024-08-28 (first published: 2024-08-12)
2,982 reads
Moving One File Across Git Branches: #SQLNewBlogger
I was working on some branching and merging with a customer and they wanted to move a file from one branch to another without taking the entire commit. I...
2024-08-28
33 reads
Observing Extended Events
Sure, you can right click on a running session for Extended Events and open the Live Data window, but are there other ways of observing what Extended Events is...
2024-08-28 (first published: 2024-08-12)
209 reads
2024-08-27
32 reads
Backup SQL Server to AWS S3 Bucket (2022 Update)
Way back in the mists of time I wrote a post on how to backup SQL server to an S3 bucket using TNTDrive, https://sqlundercover.com/2018/06/18/backup-your-on-premise-sql-server-directly-to-an-aws-s3-bucket/. Back then, if we wanted...
2024-08-26 (first published: 2024-08-13)
288 reads
Boost Your SQL Skills: A Fun, Hands-on Challenge Awaits!
Are you ready to take your SQL skills for a spin? The August 2024 SQL Practice is here to offer you a fun, hands-on learning experience. Designed with real-world...
2024-08-26 (first published: 2024-08-12)
373 reads
Comparing Power BI Core Visual and Deneb Stacked Column Chart
One of the new features in the August Power BI Desktop release is the updated legends that are styled to more accurately reflect the per-series formatting on the visual....
2024-08-26
44 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