Sql Server Radio

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

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?

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…

Today in the show:   SSMS Unuseful Tips Why Database Continuous Integration is Challenging? Monitoring Page Splits

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

In this show, we talk about everything that's new in SQL Server 2017

There are many ways to write 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

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

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

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 came to SSMS? * The right ways to manage open transactions

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

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