SQL Data Partners Podcast

http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Hosted by Carlos L Chacon and Steve Stedman, the SQL Data Partners podcast focuses on SQL Server related topics designed to help you become familiar with what’s out there, how you might use those features or ideas and how you might apply them in your environments. Welcome aboard the SQL trail.

0 Likes     0 Followers     1 Subscribers

Sign up / Log in to like, follow, recommend and subscribe!

Website
http://sqldatapartners.com/podcast
Description
In this podcast, I discuss a variety of SQL Server related topics mixed with a sprinkling of professional development and I talk with some of the biggest names in the industry. I want to introduce new and familiar topics and talk about them in a way you may have not considered. We are all on different stages as data professionals. I hope you will join me and Steve on the SQL trail compañeros--you won't regret it.
Language
🇬🇧 English
last modified
2019-11-14 12:52
last episode published
2019-11-13 19:51
publication frequency
8.77 days
Contributors
Carlos L Chacon author  
Carlos Chacon owner  
Explicit
false
Number of Episodes
175
Rss-Feeds
Detail page
Categories
Technology Education Software How-To Educational Technology

Recommendations


Episodes

Date Thumb Title & Description Contributors
13.11.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Paginated Reports in Power BI

In the second quarter of 2019, it was announced that Power BI would support paginated reports--at first this was assumed to be connected to an announcement that Power BI would support the RDL files from Reporting Services. The guidance however, was to ...
Carlos L Chacon author
6.11.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

PolyBase in SQL Server 2019

This week we heard the news of the release for SQL Server 2019 and a major focus of this release is data virtualization. In this episode, we discuss PolyBase--a topic we covered in Episode 95; however it has really come of age with SQL Server 2019. Our...
Carlos L Chacon author
24.10.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

SQL Trail Recap & Buying Power BI

SQL Trail continues to be an experiment in the making and year three proved no different. Eugene joined us this year and we discuss some of the changes, how the vision has changed for the conference and what the future will hold for our event. While th...
Carlos L Chacon author
17.10.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Database Design

After 170 episodes, we bring back Louis Davidson to talk about database design and get his thoughts on how we can get better at planning for our data. The show notes for today's episode can be found at http://sqldatapartners.com/2019/10/16/episode-178-...
Carlos L Chacon author
9.10.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Lock Pages in Memory

The Lock Pages in Memory policy came up in our internal discussions. I wanted to chat about it a bit more and I couldn't think of a better person than Rick Lowe. After our recent SQL Trail, we sit down to discuss this policy option.   The show notes fo...
Carlos L Chacon author
25.09.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Power BI Storage Options

Creating reports in Power BI is awesome, but once you are ready to publish the reports--where are you going to store all the data? In this episode, we discuss storage options for Power BI and discuss how the version of Power BI can affect storage.
Carlos L Chacon author
18.09.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Migrating to the Cloud

Are you in the cloud? Lots of folks are talking about moving to the cloud; however, as we find in today's episode this can be tricky to quantify what people mean by being "in the cloud". We are happy to welcome Rick Lowe to the show and he gives his ta...
Carlos L Chacon author
24.07.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Summer Break

Carlos L Chacon author
27.06.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Power BI Report Server

What do you do when you want to use the Visualizations of Power BI but management doesn't want to send company data to the cloud? Well, you can implement Power BI Report Server! In this episode we discuss the differences in architecture with the on-pre...
Carlos L Chacon author
12.06.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

New Data Certifications

As the data platform continues to evolve, so do certifications. In this episode we chat with Rick Heiges about the new role-based certifications and how they fit into Microsoft's cloud platform. We revisit how certifications still play a role in career...
Carlos L Chacon author
5.06.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Power BI Monitoring

From a SQL Server perspective we have many ways to identify problem areas. In this episode, we discuss ways to diagnose performance issues in Power BI. They are certainly making many strides; however, the tools won't feel as mature as they do in SQL Se...
Carlos L Chacon author
22.05.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

SQL Server Encryption

You’ve got first name, last name, full name, birth date, address, email, phone, tax ID or Social Security Number, driver’s license number, medical evaluation notes, MAC address, and IP address columns in a table. So, what would you encrypt in this tabl...
Carlos L Chacon author
15.05.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Devops with Power BI

Two years ago blogger Jay Killeen observed, "And with modern languages and modern applications such as PowerBI and Power Query you should be safe to assume there would be modern tooling. You would be wrong." In this episode, Eugene and I explore the ch...
Carlos L Chacon author
8.05.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Should you learn to code?

