Show 35 – Give Me Sambusak

Play

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

Play

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

Play

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

 

Show 30 – סילומיות

Play

We’re in Israel, and unlike in this site where we write in English, some people (Maria Zakourdaev and Yoni Nakache) insist on writing in the language of the Hebrew man. That’s how we learned about the word “סילומיות”, and in the episode we explain what it means, with demonstrations.

Another important milestone in this show is the fact that Guy is now an MVP!. We talk about how Guy got this achievement, and how you can do it too.

In addition, we talk about:

  • Azure SQL Database enhancements and possible mistakes Microsoft makes with the new features
  • sp_MSforeachdb – How to use it the right way
  • Gaps in Identity and Sequence
  • Change Data Capture (CDC)
  • SQLSaturday Israel recap
  • And more..

Items mentioned in the show:

Show 29 – Adi Sapir (Part 2)

Play

It’s part 2 of the fascinating interview we had with Adi Sapir (LinkedIn, Twitter).

On this part, we deal a lot with deploying changes to production, and mainly whether to do it using automatic tools or manually.

In addition, we talk about:

  • SSDT
  • Continues Deployment
  • The Cloud
  • Version upgrades
  • The next version of SQL Server
  • Living in America

We also talk about the cool handy tools Adi develops.

Items mentioned in the show:

 

 

Show 28 – Adi Sapir (Part 1)

Play

On this show, we have an important guest from abroad – Adi Sapir! 

Adi (LinkedIn, Twitter) is a DBA for many years and today he’s a Data Architect at Getty Images in Seattle.

We had a fascinating talk and we divided it to two parts.

On this part, we talk about:

  • The role of the Database Architect
  • The current place of SQL Server in the jungle of database systems
  • What not to do with SQL Server
  • Fighting with ORMs
  • And more..

Adi also develops a few cool products for DBAs and developers. Check them out on www.doccolabs.com

Show 27 – Partitioning

Play

On this show, our topic is Partitioning.

We first talk about how we implemented Partitioning before SQL Server 2005 (or on Standard Edition).

After that, we talk about:

  • How to implement Partitioning
  • When it’s right and wrong to use it
  • Will Partitioning help with query performance
  • How to make sure you leverage its benefits
  • Improvement Microsoft implemented over the years
  • Partitioning maintenance tactics
  • and much more..

 

Show 26 – Migrutz

Play

What’s the best way to migrate from SQL Server 2008R2 to SQL Server 2014 with a possible fallback? We start the show with an interesting discussion about this subject.

Later on, we talk about:

  • Cool tips for SSMS
  • Central Management Servers
  • Plan Guides
  • What needs does Azure DocumentDB come to address
  • Delayed Durability
  • Interesting behaviors of Availability Groups
  • Database documentation

Items mentioned in the show: