We kick off the new year discussing a new feature in SQL Server 2022 called Transact-SQL snapshot backups. Good luck with the Google search on this feature--we know we had fun. π These are not the snapshot backups you were frustrated with in 2005. We talk a little bit about who will be interested in this feature and what scenarios it will come in handy. The hardware vendors seem particularly excited about this future as they can now introduce snapshots without needing a third-party application like Veeam to do that for them. We predict more collaboration between the database administrator and the hardware administrator with this feature. We also get a couple of use case scenarios from the community that we share in this episode. Are you looking forward to using snapshots more effectively in your environment? Please let us know your thoughts!
The show notes and video for this episode can be found at https://sqldatapartners.com/2023/01/18/episode-259-t-sql-snapshot-backups/. Have fun on the SQL Trail!
Episode 236: Database Monitoring with SQL Sentry
Episode 235: SQL Trail 2021 In-person Q&A
Episode 234: Communication Tips for the IT Pro
Episode 233: ScriptDOM
Episode 232: Giving Technical Presentations
Episode 231: Mental Health and Wellness in IT
Episode 230: RTO & RPO
Episode 229: Data Migration Assistant
Episode 228: Predicting Application Problems with Database Metrics
Episode 227: SSDT Methodologies for DB DevOps
Episode 226: SQL Server IaaS Agent Extension
Episode 225: Dashboard Design Principles
Episode 224: The Standup Meeting
Episode 223: Podcast Update
Episode 222: Azure Arc-enabled Data Services
Episode 221: SQL Trail March 2021 Retrospective
Episode 220: Microsoft Ignite Recap
Episode 219: SQL Server Inventory
Episode 218: File Growths
Episode 217: A Little Something About A Few Things
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Acquired