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.
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…
S
SQL Server Radio


1
Episode 123 - Beware of the Parallel Plan
41:14
41:14
Play later
Play later
Lists
Like
Liked
41:14
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…
S
SQL Server Radio


1
Episode 122 - What you didn't know that you wanted to know about XML
49:28
49:28
Play later
Play later
Lists
Like
Liked
49:28
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…
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…
Guy and Eitan talk about recent and upcoming virtual events, and discuss the newly available runtime statistics at the operator-level in actual execution plans. Relevant links: Data Platform Virtual Summit 2020 Development Lifecycle Basics for DBAs - PASS Application Development Virtual Group Data Weekender #TheSQL Oct 17th SQL Workshops (Microsoft…
S
SQL Server Radio


1
Episode 119 - Overriding Reporting Services Authentication
36:52
36:52
Play later
Play later
Lists
Like
Liked
36:52
Guy and Eitan talk about Virtual Summits and free online courses, how to override SSRS authentication, and learn how to pronounce Eitan's name. Also, we're terribly sorry in advance for the windy interferences! Links: PASS Virtual Summit Modernizing Your Data Platform by Guy Glantser Azure SQL Bootcamp with Bob Ward & Anna Hoffman Free Courses by K…
S
SQL Server Radio


1
Episode 118 - Going reverse in a one way street
50:25
50:25
Play later
Play later
Lists
Like
Liked
50:25
Guy and Eitan talk about several workarounds that boil down to using a solution for something other than its intended purpose. Relevant links: Moving A Database to New Storage With No Downtime | Bob Pusateri Planning a Migration from Azure SQL DB to Azure Managed Instance | Eitan Blumin The Internals of the External SqlPackage Tool - Inside a bacpa…
S
SQL Server Radio


1
Episode 117 - May the Free Events be ever in your favor
40:54
40:54
Play later
Play later
Lists
Like
Liked
40:54
Today we talk about all the exciting free events that we were involved with during May, with even more to come, and also some other interesting news! Check them out: The Performance Tuning Magic Show by Guy Glantser (PASS Application Development) Accelerated Database Recovery by Guy Glantser (PASS Global Hebrew Virtual Chapter) SQL Server Setup Bes…
S
SQL Server Radio


1
Episode 116 - FREEApril and a promising May
31:24
31:24
Play later
Play later
Lists
Like
Liked
31:24
Today's show notes are quite a handful! Red Gate report about the State of Database DevOps Eitan's session about Development Lifecycle Basics for DBAs Free online conferences and events: Data Community Weekender Europe Data Platform Discovery Day GroupBy DataPlatformGeeks Virtual Symposium PASS Recordings Listing Red-Gate Streamed SentryOne Webinar…
S
SQL Server Radio


1
Episode 115 - How can UPDATE STATISTICS cause HADR disconnections?
39:49
39:49
Play later
Play later
Lists
Like
Liked
39:49
Eitan does his worst Donald Trump impression, and talks SQL Server stuff with Guy Glantser: Ola Hallengren's maintenance solution SQL Server Index Maintenance – You’re Doing It Wrong | Sean Gallardy Because Your Index Maintenance Script Is Measuring The Wrong Thing | Erik Darling How can UPDATE STATISTICS cause HADR disconnections? Eitan's File Siz…
Guy Glantser is co-hosting with Eitan Blumin for the first time, and we have a lot of topics to cover and catching up to do. PASS and SQLBits Conferences Storage Best Practices for SQL on IaaS in Azure SQL VM RP (Resource Provider) Guy's hopes for SQL Server setup options SQL Server 2019 features And more…
After a very long break, today we come to you with a very special show, with a very special announcement to make. You do not want to miss this one!By SQL Server Radio
Guy is back from New Zealand. We talk a little bit about his trip, about things that people shouldn't be doing with SQL Server, and more.
S
SQL Server Radio


