logo
episode-header-image
Apr 2016
37m 3s

Show 44 - SSMS Can Beep

Guy Glantser, Eitan Blumin
About this episode

Did you know SSMS can make sounds? We start the show with some interesting things you might do with it.

In addition, we talk about:

  • SQL Server on Linux
  • Hadoop fundamentals
  • SQL Server 2016 eBook
  • Changes to auto update statistics in SQL Server 2016
  • New SQL Server 2016 database level configurations
  • Distributed Availability Groups - what is it and use cases
  • How AWS storage works

Items mentioned in the show:

Up next
Nov 10
Episode 181 - The new SSMS is still blue
Guy and Eitan talk about the new preview version of SSMS, application locks, and stupid troubles with TempDB shrinkage. Relevant links: Announcing the Release of SQL Server Management Studio 22 Preview 3 | Microsoft Community Hub Release Notes for SQL Server Management Studio (SS ... Show More
33m 23s
Oct 13
Episode 180 - Computed Columns with PERSISTED and Indexed Expressions
We let a dice roll decide today's topic, and the winner ended up being: Computed Columns with PERSISTED and Indexed Expressions. We give our thoughts about it, best practices, pit falls, and tips. Relevant links: SQL Server 2025 Preview RC1: Now Supporting Red Hat Enterprise Linu ... Show More
37m 55s
Sep 8
Episode 179 - SQL Server 2025 RC0 announced and weird latch timeouts
Guy and Eitan discuss several interesting announcements and updates from Microsoft related to SQL Server and VS Code. And also Eitan talks about a weird issue he encountered involving page latch time-outs during DBCC CHECK command. Please fill out the SQL Server on Linux adoption ... Show More
34m 40s
Recommended Episodes
Jun 2018
Training Resources for SQL Noobs
New to learning SQL Server? Get the scoop on free online resources to look up information, ask questions of community members, and learn SQL Server from the ground up. Links from the episode are at: https://sqlworkbooks.com/dear-sql-dba/training-resources-for-sql-noobs/ 
29m 10s
Mar 2020
Data Management with Amy Krishnamohan
<p>It's all about data management this week on the podcast as <a href="https://twitter.com/briandorsey">Brian Dorsey</a> and <a href="https://twitter.com/markmirch">Mark Mirchandani</a> talk to Google Cloud Product Marketing Manager, <a href= "https://twitter.com/amykrishnamohan" ... Show More
29m 44s
May 2024
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
Erik Darling joins Kendra Little to rate different SQL Server Performance Tuning Techniques in episode 81 of the Dear SQL DBA podcast. We share our opinions of... (deep breath)   Recompile hints, Query Store hints and plan forcing, CTEs, Resource Governor, the legacy cardinality ... Show More
1h 4m
Nov 2023
86: SQL Simplified: For Data Beginners
<p>SQL is the most important data skill you can learn on your journey. And it doesn’t need to be complicated. In this episode, dive into a short SQL introduction, basic SQL commands and know how SQL can help you land your data job.</p> <p>Tune in now!</p> <p><br></p> <p><a href=" ... Show More
24m 50s
Aug 2021
Table Clustering (Clustered Index) - The pros and cons
In this episode of the backend engineering show, I discuss database clustering. This is also known as table clustering, clustered index or Index organized table all names represents the same thing. I will talk about the benefits of clustering and also the disadvantages of impleme ... Show More
28m 33s
Feb 2024
Episode 507: Stephen Margheim on SQLite in Ruby on Rails Applications
If you start a new Rails project today, you’re probably going to pick Postgres for your database. And if you have a ten year old Rails app, you might be using MySQL. But Rails ships with support for SQLite, a lightweight SQL database. Can that lightweight database be used to make ... Show More
31m 21s
Mar 2022
Understanding Aggregate Functions Performance | The Backend Engineering Show
<p>Aggregate functions like Count, max, min, avg performance really depends on how did you tune your database for that kind of workload. Let us discuss this.</p> <p>0:00 Intro</p> <p>1:22 SELECT COUNT(*)</p> <p>4:30 SELECT AVG(A)</p> <p>5:15 SELECT MAX(A)</p> <p>8:00 Best case sc ... Show More
23m 39s
Jul 2021
MySQL Statement-based Replication might not be a good idea
Replication is the process of pushing changes from the master node to worker replica nodes in a database system to allow for horizontal scalability. One of the methods of replication is statement-based which is popular in MySQL. In this episode of the Backend Engineering Show, I ... Show More
17m 46s
Nov 2021
#482: [INTRODUCING] AWS Local Zones
What are AWS Local Zones? How are customers using them for hybrid enterprise migration? Tune in to listen to Nicki chat with Andrew Purdin (Manager, Platform Engineering at MindBody), Ben Diringer (Infrastructure Architect at MindBody), John Bair (System Architect at MindBody), a ... Show More
23m 28s
Listen to millions of songs and podcasts on Anghami