최고 Sql 팟캐스트 (2024)

1
Episode 170 - Interesting topics from PASS 2023 sessions 34:10

20d ago34:10

34:10

Guy and Eitan go over the most popular sessions released from the SQL PASS archive of 2023, and discuss some other topics. Relevant links: Announcing Microsoft SQL Server 2025: Enterprise AI-ready database from ground to cloud - Microsoft SQL Server Blog Sessions Archive for 2023 - PASS Data Community Summit Resolving and Preventing Deadlocks in SQ…

1
Episode 282: OneLake - A Deep Dive 34:38

1M ago34:38

34:38

In Episode 281, we introduced Microsoft OneLake with a high-level overview. Now we're going deeper with a discussion on the Parquet format, why Microsoft went with the Delta Lake variation, and what Delta Lake format brings to the table (no pun intended). We'll also examine some "behind the scenes" aspects of file management, and why you'll still b…

1
Episode 169 - Resumable Incremental Database Integrity Checks 32:36

2M ago32:36

32:36

Guy and Eitan discuss the common challenge of long-running database integrity checks (DBCC CHECKDB) and a solution to resolve it, and why do we need integrity checks at all? Relevant links: PASS Data Community Summit Incremental Integrity Check for Large Databases - Eitan Blumin's blog SQL Server Integrity Check - by Ola Hallengren tigertoolbox/Mai…

1
Episode 281: OneLake - The OneDrive for Data 31:39

2M ago31:39

31:39

As you start using Fabric, having a central location for your data is crucial. OneLake acts as this unified destination, offering a single, consolidated repository for all your data. In this podcast episode, we explore the core features of OneLake and its benefits with our guest, Mariano Kovo, and discuss how it efficiently handles large amounts of…

1
Episode 168 - New data types in SQL Server and a question about index fragmentation 32:49

3M ago32:49

32:49

Guy and Eitan discuss some interesting news from Microsoft regarding SQL Server, and also about the right way to handle index fragmentation. Relevant links: Resources from Microsoft: Preview release of SDK-style SQL projects in Visual Studio 2022 - Microsoft Community Hub Native JSON support now in preview in Azure SQL Managed Instance - Microsoft …

1
Episode 280: A Focus on Microsoft Fabric 18:56

3M ago18:56

18:56

At the Microsoft Build Conference in May 2023, Microsoft announced the new Fabric, where you could slice and dice all your data harmoniously within the environment. A few months later, Kevin, Eugene, and I discussed this evolution of the Azure Data platform in episode 267, and our thoughts on the vision for it's future, our expectations, and predic…

1
Episode 279: SQL Server Migrations Demystified 1:03:07

3M ago1:03:07

1:03:07

If you use SQL Server, you will eventually have to migrate that instance somewhere – to a new version, a new server, the cloud . . . somewhere. Or perhaps you'll find yourself migrating from another database into SQL Server. No matter which way you slice it, SQL Server migrations can be daunting, not to mention complex and time-consuming. While we …

1
Episode 167 - Let's Troubleshoot SQL AG Synchronization Latency 37:40

4M ago37:40

37:40

Fair warning for all listeners! Before starting to listen to this podcast, very strongly recommended: Have the diagram at the bottom of this page ready in front of you, so that it'll be easier for you to follow along: Common Causes and Troubleshooting Solutions for SQL AG Data Synchronization Latency - Microsoft Community Hub (sorry in advance!) Ad…

1
Episode 166 - DR Planning for SQL Server and Loading Large CSV Files 35:32

5M ago35:32

35:32