1
What You Should Do Before You Actually Start Working
39:48
39:48
Play later
Play later
Lists
Like
Liked
39:48
Guy is in New Zealand, so Eitan Blumin comes to fill in. We talk about: CI/CD with SSDT What is a Canary Query The best performance tuning feature, ROI wise Hierarchical partitioning Azure storage for SQL Server
In this show: MySQL, Vertica, Azure Data Explorer and Matan 24 Hours of PASS: Summit Preview 2019 PASS Summit 2019: Session Schedule The Data Bias in Song Contests How SQL Server Compares Strings with Trailing Spaces Using Azure Data Explorer and Fastly to Improve Taboola Customer Experiences Kusto in Taboola – Azure Data Explorer…
S
SQL Server Radio


1
Big Mistakes with Brent Ozar (Rebroadcast)
34:54
34:54
Play later
Play later
Lists
Like
Liked
34:54
We had a technical issue with this month’s recording, so instead we’re going back to one of our favorite shows – Big Mistakes with Brent Ozar. Enjoy, and we’ll be back with new stuff in a few weeks. Among other mistakes, we talk about: How did a company end up with a table named “C” Brent’s first database disaster ever Why Guy spent two weeks in Mi…
In this show: Multi-Tenant Architecture Optimizations Parallel Update Statistics What's the Difference between CONTEXT_INFO and SESSION_CONTEXT? New Innovations for Analytics in Azure Gartner Hype Cycle SQL Notebooks in Azure Data Studio SQL Server 2017 Resumable Online Index Rebuilds
Matan is really passionate about Azure Data Explorer. He presented a session about it in the last Data Platform Meetup in Israel. In this show, Matan introduces this powerful analytics platform. Check it out: Azure Data Explorer
In this show: What a Great Event SQL Saturday Israel 2019 Was What is the Fastest-Growing Major Programming Language in the World? Exploring Azure Storage for SQL Server DBAs How Microsoft Access is Ranked among Database Management Systems? Understanding Log Buffer Flushes
SQL Pub Quiz The Keynote How to Make Sure Your SSIS Packages Will Never Fail by Guy Glantser Benchmarking in the Cloud by Gianluca Sartori Common Troubleshooting Techniques for AGs and FCIs by Allan Hirt Failover Detection Utility – Availability Group Failover Analysis Made Easy What's New - Query Performance Insights by Pedro Lopes Top 5 Tips to K…
S
SQL Server Radio


1
We don't Need MongoDB to Have Fun Tonight
34:43
34:43
Play later
Play later
Lists
Like
Liked
34:43
In this show, we talk about: SQLBits 2019 Guy is Bragging about Tel Aviv Marathon Microsoft Helps You Transform Your 2008 Server Applications with Azure MongoDB Database Skills - Sia Cheap Thrills Parody Matan is Bragging about Azure Data Explorer SQL Saturday Israel 2019 Beware of MIN/MAX Aggregates Against Partitioned Tables…
S
SQL Server Radio


1
What Happened in Samoa on December 30, 2011?
38:02
38:02
Play later
Play later
Lists
Like
Liked
38:02
In this show, we talk about: What Happened in Samoa on December 30, 2011? Business Data Monitoring with Zabbix – Easily Done Matan Introduces Design Discussion #1 Availability Group Parallel Redo Matan Introduces Design Discussion #2 Power BI Desktop Q&A Data Interaction Examples
In this show, we are happy to welcome a special guest - Dekel Asaf, R&D manager at OM2. We talked about many things, among them: Always On - or "Mostly On" Why DBAs don't Use SSDT? Database Unit Testing Sliding Window
S
SQL Server Radio


1
Do you Miss Asynchronous Triggers Tonight?
37:31
37:31
Play later
Play later
Lists
Like
Liked
37:31
In this show, we talk about: Advanced Service Broker Sample: Asynchronous Triggers Azure SQL Database Availability Zones Microsoft Learn Magic Johnson Do You Trust Your Availability Group?
Can you believe it? It's the 100th show!!! We have been doing it for 5 years, and we are having so much fun! We have been planning this show for a very long time, and we have some very special guests with us...
In this show we answered a listener's question about the 32-bit vs. 64-bit nightmare that developers have to go through when trying to access Excel files from SSIS. And we also mentioned a script to roll forward transaction log backups. The next show is the 100 show!!! We are planning a big party! Stay tuned...…
In this show, we talk about: How to Fix Orphaned DB Users Easily SSMS Auto-Recovery Feature Multi-Tenant Database Challenges Your DR Plan isn’t a Plan And much more...
S
SQL Server Radio


