Download the App!

show episodes
 
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.
 
Loading …
show series
 
Never heard of ScriptDOM? Neither had we…okay, except Kevin, who obviously knows all. Apparently, the documentation is scarce. Mala Mahadevan uses it, loves it, and graciously offered to come back to the podcast to educate us and our listeners on a product that can help us parse, process and format our SQL queries. The show notes and video can be f…
 
Public speaking is not fun for most; however, it can be very rewarding. Chris Seferlis chats with us about a few tips he has on being a speaker. Most of the tactical advice we defer to a toastmasters or public speaking group, so we give some thoughts on preparation, soliciting feedback, audience engagement, and handling criticism. I should point ou…
 
Everyone has bad days; however, how those bad days develop are unique to each of us. In a special episode, we chat with Tracy Boggiano about her experiences with Mental Health, how she has dealt with it, how each of us can work on our own mental health, and phrases we should avoid saying to those with mental health issues. Our own Eugene Meidinger …
 
No one wants to lose data when disaster strikes; however, we need to plan for some data loss and putting all the pieces in place can be tricky. There are two metrics commonly used to measure data loss and availability when it comes to planning for disasters—Recovery Point Objective and Recovery Time Objective. In this episode, we touch on how you m…
 
The scary part of upgrading SQL Server is finding out you have a problem AFTER the fact. In this episode, Mariano Kovo joins us to discuss the Data Migration Assistant tool from Microsoft. While the name can be a bit misleading, (What? Microsoft have confusing names—that's a first), the major benefit to the tool is the assessment feature to alert y…
 
As data practitioners, we want to get ahead of any problems that might come up and share those insights with others on our team. In this episode, Edward Pollack gives us a few scenarios we might consider as we attempt to prevent application issues. These techniques also go into the security space and could help prevent data loss. As we collect this…
 
Organizations look to constantly improve and offer better services and the application tooling has been built to accommodate the process. Database tooling has been a bit slower to develop; however, in this episode Eitan Blumin, a co-host at sqlserverradio.com, brings us up to speed on the latest features of SQL Server Data Tools with some thoughts …
 
Let’s say you have completed a lift and shift VM hosting to the cloud. Great—you now use Iaas services. While you don’t have to worry about the hardware, managing the software can be problematic. The SQL Server IaaS Agent Extension can offer some PaaS-like services and make it easier to manage the database environment. In this episode we chat with …
 
Have you ever created a report in a visualization tool, spent all this time and energy creating something that looked really cool, went through more edits than you could remember only to deliver the report and have the recipient go “What am I looking at?” I don’t think I am the only one and, in this episode, we explore some of the rookie mistakes I…
 
Carlos, Kevin, and Eugene reconnect after some time away with a new streaming time. Long form conversation on a single topic is also the place we want to get back to in our podcast. The show notes and video for today's episode can be found at https://sqldatapartners.com/2021/04/28/episode-224-the-standup-meeting/. Have fun on the SQL Trail!…
 
With both Kevin and Eugene busy this week, Carlos went solo to share a few changes to the podcast, including the Twitch livestream moving to Tuesday, how you can support the podcast, and podcast episodes going back to being published every other Wednesday. If you have a subject that you’d like to chat about on the podcast with us, we’d love to sche…
 
Azure Arc-enabled data services provide powerful capabilities to deploy and manage local, on-premises, and hybrid cloud data resources using the same centralized management and tooling you get from the Azure cloud. Since Eugene suggested our previous attempt at Azure Arc was insufficient, we invited Ben Weissman and Anthony Nocentino, authors of th…
 
Virtual conferences are just not the same as the conferences we are used to, but we’re still determined to provide a good learning and networking environment for our friends. We very much miss having conferences in person and look forward to that happening again. In the meantime, we have discovered Airmeet and we had a great event: our first of the…
 
As we prepare for SQL Trail on March 18th, we peek back at Microsoft Ignite and review the announcements made there—filtering out the pieces our compañeros will enjoy hearing about. Did we miss something you think we should talk about? Let us know! The show notes and video for today's episode can be found at https://sqldatapartners.com/2021/03/10/e…
 
How do you document your SQL Server environments? I can remember walking through Brent Ozar’s takeover script back in the day and how cumbersome it was to put all that information together. We have a few more options available to us now. In this episode, we discuss a listener question along with some options for doing server inventories. SQL Trail …
 
In this episode of the SQL Data Partners Podcast, Eugene and I go back to our DBA beginnings and talk about database file growth, how to manage files and how to tell when a file has grown. The show notes for today's episode (including the video with the demonstration) can be found at https://sqldatapartners.com/2021/02/17/episode-218-file-growths. …
 
The story begins with a process that has been running forever and suddenly decides to cause grief by filling up tempdb. We talk about patching, and we talk about mental health. We talk a little about various topics. The show notes for today's episode can be found at https://sqldatapartners.com/2021/02/10/episode-217-a-little-something-about-a-few-t…
 
When working on a customer on an import process, she made the comment—if we were doing true EDI, we’d [Do X]. The comment got me thinking—Aren’t we working on an EDI process? As someone who frequently has multiple roles on projects, I perhaps had lumped all the various 3 letter acronyms into the same spaghetti salad. In this episode of the podcast,…
 
We have been moving data for years with technologies like DTS and SSIS; however, these were very much designed for on-premises moves in mind. As more cloud services were being offered Microsoft needed a service to help customers using those services move data around. Azure Data Factory was born with the initial premise of moving data between cloud …
 
20 years ago, the objection to implementing security on the basis of performance had validity—especially for smaller organizations. Security was a pain in the neck; however, how many of us are still hanging on to some of those old biases. Even worse, some of us IT pros seem to put up objections to doing the most basic security procedures—sending us…
 
Microsoft released a lengthy white paper on the SolarWinds hack affecting thousands of computers. This is scary stuff, and the details continue to come out slowly and you wonder how it all will play out. Many IT pros rely on SolarWinds for monitoring and in this episode, we discuss the exploit, how mere mortals like us might feel a bit overwhelmed …
 
It was sad news to hear PASS plans to dissolve in January of 2021. So much good has come of the community and it is sad to see it go. In this episode, we explore the why behind the collapse and what we think may emerge in the aftermath. The show notes for today's episode can be found at https://sqldatapartners.com/2020/12/18/episode-210-the-elephan…
 
Finding your first full time job is incredibly difficult—and that was before we were in a worldwide pandemic. In this episode, we discuss some strategies and share some experiences about how we got our first jobs and hopefully give you some inspiration as you try to find your first experience. The show notes for today's episode can be found at http…
 
There is a growing list of formats to store data and Graph is one of the newer trends. It is becoming so popular SQL Server has created ways to implement graph structures. Mala Mahadevan joins us in this episode, and we revisit some of the origins of Graph, what it is good at, and why you may not want to rush to move all your data to Graph storage.…
 
SQL Trail 2020 was a success! There was a time I was unconvinced this would be the case. This is not to say we didn't have issues; however, talking with others helped us avoid some common pitfalls and make our event unique. Although we were virtual, I sent all the attendees a conference t-shirt, some swag, and cookies! I wanted everyone to feel som…
 
There are many programming languages available to the modern developer and there are even more options for connecting to the database. In this episode, we talk with Taurius Litvinavicius about his Manning course on connecting .NET Core to SQL Server. The show notes for today's episode can be found at https://sqldatapartners.com/2020/09/16/episode-2…
 
Power BI is founded on the idea of self-service BI and Excel is the most common data source in the world. While Power BI can import that information with ease, the data may not be in the best format. In this episode, we discuss areas report creators should consider when building Power BI reports so their reports can perform to their satisfaction an…
 
A variety of devices now have the ability to report metrics about status, performance, or other sensor information. Collecting this information and making it useful in business operations can be difficult and the Internet of Things (IoT) provides options for consuming, processing, and reporting. Microsoft has introduced a number of different offeri…
 
As we stretch the technology stack in this episode, I rely on my trusty co-hosts to get us through. Kevin and Jean-Georges Perrin do a great job giving us their thoughts on Spark. I hope you will enjoy the episode. The show notes for today's episode can be found at https://sqldatapartners.com/2020/08/06/episode-203-spark-in-action. Have fun on the …
 
As COVID-19 prevents us from gathering in the same place, how do organizers continue to put on compelling events? This strikes home as SQL Data Partners consider whether to have our SQL Trail event this fall. Matt Gordon put on an event in April and I was interested to get his take on how things went and how he accomplished his goals for the event.…
 
After we recorded Episode 189, we knew we lacked some of the business reasons behind the Common Data Model. Luckily, we reached out Tricia Wilcox-Almas and she has helped us fill in some of the gaps and also present how the Common Data Model is implemented in the new versions of Azure Data Lake. The show notes for today's episode can be found at ht…
 
To celebrate our 200th episode, we reached out to Bob Ward to come and celebrate this milestone with us. I have to plead the 5th on why it took us 200 episodes to finally invite him; however, we finally wised up and Bob walks us through some of the changes SQL Server has experienced over the years and what is in store (Spoiler—no big scoops) for th…
 
We can incur technical debt in several ways—aging technology, choosing delivery speed over scale architecture, or implementing new technology the entire team cannot yet support. I don’t know that I’ve ever worked at a place that hasn’t talked about technical debt. It wasn’t until I stumbled on a talk by Adam Lenda that make me think about the ways …
 
In a previous episode (175) we discussed migrating to the cloud, and we had a few comments from our compañeros which mentioned we should include more details around cloud infrastructure—the pieces or processes you want or DON’T want to administer. In this episode, we dive into cloud infrastructure and discuss some scenarios on when you might choose…
 
In 1990, the group Snap! release a song called "The Power". It would take Microsoft more than 20 years, but they eventually came up with a series of 'power' tools they built into Excel. Those tools later grew into Power BI--which is kinda like Voltron if you are old enough to remember. In this episode we discuss one of the first data manipulation t…
 
This is a topic I have been interested in covering for some time and as our world faces a crisis dictating that we stay home, it seems like a good time to talk about teleworking. Everyone will have a different situation of course, but we thought we share some of our experiences. I continue to suggest a need to stay connected to your team and while …
 
The number of new programming languages never ceases to amaze me. Technology advances continue to require new ways of allowing users to customize the way they use tools and Power BI is no different. In this episode, Ginger Grant joins us as we continue the conversation about DAX and some considerations you need to make should you want to pick up an…
 
After Episode 180 on PolyBase came out, we received a few questions on use cases for PolyBase. Compañeros, when you ask, we reply! This episode we carve out 3 use cases for PolyBase and ways in which you might change workflows based on this SQL Server 2019 feature. If you want to dive much deeper into PolyBase, you can always check out Kevin's book…
 
Our regular host is down for the count with the flu; however, the podcast must go on! In this episode, we answer a listener-submitted question about Power BI Premium. Kevin and Eugene take us through Sachin Gangwar’s questions. We hope you will submit your question for a future episode! The show notes for today's episode can be found at http://sqld…
 
What is the future of the DBA and what technologies should I be focused on? In this episode, we attempt to look into the crystal ball and give our take on the future of work for the data platform professional. We focus our conversation around two listener-provided questions about the best way to stay educated in an ever-changing landscape. The DBA …
 
Wouldn’t it be nice if you could filter the rows a user sees in Power BI? What’s that? You’ve already implemented Row-Level Security at the database level? Well, that actually won’t help you in Power BI. Yikes. In this episode we discuss ways to filter by records in Power BI and why it might be so confusing to implement what at first glance seems l…
 
Getting released just before the end of the year, SQL Server 2019 is now available in general release. While at first glance, it appeared this release was all about Big Data Clusters, and rightfully so--it brings 'cloud first' options to on-premises scenarios; however, it is not the only big feature. We spoke about some of the Polybase changes in E…
 
Moving data is fairly straightforward; however, mapping data from one source to another can be extremely challenging. In an attempt to help self-service BI users, Microsoft has introduced a Common Data Model, and in this episode, we discuss the new model. This may not be as approachable for organizations which already have a data warehouse; however…
 
A couple of years ago, Netflix offered a reward for anyone who could improve the algorithm for choosing a movie. The team that came in second took what they learned from it and created a company -- Databricks. In this episode, we focus on Databricks; why it is popular, what it can be used for, and considerations for its use. The show notes for toda…
 
Make it go faster! Visualizations are great, but when users start complaining about the load times on reports, it can be a tough exercise to figure out the issues. In this episode, we discuss ways you can measure the speed of your Power BI reports. We also get into some of the fundamentals of data storage for Power BI. The show notes for today's ep…
 
2020 dawns a first for our podcast. This episode is dedicated entirely to a listener question. We've had questions before; however, this episode the team tackles two questions from longtime listener Trent Adams. The context of his questions surround the concepts of IT having the ability to provide new functionality to the business and the business …
 
Why write a book, when you already have a site full of documentation? In this episode we chat with Rob Sewell about his project to write a book, DBATools in a Month of Lunches. He gives us some insights on what the book is about, how it is different than documentation, and how the process of making the book available in pieces has helped the creati…
 
​You've seen the visualizations and want to dive in--perhaps you were assigned the task. However you started with Power BI, chances are you might get stuck at some point. In this episode, we chat about strategies you can employee to help ensure success. Have a take on this? Hit us up on social media. We'd love to hear from you. The show notes for t…
 
SQL Server 2019 is out and one of the most interesting additions is SQL Server 2019 Big Data Clusters. In this episode, Kevin Feasel covers the marriage of SQL Server and Apache Spark. We discuss what Big Data Clusters are (and how it's not a SQL Server feature or an edition of SQL Server, but a thing in itself), cover some of the architecture behi…
 
Loading …

Quick Reference Guide

Copyright 2021 | Sitemap | Privacy Policy | Terms of Service
Google login Twitter login Classic login