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

Declining Work for Mental Health

This year has been a busy one for me. I had 30 trips on airplanes away from home and around 100 nights not in my own bed. It's been quite a year, and a little overloaded. There have been a few months were I traveled little, but more than a few where I was gone more than I was home. I spent 19 nights away from home in September.

A few weeks back, I realized that I had another long trip coming up in October (9 days) and the PASS Data Community Summit in November. My body is a little worn out, but my mind is also distracted and struggling to focus. I recognized the beginnings of burnout when I realized that I was slightly dreading the Summit trip. While I want to see friends and catch up, I wasn't looking for a long trip.

On the spur of the moment, actually while sitting in an airport and waiting for a flight, I sent a note to the SQL Saturday Oregon organizers asking them to withdraw my speaking submission and not select me. I felt bad for doing so as I try not to create work for others or submit to events without the intention to go, but the extra 2 days in Seattle would make lift hard, and I thought this was the best choice for my mental health. I also chatted with my boss a bit about some work opportunities that were coming up and decided to decline a few other things, as well as skip conference submissions in Q1 2024.

I'm not burned out, but I do recognize that I'm overloading my body a bit. Physically it's a bit worn out and I can see that in my frequency and effort at the gym. Mentally I'm slightly dropping the ball on a few things, working slower than I often do because I find myself slightly distracted and looking for more breaks.

One of the big learnings for me over the pandemic was that I need to ensure I take care of myself and treat myself as I'd treat someone else in similar circumstances. I've had coworkers and friends struggle at times in life, where I've made an effort to work more and help them work less. I need to remember that for myself and ensure I can lean on others where needed. Redgate is an amazing employer and everyone is willing to flex with each other to ensure work gets re-distributed or we move deadlines. My manager and I have discussed this, and we are monitoring my workload moving forward in our regular meetings.

One of the best things I've learned over the years is to say no. I say no a lot to various queries on my time. Often when I feel I can't deliver on time. This year I was looking forward to these opportunities, perhaps a bit too much, and ran myself down a bit with over-excitement. I recognized that and made an effort to take steps to help myself before I burned out or started missing commitments.

The last month (and half of the next one) has been a bit rough, but I've mentally prepared myself for the work, and seeing relief coming in a couple of weeks is helpful. I've learned a bit more about myself this year, especially in relation to my slightly changing job and hopefully, I'll do a better job managing myself next year (or my boss will).

Learning to balance work and life is important. Remembering that life, family, friends, hobbies, faith, etc. are more valuable than work, and we need to ensure we don't overwork ourselves makes us better employees and better people. Any of us can get overloaded in the short term, but don't let that become an accepted part of your life. Your employer may push, but learn to push back and protect your physical and mental health.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples

Parthprajapati from SQLServerCentral

Learn how to use CTEs through the use of a number of examples.

External Article

Query processing architecture guide

Additional Articles from Microsoft MSDN

The SQL Server Database Engine processes queries on various data storage architectures such as local tables, partitioned tables, and tables distributed across multiple servers. The following sections cover how SQL Server processes queries and optimizes query reuse through execution plan caching.

External Article

Azure Databricks Tables - Delta Lake, Hive Metastore, TempViews, Managed, External

Additional Articles from MSSQLTips.com

Learn about the different tables that can be created using Azure Databricks with a dive deep into the importance of Delta Lake tables.

Blog Post

From the SQL Server Central Blogs - How to Downgrade Or Recover a SQL Server Database To A Previous Version Using SqlPackage.exe?

SQLPals from Mission: SQL Homeostasis

How to Downgrade a SQL Server Database To A Previous Version?

Upgrading a SQL Server database to a newer version is one of the core duties...

Blog Post

From the SQL Server Central Blogs - SQL Prompt Quick Access to Helper Code

Steve Jones - SSC Editor from The Voice of the DBA

We’ve been doing some events as part of the Redgate Roadshow, and at one of the events, we had a customer ask about something that we demo’d. This post...

Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers

Site Owners from SQLServerCentral

Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations.

 

 Question of the Day

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

 

TRUNCATE an FK

I have this table in a database with a lot of data.
CREATE TABLE Employee
(EmpID INT NOT NULL
, EmpName VARCHAR(20)
, MgrID INT 
)
GO
ALTER TABLE dbo.Employee ADD CONSTRAINT
FK_Employee_Employee FOREIGN KEY
(
MgrID
) REFERENCES dbo.Employee
(
EmpID
) ON UPDATE  NO ACTION 
 ON DELETE  NO ACTION 

GO
TRUNCATE TABLE isn't allowed with tables that are referenced by a FOREIGN KEY constraint. What happens if I run TRUNCATE TABLE on dbo.Employee?

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)

The Basic Symmetric Key

