))
Each week I’ll be interviewing experts and users alike on their experience with Fabric, warts and all. I can guarantee that we’ll have voices you aren’t used to and perspectives you won’t expect. Each episode will be 30 minutes long with a single topic, so you can listen during your commute or while you exercise. Skip the topics you aren’t interested in. This will be a podcast that respects your time and your intelligence. No 2 hour BS sessions.
…
continue reading
Kendra Little's podcast discussing database performance tuning, software development, and working with data.
…
continue reading
1
Ep. 12 - Power BI, Data Viz, and Solving the Right Problem
30:17
30:17
Play later
Play later
Lists
Like
Liked
30:17
T. from Data Rocks talks about how data viz is a tiny subset of information design. The key is to focus less on just charts, but more about how the data is communicated and received. We talk about how what the user does with it separates a pile of charts from a successful design flow. I found this conversation helpful to understand it means to be g…
…
continue reading
1
Ep. 11 - Data Science, Career Paths, Learning Fabric
38:39
38:39
Play later
Play later
Lists
Like
Liked
38:39
In this episode, Steph Locke covers a wild career from data science consultant to startup owner to Microsoft manager. We talk about what’s required to work in data science. We also talk about the interaction of large language models and coding. Finally, we talk about adjusting to Power BI and Fabric. Links Statistical t-test Statistical r-correlati…
…
continue reading
In this episode with Ellen Burns-Johnson, we talk about when we worked on a cloud game for Azure Synapse, ADF, Power BI. A big lesson learned from that is a big challenge today for Fabric is getting different teams and personas to communicate with each other; it's not just about the technology. Ellen's first impression is "it seems like Microsoft i…
…
continue reading
In this Episode Els Van Vessem talks about the challenges of implementing Fabric in the government. In it they talk about doing proof of concepts with Fabric and the limitations when your data is confidential, protected and on-premises. Data sovereignty often means sticking to a hybrid approach. We also discuss the challenges of similarly named pro…
…
continue reading
Apologies for the audio; I stupidly forgot to double check my mic this episode. In this episode, Erin Dempster gives us an outside view of fabric focused on CI/CD. We talk about both deployment pipelines and devops pipelines and how she uses both tools in concert. This episode is interesting because it touches on the challenges of integrating a var…
…
continue reading
1
Ep. 7 - Semantic Link and Semantic Link Labs
28:53
28:53
Play later
Play later
Lists
Like
Liked
28:53
In this episode, Stephanie Bruno talks about semantic link and semantic link labs, which allow you to better manage your Power BI resources with Fabric notebooks. Semantic allows you to query and work directly with your semantic model. Semantic Link Labs allows you to automate running the best practices analyzer against your model. I've heard nothi…
…
continue reading
In this episode, Krystina Mishra talks about being an accidental Fabric admin. She talks about the challenges of being part of a centralized IT team that operational and business teams. She talks about the challenges of how everything with Dynamics 365 is slightly different than every other data source and how everything is convoluted with Synapse.…
…
continue reading
In this Episode, Frank Geisler explains Realtime Intelligence in Microsoft Fabric. We learn how RTI is its own thing in Fabric and is not directly backed by Parquet like a Lakehouse is. We also dig into the distinction between real-time analytics and real-time intelligence. The latter is not just reporting but being able to trigger activity based o…
…
continue reading
In this episode, Ginger Grant talks about the differences between warehouse and lakehouses in Fabric. We talk about how Warehouses make more sense if you are doing a lot of ad-hoc querying. In most other cases, Lakehouse will be easier and fewer steps. Links Lakehouse versus Warehouse decision guide Delta lake vacuum Polaris engine behind Fabric Wa…
…
continue reading
1
Ep 3. Extracting Data from Legacy Systems
35:38
35:38
Play later
Play later
Lists
Like
Liked
35:38
In this episode, Kellyn Gorman talks about the challenges of getting data out of legacy systems (i.e. relational data bases) into Fabric. She explains that whoever hosts the data wins. She talks about often content talks about the golden path or focuses on the marketing content, but it's much rarer to see content that deals with the difficult edge …
…
continue reading
1
Ep. 2 Medallion Architecture with Cathrine Wilhelmsen
35:25
35:25
Play later
Play later
Lists
Like
Liked
35:25
Cathrine explains how there isn't a single solution for architecting your data lake with Microsoft Fabric. We walk through all the different moving pieces of getting started with Fabric and lakehouses. Catherine touches on some different ways of implementing medallion in Fabric. She also makes the point Medallion is not the same as Dev / QA / Prod.…
…
continue reading
In this Episode, I interview Kristyna Ferris about the different types of data Movement in Microsoft Fabric. Specifically, we talk about gen 2 dataflows, data pipelines, and Spark notebooks. We see how you start simple and work your way up. Kristyna shares the "faucets first" approach at P3 adaptive. Links Yak shaving Rapid development Datatypes in…
…
continue reading
1
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
1:04:36
1:04:36
Play later
Play later
Lists
Like
Liked
1:04:36
Erik Darling joins Kendra Little to rate different SQL Server Performance Tuning Techniques in episode 81 of the Dear SQL DBA podcast. We share our opinions of... (deep breath) Recompile hints, Query Store hints and plan forcing, CTEs, Resource Governor, the legacy cardinality estimator, Table Variables, Automatic Plan Correction, Batch Mode, index…
…
continue reading
1
Power BI Performance Tuning with Eugene Meidinger
53:54
53:54
Play later
Play later
Lists
Like
Liked
53:54
Eugene Meidinger stops by to chat about Power BI Performance Tuning with Kendra. We talk about the various engines and languages used in Power BI and big-picture strategies for getting performance from the start. Eugene then talks about the community of tools and techniques that can be used to dig in and solve performance problems in Power BI. Euge…
…
continue reading
1
Automated Deployments and the Art of the Database with Database Michael J Swart
1:05:28
1:05:28
Play later
Play later
Lists
Like
Liked
1:05:28
In this episode, Michael J Swart joins the Dear SQL DBA podcast to talk about databases, automation, and how he’s come to illustrate some of the coolest blog posts ever to be written about data. Check out Michael’s art and blog posts at michaeljswart.com, and explore his posts by illustration at https://michaeljswart.com/browse-articles-by-illustra…
…
continue reading
SQL Server has a new feature that’s currently only available in Azure SQL Database: Optimized Locking. Jeremiah Peschka joins the podcast to talk through the docs and nerd out on locks, blocks, and how to pronounce the acronym “LAQ”. Learn more about this feature online: Optimized locking article from Microsoft Learn Transaction locking and row ver…
…
continue reading
1
Advice for Technical Leaders with Alex Robson
1:00:28
1:00:28
Play later
Play later
Lists
Like
Liked
1:00:28
Ever wondered what it's like to be a VP or Director of Engineering? Kendra chats with Alex Robson about leadership in technology, what you can get out of coaching or an MBA program (should you be interested), and what makes a high performing team. We'll also chat about recommended content to hone your tech leadership skills. Alex Robson's site and …
…
continue reading
SQL Server performance tuning expert Erik Darling joins the podcast today to chat about how good queries can go bad, how bad queries can get better, and the question on everyone's mind: if he was a database, what database would he be? This episode contains some mildly explicit language. Erik's blog: https://erikdarlingdata.com/blog/ Erik's YouTube:…
…
continue reading
1
What's up with Tech Interviews in 2023? With Jeremiah Peschka.
29:06
29:06
Play later
Play later
Lists
Like
Liked
29:06
Tech interviews are weird and wacky. How did they get this way, and how SHOULD they be? Jeremiah Peschka joins us to discuss.By Kendra Little, Jeremiah Peschka
…
continue reading
There are lots of jobs for data folks. In this episode, I'm discussing three hot job titles: Database Administrator (DBA), Database Reliability Engineer (DBRE), and Data Engineer (DE) To see the venn diagrams I made for these roles, visit https://catalyzesql.com/blog/1/01/01/dear-sql-dba-data-roles-dba-dbre-de/…
…
continue reading
1
When NOT to choose SQL Server to store your data
14:19
14:19
Play later
Play later
Lists
Like
Liked
14:19
I wrote a blog post inspired by Stephen Vakil's excellent suggested interview question, but I inverted it: When should you NOT choose SQL Server to store your data? My thoughts: * When you don't actually need a database * When you're not using structured data * When you want pure analytics, or something other than a workload involving OLTP * When y…
…
continue reading
It's Down Tools Week at Redgate. I share what "Down Tools Week" is, what I'm working on this week, and why I think it's a terrific experience for fostering creativity, innovation, and teamwork. In closing I share some thoughts on variations of this kind of project which you might use in your own organization, whether you are a developer, DBA, or ha…
…
continue reading