These are dark times. Drastic measures must be taken. In this episode, we talk about--coding. *Queue scary music* Last year I bumped into Sean McCown and found out he had coded himself a GUI for his MinionWare product. This left me both impressed and s...
Carlos L Chacon author
1.05.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Data Privacy Settings

One of the great abilities we have with Power BI is connecting to multiple data sources. Authors can actually publish data sources for others to use in their reports. Developers then get to mix and match our reports with all that data; however, there w...
Carlos L Chacon author
25.04.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Azure SQL Data Sync

Azure SQL Data Sync has been generally available for almost a year now. Have you heard of it? Are you using it? Microsoft's page tell us that "Data Sync is useful in cases where data needs to be kept up-to-date across several Azure SQL databases or SQL...
Carlos L Chacon author
17.04.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Custom Visuals

The number one reason organizations choose Power BI is the ability to visualize data; however, even with all the immediate choices, many report developers desire to create custom visualizations. In this episode, we chat about custom visualizations for ...
Carlos L Chacon author
28.03.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Artificial Intelligence

Why should I care about this episode? I know many of you are going to ask that question. Artificial Intelligence is getting lots of buzz and in this episode we invite Hope Foley from Microsoft to discuss why and how AI is relevant to those in the data ...
Carlos L Chacon author
21.03.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

The DAX Episode

DAX is the acronym for Data Analysis Expressions, and it is the formula language used throughout Power BI. In this episode we talk about DAX concepts and how they are simple and straightforward, but can be confusing for those coming from a relational d...
Carlos L Chacon author
13.03.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Very Large Databases

Are you experiencing challenges managing Very Large Databases (VLDBs), or anticipate challenges with future growth? In this episode, we are joined by Aaron Hayes to discuss the practical advice on managing very large databases in SQL Server, focusing o...
Carlos L Chacon author
28.02.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Power Query vs DAX

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 discuss...
Carlos L Chacon author
21.02.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Migrating/Upgrading 8000 databases

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 constraint...
Carlos L Chacon author
13.02.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Power BI Embedded

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...
Carlos L Chacon author
6.02.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Power BI dataflows

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 explor...
Carlos L Chacon author
24.01.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Gateways

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 a...
Carlos L Chacon author
10.01.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Windows Server Core

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 chang...
Carlos L Chacon author
2.01.2019 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Social Intelligence

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 ha...
Carlos L Chacon author
13.12.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Data Science

Do you want to be a data scientist? Do you even know what data science is? In this episode, we tackle the idea of being a data scientist and discuss the criteria and what it may take to get the job description of data scientist. So not everyone feels o...
Carlos L Chacon author
21.11.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Test Driven Development

Who hasn't had a deployment go a bit sideways?  For all the talk of DevOps these days, the ability to push out code can still be challenging.  When I heard David Moore, our guest today, talk about the increased confidence they have in pushing out datab...
Carlos L Chacon author
7.11.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

SQL Trail 2018 Retrospective

Year Two of our beautiful idea--gather together with a group of podcast listeners in a conference type format and find ways for us to connect and help each other grow.  I am influenced by what I see in other events; however, I want to add my own flavor...
Carlos L Chacon author
1.11.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Do you use Analysis Services?

Those trained in SSAS may cringe a bit, but a curious thought entered my mind.  Many organizations start using data warehouse structure with fact and dimension tables, but never make it to the 'cube' state--actually using analysis services.  Admittedly...
Carlos L Chacon author
24.10.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Azure SQL Database Managed Instance

Platform as a service has finally arrived to Microsoft's Azure offering.  With the release of Azure SQL Database Managed Instances--quite the mouthful--there is now an option to explore database services without missing all the functionality we didn't ...
Carlos L Chacon author
19.10.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

The SQL Data Partners Team

Today we, the SQL Data Partners team, celebrate our 150th podcast episode! We introduce ourselves, talk about what we're doing, our goals for the coming year and answer the SQL Family questions. Come get to know us! The show notes for today's episode c...
Carlos L Chacon author
11.10.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Managing lots of databases

Do you ever feel like you have too many databases to manage?  Managing lot of databases can get tricky and in this episode we explore some of the techniques you can use when you need to manage lots of databases.  Tracy Boggiano joins us to discuss some...
Carlos L Chacon author
3.10.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

High Performance SSRS