Guy and Eitan discuss the recent CrowdStrike incident and what it would mean for DBAs, and discuss options to load huge CSV files into SQL Server as fast as possible. Relevant links: 101 of Troubleshooting SQL Server on Linux - Microsoft Community Hub bcp utility - SQL Server | Microsoft Learn Altering lock escalation for SQL Server tables (mssqlti…

1
Episode 278: Running SQL Server on Azure VMs 1:04:29

5M ago1:04:29

1:04:29

Can you run SQL Server on Azure VM? Which VM is best? Is running SQL Server on a VM in Azure the right choice? Find out in this insightful episode with Anders Pedersen! With over 10 different SQL Server services now offered in Microsoft Azure, it can be difficult to know how you want to run your environment. Sometimes, the old ways are the best way…

1
Episode 277: PostgreSQL for the SQL Server Crowd 1:02:29

6M ago1:02:29

1:02:29

Is testing out pgAdmin on your to-do list? In this episode of the podcast, we chat with Ryan Booz, a PostgreSQL advocate at Redgate, about how a SQL Server professional might begin a dive into PostgreSQL, one of the most popular open source databases in the world. Ryan came from a career background in SQL Server, but after experiencing his accident…

1
Episode 165 - News in Azure SQL and Woes of Excel 38:44

6M ago38:44

38:44

Guy and Eitan discuss some important and interesting news from Microsoft about SQL Server, Straight Path Solutions publish 30 articles about SQL Server security checks, Guy talks about his experience with Excel, and Eitan is irritated about people still not doing SQL jobs correctly in AlwaysOn Availability Groups. Relevant links: SQLBits Free Video…

1
Episode 164 - The Good the Bad and the Ugly Transactional Replication 35:32

7M ago35:32

35:32

Guy and Eitan continue discussing HADR solutions. But this time focusing on Transactional Replication, its cons and pros and potential use cases. Also, some important announcements from Microsoft about Azure SQL! Relevant links: Data API builder General Availability (microsoft.com) Build REST API with Azure Data API Builder (DAB) (mssqltips.com) Ze…

1
Episode 276: Dynamic SQL and Testing in Isolation 41:46

7M ago41:46

41:46

Listener beware! This episode is full of danger as we tackle an interesting use case for Dynamic SQL. Dynamic SQL generally has a bad reputation in SQL Server circles, and with good reason. Dynamic SQL can open the door to many undesirable results - SQL Injection attacks being the most frightening of these. It can also be difficult to read, making …

1
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques 1:04:36

7M ago1:04:36

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…

1
SDU Show 91 with guest Mohamed Kabiruddin 48:46

7M ago48:46

48:46

SDU Show 91 features the Cloud SQL lead for Google Mohamed Kabiruddin discussing implementing SQL Server on Google Cloud저자 Dr Greg Low

1
Episode 163 - When and Why to HADR 34:37

8M ago34:37

34:37

Guy and Eitan discuss the various High Availability and Disaster Recovery options available to us in Microsoft SQL Server, their main advantages, limitations, and when it's most suitable to use or not to use them. Relevant links for further reading: AlwaysOn Basic Availability Groups / Database Mirroring AlwaysOn "Enterprize" Availability Groups Fa…

1
SDU Show 90 with guest Joe Sack 47:54

8M ago47:54

47:54

SDU Show 90 features Microsoft Senior Product Manager Joe Sack discussing Copilot integration with Azure SQL DB저자 Dr Greg Low

1
Episode 275: Machine Learning and Power BI 44:42

9M ago44:42

44:42

What kinds of problems are organizations solving with Machine Learning? In this episode, we explore a situation where a public works department was looking for more accurate information to predict future water levels based on rainfall to maintain water tank storage for balancing pressure and to prevent overflow flooding. Marathon data solutions con…

1
SDU Show 89 with guest Erin Stellato 49:36

9M ago49:36

49:36

SDU Show 89 features Microsoft Senior Program Manager Erin Stellato discussing SQL Server and data related tools저자 Dr Greg Low

1
Episode 162 - Backups and Recovery, RTO, RPO, and RCO 35:55

9M ago35:55

35:55

Guy and Eitan talk about some interesting news from Microsoft about SQL Server in Azure. And also discuss the topic of Backups and Recovery, RTO, RPO, RCO, and database Integrity Checks. Relevant links: Microsoft Copilot in Azure extends capabilities to Azure SQL Database (Private Preview) - Microsoft Community Hub Regex in SQL DB (microsoft.com) S…

1
SDU Show 88 with guest Angela Henry 1:07:26

9M ago1:07:26

1:07:26

SDU Show 88 features Microsoft data platform MVP Angela Henry discussing what she wishes people knew about data types in SQL Server저자 Dr Greg Low

1
SDU Show 87 with guest Ronen Ariely 51:05

9M ago51:05

51:05

SDU Show 87 features well-known data community member Ronen Ariely discussing why he thinks knowledge of SQL Server internals is important저자 Dr Greg Low

1
Episode 161 - EXCLUSIVE: Announcing the Biggest Innovation for Azure SQL Managed Instances (Codename: Hermes) 41:51

9M ago41:51

41:51

Niko Neugebauer and Vladimir Ivanovic are our esteemed guests for today, and they have a HUGE announcement to make about Azure SQL Managed Instances. Extra! Extra! 🗞 Hear all about it on this exclusive scoop here at the SQL Server Radio podcast! Relevant links: Azure SQL Managed Instance Next-gen GP (microsoft.com) Use Next-gen General Purpose serv…

1
SDU Show 86 with guest Armando Lacerda 41:43

9M ago41:43

41:43

SDU Show 86 features Microsoft MVP Armando Lacerda discussing SQL Server 2022 snapshot backups and data virtualization저자 Dr Greg Low

1
SDU Show 85 with guest Bob Duffy 1:19:42

10M ago1:19:42

1:19:42

SDU Show 85 features Microsoft MVP Bob Duffy discussing his approaches to developing data warehouses, and a little SQL Server history저자 Dr Greg Low

1
Episode 274: A CMM Case Study 51:13

10M ago51:13

51:13

After discussing the Capabilities Maturity Model in our last episode, it was fate when Andy Levy reached out and suggested a topic which sounds like a case study about his experience with CMM. As the only data professional in his organization at the time of his hiring, Andy went from fixing problems to slowing increasing his role in the organizatio…

1
Episode 160 - OPTION RECOMPILE and the magical Turbo button 32:49

11M ago32:49

32:49

Guy tries to convince Eitan that OPTION(RECOMPILE) is the ultimate "Turbo" button in SQL Server, and that it's strongly underappreciated. Relevant links for more info: OPTION(RECOMPILE) (Transact-SQL) - SQL Server | Microsoft Learn Recompile a Stored Procedure - SQL Server | Microsoft Learn Should I use option(recompile)? – SQLServerCentral SQL SER…

1
Episode 273: The Capability Maturity Model for Data Professionals 55:27

11M ago55:27

55:27

Have you ever felt stuck in a rut, repeating the same tasks, while knowing there is room for improvement? The Capability Maturity Model may be a way for you to start contributing to those improvements. In this podcast episode, Kevin Kline from SolarWinds walks us through how we might go from simply dealing with issues as they come, to being a contr…

1
Power BI Performance Tuning with Eugene Meidinger 53:54

12M ago53:54

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…

1
Episode 272: Performance Tuning Scripts 50:26

12M ago50:26

50:26

Do you find yourself repeating the same actions when pulling SQL Server performance metrics? Performance tuning a troublesome SQL Server can be a challenge. Luckily the community continues to produce wonderful folks like Erik Darling who contribute their knowledge to make your life a bit easier. In this episode of the SQL Data Partners podcast, we …

1
Episode 159 - Select * Wastes Money 37:55

12M ago37:55

37:55

Guy and Eitan discuss various practices in SQL Server that hurt performance and possibly waste money, negative VarDecimal numbers, renumbering Identity columns, and the new Azure Database Fleet Manager. Relevant links: SQL Server IN Clause With Multiple Literal Values Performance Behaviour | Neeraj Prasad Sharma Could SQL Injection be dangerous eve…

들어볼 가치가 있는 팟캐스트

Sql 팟 캐스트

들어볼 가치가 있는 팟캐스트

빠른 참조 가이드