))
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 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…
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 …
In 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 DataBy SQL Server Radio
S
SQL Server Radio
1
Episode 137 - It's That Time of the Month
40:58
40:58
Play later
Play later
Lists
Like
Liked
40:58
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…
S
SQL Server Radio
1
Episode 136 - On the First Day of Christmas I got a TSQL Script
41:16
41:16
Play later
Play later
Lists
Like
Liked
41:16
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…
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…
S
SQL Server Radio
1
Episode 134 - Availability Sets in Azure and SQL Server
46:20
46:20
Play later
Play later
Lists
Like
Liked
46:20
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…
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…
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…
S
SQL Server Radio
1
Episode 131 - The First Madeira Toolbox Round-Up
41:04
41:04
Play later
Play later
Lists
Like
Liked
41:04
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…
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…
S
SQL Server Radio
1
Episode 129 - 10 Comments Every DBA Wants to Say
38:42
38:42
Play later
Play later
Lists
Like
Liked
38:42
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…
S
SQL Server Radio
1
Episode 128 - Azure and SQL with Anna and Bob
39:18
39:18
Play later
Play later
Lists
Like
Liked
39:18
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…
S
SQL Server Radio
1
Episode 127 - The Red-Gate-took-over-and-now-we-get-free-stuff Summit
38:18
38:18
Play later
Play later
Lists
Like
Liked
38:18
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…
S
SQL Server Radio
1
Episode 126 - Leading a Zeitgeist in the SQL Server Community
36:31
36:31
Play later
Play later
Lists
Like
Liked
36:31
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…
S
SQL Server Radio
1
Episode 125 - Monitoring SQL Servers for a managed DBA service
39:17
39:17
Play later
Play later
Lists
Like
Liked
39:17
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 …
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..
