Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com
Hand-picked content to sharpen your professional edge
Editorial
 

Taking time off

Time is a precious commodity, and so much of our time is dedicated to working. IT professionals often have jobs with good benefits, including generous paid time off. It’s important to get away from work to relax and recharge, but, sometimes, it’s difficult to take those days that belong to us. Even when we do take the days, it’s difficult to completely break away without staying connected to work through our phones and email.

Scheduling is often a problem. What do you do if you plan time off, but there is something important scheduled during that time, and your manager thinks that you must be involved? Do you try to make sure that someone else can cover, or do you go ahead and work even though you are officially unavailable? I worked almost every weekend one summer during a big project. I didn’t mind it so much except when I was stuck in the hotel working while my family was enjoying the beach. Could I have just trained someone else to do the tasks I needed to perform that weekend? Sure, but the only good candidates were not available because they also had so much work to do on the project. If I worked in a bigger shop, delegating responsibility would have been the best solution.

There are also unexpected issues and emergencies. In a perfect world, everything that could go wrong is documented, and the steps to follow when it does are in a runbook. If you work on a small team, or are the lone person in your role, keeping that documentation current is a big effort. Sometimes, just answering a question or two is helpful to the team even when you are away.

While I was a database administrator, I went on a few cruises and several backpacking trips over the eight years I was in the role. There was typically no way to communicate during the backpacking trips, but while on the cruise, I would communicate via email (painfully slow!) every day with the junior DBA. It was difficult for me to relax because I couldn’t stop thinking about the servers and database.

It also depends on the job. When I worked at a consulting company, I didn’t have to work for the customers on weekends, holidays, or during my paid time off, but I did need to watch for emails from my manger and the sales team. I also had to spend many Sundays and Monday holidays traveling to client sites. Even while I wasn’t technically working, I was still not able to completely break away from my job on weekends.

At Redgate, I can forget about work when I take holiday trips. Yes, I do work for an amazing company, but I’m not responsible for any client work or production servers in my role as an editor. It's taken a long time for me to get to this place, but I've paid my dues. Now that it's possible to travel again, I am taking advantage of my vacation time!

What about you? Are you able to break away from your job and use those precious days to relax? Tell us in the comments.

Kathi Kellenberger

Join the debate, and respond to the editorial on the forums

 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Vendors/3rd Party Products

How does microservices architecture change database deployment?

Grant Fritchey discusses the relationship between microservices architecture and database deployment and how these two important pieces of the DevOps puzzle, can work together, or against each other in the future.

Administration of SQL Server

Time to Stop Deploying SQL Server 2016 and Windows Server 2016

Today is July 13, 2021. Besides the anniversary of Live Aid in 1985 (had to sneak a music reference in somewhere!), today marks an important date: the end of mainstream support for SQL Server 2016...

How to fix BACKUP LOG cannot be performed because there is no current database backup

From SQLServer-DBA.Com

The Backup team shared a warning message for SQL S...

Cumulative Update #25 for SQL Server 2017 RTM

From MS SQL Server Blog

The 25th cumulative update release for SQL Server ...

Starting SQL: Query Internals

From Erik Darling Data

Starting SQL: Query Internals If you want to check...

Quickly Identify Configuration Drift In Your Environment

From SQLServerCentral Blogs

As you sit and wonder about when the next Star War...

How to fix Invalid comparison due to NO COLLATION

From SQLServer-DBA.Com

Unusual no collation error on a SQL Server 2017

How to enable SQL Server trace flags

DBAs can control many aspects of SQL Server’s behavior with trace flags. In this article, Robert Sheldon explains how to enable SQL Server trace flags.

Azure Synapse (SQL Data Warehouse and Data Lake)

How to query blob storage with SQL using Azure Synapse

How do you include blob storage in reports? In this article Dennes Torres explains how to query blob storage with SQL using Azure Synapse.

Computing in the Cloud (Azure, Google, AWS)

Getting started with Azure Database for PostgreSQL – Flexible server

From SQLShack

This article will walk you through the process to ...

Add Azure Cache for Redis to Your Azure SQL Performance Tuning Toolbox

From DCAC

One of the biggest impacts on resource consumption...

Conferences, Classes, Events, and Webinars

SQL Monitor for performance and availability

Managing your entire SQL Server estate, with instant problem diagnosis, and customizable alerting has never been more vital. Discover how Redgate’s SQL Monitor enables all this from a single pane of glass.

The outlook for PASS Data Community Summit is bright

From Blog – Redgate Software

Everyone across the globe is now at different stag...

DMO/SMO/Powershell

FUN WITH POWERSHELL STRINGS

PowerShell has some of the best, most flexible string handling of any language I’ve used. In this post we’ll look at some string basics, then some of the features that make it special...

Data Science

10 data science job statistics that will blow your mind

From AllAnalytics

In 2012, Data Scientist was dubbed the sexiest job...

Database Design, Theory and Development

The Best SQL VARCHAR Do’s and Don’ts for Faster Databases

