show episodes
 
S
SQL Server Radio

1
SQL Server Radio

Guy Glantser, Eitan Blumin

Unsubscribe
Unsubscribe
Monthly
 
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.
 
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 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 ...
 
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
 
Part 1 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…
 
Guy and Eitan talk about some important news, about Availability Sets in Azure, and several useful T-SQL scripts in our Toolbox. Relevant links: Azure Feedback is back! Troubleshooting SQL Server made easy via Notebooks – seeking your feedback Open sourcing the .NET 5 C# Language Extension for SQL Server Replication enhancements in the SQL Server 2…
 
Building your own scripts to monitor SQL Server seems like a very reasonable thing to do. We’re smart folks and SQL Server is what we do for a living—we should be able to figure this out. Upon further inspection, we found it was easier for us to focus on what we do—database administration, and let the developers focus on what they do—build software…
 
Live Podcast! We decided it was time to try and get together in person and reconnect. As we did, we pulled out the microphone and started recording. As a result, we break the single topic mode this week and opened it up for a Q&A session. We touch on database monitoring, memory grants, what we miss about being in an office, and even SharePoint (Gas…
 
Guy and Eitan talk about various topics related to SQL Server, including upcoming virtual events, interesting new scripts from our toolbox, and more! Relevant links: SQL Server 2016 SP3: Last Service Pack for SQL Server SQL Server Release Dates and Product Lifecycle PASS Data Community Summit - November 8-12, 2021 Development Lifecycle Basics for D…
 
As a data pro, you are negotiating and problem-solving all the time, often without knowing it. Your success as a professional as your company evolves its Data Platform depends on how well you can communicate and influence. It’s a scary thought, but your ability to negotiate with the business directly often determines if your projects get funded. Th…
 
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…
 
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…
 
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…
 
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…
 
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…
 
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…
 
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…
 
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 …
 
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 …
 
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…
 
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…
 
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…
 
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…
 
There is a growing list of formats to store data and Graph is one of the newer trends. It is becoming so popular SQL Server has created ways to implement graph structures. Mala Mahadevan joins us in this episode, and we revisit some of the origins of Graph, what it is good at, and why you may not want to rush to move all your data to Graph storage.…
 
SQL Trail 2020 was a success! There was a time I was unconvinced this would be the case. This is not to say we didn't have issues; however, talking with others helped us avoid some common pitfalls and make our event unique. Although we were virtual, I sent all the attendees a conference t-shirt, some swag, and cookies! I wanted everyone to feel som…
 
Guy and Eitan discuss PASS Virtual Summit 2020, what we should expect, whether it's worth the price tag or not, and discuss the future of the PASS organization. Relevant links: https://www.pass.org/summit/2020/ Imagine All the People | Guy Glantser SELECT TOP (3) Pre-Conference Sessions | Guy Glantser Why I’m Not Speaking at PASS Summit and You Sho…
 
There are many programming languages available to the modern developer and there are even more options for connecting to the database. In this episode, we talk with Taurius Litvinavicius about his Manning course on connecting .NET Core to SQL Server. The show notes for today's episode can be found at https://sqldatapartners.com/2020/09/16/episode-2…
 
Loading …

Quick Reference Guide

Copyright 2021 | Sitemap | Privacy Policy | Terms of Service
Google login Twitter login Classic login