SQL Down Under is a podcast for SQL Server and data professionals
…
continue reading
Delving into the world of data analytics. From interviews with leaders in the field; to short, sharp tech episodes. This is All Things Being SQL.
…
continue reading
SQL Server Radio is a Podcast for SQL Server DBAs, database developers, architects, system administrators, and anyone else who is interested in the SQL Server platform. The show is intended to add another platform of knowledge sharing to the already strong Israeli SQL Server community.
…
continue reading
Kendra Little's podcast discussing database performance tuning, software development, and working with data.
…
continue reading
SQL Server Radio is a Podcast for SQL Server DBAs, database developers, architects, system administrators, and anyone else who is interested in the Microsoft SQL Server platform and the Microsoft data platform in general. As the data world changes, we also occasionally talk about other platforms and services like Azure and Amazon cloud services, Elastic Search, Hadoop, MongoDB, Machine Learning, and much more.
…
continue reading
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 marathonus.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.
…
continue reading
This podcast says you about the importance of self -belief Cover art photo by https://www.behance.net/raviroshan
…
continue reading
This podcast is about SQL Family, from SQL Family and for SQL Family. We're been talking about many varies things including Microsoft Data Platform and all related stuff to well known SQL members. Do not know what a #SQLFamily is? Do you know who is a member of SQLFamily? Do you want to know what they do, why they are so popular or what their dog/cat name is? Or maybe you want to become a new member? The podcast is for you!
…
continue reading
Summary In this episode, Liam, Erik and Andrew discuss various topics related to data analytics, including Andrew's background in finance and his transition to data analytics, the role of data in higher education, building a personal brand on LinkedIn, the purpose of an analytics function in a business, trends in data analytics teams, challenges as…
…
continue reading
היום גיא ואיתן מדברים עם אורחת מיוחדת מאוד - רוני ורד האחת והיחידה! 🤩 שמעו את הסיפור המעניין והפרספקטיבה המיוחדת שלה בתור מישהי שעובדת גם עם בסיס הנתונים של מיקרוסופט אבל גם עם המתחרים הגדולים שלה! קישורים רלוונטיים: דף הלינקדאין של רוני ורד Update Policy for Azure SQL Managed Instance - Microsoft Community Hub Update policy - Azure SQL Managed Ins…
…
continue reading
1
Episode 276: Dynamic SQL and Testing in Isolation
41:46
41:46
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
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 …
…
continue reading
1
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
1:04:36
1:04:36
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
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
SDU Show 91 with guest Mohamed Kabiruddin
48:46
48:46
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
48:46
SDU Show 91 features the Cloud SQL lead for Google Mohamed Kabiruddin discussing implementing SQL Server on Google CloudBởi Dr Greg Low
…
continue reading
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…
…
continue reading
1
פרק 170 - על שכפול נתונים לסביבות נמוכות וג'ובים בענן
29:41
29:41
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
29:41
גיא ואיתן מדברים על הפיצ'ר החדש של מיקרוסופט שהוכרז סוף סוף בתור GA - הלוא הוא Azure SQL Elastic Jobs. וגם, אנחנו דנים בנושא שיכפול נתונים עבור סביבות נמוכות, ועוד. קישורים רלוונטיים: General availability: Elastic Jobs in Azure SQL Database - Microsoft Community Hub Azure Elastic Jobs - The NonPlastic, Elastic Fantasic (sqlrod.com) dataplat/dbaclon…
…
continue reading
SDU Show 90 features Microsoft Senior Product Manager Joe Sack discussing Copilot integration with Azure SQL DBBởi Dr Greg Low
…
continue reading
1
Episode 275: Machine Learning and Power BI
44:42
44:42
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
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…
…
continue reading
SDU Show 89 features Microsoft Senior Program Manager Erin Stellato discussing SQL Server and data related toolsBởi Dr Greg Low
…
continue reading
1
Episode 162 - Backups and Recovery, RTO, RPO, and RCO
35:55
35:55
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
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…
…
continue reading
מה העתיד צופן לנו ה-DBA-ים? מה כדאי לנו לעשות לגבי הקריירות שלנו? גלו כל זאת ועוד בפרק ההמשך של.... ה-DBA-ים! קישורים רלוונטיים: Microsoft DBAS Club | Meetup DBA's Community | MADEIRA (madeiradata.com) Data Leaders | MADEIRA (madeiradata.com) DevGeekWeek2024 (johnbryce.co.il) ROW_NUMBER (Transact-SQL) - SQL Server | Microsoft Learn Microsoft Copilo…
…
continue reading
1
SDU Show 88 with guest Angela Henry
1:07:26
1:07:26
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
1:07:26
SDU Show 88 features Microsoft data platform MVP Angela Henry discussing what she wishes people knew about data types in SQL ServerBởi Dr Greg Low
…
continue reading
SDU Show 87 features well-known data community member Ronen Ariely discussing why he thinks knowledge of SQL Server internals is importantBởi Dr Greg Low
…
continue reading
1
#1 Lucy Alexander, Director of Insights & Analytics @ The Financial Times
44:02
44:02
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
44:02
Summary Lucy discusses her background and career path in analytics, including her experiences at The FT, ASOS and Burberry. She highlights the differences in data analytics between established brands and scale-ups. Lucy also shares her insights on the value of analytics and the challenges of leading an analytics team. She discusses the hype around …
…
continue reading
1
Episode 161 - EXCLUSIVE: Announcing the Biggest Innovation for Azure SQL Managed Instances (Codename: Hermes)
41:51
41:51
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
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…
…
continue reading
1
SDU Show 86 with guest Armando Lacerda
41:43
41:43
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
41:43
SDU Show 86 features Microsoft MVP Armando Lacerda discussing SQL Server 2022 snapshot backups and data virtualizationBởi Dr Greg Low
…
continue reading
1
SDU Show 85 with guest Bob Duffy
1:19:42
1:19:42
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
1:19:42
SDU Show 85 features Microsoft MVP Bob Duffy discussing his approaches to developing data warehouses, and a little SQL Server historyBởi Dr Greg Low
…
continue reading
1
פרק 168 - עתיד תפקיד ה-DBA-ים העוסקים בפלטפורמות מרובות
37:27
37:27
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
37:27
לגיא יש חדשות מרעישות, איתן מספר על חוויותיו ב-DATATLV, ואנחנו פותחים בדיון מעניין על המצב הנוכחי של תחום ה-DBA המודרני: האם כדאי להתמחות בכמה פלטפורמות כי זה מה שיותר ויותר ארגונים רוצים? או שיותר נכון להתמחות “לעומק” בפלטפורמה מסויימת? כל זאת ועוד בפרק מרתק שאסור לפספס! קישורים רלוונטיים: Datatlv.com CI and CD with SSDT Part 1 - Development Lifec…
…
continue reading
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…
…
continue reading
Welcome to All things being SQL. The podcast dedicated to data, analytics, insights and of course SQL. Brought to you by the team behind Infer, the analytics tool allowing any organisation to become AI enabled. Interviews, technical deep dives and a healthy dose of our opinion, strap in, it's going to be fun! Hosted by Erik Mathiesen-Dreyfus, exper…
…
continue reading
1
Episode 160 - OPTION RECOMPILE and the magical Turbo button
32:49
32:49
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
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…
…
continue reading
1
פרק 167 - מועדוני הדאטה החדשים של מדירה ולמה צריך ניטור בכלל
40:25
40:25
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
40:25
גיא ואיתן מדברים על היוזמות החדשות של מדירה בפתיחת “מועדוני המומחים” בתחום הדאטה, וגם הכרזה חשובה לגבי קהילת הדאטה הנוכחית עבור DBA-ים. וגם אנחנו מדברים על הסיבות למה צריך או לא צריך כלי ניטור לבסיסי הנתונים שלנו. קישורים רלוונטיים: Data Platform Meetup Israel | Meetup The new Microsoft Data Analysts Club - Content Hub Microsoft Data Analysts Club …
…
continue reading
1
Episode 273: The Capability Maturity Model for Data Professionals
55:27
55:27
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
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…
…
continue reading
1
Power BI Performance Tuning with Eugene Meidinger
53:54
53:54
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
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
Episode 272: Performance Tuning Scripts
50:26
50:26
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
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 …
…
continue reading
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…
…
continue reading
גיא ואיתן לומדים מטעויות, מדברים על טעויות של מיקרוסופט, ועוד. קישורים רלוונטיים: What To Avoid If You Want To Use MERGE | Michael J. Swart Use Caution with SQL Server's MERGE Statement | Aaron Bertrand I wish SQL Server had better Table Partitioning | Eitan Blumin The Best Solution for SQL Server Partitioning Sliding Window | Eitan Blumin Microsof…
…
continue reading
1
Episode 271: Pass Summit 2023 Wrap-Up
38:59
38:59
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
38:59
This past November, Eugene and I attended the 2023 PASS Data Community Summit (aka PASS Summit) in Seattle, while Kevin headed down to Orlando for the Microsoft Live! 360 event in Orlando. Having no remote option this year was fine for us, as it was great to reconnect with our friends and colleagues in the data community, as well as get updates liv…
…
continue reading
1
Episode 158 - Reverse Engineering Table Relations based on SQL Plans
41:41
41:41
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
41:41
Guy and Eitan talk about some great things about SQL Server, and mostly Guy’s experience in digging into execution plans and generating synthetic IO workloads. Relevant links: What’s new in SQL Server and Azure SQL 2023 Year in Review Multi-Tenancy in the Real World | Eitan Blumin (Data Weekender 6.5)…
…
continue reading
1
פרק 165 - יש לנו זמן לדבר על זמן כל הזמן
33:26
33:26
Nghe Sau
Nghe Sau
Danh sách
Thích
Đã thích
33:26
גיא ואיתן בתוכנית שכולה עניין של זמן. קישורים רלוונטים: הרצאה של עדי כוהן על Temporal Tables שימושים שגויים בפונקציות תאריך - מאת גרי רשף מיפוי של טבלאות שלא בשימוש כולל תמיכה בריסטרטים - מאת אריק רואש פוסטים של פול רנדל לגבי Wait Statistics: SQL Server Wait Statistics: Tell me where it hurts Capturing wait statistics for a period of time Collect W…
…
continue reading