SQL Server Radio
153 episodes - English - Latest episode: 17 days ago - ★★★★★ - 18 ratingsSQL 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.
Homepage Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
Episodes
Episode 162 - Backups and Recovery, RTO, RPO, and RCO
April 08, 2024 12:00 - 35 minutes - 82.2 MBGuy 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) SQL Server Regular Expressions Library Sample - Microsoft Community Hub STRING_SPLIT (Transact-SQL) - SQL Server | Microsoft Learn ...
Episode 161 - EXCLUSIVE: Announcing the Biggest Innovation for Azure SQL Managed Instances (Codename: Hermes)
March 21, 2024 12:00 - 41 minutes - 50.1 MBNiko 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 service tier - Azure SQL Managed Instance | Microsoft Learn Try for free (preview) - Azure SQL Managed Instance | Microsoft Learn Next-g...
Episode 160 - OPTION RECOMPILE and the magical Turbo button
February 12, 2024 12:00 - 32 minutes - 37.7 MBGuy 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 SERVER - Parameter Sniffing and OPTION (RECOMPILE) - SQL Authority with Pinal Dave
Episode 159 - Select * Wastes Money
January 08, 2024 12:00 - 37 minutes - 43.4 MBGuy 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 even when perfectly safe? | Eitan Blumin The Anatomy of Vardecimals | Mark S. Rasmussen Utility Scripts/ReNumber_Identity_Column.sql Intro...
Episode 158 - Reverse Engineering Table Relations based on SQL Plans
December 11, 2023 12:00 - 41 minutes - 47.7 MBGuy 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)
No episode this month
November 15, 2023 10:04SQL Server Radio is going on a short break this month. Please tune in next month for when we'll be coming back! In the meantime, check out some of our favorite past episodes: Episode 108 - "I Really Want to Do It" Flags Episode 115 - How can UPDATE STATISTICS cause HADR disconnections? Episode 122 - What you didn't know that you wanted to know about XML Episode 125 - Monitoring SQL Servers for a managed DBA service Episode 144 - Getting Locked Outside Without Your Keys
Episode 157 - Let's Talk Some Hardcore SQL Server
October 09, 2023 12:00 - 39 minutes - 44.6 MBGuy and Eitan go back to their SQL Server roots and go hardcore into execution plan analysis and database corruption. Relevant links: Health Check Scripts/Find_Top_Exec_Plans_to_Optimize.sql SQLServerFast.com Database Corruption Challenge by Steve Steadman A DBA's Guide to the Proper Handling of Corruption Data TLV Summit PASS Data Community Summit
Episode 156 - Back to School with Encryption as a Tool
September 11, 2023 09:00 - 39 minutes - 45.6 MBGuy and Eitan celebrate resuming the school year with some learning of their own. This time, focusing on encryption types in SQL Server. Relevant links: External REST Endpoint Invocation is now GA! Types of Encryption in SQL Server PWDENCRYPT and PWDCOMPARE Dynamic Data Masking And also, don’t forget to register for the upcoming Data TLV Summit!
Episode 155 - Kevin Chant
August 14, 2023 12:00 - 33 minutes - 38.2 MBToday we have Kevin Chant as our guest! We talk about Kevin’s favorite topics: Microsoft Fabric, Azure DevOps, SQL Server, and more. Relevant links: https://www.kevinrchant.com/2023/06/13/create-your-own-microsoft-fabric-environment/
Episode 154 - Beavers and very loud farts
July 10, 2023 12:00 - 37 minutes - 42.7 MBGuy and Eitan discuss several interesting topics and recent experiences that you'd want to hear about! Relevant links: Trigram Wildcard String Search in SQL Server The Story of DBeaver, PostgreSQL, and the silly data engineer SQL Server Error Log Management High VLF Counts Got You Down? Here's How to Keep Them Low and Performance High
Episode 153 - Erik Darling Is Our Guest For Today
June 12, 2023 12:00 - 39 minutes - 44.8 MBAs promised in the previous episode, Guy and Eitan interview an actual human this time! The one and only, the famed Erik Darling is our guest for today! Check out his official website: Erik Darling Data Erik Darling's YouTube Channel We apologize in advance for Guy's occasional audio glitches, as he was having network issues on the day of recording.
Episode 152 - We interview ChatGPT
May 08, 2023 12:00 - 37 minutes - 42.5 MBGuy and Eitan try something new for today's show - we interview ChatGPT as our guest for today, and make it pretend that it's a SQL Server expert! Let's see how it does. Relevant links: Monitor performance by using the Query Store Brent Ozar Unlimited SQLSkills Scary DBA SQL Authority PASS Data Community Summit SQLBits GroupBy Virtual Conference Data Platform Summit
Episode 151 - Tales from the SQL Bits of 2023
April 10, 2023 12:00 - 31 minutes - 73.1 MBGuy and Eitan share their experience from SQLBits 2023 and some of their favorite sessions. Relevant links: Official SQLBits Website SQLBits Content Library SQLBits YouTube Channel SQL Server Debugging with WinDbg – an Introduction Join #TeamHugo and Help Fight Leukemia Parameter Sensitive Plan optimization Azure Functions overview GitHub CoPilot
Episode 150 - Artificially Intelligent Query Processing
March 13, 2023 12:00 - 33 minutes - 77.2 MBGuy and Eitan discuss some new and existing capabilities in the SQL Server engine related to Intelligent Query Processing, and whether our job positions as DBAs are at risk due to the imminent takeover by our robot overlords. Relevant links: Intelligent Query Processing Adaptive Joins (Batch) Intelligent Query Processing Feedback family of features Parameter Sensitive Plan Optimization Scalar UDF Inlining
Episode 149 - 8 Common DBA Mistakes in SQL Server
February 13, 2023 12:00 - 35 minutes - 41 MBGuy and Eitan list several common mistakes done by DBAs in SQL Server. Some relevant links: Architecting Database Dev and Test Environments: Best Practices and Anti-Patterns for SQL Server Ola Hallengren's Maintenance Solution HADR My Jobs - Open Source Solution by Madeira Columnstore Indexes: Planning and Implementation TSQL Script to Check for Weak Passwords Script to Check for Max DOP Configuration Best Practice
Episode 148 - Rob Sewell and SQLBits 2023
January 09, 2023 12:00 - 40 minutes - 93.6 MBToday 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 - blog.robsewell.com
Episode 147 - Congratulations! It's an RTM!
December 12, 2022 12:00 - 34 minutes - 39.7 MBGuy 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 Server 2022 on-prem PASS Data Community Summit Hug a DBA song by Killa DBA SQL Server 2022 song by Killa DBA The SQL Server Native Client...
Episode 146 - New DMVs and Application Reliability
November 14, 2022 12:00 - 33 minutes - 38.4 MBGuy 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, and scale capacities – by Romain Ferraton SQL Server Standard vs Enteprise Edition features history – by Romain Ferraton SQL Server Sca...
Episode 145 - Itzik Ben-Gan Strikes Back
October 10, 2022 12:00 - 44 minutes - 50.7 MBToday 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 Central - Question of the Day Even more fun with DATETIME arithmetics (Eitan Blumin) The Itzik Ben-Gan Trick (batch processing hack)
Episode 144 - Getting Locked Outside Without Your Keys
September 12, 2022 12:00 - 33 minutes - 14.8 MBGuy 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 authentication for SQL Server Bidirectional Transactional Replication in SQL Managed Instance Considerations on Bidirectional Transactional Repli...
Episode 143 - A mash-up of mistakes all in one place
August 29, 2022 12:00 - 35 minutes - 15.5 MBToday, 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 Multiple Plans for One Query Are Bad | Brent Ozar Relevant scripts from our Madeira Toolbox: Find Unused Indexes Find Redundant Indexes Jo...
Episode 142 - What is Your Favorite Feature in SQL Server 2022?
July 11, 2022 12:00 - 36 minutes - 16.6 MBGuy 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 availability group? | Microsoft Docs Erik Darling Blog series about Parameter Sensitive Plans XML Data Compression in SQL Server 2022 ...
Episode 141 - Howda Hadr Hader Hadader
June 13, 2022 12:00 - 37 minutes - 16.9 MBGuy 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 Contention The Best Solution for SQL Server Partitioning Sliding Window Roll_Forward_Transaction_Log_Backups.sql Restore-DbaDatabase (DbaToo...
Episode 140 - Migration Challenges
May 09, 2022 12:00 - 38 minutes - 17.7 MBGuy 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 Generally available: Azure Virtual Machines increase storage throughput by up to 300% Generally available: Announcing Azure SQL Migratio...
Episode 139 - What's New in 2022
April 11, 2022 12:00 - 37 minutes - 17 MBGuy 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 SQL Migration extension Madeira Toolbox Roundup: Linked Server Vulnerability.sql Maintenance of Azure SQL Databases via Azur...
Episode 138 - EverSQL
March 14, 2022 12:00 - 37 minutes - 17.8 MBIn today's show, Guy and Eitan host the co-founders of EverSQL, Oded Valin and Tomer Shay. We talk about their automated SQL tuning solution and SQL tuning best practices in general. eversql.com - Official Website Software Vendor Mistakes - Erik Darling Data
Episode 137 - It's That Time of the Month
February 14, 2022 12:00 - 40 minutes - 19 MBIt'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 Compression Success Rates in all Databases | Eitan Blumin The Curious Case of… tracking page compression success rates | Paul Randal Th...
Episode 136 - On the First Day of Christmas I got a TSQL Script
January 10, 2022 09:00 - 41 minutes - 19.3 MBGuy 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” Solutions - From Conti Ransomware With Love sp_helprotect is very useful in permission issue - Microsoft Tech Community Databases and Guest...
Episode 135 - Announcing SQL Server 2022
December 13, 2021 09:00 - 35 minutes - 16.5 MBGuy 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 Announcing the SQL Server 2022 Early Adoption Program SQL Server 2022 | Official Microsoft The new version of sp_whoisactive - v12.00 Exten...
Episode 134 - Availability Sets in Azure and SQL Server
November 08, 2021 09:00 - 46 minutes - 21.6 MBGuy 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 2019 CU13 release This episode was recorded on October 25th, before the important announcement about the release of SQL Server 2022. Che...
Episode 133 - Good news, everyone!
October 11, 2021 09:00 - 36 minutes - 17 MBGuy 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 DBAs Group By Conference 2021 SSDT Methodologies & Features for DB DevOps Level up your skills with Bicep! TRY/CATCH and Transacti...
Episode 132 - Blythe Morrow
September 13, 2021 09:00 - 41 minutes - 19.5 MBAre 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 Community Summit Blythe Morrow in: Meet the Pre-Con Speakers Paper Sword B2B Paper Sword B2B is also the agency behind the Group By Confe...
Episode 131 - The First Madeira Toolbox Round-Up
August 09, 2021 09:00 - 41 minutes - 18.9 MBGuy 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) (New feedback item at Microsoft Q&A) Madeira Toolbox Round-Up: Missing Indexes with High Impact Increase Database File in Specifi...
Episode 130 - We just talk about stuff
July 12, 2021 09:00 - 43 minutes - 20.1 MBGuy 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 Episode 227: SSDT Methodologies for DB DevOps Data Platform Meetup Israel: Call for Speakers Wait Statistics - Torsten Strauss ...
Episode 129 - 10 Comments Every DBA Wants to Say
June 07, 2021 09:00 - 38 minutes - 17.7 MBToday 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 Automate Your Life T-SQL Tuesday #130 – Eitan’s Laws of Automation T-SQL Tuesday #135: The Tools of My Trade Test-DbaBackup Powershel...
Episode 128 - Azure and SQL with Anna and Bob
May 10, 2021 09:00 - 39 minutes - 18.8 MBWe 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 Saturday official site
Episode 127 - The Red-Gate-took-over-and-now-we-get-free-stuff Summit
April 12, 2021 09:00 - 38 minutes - 17.5 MBGuy 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 Pro Educational Series at Red Gate University Data Saturday #1 Recordings Available on YouTube Around the Clock with Azure SQL and Azu...
Episode 126 - Leading a Zeitgeist in the SQL Server Community
March 08, 2021 09:00 - 36 minutes - 17.3 MBCheck 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 Platform Meetup Israel Redgate Software takes over from PASS and commits to the future of the Summit, SQLSaturday and the community Educatio...
Episode 125 - Monitoring SQL Servers for a managed DBA service
February 08, 2021 09:00 - 39 minutes - 36.2 MBWe 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 requests from within SQL Server Case study - UPDATE STATISTICS causing TempDB stress and Availability Group fail-overs Madeira Data Sol...
Episode 124 - The Vanguards of Data
January 11, 2021 09:00 - 43 minutes - 33.1 MBGuy 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 support by SQL Server mysqlbinlog — Utility for Processing MySQL Binary Log Files FAQ about the dissolution of PASS | Andy Mallon PASS al...
Episode 123 - Beware of the Parallel Plan
December 14, 2020 09:00 - 41 minutes - 18.9 MBGuy 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 Making a more reliable and flexible sp_MSforeachdb | Aaron Bertrand PrintMAX by Ben Dill PrintMaxMinified by Eit...
Episode 122 - What you didn't know that you wanted to know about XML
November 08, 2020 21:00 - 49 minutes - 22.2 MBOur 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 | LinkedIn Azure Feedback item to update XML API engine in SQL Server Azure Feedback item to improve JSON capabilities in SQL Server
Episode 121 - to PASS or not to PASS
October 05, 2020 09:00 - 38 minutes - 17.4 MBGuy 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 Shouldn’t Either | Joey D'Antoni https://sqlsaturday.com/ https://pass.org/ https://meetup.com/ https://sessionize.com/ https://s...
Episode 120 - Operator Level Statistics
September 07, 2020 09:00 - 37 minutes - 17.4 MBGuy 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 repository in GitHub) GroupBy.org Starting SQL: Measuring A Query (Eric Darling) SSRS with Basic Authentication (open-source sampl...
Episode 119 - Overriding Reporting Services Authentication
August 10, 2020 09:00 - 36 minutes - 21.3 MBGuy 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 Kendra Little How to start with Azure Data Explorer - A new online course Overriding SSRS Authentication | Eitan Blumin ReportVie...
Episode 118 - Going reverse in a one way street
July 13, 2020 09:00 - 50 minutes - 20.1 MBGuy 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 bacpac File | Ronen Ariely (Data Platform Meetup Israel) Editing a .bacpac file | Microsoft Tech Community Blog post about Azure SQL Analyti...
Episode 117 - May the Free Events be ever in your favor
June 08, 2020 09:00 - 40 minutes - 30.6 MBToday 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 Best Practices by Guy Glantser (GroupBy.org) Data Weekender Europe Development Lifecycle Basics for DBAs by Eitan Blumin SSDT Template w...
Episode 116 - FREEApril and a promising May
May 11, 2020 05:00 - 31 minutes - 34.3 MBToday'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 Webinars T-SQL Tuesday LIVE Data Platform Meetup Israel PASS Global Hebrew Virtual Chapter Free stuff from Madeira Data So...
Episode 115 - How can UPDATE STATISTICS cause HADR disconnections?
April 13, 2020 09:00 - 39 minutes - 40.9 MBEitan 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 Size Maintenance Solution MCSA, MCSD, MCSE certifications retire; with continued investment to role-based certifications Azure SQL Manag...
Episode 114 - Lots of catching up to do
March 09, 2020 09:00 - 38 minutes - 39.9 MBGuy 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