Show 37 – Be Happy

In this show, you’ll hear lots of stories about time zones, time machines, paradoxes, and what makes humans happy.

We also talk about:

  • What is the Max Worker Threads option and when you should change it
  • SQL Server 2016 AlwaysEncrypted limitation
  • More SQL Server setup tips
  • Quoted Identifiers
  • What is Optimize for ad hoc workloads

Items mentioned in the show:

Show 36 – Podcasters Panel at PASS Summit 2015

Download Episode (mp3)

While at PASS Summit a few weeks ago, we sat together with a few other podcasters for a talk about mentors, speaking, podcasting and community.

The participants where:

Among other topics, we talked about:

  • Who are our mentors and how have they helped us?
  • What are the qualities of a good mentor?
  • How we started speaking and sharing with the community
  • What should you do when you become a mentor yourself?
  • Why a little bit of guts almost always helps
  • Why it’s important to meet new people
  • How SQL Server Radio was started

Items mentioned in the show:

PASS Summit Podcasters Panel

Show 35 – What the Hell is DPM?

Download Episode (mp3)

In this show, we talk about:

  • Our experience from PASS Summit and MVP Summit
  • Sorting by multiple languages in SQL Server
  • Service Broker enhancements in SQL Server 2016
  • Policy Based Management terminology – what are Facets?
  • Extended Stored Procedures
  • And of course, what the hell is DPM?

We also start a small tradition of giving a few SQL Server setup tips in each show.

Items mentioned in the show:


Show 34 – Do You Have a Backup?

Download Episode (mp3)

In this (rather old) episode, we talk about:

  • Analyzing real time data with Azure Event Hub and Stream Analytics
  • What is Agile
  • Text manipulation in SQL Server
  • Reading deleted data out of SQL Server
  • Identifying problems with the new SQL Server 2014 Cardinality Estimator
  • What is Trace Flag 4199
  • Lock Escalation
  • And more..

Items mentioned in the show:

Show 33 – What Google and Facebook Know about You…

Download Episode (mp3)

In this show:

  • We congratulated Matan for being awarded as a SQL Server MVP. Go Matan!
  • Just around the corner: PASS Summit and MVP Summit.
  • Think you can catch errors in a remote servers within a distributed transaction? Think again…
  • How Netflix survived AWS disruption last month by using chaos…
  • Differences between on-premises and cloud applications
  • What Google and Facebook know about you…
  • How fast is technology going to advance one year from now?
  • One Big RAID 10: The new standard in server storage
  • Why do we need right outer joins?

Show 32 – Morning Checklists, Policy Based Management and Automation with Pieter Vanhove

Download Episode (mp3)

The PASS Summit interview series continues, and today we talk to Pieter Vanhove (Blog | Twitter). Pieter is a Premier Field Engineer at Microsoft, and we talk to him about his experience from Microsoft and his previous job. Among other topics, we talk to Pieter about:

  • Why you need a morning checklist
  • How can you do it better with Policy Based Management and a Central Management Server
  • Migrating SQL Server to Azure
  • Automation in Azure

Pieter was also the first winner of Speaker Idol and therefore won the prize of presenting a session on this year’s PASS Summit. We talk about how he won the contest, and also about how he prepared for presenting a session with another presenter that lives more than 5000 kilometers from him.

Items mentioned in the show:

About Pieter

Pieter Vanhove is a Microsoft Premier Field Engineer in Belgium and has been working with SQL Server since 2000. Performance tuning, SQL audits, migrations and training are part of the job. Pieter has also a profound knowledge in implementing high availability and disaster recovery solutions. Together with the SQLUG in Belgium, he helps organizing SQL Server Days and is also a regular speaker at Belgian and international events.

Pieter Vanhove

Show 31 – The Hadoop Ecosystem with Carlos Bossy

Download Episode (mp3)

We continue our PASS Summit interview series, and today we talk to Carlos Bossy (Blog | Twitter) about Hadoop, Hive and the Hadoop ecosystem in general.

There are many technologies in the Hadoop zoo, and we explain what those technologies do, how they work compared to SQL Server tools, and when to use which technology.

We also compare R to T-SQL, and even talk a tiny bit about MongoDB.

Items mentioned in the show:

About Carlos

Carlos Bossy (MCTS, MCP BI, CBIP) is a data and BI architect with 25 years of experience in software and database development. As principal consultant of his company, Carlos focuses on developing BI solutions, including modeling data warehouses and delivering predictive analytics, integration, and reporting. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.

Carlos Bossy