Episode 34: In-Memory Tables

Episode 34: In-Memory Tables

Hello, compañeros! You’ve heard of Hekaton and in-memory tables before, but what does in memory really mean for your database? Perhaps you have questions like I did, like how does in memory OLTP differ from disk-based tables? What data types aren’t allowed in in-memory tables? Is in-memory only an “on premises” feature or does Hekaton work in Azure too? Is there a minimum amount of memory required for in-memory tables?

In Episode 34 of the SQL Data Partners Podcast, we’re going to talk about in-memory OLTP and in-memory tables with Jos De Bruijn. Jos is a Program Manager at Microsoft for SQL Server In-memory OLTP. We sit with Jos and we explore how in-memory tables work and why they’re just as durable as traditional disk-bound tables. He lays out the whole process. Jos also answers common DBA concerns about them and discusses how to make them efficient. Jos reveals the SQL Server 2016 features that affect in-memory OLTP.

As always, you can catch the show notes for today's episode at http://sqldatapartners.com/2016/03/08/inmemorytables/

Avsnitt(287)

Episode 263: SQL Server This 'n That

Episode 263: SQL Server This 'n That

When we couldn't confirm a guest speaker by recording time, Eugene, Kevin, Amanda, and I decided the show must go on, so we went into the ideas vault and pulled out a couple of listener questions we h...

29 Mars 202342min

Episode 262: Learning Azure Synapse Pt 1

Episode 262: Learning Azure Synapse Pt 1

Learning new technology can be difficult—especially when it's a technology in an area you are not familiar with. In this episode, Eugene walks us through some of the challenges he has faced getting s...

15 Mars 202332min

Episode 261: The Data Lakehouse

Episode 261: The Data Lakehouse

It would appear Microsoft has run out of words to use for new features/products, so they are just going to recycle existing words for a bit of fun at our expense. In this episode we explore the Azure...

1 Mars 202350min

Episode 260: Contained Availability Groups

Episode 260: Contained Availability Groups

We're back with another SQL Server 2022 feature—Contained Availability Groups. Have you ever failed over to a secondary node and then found a job or login missing? This new Enterprise-only feature a...

15 Feb 202336min

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 sn...

17 Jan 202327min

Episode 258: Leave 2022 Enter 2023

Episode 258: Leave 2022 Enter 2023

As we close out the year, we take a look back and think about all those SQL Server 2022 episodes we didn't record this year—and then make the goal to increase this count in the new year. 😊 We discuss...

27 Dec 202230min

Episode 257: The Business of Working for Yourself

Episode 257: The Business of Working for Yourself

Have you ever thought about working for yourself? It can be very enticing for some, and in this episode, we talk with John Sterrett about the pros and cons of running your own organization. We tackle ...

30 Nov 202239min

Episode 256: The Community Episode

Episode 256: The Community Episode

Seven years ago, I started the SQL Data Partners Podcast. We have now arrived at Episode 256, and we dedicate this episode to you, the community. Thanks to everyone who has joined us along the way, an...

3 Nov 202256min

Populärt inom Utbildning

historiepodden-se
rss-bara-en-till-om-missbruk-medberoende-2
det-skaver
harrisons-dramatiska-historia
nu-blir-det-historia
not-fanny-anymore
johannes-hansen-podcast
roda-vita-rosen
rss-foraldramotet-bring-lagercrantz
allt-du-velat-veta
rss-viktmedicinpodden
sektledare
sa-in-i-sjalen
rss-sjalsligt-avkladd
rss-max-tant-med-max-villman
i-vantan-pa-katastrofen
rikatillsammans-om-privatekonomi-rikedom-i-livet
sex-pa-riktigt-med-marika-smith
rss-basta-livet
rss-traningsklubben