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.
 
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.
 
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!
 
SQL Unplugged is your opportunity to talk LIVE with Rohan Kumar, the individuals who own the relational database at Microsoft. This new monthly show is your avenue to ask questions and talk directly to Rohan about anything and everything related to SQL Server and Azure SQL Database, and get "unplugged" scoop and insights into the inner workings of the SQL Server engineering team. These shows will be broadcast live, so you will be able to chat real-time each month. You can also submit your qu ...
 
Loading …
show series
 
Never heard of ScriptDOM? Neither had we…okay, except Kevin, who obviously knows all. Apparently, the documentation is scarce. Mala Mahadevan uses it, loves it, and graciously offered to come back to the podcast to educate us and our listeners on a product that can help us parse, process and format our SQL queries. The show notes and video can be f…
 
Are you a data professional who needs to be able to convince people that you're right? Blythe Morrow is here to help! Blythe Morrow is our special guest for today, teaching us tech folks how to talk and convince people about topics in regards to Data Platform technologies. Blythe Morrow on LinkedIn Blythe Morrow is a Pre-Con speaker at PASS Data Co…
 
גיא לא היה זמין להקליט תוכנית. אז הפעם אביתר קרני יחליף אותו, ואיתן יעשה את עיקר הדיבורים! לינקים רלוונטיים להיום: GroupBy - Voting is Open until September 8 Microsoft at the Data Platform Virtual Summit 2021 Move SQL Server licenses without Software Assurance to Azure Dedicated Hosts General availability: Change performance tiers for Azure Premium…
 
Public speaking is not fun for most; however, it can be very rewarding. Chris Seferlis chats with us about a few tips he has on being a speaker. Most of the tactical advice we defer to a toastmasters or public speaking group, so we give some thoughts on preparation, soliciting feedback, audience engagement, and handling criticism. I should point ou…
 
Everyone has bad days; however, how those bad days develop are unique to each of us. In a special episode, we chat with Tracy Boggiano about her experiences with Mental Health, how she has dealt with it, how each of us can work on our own mental health, and phrases we should avoid saying to those with mental health issues. Our own Eugene Meidinger …
 
