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
19 reads
Blog Posts
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)
264 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,551 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
24 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)
195 reads
2024-08-27
19 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)
248 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)
364 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
5 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
5 reads
Blogs
When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
Prepping for Certification, Part 4 of 4
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Flyway Tips: Automation Assistance in Flyway Desktop
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
Forums
CAST datetimeoffset(7) as a datetime in UK format
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
what are the downsides of TDE not running vs running?
hi for the 2 years i've been here I believe we've had "encryption" turned...
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers