SQL Server Radio

Download Episode (mp3) Guy is currently having fun in Thailand, so we don't have a new show this week. Instead, we republish one of our earlier episodes, where we talk about our favorite language - T-SQL. We'll be back with a new show in two weeks. Did you know that SQL was initially called "Sequel" (Structured English Query Language)? On this show, we go back to basics and talk about our favorite language - Transact-SQL (T-SQL). We cover a lot of topics in the fields of development, performance and maintenance. Among them: * The logical phases of query processing * Our favorite and least favorite T-SQL features * T-SQL development best practices * How to avoid writing long Stored Procedures * How to avoid writing the "mother of all queries" * The Axis of Evil T-SQL featrues * Why you should (almost) never use table variables Items mentioned in the show: * Matan Yungman - The Axis of Evil * Itzik Ben-Gan - Creative Uses of the APPLY Operator (Part1) * Itzik Ben-Gan - Creative Uses of the APPLY Operator (Part2)

Download Episode (mp3) There are many ways for writing efficient queries in SQL Server. In this show we talk about a few of those ways, when the key is - "keep it simple". In addition, we talk about use cases for Big Data, Ways for transferring data to a reporting server, an interesting BI project Guy is working on, and more

Download Episode (mp3) In this show, we talk about: * How to tell if you have a CPU problem in a virtualized environment * SQL Server setup tips * Guy's experience from his data science course * How we change over time * More productivity tips

Download Episode (Mp3) * Replicating Tables in Azure SQL Datawarehouse * Persisting Statistics Sampling Rate, and Other Statistics Issues * Adding Tables with Default Values Online * The Microsoft Data Science Program * Followup on a Previous Item Global Temp Tables in Azure SQL Database * Loading a Trillion Rows into SQL Server

Download Episode (Mp3) What do you do when you lost the admin password of Azure SQL DB? Tough SQL Server Interview Questions Should You Learn Data Science? Links mentioned in the show: * OpenQueryStore * Thomas LaRock - Why I'm Learning Data Science

Download Episode (mp3) * A scenario where the same sessions deadlocks itself * Other ways to think about parallelism * Database Scoped temporary tables in Azure SQL Database * Many productivity tips

Download Episode (mp3) In this show, we talk about: * Why there are more and more security and encryption projects, and how wrestling is related * More issues and things to take into account with the new cardinality estimator * The Baader-Meinhof Phenomenon * Truncating a single partition in SQL Server 2016

Download Episode (mp3) T-SQL Tuesday is the monthly blogging party of the SQL Server community. In this show, we tell stories based on the latest T-SQL Tuesday topics.  

Download Episode (mp3) In this show, we share some client stories from recent projects: * One nice thing of being a consultant * Another consolidation project with a client implemented with views * Performance recommendations from a client project * Trivial optimization vs.Simple Parameterization * Some challenges when working with MySQL  

Download Episode (mp3) In this show: * The challenges of consolidation projects * What is the Remote Query Harden error with Availability Groups * PASS Summit precons * Describe your profession in one sentence * What if Clippy found his way to to SSMS? * The right ways to manage open transactions

Download Episode (mp3) In this show of SQL Server Radio: * Different types of recompile * On what subject does Guy not agree with Paul White? * Why the buffer cache hit ratio counter is misleading * When should you stop worrying regarding the page life expectancy counter

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 of Antivirus software

Download Episode (mp3) In this show, we talk about things we've been doing forever but might not need to do them anymore. Is parameter sniffing good or bad? Should you rebuild indexes? And what about update statistics?

Download Episode (mp3) In this show, we talk about: * The GroupBy Conference * Hacking Dangers in Today's World * DR in the Cloud * Configuration Options you have to Change * The Biggest Problem with Partitioning and How to Solve it

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 Hill * SQL Saturday Israel