Guy and Eitan discuss change automation tricks for databases, do a round-up of the newest scripts in the Madeira Toolbox, and more. Relevant links: Database Change Automation: DbaTools sp_generate_merge by Daniel Nolan (readyroll) Add support for "Prevent saving changes that require table re-creation" option in SqlPackage / SSDT (Azure Feedback) (N…
 
No one wants to lose data when disaster strikes; however, we need to plan for some data loss and putting all the pieces in place can be tricky. There are two metrics commonly used to measure data loss and availability when it comes to planning for disasters—Recovery Point Objective and Recovery Time Objective. In this episode, we touch on how you m…
 
איך מודדים ביצועים של חומרה בעזרת SQL Server? ואיך משפרים את הביצועים של SQL בעזרת יומן פעולות אסינכרוני? גיא ואיתן מדברים על מגוון נושאים הנוגעים למדידה ושיפור ביצועים, ועוד. לינקים רלוונטים: Azure Data Community EightKB Conference Dativerse TPC Council HammerDB From A to E: Analyzing TPC’s OLTP Benchmarks The obsolete, the ubiquitous, the unexplo…
 
The scary part of upgrading SQL Server is finding out you have a problem AFTER the fact. In this episode, Mariano Kovo joins us to discuss the Data Migration Assistant tool from Microsoft. While the name can be a bit misleading, (What? Microsoft have confusing names—that's a first), the major benefit to the tool is the assessment feature to alert y…
 
As data practitioners, we want to get ahead of any problems that might come up and share those insights with others on our team. In this episode, Edward Pollack gives us a few scenarios we might consider as we attempt to prevent application issues. These techniques also go into the security space and could help prevent data loss. As we collect this…
 
Guy and Eitan shoot the breeze about several interesting topics that you wouldn't want to miss out on! Relevant links: SQL Server 2016 going out of mainstream support Intelligent Query Processing Capabilities in SQL Server Group by conference recordings on YouTube Dynamic search queries in T-SQL - THE NINJA WAY - by Eitan Blumin SQL Data Partners E…
 
גיא ואיתן מארחים את אחת האושיות הכי משמעותיות בארץ מטעם מיקרוסופט, הלא הוא איתי בנימין האחד והיחיד! נדבר על המון נושאים מגוונים ומעניינים, בעיקר בהקשר של מיקרוסופט, טכנולוגיות ענן, דאטה, בינה מלאכותית, ודרך אגב - מה הקשר בין איתי בנימין לבין משרד לעורכי דין??? קישורים רלוונטיים: הפרופיל של איתי בנימין בלינקד-אין Microsoft Build 2021 CosmosDB Server…
 
Organizations look to constantly improve and offer better services and the application tooling has been built to accommodate the process. Database tooling has been a bit slower to develop; however, in this episode Eitan Blumin, a co-host at sqlserverradio.com, brings us up to speed on the latest features of SQL Server Data Tools with some thoughts …
 
Let’s say you have completed a lift and shift VM hosting to the cloud. Great—you now use Iaas services. While you don’t have to worry about the hardware, managing the software can be problematic. The SQL Server IaaS Agent Extension can offer some PaaS-like services and make it easier to manage the database environment. In this episode we chat with …
 
Today we go over a list written by Kevin Chant about a year ago, and add some of our own insights. Relevant links: Ten comments I think every SQL Server DBA wants to say | Kevin Chant Eitan's T-SQL Tuesday blog posts about automation and productivity: T-SQL Tuesday #123 – Life hacks to make your day easier T-SQL Tuesday #127 – Tips and Tricks to Au…
 
גיא ואיתן מדברים על נושא טעון ומסובך - Multi-Tenant Design Patterns, ספציפית ב-Azure. מה עדיף? שרת אחד עבור כל הלקוחות? בסיס נתונים נפרד לכל לקוח? אולי שילוב של השניים? מתי כן ומתי לא? הצטרפו אלינו ותגלו! קישורים למידע נוסף: Multi-tenant SaaS database tenancy patterns Multi-tenant applications with elastic database tools and row-level security Row-…
 
Have you ever created a report in a visualization tool, spent all this time and energy creating something that looked really cool, went through more edits than you could remember only to deliver the report and have the recipient go “What am I looking at?” I don’t think I am the only one and, in this episode, we explore some of the rookie mistakes I…
 
We have two very special guests in today's show: the AzureSQL rockstars Anna Hoffman and Bob Ward! Some relevant links: Azure SQL Fundamentals | Microsoft Learn Azure SQL for beginners | YouTube Playlist Digital event: Transform Your Applications with Azure SQL http://aka.ms/newsupdate https://aka.ms/sqlworkshops DataMinutes | Data Grillen SQL Satu…
 
יש לנו היום תוכנית גדושה מלאה בחדשות ונושאים מעניינים! קישורים רלוונטיים: אתר חדש של SQLSaturday Everyone run a SQL Saturday in 2021 CallForDataSpeakers.com מפגשים וירטואליים קרובים ב-Data Platform Meetup שלנו: Transferring and Manipulating Data between Azure SQL Databases (05/05) Cognitive Services in a Box (Container) (12/05) If You Build It, The…
 
Carlos, Kevin, and Eugene reconnect after some time away with a new streaming time. Long form conversation on a single topic is also the place we want to get back to in our podcast. The show notes and video for today's episode can be found at https://sqldatapartners.com/2021/04/28/episode-224-the-standup-meeting/. Have fun on the SQL Trail!…
 
With both Kevin and Eugene busy this week, Carlos went solo to share a few changes to the podcast, including the Twitch livestream moving to Tuesday, how you can support the podcast, and podcast episodes going back to being published every other Wednesday. If you have a subject that you’d like to chat about on the podcast with us, we’d love to sche…
 
Guy and Eitan discuss lots of interesting recent news, and also about various technical topics in SQL Server. Relevant links: News about PASS and SQL Saturday: What’s next for PASS Summit this fall? Ideas forum The SQL Saturday Foundation Board of Directors The new Azure Data Community webpage from Microsoft PASS Summit 2020 session recordings PASS…
 
גיא ואיתן מדברים על אירועים מעניינים שהיו לאחרונה ואירועים עתידיים בזמן הקרוב, על איך לחסוך כסף בענן, ועוד נושאים מעניינים. קישורים רלוונטיים: Past and upcoming Data Platform Meetup sessions: Ask Us Anything: Database Performance Tuning and Optimization (February 21st) Ask Us Anything: Database Performance Tuning and Optimization (April 4th) Azure …
 
Azure Arc-enabled data services provide powerful capabilities to deploy and manage local, on-premises, and hybrid cloud data resources using the same centralized management and tooling you get from the Azure cloud. Since Eugene suggested our previous attempt at Azure Arc was insufficient, we invited Ben Weissman and Anthony Nocentino, authors of th…
 
Virtual conferences are just not the same as the conferences we are used to, but we’re still determined to provide a good learning and networking environment for our friends. We very much miss having conferences in person and look forward to that happening again. In the meantime, we have discovered Airmeet and we had a great event: our first of the…
 
As we prepare for SQL Trail on March 18th, we peek back at Microsoft Ignite and review the announcements made there—filtering out the pieces our compañeros will enjoy hearing about. Did we miss something you think we should talk about? Let us know! The show notes and video for today's episode can be found at https://sqldatapartners.com/2021/03/10/e…
 
Check out the episode where we start movements to change the way everyone writes T-SQL code, and/or deliver data platform meetups! And we also talk about a bunch of other stuff as well. Relevant Links: Join the SQL Server Community Slack and our new channel #SQLServerRadio ! Ask Us Anything: Database Performance Tuning and Optimization | Data Platf…
 
גיא ואיתן מדברים על כמה אירועים מעניינים בעבר ובעתיד, ודנים בכמה פנינות חוכמה בנושא SQL Server. קישורים רלוונטים: הצטרפו לסלאק של SQL Server Community ואל הערוץ החדש שלנו #SQLServerRadio ! Ask Us Anything: Database Performance Tuning and Optimization | Data Platform Meetup Israel Ask Us Anything 2: Database Performance Tuning and Optimization | Dat…
 
How do you document your SQL Server environments? I can remember walking through Brent Ozar’s takeover script back in the day and how cumbersome it was to put all that information together. We have a few more options available to us now. In this episode, we discuss a listener question along with some options for doing server inventories. SQL Trail …
 
In this episode of the SQL Data Partners Podcast, Eugene and I go back to our DBA beginnings and talk about database file growth, how to manage files and how to tell when a file has grown. The show notes for today's episode (including the video with the demonstration) can be found at https://sqldatapartners.com/2021/02/17/episode-218-file-growths. …
 
The story begins with a process that has been running forever and suddenly decides to cause grief by filling up tempdb. We talk about patching, and we talk about mental health. We talk a little about various topics. The show notes for today's episode can be found at https://sqldatapartners.com/2021/02/10/episode-217-a-little-something-about-a-few-t…
 
We have a special topic for today, where we talk about our own managed DBA service, and how we ended up choosing SentryOne SQL Sentry as our go-to monitoring platform for SQL Servers. Relevant links with more details: DBSmart - The Managed DBA Service from Madeira Data Solutions SentryOne SQL Sentry clr_http_request - CLR assembly to send HTTP web …
 
היום אנחנו מתמקדים בכל מה שקשור ל-Service Broker... פיצ'ר שצובר הרבה אבק בארגז הכלים של SQL Server. לינקים רלוונטיים: טריגרים אסינכרונים בעזרת סרוויס ברוקר מימוש מקביליות בעזרת סרוויס ברוקר האק שפותר בעיות ביצועים נפוצות בסרוויס ברוקר פתרונות לוגיקה אסינכרוניים באז'ור תחליף TSQL במקום סרוויס ברוקר저자 SQL Server Radio
 
When working on a customer on an import process, she made the comment—if we were doing true EDI, we’d [Do X]. The comment got me thinking—Aren’t we working on an EDI process? As someone who frequently has multiple roles on projects, I perhaps had lumped all the various 3 letter acronyms into the same spaghetti salad. In this episode of the podcast,…
 
We have been moving data for years with technologies like DTS and SSIS; however, these were very much designed for on-premises moves in mind. As more cloud services were being offered Microsoft needed a service to help customers using those services move data around. Azure Data Factory was born with the initial premise of moving data between cloud …
 
We open this year with a few updates on the podcast, a change to SQL Trail, and we invite you to give us some feedback on writing a book for 2021. The show notes for today's episode can be found at https://sqldatapartners.com/2021/01/13/episode-213-new-goals-for-2021/. Have fun on the SQL Trail!저자 Carlos L Chacon
 
Guy and Eitan host a very special guest and speak about various SQL Server and Data Platform topics, and recent events. Relevant links: for more details Cassandra - Use cases: when to use and when not to use Community call for creating the fastest number series generator | Itzik Ben Gan SQL Server Feature Request: Adding Multi-column IN clause supp…
 
גיא ואיתן מארחים אורח כבוד ומדברים על נושאים רבים מהשנה האחרונה. קישורים רלוונטיים: חברת טאבולה מגייסת Data Engineer חברת מדירה מגייסת Azure Data Architect פיצ'רים חדשים ב- SQL Server 2019 Data Platform Meetup Israel Upcoming Events Clusterless Availability Groups AlwaysOn Failover Cluster Instances How to Fix a Suspect or Recovery Pending Database…
 
20 years ago, the objection to implementing security on the basis of performance had validity—especially for smaller organizations. Security was a pain in the neck; however, how many of us are still hanging on to some of those old biases. Even worse, some of us IT pros seem to put up objections to doing the most basic security procedures—sending us…
 
Microsoft released a lengthy white paper on the SolarWinds hack affecting thousands of computers. This is scary stuff, and the details continue to come out slowly and you wonder how it all will play out. Many IT pros rely on SolarWinds for monitoring and in this episode, we discuss the exploit, how mere mortals like us might feel a bit overwhelmed …
 
It was sad news to hear PASS plans to dissolve in January of 2021. So much good has come of the community and it is sad to see it go. In this episode, we explore the why behind the collapse and what we think may emerge in the aftermath. The show notes for today's episode can be found at https://sqldatapartners.com/2020/12/18/episode-210-the-elephan…
 
Alex is a Data Platform MVP who loves DevOps. He's has been helping data professionals apply DevOps principles to relational database development and deployment since 2010. He's most proud of helping Skyscanner develop the ability to deploy 95 times a day. Alex has worked with clients on every continent except Antarctica - so he's keen to meet anyo…
 
Finding your first full time job is incredibly difficult—and that was before we were in a worldwide pandemic. In this episode, we discuss some strategies and share some experiences about how we got our first jobs and hopefully give you some inspiration as you try to find your first experience. The show notes for today's episode can be found at http…
 
Guy and Eitan take a break from talking about the PASS virtual summit, and celebrate with some interesting content. Relevant links: Notes on the PASS Virtual Summit by Andy Warren: Part 1 Part 2 Part 3 Part 4 Part 5 Part 6 Conclusions Satirical DBA Twitter accounts: @TrumpDBA @Bernie_DBA @biden_dba Concatenating Strings in SQL Server | Guy Glantser…
 
גיא ואיתן משחקים משחק נחמד בנושא SQL SERVER. הנה כמה קישורים רלוונטיים למידע נוסף: Enabling Lock Pages in Memory | Microsoft Docs Great SQL Server Debates: Lock Pages in Memory | Jonathan Kehayias SQL Server Max Memory Setting with Lock Pages in Memory | MSSQLTips Diagnose and resolve latch contention on SQL Server | Microsoft Docs LEAD and LAG Win…
 
Our guest for today is Yitzhak Khabinsky, a subject-matter expert on XML in SQL Server (among other impressive titles). We deep dive into the topic of XML, its history, its purpose and limitations within SQL Server, and fascinating capabilities that you never knew about... And also, how does JSON fit in this whole story? Yitzhak Khabinsky | LinkedI…
 
גיא ואיתן מדברים על MVP Days 2020 Israel ועוד אירועים מעניינים, וגם נוגעים קצת בנושא CI/CD עבור בסיסי נתונים של SQL Server. קישורים רלוונטיים: MVP Days Israel 2020 Azure SQL Analytics for SQL Server Monitoring | Eitan Blumin SQL Server to Azure SQL: Availability | Anna Hoffman SE7EN Deadly Sins of Database Design - Part 1 | Ami Levin SE7EN Deadly S…
 
Loading …

빠른 참조 가이드

Google login Twitter login Classic login