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

Daily Coping Tip

Ask for help and let someone else discover the job of giving

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.

Wellness Week

I work for a great company, one that I feel cares about me as more than a "resource", gives me opportunities (with responsibility and accountability, and has some nice benefits. I actually used one of those last week. I get a volunteer day every year, where I can spend time with a charity and get the day off. I used mine to volunteer for Habitat for Humanity in Denver.

During the last two years, Redgate has approached the pandemic and remote work with the idea that we need to be reasonable with each other. We need to understand that some people might have more people in their homes during work hours and may need to provide care for others. They might have other challenges, or just be struggling to cope. We were asked to work with people, rather than against them, and try to support each other as best we could. I think it worked out well, and it showed us that company cares about us.

I know some other companies have done this, though not many. When a friend talks about how their employer supported them or others in difficult times, it's always a surprise, and I am often impressed with how the organizations behave. I thought about that last month when I saw Spotify take a "wellness week" where they closed all their offices for a week. It won't necessarily cure stress and overwork, but it is a bonus chance to let some people unwind.

A few organizations have closed between Christmas and New Year's, or around the holidays, often when they don't have much business taking place. Often this is a chance for them to avoid some costs, and a fair number of them have done this without paying people for that time. It doesn't affect white-collar workers, but it does affect blue-collar ones, and I think that's a very poor message to send to your staff. Giving people an option of more time off is nice, but don't prevent them from working if they need the paycheck.

Lots of organizations slow down around this time of year, and they accept a lower amount of work getting done. I think that's a better strategy, especially if you give people more flexibility to spend time with family or take care of business. Personally, I'd like to see more companies close down for the week and pay employees. If you're not accomplishing much, maybe you should accept that and gain some goodwill by giving people a break.

I know there are lots of roles where this isn't easy. Knowledge workers have it easy compared to those that need to interact with people or things in the real world. We do know, however, the engaged and happy workers will do a better job. They'll get more done, and they'll produce more quality work. I like the idea of "wellness time" where possible to give employees a break. Even if you had to split your staff and give each half a break during different days, it might be a good investment to make in your staff.

Steve Jones - SSC Editor

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

 
 Featured Contents
Stairway to SQL Server Extended Events

Stairway to SQL Server Extended Events Level 1: From SQL Trace to Extended Events

Erin Stellato from SQLServerCentral.com

Over the course of this stairway series, we're going to explore in detail the use of Extended Events as a diagnostic data collection tool, to track down causes of poor performance in SQL Server. This first level will start from a point known and familiar to many DBAs, namely the use of SQL Trace to track down and investigate long-running queries.

External Article

Unity state machine behaviours

Additional Articles from SimpleTalk

Video games would not be much fun without animation. In this article, Lance Talbert demonstrates Unity state machine behaviours to define code running during specific animation states.

External Article

Adding Test Data to Databases During Flyway Migrations

Additional Articles from Redgate

How to add test data to a SQL Server database, during Flyway development. We use SQL Data Generator to produce some "realistic but fake" data and then SQL Data Compare to produce an INSERT script that Flyway can use to load the data into a newly-built version of the database.

Blog Post

From the SQL Server Central Blogs - SQLFAMILY Folding@Home Makes Top 100 Team

Tim Radney from Tim Radney - Database Professional

Back in March 2020 Glenn Berry created the #SQLFamily Folding@Home team and many of us joined in donating compute cycles to helping find a cure for various diseases to...

Blog Post

From the SQL Server Central Blogs - Amazon RDS Custom for SQL Server – A new beginning

AnupWarrier from SQLSailor.com

Imagine getting SA (sysadmin) access to your RDS SQL Server Instance! Well, that was not possible in the past, but during AWS re:Invent 2021, Amazon RDS Custom for SQL...

 

 Question of the Day

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

 

Checking the Sequence

If I want to get the next value that will be returned for a sequence object, called MySequence, what query should I run?

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)

Azure MariaDB

Which compatible Azure database service would you use for a MondoDB workload?

Answer: Azure CosmosDB

