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 sqldatapartners.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
SQL Data Partners Podcast
2020
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: 2019

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 sqldatapartners.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.

Feb 28, 2019

In this corner, coming in with all its Excel glory we have Power Query! And in this corner we have a new programming language, DAX! Have you ever felt like there is a tug of war going on between these two technologies? In this episode, the team discusses the two technologies, what they do, when -- and perhaps more importantly, WHY might you use them.

The show notes for today's episode can be found at http://sqldatapartners.com/2019/02/27/episode-162-power-query-vs-dax. Have fun on the SQL Trail!

Feb 21, 2019

How do you migrate 8,000 databases on a single instance in an environment that doesn't tolerate downtime? Today's episode focuses on migration strategy and how our guest Andy Levy faced the challenge of moving all those databases in the time constraints given him by the business. We also talk about some of the strategies Andy employs to administer and monitor all those databases.

The show notes for today's episode can be found at http://sqldatapartners.com/2019/02/20/episode-161-migrating-upgrading-8000-databases. Have fun on the SQL Trail!

Feb 13, 2019

The traditional model for Power BI is to pay per user, but what if you want to use the reports in your web app and don't know who all the users would be? In this episode the team explores Power BI Embedded -- how it differs from the traditional service, what you need to set it up, and some reasons why you might explore this option over the others.

The show notes for today's episode can be found at http://sqldatapartners.com/2019/02/13/episode-160-power-bi-embedded. Have fun on the SQL Trail!

Feb 6, 2019

So what happens when you want to use data from two different sources, manipulate it (transform it) and then present the data in Power BI -- and you don't know how to use SSIS? Well, it turns out you can use Power BI dataflows. In this episode we explore the topic of dataflows with our guest, Matthew Roche, and talk about the scenarios and types of folks dataflows was intended for.

The show notes for today's episode can be found at http://sqldatapartners.com/2019/02/06/episode-159-power-bi-dataflows. Have fun on the SQL Trail!

Jan 24, 2019

For only 10 bucks a month you can start visualizing your data and finally get the dashboard your executives have been waiting for!! What's that? You need to refresh the data--perhaps even multiple times a day? Oh, well it's still $10 a month, but you are also going to install a gateway. What's that you say? Well, in this episode we begin our discussion on Power BI with one of the first components you will need outside of the Power BI Desktop for your users to start interacting with updated data. We discuss what it is, some of the requirements, and our experiences setting one up.

The show notes for today's episode can be found at http://sqldatapartners.com/2019/01/23/episode-158-gateways. Have fun on the SQL Trail!

Jan 10, 2019

I can still remember working in high school when you had to 'dial in' to the internet and Microsoft bought the rights to the Rolling Stones song 'Start Me Up' for the release of their highly anticipated software Windows 95. It was a complete game changer for me and shaped my professional life with the releases of the Windows Server Operating System. While you could never just wing it, the GUI provided a rich interface and the ability to explore features without having to know all the syntax to execute the functionality. You can image the surprise I felt when Microsoft came out with Windows Core--an operating system with no GUI. While you may not have adopted Windows Core yet, our guest, Frank Henninger, suggests you should reconsider. We chat with him about the benefits, some of the challenges, and how we can better take advantage of using Windows Core.

The show notes for today's episode can be found at http://sqldatapartners.com/2019/01/10/episode-157-windows-server-core. Have fun on the SQL Trail!

Jan 2, 2019

How well do you connect with others? We generally think pretty good of ourselves and at first glance you may give yourself a pretty high score.  While there is no test you can take to compare your results to mine, the way you connect with others can have a profound influence in the workplace and we are each judged by the people we come in contact with.  Our guest in this episode, Linda Groszyk, talks with us about some of the ways social intelligence can impact us, how we can get better at it and who we can reach out to if we need help.

The show notes for today's episode can be found at http://sqldatapartners.com/2019/01/02/episode-156-social-intelligence. Have fun on the SQL Trail!

« Previous 1 2