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

The End of Summer

Growing up, this was the last week of summer for me every year. When I was a child in Virginia Beach, school started the day after Labor Day every year, which is next Monday in the US. This was our last chance to sleep in, enjoy the ocean, and stay out late without commitments. Starting next week we'd be back in school, up early, with homework to do every night.

As an adult, the end of summer doesn't really stand out anymore. Corporate changes are usually at the beginning of the year or in July, so it's the end of June or December that are slower times. September is often the beginning of conference season for me, and I've usually been preparing for travel in September, as I am this year. I'll be in San Diego in a little over a week for VS Live (if you want to join me, use the code Jones).

I hope that most people have busy times and slow times at work. If you're constantly busy and fighting fires, life is not good. That leads to stress, unhealthy living, and burnout. It's not sustainable over time, at least not if you want to keep producing high quality work. I've lived in those situations and they're neither enjoyable, nor the times when I've been at my most effective.

When work is slower, I naturally slow down a little and appreciate that I can take more time to write, answer emails and messages with more detail, and think more carefully about situations. I also use the time to get ahead administrative tasks that I sometimes put off. For me, this is producing and scheduling things I'll need later. This is often a time when I'll write questions or editorials for the future.

These are often the pieces I'm more pleased or proud of. I have time to work through details and spend more time reviewing my work. These are often the best questions I write.

As a developer, this was the time I might refactor code I'm not pleased with, or tackle some niggling piece of work that I know is needed, but never has priority. As a DBA, this is when I refactor scripts and alerts, do more maintenance, maybe add some automation for tasks that I've just been doing manually because I don't have time to do anything else. If I were  still a dev or DBA, this is when I'd be experimenting and practicing using AI as a lever to make myself more effective.

When you have slower times, what tasks do you tackle? Documentation? Improvements? What else might not get done when the pace is a little more hectic? Let me know today.

Steve Jones - SSC Editor

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

 
 
 Featured Contents
SQLServerCentral Article

Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't

vgupta from SQLServerCentral

See how SQL Server's Parameter Sensitive Plan optimization handles skewed parameters, how to verify dispatcher plans, and where PSP still falls short.

Technical Article

How to avoid nested REPLACE functions with TRANSLATE in SQL Server

Additional Articles from SQLServerCentral

This guide covers how TRANSLATE() works, how it compares to REPLACE(), and where it falls short compared to other SQL dialects like PostgreSQL and Oracle.

Blog Post

From the SQL Server Central Blogs - The Book of Redgate: Evidence

Steve Jones - SSC Editor from The Voice of the DBA

We aren’t the only company that does this, but Redgate Software does try to be data driven. Across my 18 years, I’ve had plenty of people use evidence from...

Refactoring Databases cover

Refactoring Databases: Evolutionary Database Design

Site Owners from SQLServerCentral

Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance.

 

 Question of the Day

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

 

Hyperscale Replicas I

What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?

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)

Tracking All the Queries

I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled.

One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion.

How many rows are in Query Store for this query?

Answer: 2

Explanation: Queries that run to completion are captured in Query Store (QDS). Queries that are aborted/cancelled by the user are recorded. Queries killed are not recorded. Ref:

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
Two queries work until compared with EXCEPT statement - I've got multiple databases on 2 SQL 2019 CU32 servers , all using the same schema and code base. The only difference in patch levels is Test has the July Security Update and Prod has the March one. There's a Table Valued function that fails on one database only and only on prod. Of the […]
SQL Server 2016 - Development and T-SQL
Execute as failure - Security has long been a problem for me. Every time I think I understand something, along comes another issue to show me that I don't. I want to have an application on start-up query some information from a sort of status table, to see what it is allowed to do. I have a schema called […]
SQL Server 2019 - Development
Logic question in a WHERE clause using IIF? - Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the code has me stumped. I'm trying to add a filter in my WHERE clause that basically says "omit records if [BillingReason] in (1, 2, 3) AND ([NewInsID] IS NOT NULL AND [OldInsID] IS NOT NULL)". For example: [BillingReason] = 1, [NewInsID] […]
Editorials
Admin Rights for Everyone - Comments posted to this topic are about the item Admin Rights for Everyone
A Challenge of Our Knowledge - Comments posted to this topic are about the item A Challenge of Our Knowledge
The New World Of AI Robots - Comments posted to this topic are about the item The New World Of AI Robots
An Eventual Consistency Scam - Comments posted to this topic are about the item An Eventual Consistency Scam
Article Discussions by Author
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles - Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
RegEx Functions I - Comments posted to this topic are about the item RegEx Functions I
Column Data Types - Comments posted to this topic are about the item Column Data Types
The memory toll of VARCHAR(MAX) in SQL Server - Comments posted to this topic are about the item The memory toll of VARCHAR(MAX) in SQL Server
Transaction Log Truncation - Comments posted to this topic are about the item Transaction Log Truncation
BIT_COUNT() V - Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager - Comments posted to this topic are about the item How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
SQL Server 2022 - Administration
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts? - Hello We recently encountered an issue where a SQL table unexpectedly grew in size due to an application error. The table increased from a few gigabytes to around 11 TB within one week, which completely filled the PRIMARY filegroup. To prevent this from happening again, I would like to set up an alerting system that […]
 

 

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

 

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