SQL 공개
[search 0]

Download the App!

show episodes
 
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 sqldatapartners.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.
 
S
SQL Server Radio

1
SQL Server Radio

Guy Glantser, Eitan Blumin

Unsubscribe
Unsubscribe
매달
 
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.
 
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.
 
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!
 
Loading …
show series
 
We kick off the new year discussing a new feature in SQL Server 2022 called Transact-SQL snapshot backups. Good luck with the Google search on this feature--we know we had fun. 😊 These are not the snapshot backups you were frustrated with in 2005. We talk a little bit about who will be interested in this feature and what scenarios it will come in h…
 
Today we have the pleasure of hosting Rob Sewell, and talking about the upcoming SQLBits event of 2023! Relevant links: SQLBits 2023 agenda, speakers, pricing, and registration - events.sqlbits.com/2023 YouTube playlist of all 195 sessions from SQLBits 2022 - available for free! SQLBits helpers form - beard.media/sqlbits-helpers Rob Sewell's blog -…
 
גיא ואיתן מדברים על כמה נושאים מעניינים לכבוד שנת 2023 הבאה עלינו לטובה, וגם על הכנס הכי מגניב בשנה - SQL Bits. קישורים רלוונטיים: CHECKSUM (Transact-SQL) CHECKSUM_AGG (Transact-SQL) [Replication consistency] Compare all tables between two databases at once with Table Diff tablediff utility New In SQL Server 2022 and Azure SQL: XEvent Performance M…
 
As we close out the year, we take a look back and think about all those SQL Server 2022 episodes we didn’t record this year—and then make the goal to increase this count in the new year. 😊 We discuss some of the Cardinality Estimation changes in this version and the scenarios in which this may affect other features. I ask Kevin and Eugene what tech…
 
Guy and Eitan finally celebrate the generally available release of SQL Server 2022! And also discuss other announcements from PASS Data Community Summit, and also various interesting news and features of Azure SQL announced in November 2022. Relevant links: SQL Server 2022 is now generally available Consumption-based PAYG billing model for SQL Serv…
 
גיא ואיתן מדברים על SQL Server 2022 ששוחרר באופן רשמי לציבור הרחב, על כנס PASS Data Community Summit, ועוד. קישורים רלוונטים: SQL Server 2022 is now generally available - Microsoft SQL Server Blog רשימת חידושים בענן אז'ור: Azure SQL Public Preview updates for mid-November 2022 Azure SQL General Purpose updates for mid-November 2022 Azure SQL Manage…
 
Have you ever thought about working for yourself? It can be very enticing for some, and in this episode, we talk with John Sterrett about the pros and cons of running your own organization. We tackle some of the reasons you might get started and we share some of our experiences of working in our own organizations. Each person’s journey is going to …
 
Guy and Eitan play a game of word associations to spout a bunch of stuff about SQL Server features - mostly reviewing new system objects that replaced old DBCC commands, useful scripts in our toolbox, and talking about Application Reliability Errors. Relevant links: Buffer Pool Extension SQL Server editions comparison dashboard by domains, features…
 
גיא ואיתן מתחילים בדיון בהקשר של Availability Group וזורמים לפי אסוציאציות לנושאים נוספים ומעניינים. קישורים רלוונטיים: Configure read-only routing for an Always On availability group Clusterless Read-Scale Availability Groups Azure SQL Database elastic query and sharding overview (preview) CREATE EXTERNAL TABLE (Transact-SQL) Serverless SQL pool i…
 
Seven years ago, I started the SQL Data Partners Podcast. We have now arrived at Episode 256, and we dedicate this episode to you, the community. Thanks to everyone who has joined us along the way, and we hope to continue providing content you can enjoy on the go while still connecting with your SQL Server community. While we originally thought we …
 
Today we're pleased to have the one and only Itzik Ben-Gan hosted at our show again! We talk about interesting SQL/T-SQL related topics, the experience of teaching, his new upcoming book edition of T-SQL Fundamentals, and more. Relevant links: Itzik's personal web page at tsql.lucient.com Itzik Ben-Gan's Blog posts at SQLPerformance.com SQL Server …
 
One of the biggest challenges with developers using object-relational mapping (ORM) tools is the bad queries or procedures they create. Sure, most tools can create CRUD (Create, Read, Update, Delete, Upsert) procedures, but what about the extremely advanced safe dynamic Search stored procedures? My bet is they are super inefficient and could be imp…
 
גיא ואיתן מדברים על פוסטים מעניינים, הרצאות ואירועים שהיו בחודש הקרוב, אירועים עתידיים שיהיו בחודשים הקרובים, ואיך מיקרוסופט מוסיפים פיצ'רים מוזרים ל-SQL. אה, וגם לאיתן יש מיקרופון חדש. קישורים רלוונטיים: Stop Making SQL Server Weird, Microsoft. – Erik Darling Data SQL Server Indexes With Unused INCLUDE Columns - Dave Mason Find_Top_Exec_Plans_to_O…
 
Would you be interested in a tool to help you do code review checks and provide developers guidance on best practices? In this episode of the SQL Data Partners Podcast, we talk with Kevin Martin, the creator of sp_Develop, about how his procedure can help you review naming conventions, table conventions, data type conventions, SQL code conventions,…
 
Guy and Eitan discuss a few new features in SQL Server 2022, and Guy tells a story about an interesting use case where a customer accidentally dropped their encryption keys in production. Relevant links: SQL Server 2022 RC0 is now available! Azure Active Directory authentication for SQL Server 2022 Tutorial: Set up Azure Active Directory authentica…
 
In this episode, we dive into the Power Apps offering and discuss the pros and cons of using this latest Microsoft offering. Some definitions are given and hopefully this episode can orient folks on how to position Power Apps in their organizations. The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/09/07/…
 
גיא מספר סיפורים על תרחיש מעניין אצל לקוח שאפשר ללמוד ממנו הרבה, ואיתן מספר על פרויקט Multi-Tenancy שהוא עובד עליו בימים אלה והטריקים המעניינים שהוא מימש עבורו. קישורים רלוונטיים: הרצאות באוגוסט וספטמבר: SQL Server on AWS Cloud - Roni Vered Query Store in Action - Deepthi Goguri SQL Assessment - Microsoft's Best Practices Checker - Taiob Ali Azure …
 
Today, Guy has a lot of tips to share after reviewing one of those... "problematic" customer environments. Let's just say that he's got his hands full. But it's still fun, and you get to learn as well! Relevant links: Forced Parameterization | Microsoft Docs Forced Parameterization Can Lead to Poor Performance | Microsoft Tech Community Why Multipl…
 
Knowing your SQL Server is patched when an issue occurs is worth the effort of keeping it patched. While I don’t suggest a zero-day install for most folks, setting up a regular cadence to check is a reasonable ask if you have to manage a system. In this episode of the SQL Data Partners Podcast, we discuss the need for patching and how you might go …
 
How can you begin to integrate AI models into your environment without spending months building everything out? As we continue our march to Episode 256, we bring back our friend Sam Nasr to talk about Azure Cognitive Services. Sam walks us through a few examples of how he was able to leverage some pre-packaged voice recognition services to assist c…
 
גיא ואיתן מדברים על מספר פיצ'רים מעניינים ב-SQL Server 2022, על שאילתות רקורסיביות, מיגרציות לענן, ועוד. קישורים רלוונטיים: SQL Server 2022 and windowing improvements Guidelines for defining and using recursive CTEs GENERATE_SERIES (Transact-SQL) Number series generator challenge by Itzik Ben-Gan SQL Server 2012 reaches end of support and Microsoft…
 
This episode we are doing a bit of a look back and are going to air some previously buried content. Some of the bloopers are pre-video and some of them have some physical comedy, which you’ll have to go to YouTube to see. While a few were cut out of the published episodes, they are mostly things you’ve never heard. The show notes and video for this…
 
Data marts in Power BI have arrived and the words “data mart” mean something to data professionals. In this episode of the SQL Data Partners Podcast, we introduce the latest offering in Power BI and discuss the good, the bad, and the ugly for teams looking to arrive at self-service business intelligence. The show notes and video for this episode ca…
 
Guy and Eitan discuss their favorite upcoming new features in SQL Server 2022, and talk about some major upcoming events and summits. Relevant links: SQL Server 2022 public preview is now available on Linux Introducing the SQL Server 2022 blog series by Bob Ward Contained Availability Groups in SQL Server 2022 | Eitan Blumin What is a contained ava…
 
