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

Daily Coping Tip

If you’re busy, allow yourself to pause and take a break

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.

Poor Work Management

The future of how we will work is uncertain. Every time I read something or talk to someone, I hear different thoughts and experiences, which influence how I feel. Actually, I'm not sure how I feel. Some companies are pushing back their office openings (Google, Microsoft) to a future time, while others are bringing people back part or full time. I had lunch with some friends working at a financial institution, and they are allowed to work at home a day or two a week, but otherwise, they're in the office every week. I know some other people that are back in the office five days a week.

There are mixed feelings among many people. While I don't know many technology people that want to be in the office every day, some do want the option to go periodically to the office. Depending on your commute, you might feel differently, as there are plenty of data pros that want to remain at home full time. Both groups, however, feel that we can be effective at our jobs while working remotely.

Not all management feels thtat same way, for various reasons. I ran across this piece that speculates that poor management is more likely to fear remote work than embrace it. The example in the piece, from Cathy Merill, certainly seems to indicate this is the case. While I've seen some great managers, I feel many managers aren't good at adapting to dramatic changes and struggle to change their own view of how to do their job.

I do think culture suffers when we can't get together in person. Hallway conversations and chats over coffee aren't as easy remotely, and we don't build the same bond we get in the office. Working separately at home can work, and we've had a lot of success at Redgate, but I also feel more separate from lots of co-workers and miss the chance to get together and catch up. The remote meetings are not the same, and scheduling a quick call is much more of an intrusion than being able to walk by someone's desk or stop for a minute when I see them in the hall.

Perhaps it's the energy from being around lots of people that CEOs and other management miss. It can be invigorating and exciting when lots of people are working together towards a common goal and succeeding. Perhaps management prefers to look someone in the eye and put pressure on them for a lack of performance. That is harder to do virtually, and I know lots of managers that work through intimidation.

There's also the investment made in offices. Over the years I've seen various configurations and amenities in offices, often to encourage more work and comfort away from home. I know plenty of CEOs and leaders that feel this investment needs to be used by staff for lots of hours each week because of the cost, which seems like a poor excuse to me. That money is spent. These days I suspect more employees push back on longer hours, as they should, and find comfort at home, which might also bother management.

This issue is complex, but I do know that whether we're remote or in an office, we can be effective and get work done in teams. Management should know that and use it to try and build an environment that gets the most out of all their staff, whether in the office or remote.

Steve Jones - SSC Editor

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

pass-pro-educational-series
 
 Featured Contents

Azure SQL Migrations using Azure Data Studio

bake13 from SQLServerCentral

This article looks at database migration with the Azure Data Studio extension, making it easy to move databases from an on premises SQL Server to one in Azure.

Author Power BI Reports on Real-Time ServiceNow Data

JerodJ from SQLServerCentral

This article shows in detail how to use the Power BI Connector to create real-time visualizations of ServiceNow data in Microsoft Power BI Desktop. 

The Azure SQL portfolio

Additional Articles from SimpleTalk

Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon explains the Azure SQL options.

From the SQL Server Central Blogs - Changing the Connection for Data Masker

Steve Jones - SSC Editor from The Voice of the DBA

Data Masker for SQL Server is a great tool ensuring the data you use in non-production environments is compliant with any regulations by obfuscating and changing sensitive data. This...

From the SQL Server Central Blogs - PASS Data Community Summit 2021 Precon Announcement

kleegeek from Technobabble by Klee from @kleegeek

I’m thrilled to announce my preconference training session ahead of this year’s virtual PASS Data Community Summit, held during the week of November 8-12, 2021. This event is available...

 

 Question of the Day

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

 

STRING_SPLIT Separators

I have a SQL Server 2017 database. I want to use the STRING_SPLIT() function to separate some data. For the separator, what are my options?

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)

Getting the JSON Index

I have this JSON document:

DECLARE @Json NVARCHAR(MAX)
    = N'
[
    {
        "Name": "Broncos",
        "Division": "AFC West"
    },
    {
        "Name": "Chiefs",
        "Division": "AFC West"
    },
    {
        "Name": "Steelers",
        "Division": "AFC North"
    },
    {
        "Name": "Colts",
        "Division": "AFC South"
    }
];';

I want to query this and get a result set like this:

Element  Team     Division
-------- -------- ------------------------------------------------
0        Broncos  AFC West
1        Chiefs   AFC West
2        Steelers AFC North
3        Colts    AFC South

I have this query, but what do I put in place of "xxx" to get the index value of the data?

SELECT A.[xxx] AS Element,
       JSON_VALUE(A.Value, '$.Name') AS Team,
       JSON_VALUE(A.Value, '$.Division') AS Division
FROM OPENJSON(@Json) AS A;

Answer: key

Explanation: The OPENJSON() returns these fields by default if there is no schema specified:

  • key
  • value
  • type

