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

Daily Coping Tip

Set an intention to live with awareness and kindness

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.

Disclosing the How

Many of us have written a computer program of some sort. Maybe just a script to complete a task, maybe complex software the clients interact with. For all of us, I would guess that we've been asked to do something, or we've asked ourselves to build a program, and we use that request as a specification for our code.

When we do this, how many of us get this right the first time? I'm sure some do, and the simpler or narrower the task, the more likely we get it right. However, we also sometimes make mistakes and realize that our specification wasn't correct or that we interpreted the specification incorrectly. Even when I write code for myself, sometimes I realize I haven't described when I need clearly enough, even in my own head.

That happens when I control the entire process. When someone else is my client, there are plenty of ways in which we can make mistakes, especially in decoding the specification. As we use more and more software to make decisions for us and automate our world, I wonder how often we've assumed the software works in a way different than it actually does. With machine learning and artificial intelligence programs, I think there is an even greater chance of a misunderstanding.

Recently I saw that in New York City there is a proposal to disclose how software is used in hiring decisions. Humans are barred from discriminating by law, but what about software? What if there are bias that can come out in the software based on how someone enters data?

I think there are certainly potential issues in having software evaluate individuals, though I do think software will do a better job than many people, once we've worked out the bugs and we know how we want it to work, and then we can compare that to how the algorithm produces results.

These are tough issues, and difficult projects. I also think it's important that we analyze the data that is used in testing software, to be sure that it doesn't contain its own biases. Ultimately I think having public data sets that are evaluated by many individuals is important. I could see a reference set of data and the expected results, or some range of results being required to ensure software meets the goals we want as a society. This, along with the disclosure of how algorithms work will make our use of software better over time.

Steve Jones - SSC Editor

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

 
 Featured Contents

Creating a Simple DynamoDB NoSQL Table in AWS

will2win4u from SQLServerCentral

Learn how you create NoSQL tables in DynamoDB.

SQL Server DBA Utility Dashboard

Additional Articles from MSSQLTips.com

Create a quick application that stores your favorite queries that you can use to quickly connect to any server and return the results.

What is the state of Database DevOps in 2021?

Additional Articles from Redgate

The latest State of Database DevOps report has been published and it’s packed with data from over 3000 IT professionals. You’ll learn about the latest DevOps trends, industry insights, and tips from contributors such as Pramod Sadalage and Kendra Little. Get your free copy.

From the SQL Server Central Blogs - Steps for a Successful Data Migration Session at Microsoft Ignite

kleegeek from Technobabble by Klee from @kleegeek

I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as much as I am. I was going through the content catalog for this year’s conference...

From the SQL Server Central Blogs - Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals

aen from Anthony Nocentino's Blog

My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right...

 

 Question of the Day

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

 

Deprecated Features

I am running SQL Server 2019, and I have an old codebase. I am worried that I might be using features that are deprecated and don't want to add new code using them. How can I easily check what features are deprecated on my version when writing code?

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 SQL Managed Instance Features

Which of these are allowed in an Azure SQL Managed Instance? (choose 2)

Answer: Copy only backups, OPENDATASOURCE

