Sql Server Radio

In this show, we talk about: How to Fix Orphaned DB Users Easily SSMS Auto-Recovery Feature Multi-Tenant Database Challenges Your DR Plan isn’t a Plan And much more...

Show Notes:  How to Set Up Availability Group with a Domain Account How to Start SQL Server Without Tempdb? Auto-Commit vs. Implicit Transactions What's between Corruption and Blocking? What Machine Learning Can Do?

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 card

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!

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

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