גיא ואיתן מספרים על מעשה מעניין שקרה להם בדיוק ביום ההקלטה של התוכנית. וכמובן מעדכנים על המון אירועים גדולים וחשובים שיהיו ממש בקרוב. קישורים רלוונטיים: DatatTLV Summit 2022 (September 15) Data Platform Meetup Israel upcoming events Performance Monitoring with Azure SQL Analytics (July 17) Madeira's DBSmart - Our Secrets to Successfully Managing Pr…
 
How do you keep records of your SQL Server environments? Patching levels, security accounts, configuration options, maintenance jobs and the like are some of the pieces we have to keep organized. Are you using something besides Excel to keep up with this? Sure, we can use the Content Management Server (CMS) to query across several instances, but we…
 
IT workers will generally claim they like learning new technology—it is almost a required attribute. Why then is bringing in new technology so hard? In this episode, we explore how new technologies make their way into organizations and how we might either embrace them or how this becomes a major challenge. There are so many new technologies now, it…
 
Guy and Eitan talk about a lot of exciting announcements and announcements about a lot of excitements! Does this even make sense? I don't know! Listen to the show to find out! Relevant links: How to HADR Your SQL Jobs Contained AlwaysOn Availability Groups Overview Pedro Lopes's Slides Deck for SQL Bits 2022 How to Identify and Fix TempDB Contentio…
 
While we continue to review the new features of the CTP preview of SQL Server 2022, we turn our attention to the recent Microsoft Build conference and talk about some of the announcements made. We try to separate the interesting technology from the marketing fluff and what pieces might trickle into the data platform space. Defining your requirement…
 
גיא ואיתן מדברים על SQL2022 והפיצ'רים החדשים בו, הרצאות עתידיות וכאלה שהיו לאחרונה, ועוד. קישורים רלוונטיים: Announcing the "Azure SQL Database External REST Endpoints Integration" Early Adoption Program SQL Friday Session: How to Use Parameters Like a Pro & Boost Performance? Microsoft Build 2022 Book of News Microsoft SQL Server 2022 T-SQL Enhanc…
 
Guy and Eitan discuss interesting challenges and news about migrations in SQL Server. Also, we talk about performance considerations of partitioning in SQL Server, a blog post series about how to tune performance, and new scripts in our Madeira Toolbox on GitHub. Relevant links: Data-tier Applications (DACPAC and BACPAC) About: Snapshot Replication…
 
גיא ואיתן חוזרים ל-basics! אנחנו מארחים את בן חזן הסו-שף האחד והיחיד שהחליט להחליף מקצוע, לעזוב את המטבח, ולהפוך להיות DBA במדירה! אנחנו מדברים על פרויקט ה-next generation של חברת Madeira, על איך כל אחד התחיל את המסע שלו בתור DBA ולמה, ומעלים זכרונות והארות. למה כדאי להיות DBA? מה חשוב לדעת? אל תפספסו את הפרק הזה! קישורים רלוונטיים: פרק 102 - ראיון…
 
SQL Server Management Studio (SSMS) version 18 was introduced to support SQL Server 2019 and in this episode of the podcast, we discuss some of the new updates available in SSMS and Azure Data Studio. We talk about scenarios where we use these tools and give some feedback on the new Azure services they support. The show notes and video for today's …
 
Guy and Eitan discuss upcoming events and conferences in 2022, and also about new features in SQL Server 2022, and more. Relevant links: Conferences: SQL Server & Azure SQL Conference Data Platform Virtual Summit 2022 DataGrillen PASS Data Community Summit 2022 (registration is open!) Get Ready for SQL Server 2022 Get Azure recommendation in Azure …
 
איתן וגיא נותנים לכם עדכון על הכנסים וההרצאות החשובות הצפויות בקרוב, וגם מדברים על מספר נושאים הקשורים לאוטומציות ופאוורשל. קישורים רלוונטיים: אירועים וכנסים: PASS Data Community Summit 2022 Data Platform Virtual Summit 2022 DataGrillen Conference SQL Server & Azure SQL Conference Cloud-Native Architecture & Execution Plan Analysis - Live Event at …
 
