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
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
Kendra Little's podcast discussing database performance tuning, software development, and working with data.
…
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
SDU Show 87 features well-known data community member Ronen Ariely discussing why he thinks knowledge of SQL Server internals is importantAv Dr Greg Low
…
continue reading
1
#1 Lucy Alexander, Director of Insights & Analytics @ The Financial Times
44:02
44:02
Spill senere
Spill senere
Lister
Lik
Likt
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
Spill senere
Spill senere
Lister
Lik
Likt
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!Av SQL Server Radio
…
continue reading
1
פרק 168 - עתיד תפקיד ה-DBA-ים העוסקים בפלטפורמות מרובות
37:27
37:27
Spill senere
Spill senere
Lister
Lik
Likt
37:27
לגיא יש חדשות מרעישות, איתן מספר על חוויותיו ב-DATATLV, ואנחנו פותחים בדיון מעניין על המצב הנוכחי של תחום ה-DBA המודרני: האם כדאי להתמחות בכמה פלטפורמות כי זה מה שיותר ויותר ארגונים רוצים? או שיותר נכון להתמחות “לעומק” בפלטפורמה מסויימת? כל זאת ועוד בפרק מרתק שאסור לפספס! קישורים רלוונטיים: Datatlv.com CI and CD with SSDT Part 1 - Development Lifec…
…
continue reading
1
SDU Show 86 with guest Armando Lacerda
41:43
41:43
Spill senere
Spill senere
Lister
Lik
Likt
41:43
SDU Show 86 features Microsoft MVP Armando Lacerda discussing SQL Server 2022 snapshot backups and data virtualizationAv Dr Greg Low
…
continue reading
1
SDU Show 85 with guest Bob Duffy
1:19:42
1:19:42
Spill senere
Spill senere
Lister
Lik
Likt
1:19:42
SDU Show 85 features Microsoft MVP Bob Duffy discussing his approaches to developing data warehouses, and a little SQL Server historyAv Dr Greg Low
…
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
Spill senere
Spill senere
Lister
Lik
Likt
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
Spill senere
Spill senere
Lister
Lik
Likt
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
Spill senere
Spill senere
Lister
Lik
Likt
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
Spill senere
Spill senere
Lister
Lik
Likt
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
Spill senere
Spill senere
Lister
Lik
Likt
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
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
Spill senere
Spill senere
Lister
Lik
Likt
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
Spill senere
Spill senere
Lister
Lik
Likt
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
Moving up the ranks in the holy technology wars is the medallion architecture, and boy are we interested in getting your thoughts. Not since the 2008 Olympics and Michael Phelps' tenth of a second win over Milorad Cavic has there been so much controversy around bronze, silver, and gold. This episode of the podcast has a genesis with Databricks and …
…
continue reading
SDU Show 84 features Microsoft MVP Rob Sewell discussing command line utilities for SQL Server including go-sqlcmd and the upcoming SQL Bits conferenceAv Dr Greg Low
…
continue reading
1
פרק 164 - מה זה דאטה? פרק מיוחד לילדים
29:03
29:03
Spill senere
Spill senere
Lister
Lik
Likt
29:03
אם אתם עובדים בתחום ה-DATA, ורוצים ללמד את ילדיכם הקטנים מה אתם עושים בעבודה, אז תשמיעו להם את הפרק המיוחד הזה! מה אתם חושבים? יצא לנו מגניב? מעניין? או משעמם מידי לילדים? בכל זאת, פעם ראשונה שאנחנו מנסים דבר שכזה.Av SQL Server Radio
…
continue reading
1
Episode 269: Why Do I Need a Managed Service Provider?
16:31
16:31
Spill senere
Spill senere
Lister
Lik
Likt
16:31
In this Episode, Carlos talks about managed services and shares some of the benefits of working with an MSP, as well as potential cons. The term manage services refers to the practice of outsourcing business administration or management responsibilities to the third party. Why would you ever want to outsource these pieces? Listen in to learn more a…
…
continue reading
1
Episode 157 - Let's Talk Some Hardcore SQL Server
39:00
39:00
Spill senere
Spill senere
Lister
Lik
Likt
39:00
Guy and Eitan go back to their SQL Server roots and go hardcore into execution plan analysis and database corruption. Relevant links: Health Check Scripts/Find_Top_Exec_Plans_to_Optimize.sql SQLServerFast.com Database Corruption Challenge by Steve Steadman A DBA's Guide to the Proper Handling of Corruption Data TLV Summit PASS Data Community Summit…
…
continue reading
1
פרק 163 - גיא ואיתן מארחים את אלכס פלס
44:38
44:38
Spill senere
Spill senere
Lister
Lik
Likt
44:38
גיא ואיתן מארחים את אלכס פלס האחד והיחיד - ארכיטקט פתרונות דאטה ובינה מלאכותית במיקרוסופט. בואו לקבל נקודת מבט של מיקרוסופט על השוק הטכנולוגי הבינלאומי, ומידע על טכנולוגיות חדשניות ומעניינות. קישורים רלוונטיים: פרופיל של אלכס פלס בלינקדאין OpenAI ChatGPT The A.I. Dilemma Microsoft Fabric אירועים ומיטאפים קרובים: Navigating Large Data in PowerBI wit…
…
continue reading
1
Episode 268: AI and the Future of the Database
53:41
53:41
Spill senere
Spill senere
Lister
Lik
Likt
53:41
We love hearing from our listeners!!! In this episode, a long-time listener asked about the future of AI in the data platform space. We thought this was a very interesting topic as Microsoft has been including Artificial Intelligence or AI in more and more of its marketing material. In this episode we'll dive into the definition of AI, what feature…
…
continue reading
1
Automated Deployments and the Art of the Database with Database Michael J Swart
1:05:28
1:05:28
Spill senere
Spill senere
Lister
Lik
Likt
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
All your data, all your teams—in one place. What am I? If you said Microsoft Fabric, you win! When I interned with Cisco Systems in 2000, I supported a platform called Unified Messaging. At that time, we were talking about getting your email, voice mail, and faxes all in one place. My, how the times have changed. To a certain extent, the Microsoft …
…
continue reading
1
Episode 156 - Back to School with Encryption as a Tool
39:42
39:42
Spill senere
Spill senere
Lister
Lik
Likt
39:42
Guy and Eitan celebrate resuming the school year with some learning of their own. This time, focusing on encryption types in SQL Server. Relevant links: External REST Endpoint Invocation is now GA! Types of Encryption in SQL Server PWDENCRYPT and PWDCOMPARE Dynamic Data Masking And also, don’t forget to register for the upcoming Data TLV Summit!…
…
continue reading
1
Jer and Kendar Explore Optimized Locking
28:57
28:57
Spill senere
Spill senere
Lister
Lik
Likt
28:57
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