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
Jul 7
Episode 177 - Five and a Half Enhancements in SQL Server 2025
Guy and Eitan discuss Stephen Planck's blog post "Five SQL Server 2025 Enhancements DBAs Will Notice", and add some of their own insights. Relevant links: Five SQL Server 2025 Enhancements DBAs Will Notice - SQL Table Talk Configure a flexible automatic failover policy for an ava ... Show More
29m 18s
Jun 9
Episode 176 - SQL Server 2025 and more
Many announcements and interesting releases came out this past month, so we got a lot to talk about in this episode! Relevant links: What's New in SQL Server 2025 - SQL Server | Microsoft Learn SQL Server 2025 - AI ready enterprise database from ground to cloud | Microsoft Commun ... Show More
38m 14s
May 12
Episode 175 - Migrating from on-prem to AWS RDS
Guy talks about a recent migration project he was working on to move an on-prem SQL Server to AWS RDS. Eitan talks about a new AI-related feature in Azure SQL Databases. And we also discuss the new SNAPSHOT backup T-SQL command in SQL Server 2022. Relevant links: Importing and ex ... Show More
38m 59s
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
It’s all about data management this week on the podcast as Brian Dorsey and Mark Mirchandani talk to Google Cloud Product Marketing Manager, Amy Krishnamohan. Amy starts the show by explaining that Cloud SQL is a fully managed relational database service that recently added Micro ... Show More
29m 44s
Nov 2023
86: SQL Simplified: For Data Beginners
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. Tune in now! 🗄️ Join FREE SQL hands-on workshop th ... Show More
25m 25s
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
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. 0:00 Intro 1:22 SELECT COUNT(*) 4:30 SELECT AVG(A) 5:15 SELECT MAX(A) 8:00 Best case scenario 11:30 Clustering 14:00 Clusteri ... 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