Show 40 – Bob the Builder

Show 40!

During the show, we talk a little bit about Bob Marley, his songs and their meaning.

We also talk about:

  • Recommended bucket count for In-Memory OLTP
  • On Index rebuild, disable and statistics update
  • How the Datetime2 data type is stored
  • Various SQL Server tuning switches
  • Which operators can work in batch mode
  • AlwaysOn Availability Groups enhancements in SQL Server 2016
  • Async_network_io issues
  • The CXPacket and SOS_scheduler_yield wait types and what they mean

 

Show 39 – Life Balance

This episode doesn’t talk about SQL Server at all.

It talks about changing the way we think and behave around work.

Many of us High-Tech workers are constantly working long hours, checking emails on the phone and taking work home.

We talk about how it can be done differently, and Guy brings his own personal story about how he’s done it.

We talk about working hours and adjusting between work and family life, but also about being home mentally and not only physically, about being disconnected, and about managing a company in a challenging and different way than what most companies do.

You really don’t want to miss this one.

Items mentioned in the show:

Show 38 – Let the Kids Play


Another show is here, and as usual, we have a few items up our sleeves.

Among other topics, we talk about:

  • Best practices for patching SQL Server
  • SQL Server 2016 In-Memory OLTP Enhancements
  • JSON “support” in SQL Server 2016 and XML
  • Database Kosher Certification
  • Erland Sommarskog’s beta_lockinfo
  • SQL Server Monitoring
  • How Albert Einstein came up with his theories

We also talk about family meals, Bar Mitzvas, a funny Druze guy, and more.

 

 

Show 37 – Eitan Blumin


On this show, we have a guest again – Eitan Blumin!

We talk to Eitan about his specialties and about what he loves about SQL Server and what project he’s proud of.

We also talk extensively about Azure DocumentDB, its concepts and when to use it rather than SQL Server.

At the end, Eitan also gives a good advice to people just starting their database career.

Items mentioned in the show:

 

Show 36 – Build, Ignite and SQL Server 2016


Microsoft arranged to huge confrences lately – Build and Ignite, in which they announced some big news. We talk about the news in general, and the things that relate to us as data people.

Among other topics, we talk about:

  • SQL Server 2016 new features
  • Azure SQL Database Enhancements
  • Azure SQL Data Warehouse
  • Azure SQL Data Lake
  • The new way of Microsoft

We also cover other “ordinary stuff”:

  • Internals of In-Memory OLTP
  • Displaying format vs. storing format

Items mentioned in the show:

Show 35 – Give Me Sambusak


On this show, we talk about Alan Turing and how he broke the Enigma machine, about “Ma Yesh”, “Zehu Ze”, and about Sambusak. We also tell a few bad geek jokes.

Oh, we also talk about SQL Server related stuff: About adjusting Log Shipping, about identity and sequence, about execution plans, Azure SQL Database backups, and about Columnstore.

Items mentioned in the show:

Show 34 – GuyDB


On this show, we summarize our European trip, talk about some enhancements in Azure SQL Database and why it’s now a big thing, talk about why In-Memory OLTP is not good enough yet, talk about the best sessions in PASS Summit 2014, talk a bit about MySQL, and more.

Items mentioned in the show:

Show 31 – SQLSaturday Israel Recap


On this show, we summarize the technical part of SQLSaturday Israel which took part last month. We talk about the interesting sessions we attended, and about the things we covered about in our sessions.

Among other topics, we talk about:

  • What is Bulk Loading
  • What is Minimal Logging and how you can achieve it (not as easy as you think)
  • What is EAV and how you can make it super fast
  • Clustered Index Scan vs Allocation Order Scan
  • How to start thinking about “Big Data” technologies
  • How we get prepared for delivering a presentation
  • And more..