Explanation: You are allowed to use OPENDATASOURCE (with some limitations) and perform COPY ONLY backups. You cannot attach database files or create database snapshots. Ref: Features of SQL Managed Instance- https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

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 - Development
SSIS guidance - hi all Looking for a general directional pointer on something I am trying to achieve in SSIS I want to pull a number of column values from a table in a DB , store these in a variable and then use that variable in an outbound API call which will use those values as parameters […]
SQL Server 2016 - Administration
xp_cmdshell - how to check which job or  stored procedure using xp_cmdshell in sql server ?
consolidate error logs - i need to configure job to consolidate sql error log sizes   from multiple servers , iam not proficient in developing scripts  nor packages ,  any one help in  doing this task .
User unable to see Logins after recreation of permissions in new instance - Hello All I was tasked with setting up a new instance on the same server, but with a higher version (from 2012 to 2016). User would like to test higher version before moving dbs there. After installation I recreated all the logins using these guidelines - https://www.sqlshack.com/move-or-copy-sql-logins-with-assigning-roles-and-permissions/ User confirmed successful login, but one thing that's […]
SQL Server 2016 - Development and T-SQL
? on Count specific value on XML data - Hi How do I find a count of a specific value in XML? data.value('count(/SampleXML/Colors/*)', 'int') finds all so say Black in [1] and Red in [2] and Black in [3] How do I get Black 2. Red 1   Thanks    
SQL 2012 - General
How to write update query to check exist column by value 1 where it exist on tab - How to update check exist column by value 1 where partid exist on table FeaturesvalueA or FeaturesvalueB ? I work on sql server 2012 I face issue I need to update column checkexist on table temp where partid exist at least one time on table #FeaturesvalueA or table #FeaturesvalueB But if partid exist on both […]
How to Update field updatedStuffDiff when i have different values for parts exis - I work on sql server 2012 I face issue I can't update column name updatedStuffDiff with different feature value for every feature based on partid so when i have two part have same feature but different values then display it as result on column updatedStuffDiff based on partidc and partidx on table #temp so result i […]
SQL Server 2012 - T-SQL
update query problem - Is there a way to take these two records and update the NULL values in one to match the filled in values for another? e.g. Record One in CallTable:      ID# 5263       CallID = 563522       Fname = Ben               Lname = Foster Record Two in […]
SQL Server 2019 - Administration
Estimating compute cost per type of transaction - Hello, I am creating a program that calculates the Read, Insert, Update, Delete statements that exist in code. Since we  know: The type of transaction, the number of parameters passed, the size of the table, I thought good to provide a calculation cost for each program/function. That is to say, A read operation in a […]
Name of the remote server in a query - Hi, I want to retrieve the name of the remote server in my SQL server query: exec ('CREATE OR ALTER PROCEDURE ins_tmp_proc AS BEGIN INSERT INTO dbo.tmp (job_id, name, ..., server) SELECT job_id, name, .., @@SERVERNAME from msdb.dbo.sysjobs UNION SELECT job_id, name, .., @@SERVERNAME from .msdb.dbo.sysjobs END') I tried executing just the SELECT statement by […]
SQL Server 2019 - Development
Stored Procedure "Caching" - I'm having an issue with a database that I recently moved from SQL 2014 to SQL 2019 (Standard in both cases).  The users get data from the database using stored procedures either through the UI or linked to Excel (using an ODBC).  The users will execute the same procedure multiple times with different parameters expecting […]
Logic is not wokring - hi, I have 3 types of invoices , INNU,INN1, INN2 I am trying to filter out invoices that are "INN1" and "Unpaid" ( I dont want INN1  Unpaid invoices ) I tried to use the following condition but Its taking out all the "Unpaid" invoice. where [Invoice Class] IN (@invoice) and ( invoice_cl <> 'INN1' […]
Integration Services
[ADO NET Source [2]] Error: The ADO NET Source was unable to process the data. F - I am trying to get data from myslq into mssql with ssis. I am getting these errors: [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ADO NET Source returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by […]
The Future of Community
SQLSaturday Foundation - We are setting up this thread to welcome questions and comments about the latest announcement where Redgate has announced plans to establish a community-run SQLSaturday foundation and donate the SQLSaturday brand and assets. The foundation would support the data platform community to run your own regional SQLSaturday events, which are vital in helping communities across […]
MySQL
Longblob to varbinary(max) - hi , I am having issue with SqlMigrationTool migarting mysql data to MSSQL server. During the migration , i have no issues , but when i pulled data with longblob datatype , data is converted to varbinart(max) which is right . But user mentioned data is null for most of the records where she is […]
 

 

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

 

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