Category Archives: Podcast

Be as Lazy as Possible

Download Episode (mp3) In this show, we talk about: Glenn Berry’s Diagnostic Information Queries The options for restricting access using Azure SQL Database firewall Something Cool We Learnt Today The role of the UPDATE lock in SQL Server Building your performance monitoring infrastructure And some big news…

Let Me Index That for You

Download episode (mp3) Today in the show, we talk about: Types of business analytics Is cardinality estimation the most common cause for performance problems? How to answer the question “what do you do”? Old news about AWS max database size in RDS New project architecture challenges Reporting and comic books Scary bug with mirroring and

Continue reading

[Replay] Show 11 – T-SQL

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”

Continue reading

Help the Optimizer

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

Continue reading

We Don’t Have a Name for This Show

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