Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup times and resource contention. T-SQL Snapshot Backup, a new feature in SQL Server 2022, addresses...
2024-09-01 (first published: 2024-08-31)
154 reads
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)
280 reads
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,665 reads
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)
198 reads
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)
254 reads