SQL Server Radio

Download Episode (mp3) Another episode is here, and this time we talk about: * Lady Gaga * SQL Server is the database management system of the year * Complicated issue with licensing * SSMS enhancements * What do you do when you can't connect to SQL Server? * How hackers connect to your database 

Download Episode (mp3) In this show, we talk about: * Some announcements about our upcoming SQL trips * Context_info enhancements in SQL Server 2016 * Problems when restoring a database with single user mode * Exctracting data from OLTP and inserting to a data warehouse * @SQLServerRadio on Twitter

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

Download Episode (mp3) In this show, we talk about: * Guy is coming to SQLSaturday Melbourne for a Precon about Hadoop Fundamentals * A problem with a common performance tuning trick * The GroupBy conference * The SQLGrillen conference * Advantages of SQL Server 2016 Enterprise Edition * The wisdom of the crowds We also have a new promo for the show! Let us know what you think about it in the comments!

Download Episode (mp3) This special show is all about Christmas. Surprisingly, It turns out that Christmas is related to SQL Server in many ways, and we list them in the show. Merry Christmas everybody!

Download Episode (mp3) In this show, we talk a lot about interesting projects we've been a part of lately, in addition to other interesting items: * Guy on installing a 3-node SQL Server 2016 Availability Groups cluster with no domain * Matan on migrating a system to In-Memory OLTP * Why Matan doesn't hate the MERGE statement anymore * SQL Server 2016 SP1 * Thoughts and clarifications about DBCC CheckDB

Download episode (mp3) In this show, we host our friend Shy Engelberg again and talk about: * New features in SQL Server Hydra * The future of Linked Servers * External Data Sources * Scripts from the SQL Server Tiger team * How the guys at Facebook verify their backups can be restored * Recommended approaches for HA and DR Also, during the show Guy takes some of his recommendations regarding temp tables and table variables back Items mentioned in the show: * dbatools * DBA Googling on Twitter

Download Episode (mp3) In this show, we host our good friend and great DBA, Shy Engelberg. Together with Shy, we talk about: * Guy's new online course - Advanced Query Tuning in SQL Server * How to write queries for dynamic search screens * Use cases for MongoDB and Machine Learning * What is the adaptive query plan feature * How Shazam works, and how it's related to the show * Thoughts on HA and DR * Thoughts on SQL Server licensing * Thoughts on bringing Azure features to the ground * And more.. What can you learn in Guy's course? * What is the Plan Cache and why is it needed * How to find your problematic queries * How to read and analyze execution plans * How to measure query performance * Query hints and plan guides * Parameter Sniffing issues * Query tuning case studies Inside the show, you'll also find a coupon code for the course. About Shy Shy Engelberg is the CTO of Valinor, and a Partner Technology Solutions Professional. He's also a data and cloud technologies enthusiastic. He believes that data drives the world, and cloud technologies fuel it. He constantly finds solutions to all sorts of problems and needs, and still learning something new every day.

Download Episode (mp3) In this show of SQL Server Radio: * Transactional Replication tips * How to self destruct a SQL Server Agent job * Storage at speed of memory on Windows Server 2016 and SQL Server 2016 * Database backup and in Amazon RDS * Writing and syncing files to AWS s3 * Mapping a partition to a filegroup in a partitioned table * A cool Twitter account for monitoring fixed SQL Server issues Items mentioned in the show: * Accelerating SQL Server 2016 performance with Persistent Memory in Windows Server 2016 * Guy Glantser - Query Timeout of the Distribution Agent * Brent Ozar - HOLY COW. Amazon RDS SQL Server Just Changed Everything * @closedasfixed on Twitter

Download Episode (mp3) PASS Summit is next week, and in this show, we cover the sessions, the parties, the networking opportunities and the other goodies of the summit.    

Download Episode (mp3) We start the show with a game of Yes/No questions. Afterwards, we talk about: * Must we wait to service pack 1 before installing a new SQL Server version? * Comparing wait stats between dates * Tests when upgrading to SQL Server 2016 * Paul Randal's waits and latches library * And more.. Items mentioned in the show: * Paul Randal's waits and latches library * Remus Rusanu - Why I have high hopes for the quality of SQL Server 2016 release * Guy Glantser - We Must Wait for SP1 before Upgrading to SQL Server 2016  

Download Episode (mp3) In a few days delay, show 56 is here, and this time we talk about: * Itzik Ben-Gan's ways for unpivoting data * Auditing every change in every table * The Dunning-Krugher Effect and how it's related to new technologies * Use Cases for XML and JSON * Some differences between SQL Server and MongoDB * Transactional consistency between different databases in an Availability Group * Agent Profiles in SQL Server replication * The best "feel good" song in history Items mentioned in the show: * Itzik Ben-Gan - Unpivoting Data * Noa Brodezky - How to Audit Changes for Every Table in SQL Server * Matan's 24 Hours of PASS session - MongoDB for the SQL Server Professional * Guy's 24 Hours of PASS session - From XML to JSON

Download Episode (mp3) Today in the show, we: * Check whether Set Nocount On is still needed * Extract data easily * Deep dive into Always Encrypter * Unmask Dynamic Data Masking * Check why we don't get emails about deadlocks * Check why a monitoring software couldn't monitor Items mentioned in the show: * Paul Randal's Waits and Latches Library * Aaron Bertrand - Performance Surprises and Assumptions : SET NOCOUNT ON * SQL Table Zip * Phil Factor - Unmasking the Dynamic Data Masking * Gianluca Sartori - Unmasking the Dynamic Data Masking (easier) As always, if you have any questions, comments or interesting stories, drop us a line and we'll talk about them.

Download Episode (mp3) Itzik Ben-Gan has many T-SQL tricks. In this show, we talk about a few of them: * How to get Batch Mode Processing with regular tables * How to share Identity between different tables * How to use Cross Apply for Unpivot In addition, we talk about what SOS_Scheduler_Yield means and answer the question - is it always the DBA's fault? If you would like your question to be featured on the show, just head over to SQLServerRadio.com, drop us a line, and we'll talk about it in one of the upcoming shows. Items mentioned in the show: * Itzik Ben-Gan - What You Need to Know About Batch Mode Window Aggregate Operator in SQL Server 2016  

Download Episode (mp3) Guy is back from a one month trip in the United States, and we're back with another show of SQL Server Radio. In this show, we talk about a few of our upcoming speaking gigs (PASS Summit and SQL Server Days in Belgium), about File-Snapshot backups in SQL Server 2016, about triggers in DB2, SQL Server 2016 CU1, about where to spend your thinking time, and more. Items mentioned in the show: * Matan Yungman - If You Have to Think, You're Doing it Wrong * Guy Glantser - Who the Hell is Going to Listen to SQL Server on the Radio? * Matan Yungman - My PASS Summit 2016 Session Submissions Feedback * File-Snapshot Backups for Database Files in Azure * New Memory Grant Warnings * Matan's SQL Server Days Precon