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
 

What to do with more free time

Many data professionals have begun working remotely over the past year and a half which translates to less time spent commuting. In my own case, I’ve been a remote worker for almost ten years, but before that I spent two hours on the road each day.

This got me wondering what folks have done with the extra time no longer used driving back and forth to work. There have been more childcare duties in some cases, as kids may have been attending school remotely, but it also has been the time to pick up some new hobbies or volunteer at a nonprofit. Since I’ve been working from home, I get more sleep. I’m a night owl, so I love waking up 15 minutes or so before my workday begins.

I would guess the most popular new hobby of the pandemic was baking bread, especially sourdough. Many of my friends posted about baking on social media. This article lists the top new hobbies, although I wouldn’t call watching TV a hobby! Since the lockdowns began, I’ve devoted more time to my interests in crocheting and 3D printing, but I also picked up a new one, cookie decorating.

Over the years, friends in the data platform community have formed unofficial interest groups around running, photography, scuba diving, karaoke, and more. These hobbies may be relaxing or at least a creative outlet that allows one to forget about work for a bit. The best was when many us with 3D printers made ear-savers to help hospital and other front-line workers.

On the other hand, no one should feel guilty for downtime, and hobbies shouldn’t add more stress. I love the session given by Jes Schultz where she explains how not to be “busy” and when to say “no.” I’ve used her advice many times, although I do love big projects and sometimes take on too much.

Hobbies should be enjoyable and not make our lives more hectic. Free time is precious, so we all must spend it wisely, and sometimes doing nothing is better than filling up every minute.

 

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.
Administration of SQL Server

Moving Data to a New Filegroup

From Callihan Data

There are plenty of scenarios where you may want t...

Deep Dive into SQL Server Statistics

From SQLShack

In this article, we will go through some details a...

How to change an Azure SQL Database Collation

From SQLShack

This article explores the Azure SQL Database Collation configuration and how to change it while importing the database from a BACPAC file. Introduction The collation refers to a configuration...

Azure SQL Database

Data Migration from Azure SQL Database to Azure Database for PostgreSQL

From SQLShack

In this article, we will learn how to migrate data...

Azure Synapse (SQL Data Warehouse and Data Lake)

An Introduction to Azure Data Integration Pipelines

From Paul Andrew

Azure Data Factory & Azure Synapse Analytics F...

Azure Test Plans example for Azure Synapse Analytics

From Kevin Chant

Reading Time: 8 minutes In this post I want to co...

Big Data

Big Data at 10: Did Bigger Mean Better?

From Dataversity

Click to learn more about author Mathias Golombek....

Career Growth and Certifications

Looking for a new job in tech? It may be your lucky day

From Ars Technica

Employers are turning on the charm to attract engi...

Community Interests

Why a Code of Conduct is Valuable

From SQLGene – Learning SQL Slowly

I believe having a Code of Conduct is valuable and...

Recorded conference sessions

From SQL Server Fast

Since the start of the Covid-19 pandemic, conferen...

The Power of User Groups

From SQLServerCentral Blogs

Fascination has always been with me when thinking ...

Computing in the Cloud (Azure, Google, AWS)

Single-cloud versus Multi-cloud

From SQLServerCentral Blogs

A discussion I have seen many companies have is if they should be single-cloud (using only one cloud company) or multi-cloud (using more than one cloud company). The three... The...

Conferences, Classes, Events, and Webinars

Register Now For PASS Data Community Summit 2021

Registration is now open for our free and online data platform conference. Join 1000s of your data peers at PASS Data Community Summit and get access to up to 5 days of training, sessions, networking activities, and events. This year's program has been carefully designed to help you achieve your goals, wherever you are in your data career.

Donovan Brown & Mark Fussell: Cloud Native development with Dapr

Donovan Brown and Mark Fussell, Program Managers from the Azure CTO Incubations team at Microsoft, join Steve Jones to talk all things modern Cloud Native development with Dapr.

Why effective monitoring is essential for your growing estate

Join Grant Fritchey and database professionals from WestJet, Fiducia Gad and Richemont to learn how effective estate monitoring enables them to manage continually evolving environments, and intensifying data demands.

DMO/SMO/Powershell

How to resolve a hostname or ip address with Powershell

From SQLServer-DBA.Com

