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

The Mythical Bus Accident

What if I got hit by a bus?

I'm sure many of you have heard some variation of this, or used it, or maybe your boss told you to be ready in case you (or someone more important) gets hit by that vehicle. This is the "bus factor," and it's often used in reference to preparation for unforeseen events. Not literally someone getting hit by a bus, but perhaps a sudden accident that takes someone away from work (hopefully not fatal). Perhaps it's someone leaving for a new job. Maybe it's retirement, which is something my boss and I at Redgate chat about periodically.

Don't worry, I'm not planning on retiring anytime soon. I expect to work until at least 2033 and possibly longer. Likely longer, I'm a weird work-a-holic in some ways, and I love my job.

Recently, Rob Sewell wrote about a DR plan for his life, and specifically about his setup in case his wife needs to understand what's running. I certainly don't have the automation or complex computer setup he does. In fact, none of my computers really need to be running for anything on the ranch to function.

However, there is a lot of important data.

If you think about how embedded your life is with digital assets, you'll realize quickly that if you were to get hit by the mythical bus, a lot of stuff might disappear. Most won't matter, but your partner/spouse/children/parents might care about some. They might really care about a few items.

There will be passwords to banks, the locations of photos, videos, and other memories. There will be documents you've kept on maintenance, or manuals on how something works, or maybe it's just the various email (and social) accounts you have. You might not care, but the person behind you might feel the need, and want to, notify your friends and coworkers that you're gone. Maybe your family wants to know how to keep your site alive (I still miss Tom and re-read his work occasionally).

This isn't to be morbid or worry you, but the planning you might undertake for your life is a lot like the planning that you should be doing at work for your job. Others should be able to take over for you (especially on vacations), and a guide to how you've solved problems, patched over issues, and built scripts that run rarely but reliably for some forgotten reason. Those items should be available to others. Certainly, your IT staff can give someone else access, but will those others know what to do with that access?

I've documented a bunch of processes for SQL Server Central. Mostly so I can go on sabbatical and not worry, but also so that others can share the load. I've given away some of my work to others, I've been lucky to have others volunteer (volun-told) to help, and I realize as I write this, I likely need to update some docs. Not a fun task, but my buddy Claude can likely help me. And he will.

Planning for the future is prudent, it's respectful to others, and it's a common courtesy. I used to think the future was a long way off, but as I age, I realize it's closer than I think. Planning for the future is a good idea, and it's something I need to ensure I update every so often, to help the others in my life.

 

Steve Jones - SSC Editor

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

 
 
 Featured Contents
SQLServerCentral Article

Implicit Conversions Cripple SQL Server

sabyda from SQLServerCentral

Learn about implicit conversions, which can dramatically affect the performance of your workload.

Technical Article

Vector search in SQL Server: VECTOR_DISTANCE, VECTOR_SEARCH, and index trade-offs

Additional Articles from SQLServerCentral

Learn how to use VECTOR_DISTANCE and VECTOR_SEARCH in SQL Server to find semantically similar data.

Blog Post

From the SQL Server Central Blogs - Learn about Modern Microsoft Apps in San Diego

Steve Jones - SSC Editor from The Voice of the DBA

I wrote about learning today for the editorial: I Can’t Make You Learn. I sure hope you want to learn. It’s been great for my career and it will...

Blog Post

From the SQL Server Central Blogs - Red Flags in Your Query (T-SQL Tuesday #200)

Zikato from StraightforwardSQL

When I'm looking at a query, I bet it's bad if I see... a shopping list of red flags I've learned to spot, from AI-generated code to SSMS map...

SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration

SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration

Site Owners from SQLServerCentral

With built-in AI for application development and advanced analytics powered by Microsoft Fabric, SQL Server 2025 empowers you to innovate—securely and confidently. This book shows you how.

 

 Question of the Day

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

 

BIT_COUNT() III

In SQL Server 2025, I run this code:
select bit_count(-1)
What is returned?

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)

Moving the Error Log

How can I change the location in which the SQL Server error log is written in SQL Server 2025?

Answer: In the SQL Server Configuration Manager, alter the Startup Parameters tab to change a parameter to a new path

Explanation: You need to alter the SQL Server Configuration Manager settings for startup parameters. Ref: Database Engine Startup Parameters - https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/database-engine-service-startup-options?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 2019 - Administration
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019 - We want to enable ADR on our SQL Server 2019 instances. I’ve heard that the PVS cleanup process is still single-threaded in SQL Server 2019. Do you have any feedback or experience with this? Is there any noticeable latency, or is it strongly recommended to move to SQL Server 2022 before enabling ADR?
SQL Server 2019 - Development
cons for a dev machine in a different version of sql from our prod server - hi, im not a dba. For a couple of years our dev sql server has been a 2022 vm std instance with varying levels of horsepower depending on how loudly we objected.   For many years our prod , 2019 on prem std.  both have ssas, ssis, ssrs and of course the engine. We are looking […]
Editorials
Forward Deployed Engineers - Comments posted to this topic are about the item Forward Deployed Engineers
SSRS Reminded Me of the Time Microsoft Retired TMG - Comments posted to this topic are about the item SSRS Reminded Me of the Time Microsoft Retired TMG
I Can't Make You Learn - Comments posted to this topic are about the item I Can't Make You Learn
A Quick Second Opinion - Comments posted to this topic are about the item A Quick Second Opinion
Article Discussions by Author
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage - Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
DBCC CHECKDB Limits II - Comments posted to this topic are about the item DBCC CHECKDB Limits II
BIT_COUNT II - Comments posted to this topic are about the item BIT_COUNT II
Why Your SQL Permissions Disappeared - Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
Why Your SQL Permissions Disappeared - Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload - Comments posted to this topic are about the item Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Checking the Error Log I - Comments posted to this topic are about the item Checking the Error Log I
SQL Server 2022 - Administration
Upgrade 2016 Standard to 2022 Express - Title pretty much says it all - can this be done? I've tried several paths and always come up against some failure in the installation process. I can install a new version of 2022 Express, but that means also porting all my logins and roles, as well as restoring every database. I would much prefer […]
SQL Server 2022 - Development
Getting results from a Procedure to join to a query - I have a need to execute a stored procedure and return the results to something I can join to in a query. I am trying to execute a Trial balance from our ERP and get those balances and account numbers to correlate to another table with new account numbers. So my stored procedure execution looks […]
 

 

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

 

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