SQL Server Radio

Download Episode (mp3)

 

A few months ago we hosted Sean McCown for a talk about indexing tips and backup performance.

On this show, we have Sean again.

Sean reveals tons of backup tips and tricks while talking about his new free product, Minion Backup.

Among other topics, we talk about:

* What are VLF's and why it's not good to have many of them

* When you SHOULD use shrink

* Why Sean doesn't like Policy Based Management

* How to monitor backup progress

* Regular Expressions in SSMS

And as always with our guests, we play Scattergories, and Sean tells a VERY interesting story about cluster configuration.

Items mentioned in the show:

* Minion Backup

* Sean's PASS Summit session - Monster Text Manipulation: Regular Expressions for the DBA

* Sean's PASS Summit precon - The Enterprise Scripting Workshop

 

About Sean:

Sean McCown is a Microsoft Certified Master in SQL Server 2008. He is also a SQL Server MVP with over 20 years experience in databases. Sean is also founder and co-owner of the renowned website MidnightDBA.com where he records free SQL Server training videos and co-hosts the popular webshow, DBAs@Midnight.

A few months ago we hosted Sean McCown for a talk about indexing tips and backup performance.

On this show, we have Sean again.

Sean reveals tons of backup tips and tricks while talking about his new free product, Minion Backup.

Among other topics, we talk about:

• What are VLF's and why it's not good to have many of them
• When you SHOULD use shrink
• Why Sean doesn't like Policy Based Management
• How to monitor backup progress
• Regular Expressions in SSMS

And as always with our guests, we play Scattergories, and Sean tells a VERY interesting story about cluster configuration.

Items mentioned in the show:

• Minion Backup
• Sean's PASS Summit session – Monster Text Manipulation: Regular Expressions for the DBA
• Sean's PASS Summit precon – The Enterprise Scripting Workshop

About Sean:

Sean McCown is a Microsoft Certified Master in SQL Server 2008. He is also a SQL Server MVP with over 20 years experience in databases. Sean is also founder and co-owner of the renowned website MidnightDBA.com where he records free SQL Server training videos and co-hosts the popular webshow, DBAs@Midnight.

Download Episode (mp3)

We tried something new this time, and broadcast the show live on Persicope.

Periscope is a service by Twitter that allows each one to start a live broadcast anywhere and anytime from his phone or tablet. We will try it out a few more times, so watch for our announcements about future broadcasts on Twitter.

As for SQL Server stuff, among other topics, we talk about:

SQL Server Developer Edition vs. Enterprise Edition

Benchmarking Columnstore Indexes and Columnstore in SQL Server 2016

Restoring transaction logs on Amazon RDS

Log Shipping on disconnected servers

Amazon RDS vs. Azure SQL Database

Amazon Aurora

Denormalization

Foreign Keys

Links mentioned in the show:

* Matan Yungman - Columnstore Indexes: Questions and Answers

* Kendra Little - The Easiest Way to Restore Transaction Logs to a Point in Time

* Matan Yungman - Can Log Shipping Work Without Shipping the Log?

We tried something new this time, and broadcast the show live on Persicope.

Periscope is a service by Twitter that allows each one to start a live broadcast anywhere and anytime from his phone or tablet. We will try it out a few more times, so watch for our announcements about future broadcasts on Twitter.

As for SQL Server stuff, among other topics, we talk about:

• SQL Server Developer Edition vs. Enterprise Edition
• Benchmarking Columnstore Indexes and Columnstore in SQL Server 2016
• Restoring transaction logs on Amazon RDS
• Log Shipping on disconnected servers
• Amazon RDS vs. Azure SQL Database
• Amazon Aurora
• Denormalization
• Foreign Keys

Links mentioned in the show:

• Matan Yungman – Columnstore Indexes: Questions and Answers
• Kendra Little – The Easiest Way to Restore Transaction Logs to a Point in Time

Download Episode (mp3)

On this show, we host a good friend of both of us - Boris Hristov!

Boris (blog | twitter) is a SQL Server MVP from Bulgaria and a really passionate and efficient guy. He delivers a lot of technical training and also talks a lot about presentation design. We talk to Boris about those things and also about travelling, sports, work-life balance, and more.

Among other topics, we talk to Boris about:

* Boris' community initiative, SQL Hangouts

* What is Policy Based Management and why is it so important?

* How can you use Distributed Replay in your environment?

* The importance of presentation design

* Data corruption

* Efficiency

* What is Tapout XT

Items mentioned in the show:

* SQL Hangouts

* Guy Glantser on SQL Hangouts about founding a company and work-life balance

* Matan Yungman (with William Durkin) on SQL Hangouts about transitioning from DBA to consultant

* Boris Hristov - Presentation Design - Why You Should Care?

* Boris Hristov courses on Pluralsight

About Boris

Boris is a SQL Server Consultant and Pluralsight Author from Bulgaria who you can regularly see speaking at conferences all across Europe. He is also training companies and students in the “Art of SQL Server” and loves to share his knowledge online as part of podcasts, webcasts or on his blog – http://borishristov.com/blog/.

The fastest way you can reach him is on twitter where he writes under @BorisHristov and you can even join him for a SQLHangout which are video conversations that he hosts with people from the SQL Server community.

On this show, we host a good friend of both of us – Boris Hristov!

Boris (blog | twitter) is a SQL Server MVP from Bulgaria and a really passionate and efficient guy. He delivers a lot of technical training and also talks a lot about presentation design. We talk to Boris about those things and also about travelling, sports, work-life balance, and more.

Among other topics, we talk to Boris about:

• Boris' community initiative, SQL Hangouts
• What is Policy Based Management and why is it so important?
• How can you use Distributed Replay in your environment?
• The importance of presentation design
• Data corruption
• Efficiency
• What is Tapout XT

Items mentioned in the show:

• SQL Hangouts
• Guy Glantser on SQL Hangouts about founding a company and work-life balance
• Matan Yungman (with William Durkin) on SQL Hangouts about transitioning from DBA to consultant
• Boris Hristov – Presentation Design – Why You Should Care?
• Boris Hristov courses on Pluralsight

About Boris

Boris is a SQL Server Consultant and Pluralsight Author from Bulgaria who you can regularly see speaking at conferences all across Europe. He is also training companies and students in the "Art of SQL Server" and loves to share his knowledge online as part of podcasts, webcasts or on his blog – http://borishristov.com/blog/.

The fastest way you can reach him is on twitter where he writes under @BorisHristov and you can even join him for a SQLHangout which are video conversations that he hosts with people from the SQL Server community.

Download Episode (mp3)

Two weeks have passed, and another show is here!

We start by talking about scary DBA sentences

We continue with PASS Summit 2015 and about the sessions we'll deliver at the summit.

We then talk about:

* T-SQL code patterns

* interesting scenarios with small but very active SQL Server tables

* jobs that will be replaced by machines

* Tempdb Contention and improvements in SQL Server 2016

* The power of SQL for other data solutions like Couchbase and Azure Stream Analytics

* And more..

Items mentioned in the show:

* Kendra Little - Contest: Write the Scariest DBA Sentence

* PASS Summit 2015

* Matan Yungman - The Data Loading Performance Presentation (from 24 Hours of PASS)

* Dwain Camps - High Performance T-SQL using Code Patterns

* Matan Yungman - Can a SQL Server Table be Too Small?

* Will Your Job Be Done By a Machine?

* The Azure Stream Analytics Query Language

* Couchbase N1QL

Two weeks have passed, and another show is here!

We start by talking about scary DBA sentences

We continue with PASS Summit 2015 and about the sessions we'll deliver at the summit.

We then talk about:

• T-SQL code patterns
• interesting scenarios with small but very active SQL Server tables
• jobs that will be replaced by machines
• Tempdb Contention and improvements in SQL Server 2016
• The power of SQL for other data solutions like Couchbase and Azure Stream Analytics
• And more..

Items mentioned in the show:

• Kendra Little – Contest: Write the Scariest DBA Sentence
• PASS Summit 2015
• Matan Yungman – The Data Loading Performance Presentation (from 24 Hours of PASS)
• Dwain Camps – High Performance T-SQL using Code Patterns
• Matan Yungman – Can a SQL Server Table be Too Small?
• Will Your Job Be Done By a Machine?
• The Azure Stream Analytics Query Language
• Couchbase N1QL

Download Episode (mp3)

A few shows ago, we talked briefly about Virtualization and mentioned it would be a good idea to have a Virtualization expert on the show.

In this show, we have David Klee (Blog | Twitter), one of the top Virtualization experts in the SQL Server space.

We talk to David about:

* What's important to know when virtualizing SQL Server

* How to properly size your VM

* What metrics to monitor when virtualizing

* When to use SQL Server High Availability features and when to use them at the virtualization side

* When NOT to virtualize

* Some of David's most challenging projects

In addition, we talk to David about starting a company and the life of an independent consultant.

About David

David is a technologist that is lucky enough to have a job doing that which he enjoys – working in high technology, using cutting edge technology to make businesses more efficient. He is the Founder and Chief Architect of Heraflux Technologies, and travels around the country working with companies to reduce risk, improve performance, and virtualize their business-critical SQL Server infrastructures.

David regularly contributes to the PASS Virtualization, Performance, and High Availability and Disaster Recovery virtual chapters. David also helps to run and coordinate the Omaha SQL Server Users Group.

David is also a member of the PASS High Availability and Disaster Recovery Virtual Chapter board. The virtual chapter meets the second Tuesday of each month for a one hour technical presentation on high availability and disaster recovery topics.

A few shows ago, we talked briefly about Virtualization and mentioned it would be a good idea to have a Virtualization expert on the show.

In this show, we have David Klee (Blog | Twitter), one of the top Virtualization experts in the SQL Server space.

We talk to David about:

• What's important to know when virtualizing SQL Server
• How to properly size your VM
• What metrics to monitor when virtualizing
• When to use SQL Server High Availability features and when to use them at the virtualization side
• When NOT to virtualize
• Some of David's most challenging projects

In addition, we talk to David about starting a company and the life of an independent consultant.

About David

David is a technologist that is lucky enough to have a job doing that which he enjoys – working in high technology, using cutting edge technology to make businesses more efficient. He is the Founder and Chief Architect of Heraflux Technologies, and travels around the country working with companies to reduce risk, improve performance, and virtualize their business-critical SQL Server infrastructures. David regularly contributes to the PASS Virtualization, Performance, and High Availability and Disaster Recovery virtual chapters. David also helps to run and coordinate the Omaha SQL Server Users Group.

David is also a member of the PASS High Availability and Disaster Recovery Virtual Chapter board. The virtual chapter meets the second Tuesday of each month for a one hour technical presentation on high availability and disaster recovery topics.