How to resolve the fully qualified name of a serve...

Fun with PowerShell Loops

From Arcane Code

Fun with PowerShell Loops

Data Science

Now that machines can learn, can they unlearn?

From Ars Technica

Researchers see if they can remove sensitive data ...

Database Design, Theory and Development

The sysname datatype defaults to not NULL.

From SQLStudies

The other day I was creating a table to store some...

When Is It OK to Drop ACID Database Safeguards?

From IT Pro - Microsoft Windows Information, Solutions, Tools

ACID database safeguards can come at a performance...

DevOps and Continuous Delivery (CI/CD)

How to Use AI for SQL Tuning for a Real Automated Process

From SQL Server – {coding}Sight

The rapid evolution in development from rigidly structured data to responsive, flexible databases allows database administrators (DBAs) to work closely with developers. DBAs are often tasked with finding ways...

ETL/SSIS/Azure Data Factory/Biml

Develop ETL templates for Data Warehousing using Azure Data Factory

From SQLShack

In this article, we will learn how to develop ETL ...

JSON

Think twice about storing JSON in your SQL Server database

From Born SQL

During routine maintenance on a customer’s production server, I discovered that they have one table consuming 40% of the storage in their database. That table contains just under 10...

Performance Tuning SQL Server

Persist sampling rate for automatic SQL Server statistics updates

From SQLShack

This article explores Persist sampling rate featur...

The APPEND_ONLY_STORAGE_INSERT_POINT Latch

From SQLPerformance

In his ongoing series on latches, Paul Randal expl...

SARGability Week: Using Dynamic SQL To Fix Non-SARGable Queries

From Erik Darling Data

Specific The non-SARGABLE pattern that dynamic SQL helps you deal with is the the catch all query pattern, which can look like: col = @parameter or @parameter is null col = isnull(@parameter,...

Fundamentals of SQL Server Statistics

From SQLShack

In this article, we will take a glance at the fund...

SARGability Week: What Is It, Anyway?

From Erik Darling Data

SARGability is the in-club way of saying ...

PowerPivot/PowerQuery/PowerBI

Comparing Events in Power BI

From Excelerator BI

Today I am sharing another of those videos where I...

Working with Python in Power BI

From SQLShack

In this article, we are going to learn about worki...

A Step-by-Step Overview of Paginated Reports in Power BI

From BlueGranite Blog

Paginated Reports for Power BI offer pixel-perfect control over the format of each element of a report. They allow users to fine-tune each field of the report, such as...

How Query Folding And The New Power BI Dataflows Connector Can Help Dataset Refresh Performance

From Chris Webb's BI Blog

You may have noticed that a new dataflows connecto...

CROSSJOIN – DAX Guide

From SQLBI

CROSSJOIN: Returns a table that is a crossjoin of ...

Professional Development

5 Guy in a Cube tips to make BETTER VIDEO!

From Guy in a Cube

Recording video is hard. So much goes into it that...

Goodbye WordPress, Hello Hugo!

From Cathrine Wilhelmsen

In 2021, I said goodbye WordPress and hello Hugo. ...

Security News and Issues

5 Vexing Cloud Security Issues

From IT Pro - Microsoft Windows Information, Solutions, Tools

Address these five common cloud security issues to...

T-SQL

Optimizing a string split and search

From Sunday morning T

We’re no strangers to doing things in T-SQL that...

How to Use SQL SUM Function

From SQL Server – {coding}Sight

SQL is a powerful and widely-used programming language for data storage, retrieval, and manipulation. One of the most commonly-used operators in SQL is SUM – a logical operation that...

Using the OUTPUT Clause in TSQL for Auditing

From Steve Stedman

The OUTPUT clause is often times underappreciated ...

SQL Server identity column

From Simple Talk

The SQL Server identity column is used to populate...

Distinct List in String_Agg

From Greg's Ramblings SQL, Programming and IT Life

SQL introduced the new STRING_AGG feature in SQL 2...

CROSS vs OUTER: Knockdown drag-out free for all

From Sherpa of Data

In this corner, with a total of 10 letters – we ...

Virtualization and Containers/Kubernetes

Virtual Machines in the Cloud can be smaller than On-Premises

From DCAC

One of the big mistakes that I see when working wi...

 
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. 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

 

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