Info

SQL Data Partners Podcast

Hosted by Carlos L Chacon, the SQL Data Partners Podcast focuses on Microsoft data platform related topics mixed with a sprinkling of professional development. Carlos and guests discuss new and familiar features and ideas and how you might apply them in your environments. Visit our website for episode show notes at marathonus.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.
RSS Feed Subscribe in Apple Podcasts
2024
February
January


2023
December
November
October
September
August
June
April
March
February
January


2022
December
November
October
September
August
July
June
April
March
February
January


2021
December
November
October
September
August
July
June
May
April
March
February
January


2020
December
October
September
August
July
June
April
March
February
January


2019
December
November
October
September
July
June
May
April
March
February
January


2018
December
November
October
September
August
July
June
May
April
March
February


2017
December
November
October
September
August
July
June
May
April
March
February
January


2016
December
November
October
September
August
July
June
May
April
March
February
January


2015
December
November
October
September
August


Categories

All Episodes
Archives
Categories
Now displaying: December, 2015

Hosted by Carlos L Chacon, the SQL Data Partners Podcast focuses on Microsoft data platform related topics mixed with a sprinkling of professional development. Carlos and guests discuss new and familiar features and ideas and how you might apply them in your environments. Visit our website for episode show notes at marathonus.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.

Dec 30, 2015

One of the new features being added to SQL Server 2016 is the Query Store which will allow for greater access to the performance history of your databases.  This is going to be extremely helpful when you are approached about 'What happened this morning?'  With the Query Store feature, you will now be able to provide some insight into that question.

I chat with Borko Novakovic, the program manager for Query Store feature, and he shares with you, Compañeros, details about the new feature and how those interested in performance monitoring will be able to use this for their benefit. 

Even if you aren't going to run SQL Server 2016 as soon as it comes out, you will find this information interesting and I hope it helps you along the SQL trail.  Have fun out there.

You can find the show notes for today's episode at http://sqldatapartners.com/2015/12/29/query-store/

Dec 23, 2015

If I were a betting man, I would wager your disk IO system is probably the biggest bottleneck in your SQL Server right now.  Sure, there are lots of moving pieces, but if you can tame the IO situation, you are putting yourself in the drivers seat.  So how do you go about putting together the pieces you need identify your IO constraints?

I chat with Theresa Iserman, a premier support engineer at Microsoft about some of her thoughts and why IO in general is an issue.  She gives us some guidelines and even some metrics to check out.  Join us in the conversation, and I'll see you on the SQL trail . . .

As always you can check out the show notes at http://sqldatapartners.com/2015/12/22/iotuning/ 

Dec 16, 2015

In what has to be one of the most downloaded SQL Server scripts on the planet with over 73,000 downloads, sp_whoisactive has been providing active session information to data professionals for eight years.  I catch up with Adam Machanic to talk a bit about how the procedure came to be, how he uses it and what is in store down the road.

If you are using SQL Server and haven’t used sp_whoisactive before, I invite you go and download it right now, then come back and listen to the program.  We will wait for you.  Ready?  Let's do this.

Have fun on the SQL trail compañeros.

You can see the show notes for today's episode at http://sqldatapartners.com/2015/12/15/sp_whoisactive/

Dec 9, 2015

As one of the newest Azure offerings, Azure Data Factory can at first thought be compared to SSIS.  I don't think we are quite there yet with the comparisons; however, I talk with MVP Reza Rad and discuss some of the similarities and differences between the two.

A consultant now living in New Zealand, Reza has lots of experience with the data management and gives us the scoop on the initial offering of this new Azure tool.  I hope you enjoy the episode.  If you have some feedback or comments, feel free to reach out on Twitter--I am @CarlosLChacon

 

You can see the show notes at http://sqldatapartners.com/2015/12/08/azure-data-factory/

Dec 2, 2015

We all start somewhere and if you can find a mentor who will help you on your way by pointing you in a direction you had not considered, you are a lucky person indeed.  This episode I chat some fellow podcasters about their experience with mentors and the characteristics we think good mentors have.

Experience is simply the name we give our mistakes. -Oscar Wilde

Be brave. Take risks. Nothing can substitute experience.  -Paulo Coelho

Experience is what you got by not having it when you need it. -Author Unknown

[A mentor and mentee] is the third most powerful relationship for influencing human behavior (after the family and couple relationships ) if it is working. -Richard E. Caruso, PhD

 Part of the reason I have the podcast is to help bring to light some thoughts and ideas you may not have considered.  I hope this continues with today's episode.  I hope you check it out.

You can see the links to the other podcasts at http://sqldatapartners.com/2015/12/01/role-of-mentors/

1