Which of these options (multiple) are needed to create a symmetric key with the CREATE SYMMETRIC KEY command in SQL Server 2022?

Answer: ALGORITHM, ENCRYPTION BY

Explanation: The two options needed for CREATE SYMMETRIC KEY are the algorithm and the encryption by. There is no default algorithm, and the key must be encrypted by some method. Ref: CREATE SYMMETRIC KEY - https://learn.microsoft.com/en-us/sql/t-sql/statements/create-symmetric-key-transact-sql?view=sql-server-ver16

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 2017 - Administration
Issue with Secondary ReadOnly Replica - Hi All, I have a two node AG cluster with primary and read only secondary. About two months ago, we have this issue started happening , when randomly, the primary and secondary sync just stops, the secondary is still showing as synchronizing  ( async mode) but on AG dashboard it shows as delayed and time […]
Query taking long time-perf - Hi All, One of the SELECT query is taking a long time to execute. Its is a view and it is calling another view. dev team says,its a simple SELECT, why it takes so much time. I see this query is filling up entire tempdb i.e. more than 2TB and it takes 7 hours time […]
Availability Group didn't get secondary DB added? - Yesterday I was working on some T-SQL code to create an AG and add databases to the AG. My scripts worked fine, or so I thought. Silly me forgot to check the secondary nodes. Apparently ALTER AVAILABILITY GROUP [MYAGName] ADD DATABASE MyDBName; only added the database to the primary node of the AG and it […]
SQL Server 2016 - Administration
To partition or not to partition - I have a database that is growing and growing an management does not want to entertain developing an archival process. We have indexes that are larger than some tables. The immediate thought would be to implement partitioning on the main table within this database. The only time data is removed from the database is when […]
SQL Server 2012 - T-SQL
Adding dates between data ??? - HI, Sorry for being so obscure on this problem, just not sure where to start. I have some data,  Student, subject and date, subject is always the same  that being "Note" I'd be running this for each day of the month , each student should have one records each 6 days, but sometimes it can […]
SQL Server 2019 - Administration
high VLF proactive monitoring - Dear Experts, Need advise on how to get proactive alerts for high VLF counts that being when any db generates high vlf than threshold it should alert the DBA either via sql server databasemail or operator, currently i am having a mechanism where it generates a report on daily basis but the problem here it […]
SQL Server 2019 - Development
Count only unique dates from a subquery - Hello, I have a question. I have a code where I am trying to calculate 'Count of Days with Sales'. This part of SQL looks like the code I provide below. It roughly means that if POADAT (Activity Date) is within - 7 days of Week Ending Date and actual Week Ending date then count […]
SQL Azure - Development
There are no user tables in my Azure SQL Database?! - With help from here I've finally been able to open the Azure SQL Database I created earlier. I created the database using one of the Microsoft AdventureWorks sample databases. However, looking at it both with SSMS and Azure Data Studio I don't see any user tables that should have been created when I created the […]
SQL Azure - Administration
Azure SQL Cluster Failover notification - Thanks for your time in reading this....first and foremost I have an Azure SQL cluster setup in both the East Region (Primary) and West Region(Secondary) Everything works well NOW here is the challenge...with on prem i can easily get a notification when there is a fail-over OR fail-back and this would run seamlessly when ON […]
Reporting Services
SSRS Matrix Rendring wrong position - Hi All, I am working on a report where I am using a Matrix. In design mode no error appears for me, but when running the report, the Matrix position is wrong and it is splitted on 2 or 3 pages and I didn't understand the issue. Can anyone help me and thanks in advance.
Integration Services
Run the Stored procedure , loop through dates in SSIS - I have a ssis package , where i need to get the start date and end date ( from audit log table ) and pass the dates to run SP,  through a loop. I have set date variables : 1) startdate ='10/13/2023' ( which comes from audit log table ) 2) Enddate varible ='10/15/2023' ( […]
SQL Server 2022 - Administration
Alerts to my SQL Server - I need a site with a package with alerts to download, to use in SQL Server. Could you sugest any best sites to me ?
SQL Server 2022 - Development
Replace Special Characters in SQL - How to replace all special characters in SQL input System.Text.RegularExpressions.Regex.Replace(input, "\{\*?\\[^{}]+}|[{}]|\\\n?[A-Za-z]+\n?(?:-?\d+)?[ ]?", "")
Generate sql in the instance - I need to generate SQL code that, in the instance, creates all the objects for each of the databases and generates an SQL output code. I need to do this via script, it can be PowerShell or T-SQL
inserting into varchar field doesn't error when > 8000 bytes - hi, Just an observation I was trying to make sense of. I'd appreciate anyone's explanation for why this happens. I've got a table field with datatype varchar(10). If a value greater than 10 bytes is inserted into this field, an error is generated and the row doesn't get inserted. However, if I have a field […]
 

 

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

 

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