SQLServerCentral.com Community Update for {date}

Problems displaying this newsletter? View online.

Featured Contents

Question of the Day

The Greatest of All

The Voice of the DBA

Daily Coping Tip

Look around and spot three things you find unusual or pleasant

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.

The Right to Repair

I'm a do-it-yourself (DIY) person in many ways. I work on equipment on the ranch, repair or improve things in the house, and often tackle electrical or mechanical tasks. I've replaced hydraulic hoses, changed oil, replaced brakes, changed outlets, wired up lights, and more. I keep a hand cleaning degreaser handy and use it regularly.

I think many people who work in software development are the same way, and often I find they want to rebuild things themselves rather than adopt or improve what's there. Many organizations have a fair amount of NIH Syndrome inside that results in money and resources spent on software that might be better used elsewhere. I think some of this is going away as current trends in software make use of APIs, OSS, and services to cobble together a workflow rather than just building something from scratch.

However, that's not always something we can do. In fact, we often can't take apart commercial software and fix it, not even when it's broken and in need of repair. That same philosophy is starting to pervade products in the real world, which is disappointing to me as someone that likes to be able to repair something I own.

There is a good article on the right to repair over at Make magazine. In this case, the argument is that there are certain restrictions manufacturers put in place to limit the ability of individuals or third parties to repair products. In the physical world, I think this is a problem for actual devices, but it's also becoming an issue as software pervades the operation of many physical devices. One of the higher-profile complaints has been with tractor service.

I don't know how we reconcile the right to repair and own something with the intellectual property rights of software. It is a thorny issue, and one that I am not sure of how I would want to frame the rights, but I do hope that we at least ensure that physical products people own can be repaired by individuals, including the ability to "reset" software as needed.

Steve Jones - SSC Editor

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

Featured Contents

Data and database management in everchanging technology landscape

roopesh.uniyal@gmail.com from SQLServerCentral

This article discusses how the cloud and other technologies help companies to manage their data appropriately in the modern world.

What is Change Management?

Additional Articles from SimpleTalk

Change manage is a process to prepare an organization to implement change. In this article, Rohan Kapoor explains the five components of change management.

How to get DevOps buy-in across your organization

Additional Articles from Redgate

In our latest DevOps 101 Series live webinar Grant Fritchey discusses why the key to successful DevOps implementation is gaining buy-in, and how you can achieve this in your organization.

From the SQL Server Central Blogs - KQL and ADX – Is this really like SQL?

Martin Catherall from measure twice, cut once.

Hopefully, you’re aware that Azure Data Explorer can be accessed by anybody with a valid Microsoft Account Identity or MSA for short. If you need a one, then hop...

From the SQL Server Central Blogs - Metadata-driven pipelines in Azure Data Factory | Part 1

Rayis Imayev from Data Adventures

(2022-Mar-04) Looking in the Oxford dictionary, Metadata can be described as "information that describes other information in order to help you understand or use it", as well as Pipeline is "a series...

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	The Greatest of All
What does this code return in an Azure SQL Database? SELECT so.OrderTotal - GREATEST( so.discount1, so.discount2, so.discount3) FROM SalesOrder so
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)

Starting a Pipeline

In Azure Data Factory, which item will initiate the execution of a pipeline?

Answer: a trigger

Explanation: A trigger is used to start an ADF pipeline. The trigger can be manual, a schedule, or various types of events. Ref: Pipelines Execution and Triggers - https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers

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

Need advice on optimizing a query - Hi All, We have an application internal query which runs multiple times and it is taking ~30 mins. The query is selecting data from a VIEW. Wanted to know the causes of slowness of the query and looking for any possible recommendations. This database is vendor specific database and the query is generated/executed by that […]

SQL Server 2016 - Administration

Changing license in SQL Cluster environment - Hello, We have installed Enterprise edition for SQL Serve cluster environment (Two node) based on client requirement. But, now client wanted to change the SQL server edition to Standard edition due to some licensing issue. Is there any option to downgrade SQL cluster from Enterprise to Standard edition or do i have to completely destroy […]

Free Space on Clustered Environment - Hello! The script outputs the mounted disk information, what do I need to incorporate to get information for drives that are local to that particular node like C:\? SELECT DISTINCT volume_mount_point [Disk Mount Point], file_system_type [File System Type], logical_volume_name as [Logical Drive Name], CONVERT(DECIMAL(18,2),total_bytes/1073741824.0) AS [Total Size in GB], ---1GB = 1073741824 bytes CONVERT(DECIMAL(18,2),available_bytes/1073741824.0) AS […]

