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:

Carlos L. Chacon from the SQL Data Partners podcast

Richie Rump from the Away from the Keyboard podcast

Chris Bell from the WoxPod podcast

Us, Guy and Matan, the SQL Server Radio guys

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:

SQL Data Partners Podcast

Away from the Keyboard Podcast

WoxPod Podcast

Guy entering as Superman at PASS Summit

Statistics Parser

SQL Server Radio show 8 - SQLRally Inteviews

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:

https://www.youtube.com/watch?v=aFQItkURnY0

https://www.youtube.com/watch?v=54w4IyGQeJ8

https://www.youtube.com/watch?v=UNANwv7j5TI

* The Data Loading Performance Guide

* Ronen Ariely - T-SQL: Sort Data by Multiple Languages

* Aaron Bertrand - Service Broker Enhancements in SQL Server 2016

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:

* Identifying SQL Server 2014 New Cardinality Estimator issues and Service Pack 1 improvement

* Robert Sheldon - Microsoft Azure Stream Analytics

* Rob Sewell - Setting Up and Using Azure VM SQL Automated Backup (and Restore)

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:

* Pieter's PASS Summit Session: Run Your DBA Morning Checklist with Policy-Based Management

* Pieter Vanhove - How to perform index maintenance on Azure SQL Database

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.

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:

Carlos' PASS Summit Session: Use Hive and Hadoop for High-Performance Data Warehousing

Feodor Georgiev - Using R to Explore Data by Analysis - for SQL Professionals

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.