1
Availability Groups, Corruption, Implicit Transactions and More…
29:14
29:14
Play later
Play later
Lists
Like
Liked
29:14
Show Notes: How to Set Up Availability Group with a Domain Account How to Start SQL Server Without Tempdb? Auto-Commit vs. Implicit Transactions What's between Corruption and Blocking? What Machine Learning Can Do?
Show 96 is here. Among other stuff, we talked about: SQLGrillen 2018 Simulating IGNORE NULLs Functionality on FIRST_VALUE and LAST_VALUE Functions Database Corruption Story Query Store, Automatic Query Tuning, and how they relate to automatic card
S
SQL Server Radio


1
SQL Server Programming Best Practices Panel
58:40
58:40
Play later
Play later
Lists
Like
Liked
58:40
it's been very busy lately, and Guy is currently abroad, so we're posting something a little different. For the 100th show of the Hebrew edition, we celebrated with 5 panels about different topics we held on SQLSaturday Israel. One of the panels was about programming best practices in SQL Server, and conveniently, it was in English. We'll be back i…
In this show, we talk about: Google Duplex Accessing External Resources from SQL Server SQL Saturday Israel 2018 24 Hours of PASS Optimizing Server-Side Paging How to Change the Fonts in SSMS And more..
Today in the show, we solve (well, almost) a SQL Server crossword by Kenneth Fisher...
Today in the show: The Best SQL Server Five-Words Tech Horror MongoDB Aggregation Feature in Azure Cosmos DB Data Discovery and Classification in SSMS Managing Multi-Tenant Applications Which One is Better? IN or BETWEEN?
Today in the show: How to Schedule a Failover Use Inline Functions Instead of Scalar Functions Guy’s Productivity Guide Maintenance Plans Security Hole! And More…
S
SQL Server Radio


1
SSMS, Continuous Integration and Page Splits
37:11
37:11
Play later
Play later
Lists
Like
Liked
37:11
Today in the show: SSMS Unuseful Tips Why Database Continuous Integration is Challenging? Monitoring Page Splits
Today in the show: How to Deploy Schema Changes with Zero Downtime We are All Experts in Identifying Cats How to Troubleshoot Application Timeouts Signs You are not a Senior DBA SQL Saturday Israel Precons Announced
In this show, we talk about everything that's new in SQL Server 2017
There are many ways to write efficient queries in SQL Server. In this show we talk about a few of those ways, when the key is - "keep it simple". In addition, we talk about use cases for Big Data, Ways for transferring data to a reporting server, an interesting BI project Guy is working on, and more
In this show, we talk about: How to tell if you have a CPU problem in a virtualized environment SQL Server setup tips Guy's experience from his data science course How we change over time More productivity tips
In this show, we share some client stories from recent projects: One nice thing of being a consultant Another consolidation project with a client implemented with views Performance recommendations from a client project Trivial optimization vs.Simple Parameterization Some challenges when working with MySQL…
S
SQL Server Radio


1
If Clippy Found His Way to SQL Server Radio
29:50
29:50
Play later
Play later
Lists
Like
Liked
29:50
In this show: * The challenges of consolidation projects * What is the Remote Query Harden error with Availability Groups * PASS Summit precons * Describe your profession in one sentence * What if Clippy came to SSMS? * The right ways to manage open transactions
In this show, we talk about: Our sessions at the GroupBy conference Another difference between the old and new Cardinality Estimators Lightweight Profiling in SQL Server 2016 SP1 Sign Matan's wife is married to a DBA SSDT 2017 A cool SSMS shortcut
Today in the show, we talk about: Another optimization for cases where you have to use cursors How to migrate a database to a lower version Paging in various SQL Server versions And more..