Explanation: The Azure CosmosDB service is compatible with MongoDB. Ref: Azure Database Products - https://azure.microsoft.com/en-us/product-categories/databases/

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
T-SQL Error: Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '('. - I could use some help figuring why this use of CONVERT isn't working as expected. --T-SQL Code: 1 SET nocount ON 2 DECLARE @JobName sysname 3 SELECT @JobName = [name] FROM msdb.dbo.sysjobs 4 WHERE Job_id = CONVERT(uniqueidentifier, $(ESCAPE_NONE(JOBID))) 5 PRINT '>'+@JobName+'<' --Error: Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '('. --SQL […]
SQL Server 2016 - Administration
Change tracking disabled but auto cleanup running anyway - I recently noticed in the logs of one of my 2016 servers that the Change Tracking manual cleanup procedure is running for all databases. I have checked the databases and change tracking is off for all of the databases. sys.change_tracking_databases and sys.change_tracking_tables are both empty I tried to just disable the auto cleanup but get […]
Using EE to trace the code generated by an app - Hi all, We have an app that currently requires Admins /Power users to navigate a difficult GUI, but clearly it's sending SQL to the DB.  A first look at the underlying table shows the column names map perfectly to the fields in the form, but of course the table has multiple dependencies, so I'm hoping […]
SQL Server 2016 - Development and T-SQL
help with case statement - Hi I need help with the SQL query.. requirement is that wherever flag is null and room_cd is single for room then it should be labelled as Any_empty and if room_cd is multiple for room then it should be labelled as M_empty or F_empty depends on the majority of flag in room. like in room […]
Development - SQL Server 2014
Query - Hi I have below data and i want if both Sale & Purchase = 'N' then that record should not be displayed Item   Name Purchase Sale 1          AB           Y             N 2         BC           N      […]
Month Name - Hi How to get Month Name from Date field Thanks
SQL Server 2019 - Development
Query Run Time - Hi everyone The query I am working on seems slow to me.  The table has about 600 records and the query takes about 15 seconds to run.  I put on statistics and here is what I get.  I don't know how to interpret this.  Are the stats showing what I am seeing?  I took a […]
How to create a 2nd temp table in SQL - I have such a situation. I basically need to put my whole code into a second temp table(?) to be able to select from it. The code inside works just fine I just cannot understand how to basically create a bigger temp table that will absorb the first one and the previous select and later […]
Issue with NULL not allowing a calculation to happen - I have such a situation I use this command to basically allow division by 0. So far it was working just fine, but now it for some reason no longer works well for me. SET ARITHABORT OFF SET ANSI_WARNINGS OFF   I am trying just to make a simple calculation like this   sk.OH + […]
Arithmetic overflow error converting expression to data type smallint - Hi everyone I am getting error Arithmetic overflow error converting expression to data type smallint The calculation I am doing is producing very small numbers like 0.0000005328. How can I fix the calculation so it produces correctly?  I am guessing I have to typecast the calculation so it works properly because smallint is definitely wrong.  […]
SQL Azure - Development
Getting error 64 when trying to connect to the AdventureWorksLT database - A couple of weeks ago I asked here how to get a sample database into Azure SQL. I got great feedback and was able to get the AdventureWorksLT database into Azure SQL. However, as often happens where I work, I was pulled away to work on other, urgent, tasks. So, I'm only now able […]
Reporting Services
Production setup of SSRS - I'm learning SSRS at this time - I have a SQL Server developer edition, SSRS service and Report Builder installed all in a same VM running on my laptop. I'm trying to figure out what's the best practice setup for production scenarios? I figured the Reporting services will be installed on a web server, which, […]
Powershell
invoke-sqlcmd : Cannot open database requested by the login. login. Login failed - Hello, I am not able to figure out why invoke-sqlcmd is not working. It’s giving login failed error..This user has sysadmin permissions. When the azure release pipeline runs, if the database does not exist then it restores the new database from the .bak file....and i am using invoke-sqlcmd command for that......when i try to run […]
SQLServerCentral.com Website Issues
Emails from forum posts aren't going to the post - I've noticed that the emails about forum posts I've been getting from SQLServerControl.com the last week or so, no longer point to the post in the forum. I just wanted to mention this.
Job Postings
HIRING: Data Warehouse Developer at Center for American Progress - Reports to: Senior Director, Enterprise Systems and Procurement Staff reporting to this position: None Department: Technology Position Classification: Exempt, full time; Nonunion - Level 6 Minimum compensation: $75,000 Summary The Data Warehouse Developer will deliver integration solutions to American Progress. The position will focus on automating integrations between various business systems, including Unanet, Paycom, Salesforce, data services, and data warehouse […]
 

 

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

 

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