From SQL Server – {coding}Sight

This post has “strings attached: for a good reas...

ETL/SSIS/Azure Data Factory/Biml

SSIS Script Error: Cannot Load Script for Execution

From AndyLeonard.blog()

If I had a nickel for every time I’ve encountered “Cannot load script for execution,” I’d have a lot of nickels. In this short (7:24) video, I demonstrate the...

Internet of Things

The Internet of Things is a Complete Mess (and how to Fix it)

I've spent more time IoT'ing my house over the last year than any sane person ever should. But hey, it's been strange times for all of us and it's kept me entertained...

Performance Tuning SQL Server

The Asynchronous Ledger Trick for Fast SQL Server Insert, Update and Delete Processes

From Eitan Blumin

Do you find yourself facing performance problems a...

Why Are Linked Server Queries So Bad?

From Brent Ozar Unlimited

Remember when you were in school, and you had a cr...

PowerPivot/PowerQuery/PowerBI

How to fix direct Query authentication delegation issues with Power Bi Report Server with Edge and Chrome

With the end of the IE support for Power Bi (and in general tbh), companies are scrambling finally to move their users from the legacy browser to modern ones; it was about time if you ask me.

Calculating Age in Power BI

From DCAC

In week 26 of Workout Wednesday for Power BI, I as...

Power BI Dataset Refresh, Column Encoding And The First Partition

From Chris Webb's BI Blog

If you’ve been following some of my recent posts...

Filter One Slicer Based on Another Slicer in Power BI

From Excelerator BI

This is a follow up article from my last blog post...

Exploring the Power Automate Visual in Power BI | Sending emails

From Guy in a Cube

Using Power Automate? Using Power BI? Why not put ...

How to Name Worksheets in a Paginated Report Exported to Excel

From Paul Turley's SQL Server BI Blog

This question comes up every few years in SQL Server Reporting Services. Of course, in Power BI Paginated Reports, we have the same features. A couple of days ago,...

Replication

SQL Server Transactional Replication Issues

From SQL Server – {coding}Sight

We started talking about SQL Server Transactional Replication issues earlier. Now, we are going to continue with a few more hands-on demos to understand frequently faced Replication performance issues...

SQL Memorial

Crocs and Naps….

From Curious..about data

I was planning a blog post for a TSQL2sday..instea...

RIP Brian Moran

From SQLServerCentral Blogs

When someone older than you dies, it’s sad, thou...

Rest In Peace, Brian Moran

From AndyLeonard.blog()

It grieves me to share that my friend and brother,...

T-SQL

What are SQL Aggregate Functions? (Easy Tips for Newbies)

From SQL Server – {coding}Sight

SQL Aggregate Functions are functions that perfor...

Combinations with Cross Join

From Callihan Data

Have you ever wanted to get the combination of eac...

Starting SQL: Why SELECT * Is a Bad Idea

From Erik Darling Data

Starting SQL: Why SELECT * Is a Bad Idea If you wa...

Using a CTE to Split a String Into Rows with Line Numbers

From Steve Stedman

Years ago while working on my CTE presentation for...

Remove comments from your T-SQL code

From TomazTsql

Removing comments from your T-SQL query can be dau...

TSQL Basics Part 16: EXCEPT INTERSEPT UNION

From Steve Stedman

This is part 16 of a 19 part series on TSQL Basics...

A Different Way to Compare Data

From Sherpa of Data

Last week, we discussed the INTERSECT operator and...

Fundamentals of table expressions, Part 10 – Views, SELECT *, and DDL changes

From SQLPerformance.com

Continuing his series on table expressions, Itzik ...

SQL Server RAISERROR Statement with Simple Examples

From SQL Server – {coding}Sight

The SQL RAISERROR statement is used to send a cust...

Stored Procedure to Delete Duplicate Records in SQL Table

From SQL Server – {coding}Sight

Sometimes during our run as DBAs, we come up acros...

Getting Row Numbers with Window Functions–#SQLNewBlogger

From SQLServerCentral Blogs

Another post for me that is simple and hopefully s...

Padding a string in SQL Server

From SQLStudies

I’ve been working on converting a piece of DB2 c...

Virtualization and Containers/Kubernetes

T-SQL Tuesday 140 – Easy demos using containers

From Kevin Chant

My T-SQL Tuesday contribution for this month is about doing easy demos using containers. Which is hosted by Anthony Nocentino this month...

T-SQL Tuesday #140: What have you been up to with containers?

From No Column Name

So this is a post that will not be educational, but it’s the latest encounter that I’ve had with containers, so it’s the most present in my mind...

T-SQL Tuesday #140 – What have I been doing with Containers

From Deb the DBA

It’s another T-SQL Tuesday! Thanks to Anthony No...

Fun with Containers

From Curated SQL

Barney Lawrence has some fun with containers, star...

 
RSS FeedTwitter
This email has been sent to newsletter@newslettercollector.com. 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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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