SQL Data Partners Podcast

SQL Data Partners Podcast

By Carlos L ChaconTechnologyEducation
Download on the App Store

SQL Data Partners Podcast episodes

  • Episode 42: Who made that change? Find out with Auditing

    How did that get changed--do you ever get that question? 

    In this episode I talk with Brad McKuhen about how you would answer
    that and how you might need more than just enabling the auditing
    feature in SQL Server.  If you are willing to be a bit
    proactive and do some testing, you might be able to give an answer
    to that question instead of the same old shoulder shrug.

    Check out the shownotes for today's episode at  http://sqldatapartners.com/2016/05/03/auditing/.  See you on the SQL

    trail!

    31 min
  • Episode 41: Index Maintenance

    Compañeros, you know good care and feeding of your indexes is VITAL to a healthy database. In this episode of the SQL Data Partners Podcast, I talk to Sean McCown about the best practices for index maintenance and how those guidelines are now part of his Minionware software. The show notes for today's episode are available at http://sqldatapartners.com/2016/04/26/indexmaintenance

    51 min
  • Episode 41: Index Maintenance

    Compañeros, you know good care and feeding of your indexes is

    VITAL to a healthy database.  In this episode of the SQL Data
    Partners Podcast, I talk to Sean McCown about the best practices
    for index maintenance and how those guidelines are now part of his
    Minionware software.
    The show notes for today's episode are available at http://sqldatapartners.com/2016/04/26/indexmaintenance

    51 min
  • Episode 40: SQL Server Compression

    In this episode of the SQL Data Partners Podcast I chat with Jason Brimhall, about SQL Server compression and his experience with it. He also answers your compression questions: Why is it a bad idea to compress everything in your database and how does compression work?

    You can check out the show notes for today's episode at http://sqldatapartners.com/2016/04/20/compression/. Have a good week and I'll see you on the SQL trail.

    36 min
  • Episode 40: SQL Server Compression

    In this episode of the SQL Data Partners Podcast I chat with Jason Brimhall, about SQL Server compression and his experience with it. He also answers your compression questions: Why is it a bad idea to compress everything in your database and how does compression work?

    You can check out the show notes for today's episode at http://sqldatapartners.com/2016/04/20/compression/. Have a good week and I'll see you on the SQL trail.

    36 min
  • Episode 39: Set statistics and StatisticsParser.com

    Today on the SQL Trail I talk with Richie Rump, the podcaster, blogger, and now new hire at Brent Ozar. He and I discuss measuring query performance, using SET STATISTICS, and the story behind his Statistics Parser application. He also talks about navigating the space between developer and DBA.

    The show notes for today's episode are at http://sqldatapartners.com/2016/04/02/statisticsparser/

    31 min
  • Episode 39: Set statistics and StatisticsParser.com


     Today on the SQL Trail I talk with Richie Rump, the podcaster, blogger, and now new hire at Brent Ozar. He and I discuss measuring query performance, using SET STATISTICS, and the story behind his Statistics Parser application.  He also talks about navigating the space between developer and DBA.

    The show notes for today's episode are at http://sqldatapartners.com/2016/04/02/statisticsparser/

    31 min
  • Episode 38: SQL Server 2016 Feature Review

    Compañeros! You heard rumblings about how awesome SQL Server 2016 is, right? I talk with Rick Heiges about the wins he's seen for his clients using SQL Server 2016, including how one client's move from a large Oracle rack to SQL Server garnered them huge improvements in query performance.

    Show notes for today's episode are available at http://sqldatapartners.com/2016/04/02/sqlserver2016/

    29 min
  • Episode 38: SQL Server 2016 Feature Review

    Compañeros! You heard rumblings about how awesome SQL Server 2016 is, right?  I talk with Rick Heiges about the wins he's seen for his clients using SQL Server 2016, including how one client's move from a large Oracle rack to SQL Server garnered them huge improvements in query performance.

    Show notes for today's episode are available at http://sqldatapartners.com/2016/04/02/sqlserver2016/

    29 min
  • Episode 37: PowerBI and the DBA

    In this episode of the SQL Data Partners podcast I sit with Patrick LeBlanc during SQL Saturday RVA. We chat about Microsoft PowerBI. PowerBI is a business intelligence tool that easily connects disparate data sources to create dashboards and I was interested to get his thoughts on how this would affect the data professional. Patrick answers my questions about the application and also explains why he thinks that PowerBI has grown in popularity so quickly.

    The shownotes for today's episode are found at http://sqldatapartners.com/2016/03/29/powerbi/

    28 min

About SQL Data Partners Podcast

From the publisher's feed

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…