| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| 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 |
There are plenty of scenarios where you may want t... |
In this article, we will go through some details a... |
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... |
In this article, we will learn how to migrate data... |
Azure Synapse (SQL Data Warehouse and Data Lake) |
Azure Data Factory & Azure Synapse Analytics F... |
Reading Time: 8 minutes In this post I want to co... |
Click to learn more about author Mathias Golombek.... |
Career Growth and Certifications |
Employers are turning on the charm to attract engi... |
I believe having a Code of Conduct is valuable and... |
Since the start of the Covid-19 pandemic, conferen... |
Fascination has always been with me when thinking ... |
Computing in the Cloud (Azure, Google, AWS) |
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 |
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 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. |
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. |
How to resolve the fully qualified name of a serve... |
Fun with PowerShell Loops |
Researchers see if they can remove sensitive data ... |
Database Design, Theory and Development |
The other day I was creating a table to store some... |
ACID database safeguards can come at a performance... |
DevOps and Continuous Delivery (CI/CD) |
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 |
In this article, we will learn how to develop ETL ... |
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 |
This article explores Persist sampling rate featur... |
In his ongoing series on latches, Paul Randal expl... |
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,... |
In this article, we will take a glance at the fund... |
SARGability is the in-club way of saying ... |
PowerPivot/PowerQuery/PowerBI |
Today I am sharing another of those videos where I... |
In this article, we are going to learn about worki... |
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... |
You may have noticed that a new dataflows connecto... |
CROSSJOIN: Returns a table that is a crossjoin of ... |
Recording video is hard. So much goes into it that... |
In 2021, I said goodbye WordPress and hello Hugo. ... |
Address these five common cloud security issues to... |
We’re no strangers to doing things in T-SQL that... |
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... |
The OUTPUT clause is often times underappreciated ... |
The SQL Server identity column is used to populate... |
SQL introduced the new STRING_AGG feature in SQL 2... |
In this corner, with a total of 10 letters – we ... |
Virtualization and Containers/Kubernetes |
One of the big mistakes that I see when working wi... |
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. |
|
|