SQL awam
[search 0]
lebih
Download the App!
show episodes
 
Artwork

1
SQL Server רדיו

Guy Glantser and Eitan Blumin

Unsubscribe
Unsubscribe
Bulanan
 
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
 
Artwork

1
SQL Server Radio

Guy Glantser, Eitan Blumin

Unsubscribe
Unsubscribe
Bulanan
 
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 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
 
Loading …
show series
 
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
 
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
 
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
 
גיא ואיתן מדברים על הפיצ'ר החדש של מיקרוסופט שהוכרז סוף סוף בתור 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
 
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
 
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
 
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
 
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
 
לגיא יש חדשות מרעישות, איתן מספר על חוויותיו ב-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
 
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
 
גיא ואיתן מדברים על היוזמות החדשות של מדירה בפתיחת “מועדוני המומחים” בתחום הדאטה, וגם הכרזה חשובה לגבי קהילת הדאטה הנוכחית עבור DBA-ים. וגם אנחנו מדברים על הסיבות למה צריך או לא צריך כלי ניטור לבסיסי הנתונים שלנו. קישורים רלוונטיים: Data Platform Meetup Israel | Meetup The new Microsoft Data Analysts Club - Content Hub Microsoft Data Analysts Club …
  continue reading
 
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
 
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
 
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
 
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
 
גיא ואיתן בתוכנית שכולה עניין של זמן. קישורים רלוונטים: הרצאה של עדי כוהן על 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
 
אם אתם עובדים בתחום ה-DATA, ורוצים ללמד את ילדיכם הקטנים מה אתם עושים בעבודה, אז תשמיעו להם את הפרק המיוחד הזה! מה אתם חושבים? יצא לנו מגניב? מעניין? או משעמם מידי לילדים? בכל זאת, פעם ראשונה שאנחנו מנסים דבר שכזה.Oleh SQL Server Radio
  continue reading
 
Loading …

Panduan Rujukan Pantas

Podcast Teratas