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

Daily Coping Tip

Plan a fun or exciting activity to look forward to.

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

Life Organization

For years, those of us in technology have often worked outside of the core working hours for our organization. Whether this is being on-call, staying late, or coming in when asked. It's not uncommon for many developers and Ops staff to work 60, 70, or more hours to get things built/deployed/supported for our customers.

Often we do this while juggling lots of tasks on a to-do list. While many things might be in a ticketing system, often I find there are tasks on a project plan, requests from team members, and other items which don't fit neatly into a ticket. I'm juggling more than one to-do list.

The line between work and personal life has often been blurred. I've taken work calls on the golf course, in an airport, late at night in my bathroom, while shopping with my wife, even at kid's sporting events. I regret not pushing back more to a few managers early in my career, but I also recognize that I (and many of you) are sometimes in poor cultural situations and we don't have a choice if we want to keep employed.

A quick reasoning why I feel this way, and perhaps why some of you do. I had a boss paging my on a Friday night while I was at a comedy club with my wife. I walked outside to take the call during a break and was told I wasn"t responding quick enough to the call. The emergency? A test of how quickly I'd respond on a Friday night. Note that we were not a 24x7 business. I was asked to resign on Monday after pushing back Friday night that I wasn't answering any more pages that weekend.

With the pandemic, and many of us data professionals working from home, the line between work and personal life has blurred further. In many cases, our work isn't bound by a clock, and we might easily move some work to personal time to take personal time during working hours. Trading an hour after kid's bedtime to work so that you can lunch with them during the day seems like a good thing all around.

However, what I'm wondering today is how we start to manage and juggle all our tasks when we might not easily be able to separate all our time into work and personal? We might have work deliverables, which are already in multiple to-do lists. Our partner might ask us to handle some items around the house, we have scheduled events for kids or friends, or even ourselves. Perhaps we volunteer at the user group, a church, or other place and we have various deliverable items we've agreed to handle.

On top of the myriad of tasks, some of these repeat regularly and might not have due dates. How we you handle keeping track of all the things in your life?

I'll admit I don't do this well. I put most things with specific deadlines on a calendar as meetings. These include speaking engagements, travel, meetings, doctor's appointments, and coaching events. If I need prep time, I'll often schedule a few earlier meetings to either prep or remind myself I have something coming.

For other To-do items, I sometimes put them on a list, but I find the lists growing out of control, and I don't have a good handle on how to think about tracking UTV oil changes, vacation planning, getting a package to my daughter, fixing a fence post at the ranch, reaching out to a UG to speak, and more. I don't have a good way to track, visualize, prioritize (or re-prioritize) these items in a busy life.

In some sense, life is somehow out of control and chaotic, and I tackle things when I have time and think about an item. Or I respond to a crisis.

Someone asked me how I keep organized, and I realized I'm not very organized. I do a good job with many things, but there are plenty aren't well organized. Fortunately, there isn't a lot of need to have these items tightly scheduled, and like technical debt, I can let some of them go for days or weeks (or months).

If you have ideas, suggestions, or you suffer from the same issues, I'd love to know what works for you, or just that you feel things are out of control as well.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Cassandra Springboot Integration

Shivayan Mukherjee from SQLServerCentral

In this article, you will see how to initialize a Cassandra database that is used in a Springboot application.

External Article

Join a community like no other at Summit

Additional Articles from Redgate

There's not long until PASS Data Community Summit takes place. There's still time to register for an in-person or online pass, and unlock access to over 300 world-class sessions. Join liked-minded attendees at the year's largest hybrid data platform conference. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE
Register now

External Article

Leveraging the Script Activity within Azure Data Factory

Additional Articles from MSSQLTips.com

Learn how to use the Script activity in an Azure Data Factory pipeline to deploy and populate databases using DDL, DCL, and DML statements.

Blog Post

From the SQL Server Central Blogs - From Manual to DevOps at the Data Community Summit

Steve Jones - SSC Editor from The Voice of the DBA

This year the annual PASS Data Community Summit is hybrid, both in-person and virtual. It’s exciting to have this coming back and I look forward to seeing people in...

Blog Post

From the SQL Server Central Blogs - Notes on SQLSaturday Orlando 2022

Andy Warren from SQLAndy

First, the numbers. We registered 240 people, had about 110 on site. That’s definitely better than last year and still quite a bit under what it was pre-Covid. I’ll...

 

 Question of the Day

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

 

The Azure Database Timezone

How can I check the current timezone of an Azure SQL Database or a Managed Instance from a client?

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)

PARSEing strings

What does the PARSE() function do?

Answer: Converts a string value to a new data type, using a language or culture parameter

