Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
 
The Voice of the DBA
 

Communication, For Incidents and Life

Many years ago, I was on call for a production system. This was common for me since I was one of several production DBA’s for the company.  It was a normal weekend for me, and I got up and started playing with my kids. They were heavily into trains, and we were laying out our latest large train set in the living room. We would cover most of the floor with train tracks. The kids would later use the train to pick up little people from various cities, and they played various games.  As I assembled the tracks, I got a message on my phone. 

“Sys alert: DB-01 Server is not responding” 

Since this was one of the primary databases, I was very concerned. This was the days before Slack, so we didn’t have good “channels” to post a message and ask what was going on.  I logged in and started troubleshooting to figure out what was going on. At the same time, I started reaching out to some of the operations folks to see if they knew anything. I got a response back. 

Ops: “Hey Pat, we took that down since we are doing upgrades on the system right now; it should be done soon”.  

Obviously, my first thought was WTF????? But….Instead. 

Me: “Ok, I wasn’t aware of this. Do you need anything from me?” 

Ops: “No, we should be done in about 20 minutes, and then you will probably need to validate”

Me: “Ok, I’ll wait and see”  

20 minutes later,

Kids: “Dad, dad, dad,  can you finish the train tracks…” 

Me: “A few more minutes, I’ll help soon” 

30 minutes past…….

Kids: “Dad! Dad, Dad!......can we get the train tracks finished” 

Me: “Almost done…..just a few more minutes” 

Me: “Hey guys, still waiting here by the computer. Do we have things back up and running”

Ops: “Oh ya, all good. We were done about 30 minutes ago”...........

Some of you out there will be nodding your heads right now since you lived through days like this as well. Anyone who’s been on call for a system has dealt with issues when the system goes down or problems arise. It’s especially hard when simple communication issues make you lose time with family, friends, or just relaxation.  

To help, I thought I would share some simple communication tips and tricks. Now keep in mind, technical folks like engineers, operations, database people, and network people are NOT typically great at communication. They are usually very introverted, and the last thing they want is to talk about something that might cause downtime or a problem in the system. These guidelines help with that. 

  1. Do not be afraid to over communicate. If something is large enough to impact the entire system, then YES, the General channel in Slack with an @here is acceptable! Your company may say otherwise, but start with this idea and modify it later.  
  2. Don’t fault people for over communicating! I see this very often! People will complain that they don’t want to be alerted about something that doesn’t impact them. If you own the change and it will impact systems, it is your job to communicate it.  If someone complains that they shouldn’t have to worry about it, agree and tell them anyways. 
  3. Be clear and concise in what you are doing. Avoid. “The system will be down”. Which system? How long? Will it impact product X? Is it the whole system or just one part? It’s much better to be clear. “The order system will be down from 9:00 a.m. to 9:15 a.m. This will only impact orders; all other aspects of the system will work” 
  4. Be clear about who you need involved and what you might need from them. “We will need the DBA team after we complete at 9:15 am” “We need engineering to validate this change at 9:15 a.m. "  This message also sets up clear lines of communication. “We will use this “channel” to discuss all items related to this”. The channel can be a Slack channel, Telegram, WhatsApp, or sms text group. Anything that supports a group of people talking and coordinating. 
  5. Follow up clearly and concisely. NEVER just post “It’s done”. Much better would be. “The update is complete, and the system is back up and running. We have validated these items, and if you see any issues, please contact us”.  

 

I know these all sound like communication tips for incidents and system updates, but they're really guidelines for all the communication you do. You can use these in meetings, when working with other teams, or even when organizing things with friends. The more you practice these ideas of clear communication, the better things will be for you in your career.  

Hope these help, and you have uneventful weekends, spending time doing the things you love! 

 

Pat Wright

Join the debate, and respond to today's editorial on the forums

 
 
 Featured Contents
SQLServerCentral Article

Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server

john.martin from SQLServerCentral

Learn how to use CHOOSE() and IIF() to validate priorities and return easy to read messages to the user.

External Article

How to Create an Alert in the Microsoft Fabric Warehouse

Additional Articles from MSSQLTips.com

We are building a new data platform with Microsoft Fabric and we’re using the warehouse for our “gold layer”. We don’t have real-time ingestion or analytic requirements, but we have a use case where we want to send an alert if a certain threshold is reached. Ideally, the alert is sent when a SQL query returns a result set.

Technical Article

Take the 2027 State of the Database Landscape Survey

Press Release from SQLServerCentral

Share your view on the database landscape and you could win USD$500.

From the SQL Server Central Blogs - How to Clear the SSMS Cache (SSMS 21 and Later)

SQLPals from Mission: SQL Homeostasis

How to Clear the SSMS Cache (SSMS 21 and Later)

Updated for SSMS 21 and later: This is a new, rewritten version of my earlier article...

Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

Site Owners from SQLServerCentral

Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance’s performance. 

 

 Question of the Day

Today's question (by Grant Fritchey):

 

PostgreSQL psql Meta Commands: Tables

Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Grant Fritchey)

PostgreSQL psql Meta Commands: Databases

Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?

Answer: \l

Explanation: The correct answer is \l. You can also use \list. For more details, you can use \l+ or \list+. The other commands are: \d: list all tables, views and sequences \db: list tablespaces \q: quit psql Read all about it in the PostreSQL documentation on psql: https://www.postgresql.org/docs/18/app-psql.html

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


Editorials
Training the next generation - Comments posted to this topic are about the item Training the next generation
Risk Vs Reward, The never ending ROI discussion. - Comments posted to this topic are about the item Risk Vs Reward, The never ending ROI discussion.
I Struggle - Comments posted to this topic are about the item I Struggle
The DBA is Dead! Long Live the ! - Comments posted to this topic are about the item The DBA is Dead! Long Live the !
It's Never Just One Thing - Comments posted to this topic are about the item It's Never Just One Thing
Article Discussions by Author
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4) - Comments posted to this topic are about the item Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
PostgreSQL psql Meta Commands: Databases - Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Hyperscale Replicas IV - Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek - Comments posted to this topic are about the item The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Using CHOOSE() - Comments posted to this topic are about the item Using CHOOSE()
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary) - Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
Calculating Min-Max Normalization in PowerBI - Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
SQL Server 2022 - Administration
Anyone knows where to download SQLexpress edition for 2022 - Where to download earlier version of SQL server express 2022?   Thanks
SSL/TLS Cert Validity Periods Decreasing - Hi, to all of you who are using CA certs on SQL Server boxes to avoid the need to check that pesky 'Trust Server Certificate' box. It seems there is an industry-wide agreement to shorten the validity period of these certs, down to just 47 days in 2029: Shorter validity periods coming for SSL/TLS certificates: […]
SQL Server 2022 - Development
Trigger isn't working - Hi, I have a trigger, that works fine elsewhere but is not working at this location. At one point I put a print statement in the trigger just to see if it was firing. The message comes through, but the data is not being copied to the new table. USE [db name] GO /****** Object: […]
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -