SQL Server Radio

In this show, we talk to William Durkin (Blog | Twitter), an Englishman "stuck in Germany".

William just switched to being an independent SQL Server consultant, and we talk to him about going independent, how to price yourself the right way, and about many good SQL Server tips.

Specifically, we talk about:

• His way for becoming an independent consultant
• How to price yourself by value and not by time
• SQL Server Replication tips
• Tips for upgrading SQL Server with minimal downtime
• What is the meaning of 5 nines and how much technical and financial investments it requires
• When and how to use DNS aliases with your SQL Servers
• Dynamic Data Masking use cases
• Linked Servers performance tips

Items mentioned in the show:

• Double Your Freelancing - Student Success Story with William Durkin
• Global Azure Bootcamp
• SQLKonferenz

About William

William is an independent SQL Server consultant from England (now in Germany). He has experience as a DBA in large multi-national SQL Server environments and is a regular speaker around Europe.

Download Episode (mp3)

On this show, we talk to the famous podcaster, Richard Campbell (LinkedIn | Twitter).

Richard is the co-host of the .NET Rocks podcast, host of the RunAs Radio podcast, and a long-time technology consultant and business owner.

We talk to him about Devops, the Microsoft data platform, the cloud and podcasting.

Among other topics, we cover:

* What is DevOps, and how the database fits in this kind of strategy

* The state of the Microsoft data platform and the new versions of SQL Server

* How Microsoft Azure competes with Amazon and Google Cloud

* Will you lose your job to the cloud?

* What was the original purpose of the relational model

* The history of the .NET Rocks podcast and how its done today

Items mentioned in the show:

* .NET Rocks Podcast

* RunAs Radio Podcast

* Goldman Sachs on Microsoft: 'We Were Wrong'

* Serial Podcast

* .NET Rocks Show 1220 - Next Generation Airliners Geek Out

About Richard:

Richard Campbell wrote his first line of code in 1977. His career has spanned the computing industry both on the hardware and software sides, development and operations. He was a co-founder of Strangeloop Networks, acquired by Radware in 2013 and spent five years on the board of directors of Telerik which was acquired by Progress Software in 2014. Today he is a consultant and advisor to a number of successful technology firms as well as the founder and chairman of Humanitarian Toolbox (www.htbox.org), a public charity that builds open source software for disaster relief. Richard is the co-owner and content planner of the DevIntersection (www.devintersection.com) group of conferences. He is also the host of two podcasts: .NET Rocks! (www.dotnetrocks.com) which publishes three shows a week to .NET developers and RunAs Radio (www.runasradio.com) which is a weekly show for IT Professionals. You can reach Richard at [email protected].

On this show, we talk to the famous podcaster, Richard Campbell (LinkedIn | Twitter).

Richard is the co-host of the .NET Rocks podcast, host of the RunAs Radio podcasts, and a long-time technology consultant and business owner.

We talk to him about Devops, the Microsoft data platform, the cloud and podcasting.

Among other topics, we cover:

• What is DevOps, and how the database fits in this kind of strategy
• The state of the Microsoft data platform and the new versions of SQL Server
• How Microsoft Azure competes with Amazon and Google Cloud
• Will you lose your job to the cloud?
• What was the original purpose of the relational model
• The history of the .NET Rocks podcast and how its done today

Items mentioned in the show:

• .NET Rocks Podcast
• RunAs Radio Podcast
• Goldman Sachs on Microsoft: 'We Were Wrong'
• Serial Podcast
• .NET Rocks Show 1220 - Next Generation Airliners Geek Out

About Richard:

Richard Campbell wrote his first line of code in 1977. His career has spanned the computing industry both on the hardware and software sides, development and operations. He was a co-founder of Strangeloop Networks, acquired by Radware in 2013 and spent five years on the board of directors of Telerik which was acquired by Progress Software in 2014. Today he is a consultant and advisor to a number of successful technology firms as well as the founder and chairman of Humanitarian Toolbox (www.htbox.org), a public charity that builds open source software for disaster relief. Richard is the co-owner and content planner of the DevIntersection (www.devintersection.com) group of conferences. He is also the host of two podcasts: .NET Rocks! (www.dotnetrocks.com) which publishes three shows a week to .NET developers and RunAs Radio (www.runasradio.com) which is a weekly show for IT Professionals. You can reach Richard at [email protected].

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:

* Rob Volk at Speaker Idol

* The Five Minute Journal

* Smart Passive Income

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)