Explanation: PARSE() is a function that is designed to convert strings to other data types, date/time or numerics. This can be done with an optional culture parameter. If no culture is included, then whatever SET LANGUAGE is set to is used. Ref: PARSE() - https://learn.microsoft.com/en-us/sql/t-sql/functions/parse-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 2016 - Administration
WinRm run Invoke-ProcessPartition : A connection cannot be made - I have a script which is used to connect to a remote SQL Server. It works well when in local Windows environment. However, when I run it use winrm on another server, this exception happens: Invoke-ProcessPartition : A connection cannot be made. Ensure that the server is running CategoryInfo : NotSpecified: (:) [Invoke-ProcessPartition], ConnectionException FullyQualifiedErrorId […]
SQL Server 2016 - Development and T-SQL
Table Header with Dynamic Dates - Hello,  I need to create a dynamic table that produces a Date Column Header based on Date parameters entered, is this possible?  My table is as follows, followed by the desired results: CREATE TABLE #t (CustID int, StaffID int, JobID int, Dt datetime, Units money) INSERT INTO #t (CustID, StaffID, JobID, Dt, Units) VALUES (101, […]
Euro Symbol and Collations - I'm looking to see if I can support all Western European languages in Non-Unicode columns and the first thing that sprang to mind was supporting the Euro currency symbol €. It seemed to work, but when I changed the Collation to SQL_Latin1_General_CP850_CI_AI it failed unless I declared the value as NVARCHAR.  I'm forced to work […]
CONCAT and SUM from one dataset in SQL Server 2016 - Given the sample date: ID Code Store Value 1 PEN BAJA 10 2 PEN BAJA 15 3 NOTEBOOK LA 27 Is there a query which will output the data: ID Code Store Value 1,2 PEN BAJA 25 3 NOTEBOOK LA 27 The values for code and store are unknown in advance (so can't use any […]
Administration - SQL Server 2014
Windows Account getting wrong SID when added to SQL Server - I have a truly odd one and wonder if anyone else has even seen this. I have a situation where multiple accounts were accidentally got deleted from the domain. The accounts were not able to be recovered so they were recreated and I have been going through the servers dropping the users from the DBs […]
SQL Server 2019 - Administration
MS Access to SQK - We have a department that has quite a few Microsoft access databases. MDB files. They don't have resources to build applications so they created Access db to use with forms and reports on it. They would like to export data from some of the tables into SQL server, so that they can use together with […]
SQL Server 2019 - Development
Split column into multiple column/rows - Hi, I hope someone can help with an issue I'm facing. Within the database I'm working with there is a Column that holds multiple Values and display descriptions e.g [{"display":"Section1","value":"1"},{"display":"Section2","value":"2"}] What is the best way to split the column information into multiple columns so I can can have a 2 columns e.g.  Value and Display […]
Query table results for Yesterday not giving results for just yesterday - I have tried a couple of where clause statements for date yesterday. No matter what I put in there it provides results for the entire table. Here is the query; USE [nms_rt] GO SELECT [Timestamp] AS 'DateTime' ,[Name] AS 'Location Name' ,[AtcsLine] AS 'Line' ,[AtcsGroup] AS 'Group' ,[Error] AS 'Errors' ,COUNT([Error]) over (partition by [Name] […]
Case Statement give me an error - CASE WHEN PM_PROJECT.PROJ_MGR_ID IS NULL THEN CASE WHEN PM_PROJECT.SCHED_MGR_ID IS NULL THEN ' ' ELSE SCH_MNGR END ELSE PROJ_MNGR END PM_SM, Option 2 NVL2(PM_PROJECT.SCHED_MGR_ID,SCH_MNGR,PROJ_MNGR) PM_SM,
Cube Deployment issue - Hi All, I am kind of lost . SSAS Cube deployment with the message 'You cannot deploy the model because the localhost\SQL deployment server is not running in multidimensional mode. 0 ' I have searched all the forms and everywhere tried to accommodate the fixes they have given. But still no luck. I am able […]
SQL Azure - Administration
Unable to Connect to Azure PaaS Instance using SSMS 18.x - Good Morning Team, When we try to connect to Azure PaaS instance using SSMS 18.x from our VDI's; we are unable to connect and receive Error Message 10060. The same Azure PaaS Instances are reachable from our Azure VM's using SSMS without any issues. However on the VDI's; In SSMS->Additional Connection Parameters; if we specify […]
Azure Data Factory
Newbie Azure Data Factory question. - Hello! When setting up a sink in ADF, what makes the "Preview data" button update in the destination data set? When I make changes to the pipeline, I want to look at the results, but they stay the same. Thank you!
Reporting Services
Adding report inputs to history by extension or js - Is there a way to add all queries/inputs you queried with to be added to the normal browser history so you can look through them the other day?? And go back and forward at anytime?
SSRS 2012
Repeating Rectangle/Tablix - Hi there, I'm trying to enable a rectangle or tablix to repeat on every page i.e like an invoice but I don't want it to be in the header. Even when I set to repeat on pages to true it still won't repeat. Is there another way to do this? Thanks in advance Liam
General
What's been your most favorite/fun project you've worked on? - I'm looking for something fun to make. I love learning about all the intricacies of programming and how something was made like RCT2 or small programs that made you money without knowing it would. What's coolest thing you've programmed?
 

 

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

 

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