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
28 reads
Blog Posts
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)
199 reads
2024-08-27
20 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)
255 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)
367 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
39 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
19 reads
A New Word: Midding
midding – n. the tranquil pleasure of being near a gathering but not quite in it – hovering on the perimeter of a campfire, talking quietly outside a party,...
2024-08-23
65 reads
One Month with the Dell Latitude 7450
It was just over a month ago that I got a Dell Latitude 7450 from our corporate IT group. It wasn’t my first choice, but as Redgate grows, they’re...
2024-08-23
17 reads
Blogs
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers