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

Bean Counting to Burnout

This editorial was originally published on Oct 14, 2020. It is being re-published as Steve is on vacation.

I was listening to a story about healthcare in the US recently. This was an interview with Vivian Lee, the author of The Long Fix, which proposes some ways to improve the system under which I live. I thought it was a good interview, and I am looking forward to reading the book.

There was one stretch in the interview that caught my ear, and that was on the struggles of many modern doctors in the US to avoid burnout. A part of the reason for this is the amount of paperwork they must complete, which takes away from many of the reasons they got into practicing medicine.

I know that many people in IT professions work long hours. We have lots of deadlines to meet, on call responsibilities, and the pressures to ensure that our systems work well for customers and clients. We don't necessarily have the upside that doctors do, so working harder doesn't necessarily lead to more compensation.

On top of the work we do, there seem to be no shortage of meetings in many companies, though I don't hear too many complaints about paperwork. However, with the move to more OpEx and cloud services, I wonder if we will have to deal with more paperwork in the future, more reporting, and more accountability for the financial side of our departments.

I would like to think that we will continue to work with technology most of the time, and I hope that after this pandemic that most managers will cut down on meetings and start to trust more people to get work done without oversight. We certainly have enough of a risk of burnout without the added burden of unnecessary meetings and paperwork.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now

vgupta from SQLServerCentral

SQL Server 2022 brought powerful new T-SQL functions that eliminate long-standing workarounds. This article walks through five of the most impactful additions — GENERATE_SERIES, GREATEST/LEAST, DATE_BUCKET, the WINDOW clause, and IS NOT DISTINCT FROM — with practical code examples you can use immediately.

SQLServerCentral Article

PASS Europe comes to Frankfurt

Steve Jones - SSC Editor from SQLServerCentral

PASS Europe comes to Frankfurt, Germany on June 10-11, 2026.

Blog Post

From the SQL Server Central Blogs - Creating a Pulsing Conducting Baton - Part 1

Bert Wagner from Bert Wagner

Train Wreck
The last time I watched a high school band nearly fall apart mid-performance was when the relatively new, certainly nervous band director started the piece off much faster...

Blog Post

From the SQL Server Central Blogs - Track SQL Server Configuration Changes Using the Error Log

SQLPals from Mission: SQL Homeostasis

Track SQL Server Configuration Changes Using the Error Log

If you work with SQL Server long enough, you or someone will eventually want to know, “Did...

Definitive Guide to DAX cover

The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel

Site Owners from SQLServerCentral

Now expanded and updated with modern best practices, this is the most complete guide to Microsoft’s DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization.

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

No More Deadlocks

After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?

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

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

QUOTENAME Behavior

I use QUOTENAME() like this in code?

DECLARE @s VARCHAR(20) = 'Steve Jones'
SELECT QUOTENAME(@s, '>')

What is returned?

Answer:

Explanation: This returns , the same as this code:

DECLARE @s VARCHAR(20) = 'Steve Jones'
SELECT QUOTENAME(@s, '<')

Ref: QUOTENAME() - https://learn.microsoft.com/en-us/sql/t-sql/functions/quotename-transact-sql?view=sql-server-ver17

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.


SQL Server 2016 - Administration
SQL Server Showing Out of Space But Plenty of Drive Space - We have a SQL Server installed. We have a 500GB drive for the database. Currently, we have 95 GB free on this drive. When I go into the database, and look at the Shrink File toolset, it shows the database at 410000 MB and the Available Free Space at 4500 MB, but the drive itself […]
Data Transformation Services (DTS)
Before Using AI with Business Data, Read This - Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis and reporting to workflow automation and customer support. While these systems can improve productivity, many organizations are adopting AI faster than they are addressing potential privacy and security risks. One of the biggest concerns is how sensitive business information is handled […]
Editorials
What Can AI Really Do? - Comments posted to this topic are about the item What Can AI Really Do?
We Are Eating Our Own Seed Corn - Comments posted to this topic are about the item We Are Eating Our Own Seed Corn
The New Wave of Security Threats - Comments posted to this topic are about the item The New Wave of Security Threats
There's Too Much to Learn - Comments posted to this topic are about the item There's Too Much to Learn
Article Discussions by Author
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit - Comments posted to this topic are about the item Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Distance Metric Algorithms - Comments posted to this topic are about the item Distance Metric Algorithms
Designing SQL Server ETL Pipelines That Don't Break at Scale - Comments posted to this topic are about the item Designing SQL Server ETL Pipelines That Don't Break at Scale
Detecting Deadlocks Quickly - Comments posted to this topic are about the item Detecting Deadlocks Quickly
Creating a JSON Document IV - Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE - Comments posted to this topic are about the item Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
SSRS Is Dead. Here Are Your Real Options - Comments posted to this topic are about the item SSRS Is Dead. Here Are Your Real Options
The Distance Metric - Comments posted to this topic are about the item The Distance Metric
SQL Server 2022 - Development
Permissions Removal When Changing Object Schema - When the schema of an object is changed, SQL Server wipes out the previous set of permission grants. Usually this applies when the permissions are granular. Such as "GRANT SELECT ON abc.MyTable TO Mylogin." And usually, I only care when I have to drop the schema-owning user from the database for whatever reason. What I […]
 

 

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

 

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