Episode 259: T-SQL Snapshot Backups

Episode 259: 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!

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!

Jaksot(287)

Episode 31: What Has Virtualization Done To My Database?

Episode 31: What Has Virtualization Done To My Database?

As database administrators, we have to live with virtualization.  As a consultant, I can't think of a single environment I have been in that didn't have some of the SQL Servers virtualized.  Troublesh...

17 Helmi 201630min

Episode 30: The Best Investment You Can Make

Episode 30: The Best Investment You Can Make

Think of one big investment that will be made this year.  How will it affect you?  Perhaps there is a large server migration project or move to Azure on the books this year.  Maybe you have been given...

10 Helmi 201629min

Episode 29: You Thinking What I Am Thinking?

Episode 29: You Thinking What I Am Thinking?

We each have our way of going about things–this is what makes us unique.  When it comes to getting data out of the database, many times we might think that SQL Server would go about getting data the s...

3 Helmi 201630min

Episode 28: How Do You Know There Is A Problem?  Baselines!

Episode 28: How Do You Know There Is A Problem? Baselines!

Have you ever had a situation where performance got worse and you were sure why?  Do you keep records of when changes happen to your system?  How do we know there's a problem?  Baselines can help us o...

27 Tammi 201632min

Episode 27: Testing Changes Before You Break Production

Episode 27: Testing Changes Before You Break Production

Have you ever wanted a feature to help you assess the impact of future SQL Server upgrades, the impact of hardware or operating system upgrades, and for SQL Server tuning?  Well that tool has been aro...

20 Tammi 201631min

Episode 26: DevOps for the Database--Everyone is Doing it, Right?

Episode 26: DevOps for the Database--Everyone is Doing it, Right?

DevOps for the database--you have probably heard the term if you work in an organization that is deploying code on a regular basis.  The developers have this down to a science, and now it is the datab...

13 Tammi 201626min

Episode 25: Stretch Database

Episode 25: Stretch Database

SQL Server 2016 has several new features and this episode explores the stretch database feature.  One of the unique attributes of this feature is that it uses both the on premise instance and the Azur...

6 Tammi 201632min

Episode 24 Query Store

Episode 24 Query Store

One of the new features being added to SQL Server 2016 is the Query Store which will allow for greater access to the performance history of your databases.  This is going to be extremely helpful when ...

30 Joulu 201535min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
voi-hyvin-meditaatiot-2
rss-narsisti
adhd-podi
psykopodiaa-podcast
rss-rahamania
rss-uskonto-on-tylsaa
rss-valo-minussa-2
mielipaivakirja
rss-vapaudu-voimaasi
rss-niinku-asia-on
rss-duodecim-lehti
rahapuhetta
ilona-rauhala
aamukahvilla
aloita-meditaatio
kesken
dear-ladies
rss-eron-alkemiaa
rss-arkea-ja-aurinkoa-podcast-espanjasta