Who made that change? It is one of those questions that can send chills down the spine of those responsible for databases. In this episode, Josephine Bush talks with us about how we can use a combination of the native tools—auditing and extended events along with some custom reporting to be prepared for questions about change when more environments…
 
Conferences are on the uptick as COVID restrictions lift and we are excited for the upcoming year. After Eugene's return from SQLBits my thoughts revolved around what I wanted to learn this year at conferences and how you and I can go about picking the content we want to know more this year. Join us for a quick discussion on deciding what to learn …
 
גיא ואיתן מדברים על כמה הודעות חדשותיות חשובות מאוד שלא קשורות בכלל לפוליטיקה! (וגם לומדים קצת ענייני SQL על הדרך שזה תמיד כיף) קישורים רלוונטיים: מיטאפים בריאקטור בתל-אביב הרצאות בנושא הסמכת Azure Data Engineer Associate Big Data Clusters and Polybase Scale-Out Nodes are Being Retired - The path forward for SQL Server analytics פוסטים של בוב דור: …
 
It's that time again! The time to talk about SQL Server! We got a bunch of different topics to talk about on this show. Relevant links: Cardinality Estimation: Combining Density Statistics | Paul White SQL Server CE: Multiple single-column statistics connected by AND SQL Server CE: Multiple single-column statistics connected by OR Detect Low PAGE C…
 
גיא ואיתן דנים במספר נושאים מעניינים שמטרתם, בסופו של דבר, לדאוג לשלומן של הטבלאות בבסיסי הנתונים שתחת אחריותנו. קישורים רלוונטיים: The Complete Guide to Temporary Tables and Table Variables - Part 1 | Guy Glantser The Complete Guide to Temporary Tables and Table Variables - Part 2 | Guy Glantser The Curious Case of… tracking page compression succe…
 
SQL Server 2012 is end of life later this year. I feel too young for this to be happening—it seems like only last year SQL Server 2005 came out. In this episode of the podcast, we talk about upgrading your SQL Server. We share some concepts, gotchas, war stories, situations we want to avoid, how to access license keys in Azure, and a few other migr…
 
Do you find you need to keep SQL Server tables in sync across multiple systems? After several projects involving syncing data, we return to the topic of Azure SQL Data Sync with some real world examples of why we choose this option and how it worked for us. While there are some limitations, the feature is very stable, and we have had minimal, minor…
 
Guy and Eitan discuss some interesting announcements and focus on the topic of Security in SQL Server. Relevant links: Announcing new features for the SQL IaaS Agent Extension! - Microsoft Tech Community Troubleshooting SQL Server made easy via Notebooks – seeking your feedback - Microsoft Tech Community Veeam security breach: Backup “Removal” Solu…
 
Azure Synapse Link is a feature coming to SQL Server in the next release. While there are few details on what the new feature will look like, we discuss how this same service is implemented in other Azure services. The show notes and video for this episode can found at https://sqldatapartners.com/2022/01/05/episode-240-azure-synapse-link. Have fun …
 
גיא ואיתן מדברים על הטייס האוטומטי ב-SQL, על נושא ה-DEVOPS בבסיסי נתונים, ועוד. קישורים רלוונטיים: Easily Collect Database Information | Guy Glantser Performance Tuning Like a Pro - with Hypothetical Indexes | Eitan Blumin Data Platform Meetup Special Edition Azure Data Engineer Certification Prep Playlist on YouTube Simplify Azure SQL Virtual Mach…
 
SQL Server 2022 has been announced and we are excited to start unpacking the new features. For this episode, we start with a very interesting feature--Bi-directional HA/DR to Azure SQL. We have the ability to failover to the cloud now—the trick is, getting back is not as simple. Now, the on-premises version will be compatible with Azure SQL Managed…
 
Guy and Eitan talk about the interesting new features announced in SQL Server 2022, a new sp_whoisactive version, and a bunch of Microsoft blog posts on Tech Community. Relevant links: SQL Server 2022: Announcing SQL Server 2022 preview: Azure-enabled with continued performance and security innovation Introducing SQL Server 2022 | Bob Ward Announci…
 
Part 2 Power BI has been described as a “self-service” BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, there are a few things most organizations will want to address before turning users loose with Power BI. In this conversation, Brandon Michals helps us take a look at three areas of consideration: your company, you…
 
Loading …

빠른 참조 가이드