T-SQL Snapshot Backups
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!
One of the changes is that SQL Server will support the RESTORE of those snapshots and you can restore it in NORECOVERY mode and add logs to it.
Meet the Hosts
With more than 10 years of working with SQL Server, Carlos helps businesses ensure their SQL Server environments meet their users’ expectations. He can provide insights on performance, migrations, and disaster recovery. He is also active in the SQL Server community and regularly speaks at user group meetings and conferences. He helps support the free database monitoring tool found at databasehealth.com and provides training through SQL Trail events.
Eugene works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.
Kevin is a Microsoft Data Platform MVP and proprietor of Catallaxy Services, LLC, where he specializes in T-SQL development, machine learning, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL, president of the Triangle Area SQL Server Users Group, and author of the books PolyBase Revealed (Apress, 2020) and Finding Ghosts in Your Data: Anomaly Detection Techniques with Examples in Python (Apress, 2022). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.