SSRS is great -- it comes with SQL Server, provides quite a bit of functionality, but sometimes doesn't always perform well. In this episode we welcome back Bert Wagner as he chats with us about some of the ways he has improved his under-performing rep...
Carlos L Chacon author
19.09.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Always Encrypted

Security is always important to data folks and when a new feature like Always Encrypted comes along, it gets your attention. In this episode, we discuss this feature introduced in SQL Server 2016. We are joined by our guest Sam Nasr and he shares an ov...
Carlos L Chacon author
12.09.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

SQL Trail Speakers

So what is SQL Trail all about?  In this episode we invite our MVPs to discuss some of the topics they are ready to share on SQL Trail.  We know there are lots of options for training and networking -- this is our iteration on what the experience shoul...
Carlos L Chacon author
5.09.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Is SSIS still relevant? Part 2

In this episode we finish up our conversation with Jason and Cathrine and talk about how they keep up with all the changes in data conversions.  The advent of Azure services is great, but can be tricky to navigate.  We also get to hear Jason's answers ...
Carlos L Chacon author
29.08.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Is SSIS still relevant? Part 1

Moving data with SSIS is a forgone conclusion for most of us -- it is part of SQL Server, it has a interface we are somewhat familiar with, and connects to lots of common data sources like csv, excel, and of course SQL Server. Are our needs changing as...
Carlos L Chacon author
9.08.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Transitioning from DBA to Data Warehouse Architect

We frequently talk about how many DBAs are concerned our job may be phased out in the future. This episode discusses one common career path in going from DBA to Data Warehouse Architect and we talk with Thomas LeBlanc about his transition: his decision...
Carlos L Chacon author
26.07.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Do You Have a HEAP of Hurting?

Are you giving yourself a HEAP of trouble by using tables with no clustered indexes?  But it is faster you say . . . because you don't have to worry about the sorting when inserting.  Our guest Rick Lowe suggests everything is fast until you decide to ...
Carlos L Chacon author
4.07.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Wait, Wait, What?

In this episode, we chat with David Maxwell about wait stats, what they are and why we should care about them. There are so many different directions we can go and if you have a specific use case you’d like us to consider, let us know and we can includ...
Carlos L Chacon author
20.06.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Why data types matter

They're just numbers, right?  A date's a date.  It's just string data, who cares?  I admit I have posed those questions before and only much later did I understand how complicated it can get. Angela Henry, our guest for today, has heard these same phra...
Carlos L Chacon author
13.06.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Getting Started with SQL Server in Azure

"The move to the cloud is inevitable."  Listening to Microsoft marketing and all the MVPs out there, it can certainly seem like we are getting further and further behind each day we aren't use cloud services.  Sure, lift and shift of VM resources are s...
Carlos L Chacon author
6.06.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Meeting of the Minds

I invited our fearless panelists Kevin Feasel and Eugene Meidinger to join me for a podcast discussion.  We couldn't agree on a topic so we'll just call this episode Meeting of the Minds.  You're welcome. The show notes for today's episode can be found...
Carlos L Chacon author
31.05.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

You want to work with Analytics?

What’s in a name? That which we call a rose, by Any Other Name would smell as sweet.  We could say the same for analytics -- there are plenty of similar or related words we use to describe the role or process of working with data.  In this episode, we ...
Carlos L Chacon author
23.05.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Devops with Visual Studio

Everybody does things a little differently and this is one of the things I LOVE about the podcast--chatting with others about how they get work done.  In this episode I chat with Tom Norman about how he uses Visual Studio for source control, deployment...
Carlos L Chacon author
16.05.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Seinfeld Episode

Normally we have one specific topic we focus on each episode.  This episode is a little different. The show notes for today's episode can be found at http://sqldatapartners.com/2018/05/16/episode-135-seinfeld-episode/. Have fun on the SQL Trail!
Carlos L Chacon author
9.05.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

CosmosDB

It is not very often the internal codename is used when a product is launched; however, when you think about a database designed with global distribution in mind, CosmosDB makes sense.  I was a bit shocked to hear Microsoft was releasing another databa...
Carlos L Chacon author
3.05.2018 http://static.libsyn.com/p/assets/9/5/8/4/95843cc1618604d9/PodcastIconCentered1400.png

Shrinking Files

While the ability to shrink data files is available in SSMS, the conventional wisdom is don't do it.  I was extremely curious when I read an email from our guest suggesting the opposite.  In this episode we explain the 'real world' and discuss why you ...
Carlos L Chacon author