The key is the index of the element. It can also be the property name is something is specified, but in this case, the index is returned. Ref: OPENJSON - https://docs.microsoft.com/en-us/sql/t-sql/functions/openjson-transact-sql?view=sql-server-ver15

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
Wait stats - I am not seeing any high resource utilization like CPU/Memory and Disk queue length. But seeing a waits  during the performance issues. Is that be related to the issue? Please advise?
SQL Server 2017 - Development
Need help on ( Keep it existing, Add new ) & ( Remove existing, Add new ) - I've table & EXISTING data as below, Scripts as following, CREATE TABLE [dbo].[IncidentProgressAssignPeople]( [Id] [int] IDENTITY(1,1) NOT NULL, [IncidentProgressId] [int] NOT NULL, [ToUserId] [nvarchar](450) NOT NULL, [ReplyDate] [datetime] NOT NULL, [isInProgress] [bit] NULL, [isInProgressDate] [datetime] NULL, [isResolved] [bit] NULL, [isResolvedDate] [datetime] NULL, [dtVersion] [timestamp] NULL, CONSTRAINT [PK_IncidentProgressAssignPeople] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX […]
SQL Server 2016 - Administration
AD Group SQL Login Access Details - Good Morning, We have AD Group with members. The AD Group is created as SQL Server login. I would like to know what all access this login has. Please let me know.
Default Trace File Q - Are Does Not Exist and Do Not Have Permission events inc - SQL SERVER 2016 (13.0.5026.0) NOTE: The reference SQL code is not something I/We created but was setup by Prophix when they implemented the system for us. I am only responsible for trouble-shooting it when things fail, not for the T-SQL code it uses. We have a B2B app named Prophix that drops an existing table […]
Administration - SQL Server 2014
Probleme With Access to Reporting Services SSRS - Hi I have a problem when i try tio display Report, (Win Server  2008R2 And SQL 2014 ) i can access only with a Local account, but for the athers AD account it display an error like see attach, But before it s working correctly. Withe the local account i can display the page, but […]
3 node Always On but only 1 node points to correct listener IP - Hello, I have 3 node SQL server 2014 SP3-CU4-GDR, and each server is on a different subnet: server1: 192.168.1.25 server2: 192.168.2.25 server3: 192.168.3.25 and I have the listener with mutliple subnets configured like so: 192.168.1.0/24 - ip address 192.168.1.26 192.168.2.0/24 - ip address 192.168.2.26 192.168.3.0/24 - ip address 192.168.3.26 192.168.4.0/24 - ip address 192.168.4.26 so […]
SQL 2012 - General
What makes MS SQL Server worth paying for over MySQL? - Considering well designed, large DBs that have high usage, what do MS SQL Server and another commercial DB systems offer that MySQL and other free systems don't? Is it a performance thing? security, backup, redundancy?
How to use inner join instead of where exists statment ? - I work on sql server 2012 i face issue ican't replace (where exists) by inner join so How to do it SELECT pr.partid from parts.Nop_Part pr with(nolock) inner join extractreports.dbo.RequiredPartsPL rp with(nolock) on rp.partid=pr.partid inner join Parts.Nop_PackageAttribute pa WITH(NOLOCK) on pa.packageid=pr.packageid inner JOIN dbo.Core_DataDefinitionDetails dd WITH(NOLOCK) ON pa.[Key] = dd.ColumnNumber --and dd.acceptedvalueid=64 where exists(select 1 […]
SQL Server 2019 - Development
Copy files from folder using SQL Server. - Good day everyone. I hope someone can help me on that one. I have a database that include file folder and document location into tables and the actual document is store on a document server. I would like to copy specific documents to a different location and rename the document to a more readable name […]
Merge Conflicts with SQL Server Database Project - I hope someone more familiar with database projects can provide me some guidance. I am currently trying to introduce a better source control solution and automated deployment solution for a project I have joined. The current state is I have a database project in Visual Studio 2019 which will be used to maintain an Azure […]
Implicit conversion on hash key column is causes very slow insert - I am trying to insert some data into some stage tables where the insert is taking far too long. For example a table containing up 600000 records is taking nearly an hour to complete. In the select part of the query we are are creating a hash of the columns which is later used for […]
SQL Azure - Development
Unable to add data disk in Azure SQL Virtual Machine - Trying to extend my data disk to get some free space in the drive. But I couldn't able to resize the data disk in my SQL Virtual Machine in Azure as the resize option greyed out. And the disk is managed disks only. Please some one can suggest me on this...., it would be greatly […]
Amazon AWS and other cloud vendors
Does AWS RDS SQL SERVER support to file access from EC2 server local path? - I would like see is there any option to access the EC2 machine file from RSD SQL Server? Notes: EC2 and RDS were in the same VPC. I am using RDS SQL server Standard Edition.   Can you please help me on this? if it doesn't are there any plans to? Thanks in advance!
General Cloud Computing Questions
anyone using vercel sqlite3? - Hello! I am trying to use sqlite3 on Vercel just to setup my environment, but I don't know how. I saw that when deploying python app, Vercel installs sqlite3 on their own but I can't find a way to access it ... my python app can't find sqlite3 module . How can I get an […]
SSDT
Execute sql task behave differently when run in isolation versus part of package - SQL Server 2019 Azure. I have a basic fact load package that someone has tagged an execute sql object onto the end of that updates various fields in a fact table. when I run the whole package, 2 out of the 6 columns do not update and when selecting from the table, they appear as […]
 

 

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

 

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