Author: Matan Yungman

A Sign Your Wife is Married to a DBA

Download Episode (mp3) 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 A bug with CDC after a cumulative update The overhead

Continue reading

Hilbert’s Hotel

Download Episode (mp3) We’ve been travelling a lot lately, so It’s been a while, but we’re back! In this show, we talk about: Tips for SQL Server in the cloud We’re speaking at the GroupBy conference Using a Dates table for solving T-SQL problems Interesting way to explain the SQL Server security model by Kevin

Continue reading

Great Productivity Tips

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 

Don’t Run Barefoot

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

SQL Server 2000 Good Old Days

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..

The Elephant in the Room

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

Continue reading

12 Days of Christmas

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!