SQL Server 2016 - Development and T-SQL

SSRS Matrix - Conditional expression to change Background color based on value - I have a matrix in my SSRS 2016 reporting services report. I am trying to set a conditional expression on background color for the sum(field.value). This field is formatted as a percent. Here is my expression which does appear to have any errors: Background Color Expression: =Switch(Fields!PicturesbeforeFirstSignoutCount.Value<.80,"Red",Fields!PicturesbeforeFirstSignoutCount.Value >= .80 and Fields!PicturesbeforeFirstSignoutCount.Value < .95,"Yellow",Fields!PicturesbeforeFirstSignoutCount.Value >= .95,"lightGreen") […]

Development - SQL Server 2014

Simple sort makes query hang - I have a fairly simple query that is supposed to return only a single number – the ID of the TOP record from the query. It is not especially elegant, but it works well, except for the Sort clause. When I select and execute all but the Sort clause, it executes instantly, but naturally does […]

SQL 2012 - General

How to make select statment get data based on partid from last date with gapes ? - I work on sql server 2012 i face issue i need to make select statment get Partid from last month until current month based on last date exist per partid and on same time if there are any gaps between dates then file it based on last date so first case if i found partid […]

SQL Server 2019 - Administration

(707) 710-9881 ➽ Delta Airlines Reservations Contact Number - Delta Airlines Reservations Contact Number (707) 710-9881 Delta Airlines Reservations Contact Number (707) 710-9881 Delta Airlines Reservations Contact Number (707) 710-9881 Delta Airlines Reservations Contact Number (707) 710-9881 Delta Airlines Reservations Contact Number (707) 710-9881 Delta Airlines Reservations Contact Number (707) 710-9881 How to Quickly Get in Touch with Delta Airlines? Help Center Delta […]

Always On - We had log backup issue due to the space filled up on the backup drive, and that caused the database to be in suspended state on the secondary replica due to not enough space on the disk . I could not able shrink the database on primary due to suspended state on the secondary replica […]

SSD drives for SQL Server - Our company is using a Citrix farm for some of our SQL Servers (2019), they currently have an SSD for their storage so our servers have the tempdb/data/logs all using the E drive. Does it make sense to try and have these files separated out since they are now on SSD drives? I have asked […]

SQL Server 2019 Instance Name Change - I am running SQL 2019 on Windows 2019 server and have come across an issue I have not seen before and cannot find a resolution on the web. I have went through the normal process of changing the Instance name by using the following.. EXEC sp_dropserver '<old_name\instancename>'; GO EXEC sp_addserver '<new_name\instancename>', local; GO I rebooted […]

SQL Server 2019 - Development

Finding duplicates in a table with 20 million records - HI All I have a huge table with 20M records with around 70 columns. I need to check if a combination of 30 columns has duplicate values. Use of Group by takes too long and is very heavy on tempdb. I was thinking to concatenate the 30 columns and do a CHECKSUM and then group […]

SQL Azure - Development

Sales Force Connector Question - Hello All - I have a question regarding the Sales Force Connector in a logic flow. I'm very new to this and haven't been able to find any answers via endless searching. I'm able to create a flow which connects to my instance of Sales Force. I need to return accounts and their corresponding account […]

Azure Data Factory

Staging issue for Copy data using non-standard table name - This is an issue I've encountered in ADF/Synapse Pipelines when looking to Ingest a table from SAP that have non-standard characters in them. The copy bombs out giving an error message: { "errorCode": "2200", "message": "Failure happened on 'Sink' side. ErrorCode=AdlsGen2OperationFailed, 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Operation returned an invalid status code 'BadRequest'. Account: 'ingvdatalakenp'. […]

Design Ideas and Questions

Denormalized as much as possible - Please assist? I would like to model this data(https://docs.google.com/spreadsheets/d/1-9x4ean4QleYODvu8GsAsgm8OKVjABeM/edit?usp=sharing&ouid=104129043494164133703&rtpof=true&sd=true) for Bigquery as much as possible in a denormalized data model. Bigquery favours denormalized data models. I am busing creating the data model of the data tab/table in the sheet. The Data tab/table contains the data as it comes from CM360(data source). Journey and Mapping Tab/table […]

Business Intelligence

compare and insert - Hello, new to ssis so wanted to find out how to compare the data in the destination then get data from source and insert what exist (in source) for example i have set of record id in the destination. based on that i need to bring that record id only from source to destination. Thanks […]

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.