SQL Server Radio

Download Episode (mp3) 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 cars

Download Episode (mp3) 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 in two weeks with a regular show. Enjoy!

Download Episode (mp3) It's about time we have a guest in the show! We are excited to welcome Alex Yates (@_AlexYates_). In this show we talk about continuous integration, delivery and deployment for databases, why is it so hard, and what is the secret sauce. Here are some of links we covered in the conversation: Working with Devs… Database DevOps Anti Patterns Alex Yates - Database Development Alex Yates - Critiquing two different approaches to delivering databases: Migrations vs state

Download Episode (mp3) 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..

Download Episode (mp3) Robert Davis, aka @SQLSoldier, has recently passed away unexpectedly. This was a shock to the entire SQL family, and of course to his wife, Chrissy. Robert was one of the most known and loved professionals in the SQL community. He will be certainly missed. We dedicate this show in honor of Robert. We talk about some of his best blog posts over the years, his contributions, and also about his jokes. Here are some relevant links: SQLSoldier - News From the Front Lines Remembering Robert Davis, aka @SQLSoldier Memorial and Grief fund For Chrissy

Download Episode (mp3) Today in the Show: Inside the Mind of a Master Procrastinator 24 Hours of PASS The Next GroupBy Conference SQLGrillen 2018 A Flexible New Way to Purchase Azure SQL Database SQL is 44 Years Old and We Still Use It Today SQL Server Advanced Threat Protection Survey SQL Challenges

Download Episode (mp3) Today in the show, we solve (well, almost) a SQL Server crossword by Kenneth Fisher...

Download Episode (mp3) 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?

Download Episode (mp3) 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

Download Episode (mp3) 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...

Download Episode (mp3) SSMS Unuseful Tips Why Database Continuous Integration is Challenging? Monitoring Page Splits

Download Episode (mp3) Today in the show: Guy is back from Nepal The GTD method for productivity The future of DBA work (Data Engineering and Database Reliability Engineering) Threadpool waits Getting used to learning new things Good old Implicit_Conversion And more..

Download Episode (mp3) In this show, we talk about: Glenn Berry's Diagnostic Information Queries The options for restricting access using Azure SQL Database firewall Something Cool We Learnt Today The role of the UPDATE lock in SQL Server Building your performance monitoring infrastructure And some big news...

Download episode (mp3) Today in the show, we talk about: * Types of business analytics * Is cardinality estimation the most common cause for performance problems? * How to answer the question "what do you do"? * Old news about AWS max database size in RDS * New project architecture challenges * Reporting and comic books * Scary bug with mirroring and database snapshot

Download Episode (mp3) In this show, we talk about everything that's new in SQL Server 2017