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

Daily Coping Tip

Share an article, book, or podcast that helped you

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.

Where We Need Better AI Disclosure and Responsibility

There are a lot of contract and gig jobs taking place in the world today. It used to be this was widely spread throughout programming and technology, but these days many types of jobs are commonly done as contract workers. I like the flexibility, but I also think that contract workers need to be better at saving and planning for the future because of less employment stability.
 
One trend that I've seen taking place in some of these positions is the use of software and AI to determine if a worker is doing an acceptable level of work on a regular basis. Amazon might be one of the highest-profile companies doing this, as they expand into the delivery business. They are using the power of computers to manage an army of workers. This includes terminating them. There's an article that talks about some of the experiences.
 
I don't know how their system works, but I do know the frustration of trying to work with a company that doesn't use humans for many tasks. If you've ever tried to contact Google, you know that it's incredibly difficult to actually communicate with a human. Google seems to think that its automated systems can handle all situations. They might handle many things, but they don't do a good job in plenty of situations, and there is little recourse to have a human intervene.
 
I do think that AI and ML can help in many cases, but they certainly are looking for broad patterns. Maybe this handles the middle 80% of cases, or maybe it's more like 60%, but there are plenty of situations where humans ought to be involved. Maybe more important, when someone uses these systems to make decisions that impact humans, there should be some explanation and understanding of how the general model impacts this specific situation. We want to know why the computer comes to its conclusion in medical care, employment, legal issues, or maybe anything else.
 
There is work being done to try and explain how these models work. The important thing, however, is to ensure that while we understand, we also need to disclose this to those affected by how the systems work. Any appeal process should include this explanation, and likely with a human involved at some point to help evaluate the model for accuracy, fairness, or any other measure that is relevant.
 
 
 
 

Steve Jones - SSC Editor

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

 
 Featured Contents

Connect to and Query Salesforce Data in QlikView

JerodJ from SQLServerCentral

This short article shows how to connect to Salesforce data with CData and produce a chart from a query.

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 13: Simple Context Manipulation: Introducing the DAX All() Function

Bill Pearson from SQLServerCentral.com

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX All() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to All(), focusing largely upon its most basic uses in manipulating filter context.

Discovering What’s Changed by Flyway Migrations

Additional Articles from Redgate

A set of PowerShell cmdlets that will 'diff' two versions of a database and provide a high-level overview of the major database changes made by successive Flyway migrations. You can 'diff' a SQL Server database to the same one on PostgreSQL and find out which objects are the same and which are different.

Join SQL Server tables where columns include NULL values

Additional Articles from MSSQLTips.com

Dealing with NULL values especially when joining tables can become a challenge. Let's take a look at this issue and how this can be resolved.

From the SQL Server Central Blogs - Experiment: Does sp_recompile on a table update associated views.

Kenneth.Fisher from SQLStudies

tldr: No. You have to use sp_refreshview. One of the only good things to come out of all of the ... Continue reading

From the SQL Server Central Blogs - Using PyApacheAtlas to import SQL Server extended properties to Azure Purview

Daniel Janik from Confessions of a Microsoft Addict

Azure Purview is a compliance and data governance platform in Microsoft’s Azure cloud. The platform is currently in public preview and has quite a few features; but, does not...

 

 Question of the Day

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

 

Python Universal Newlines

I am using the open() method in Python to load a text file. Which parameter do I add to enable universal newlines for the file?

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)

Trace Flag Scope

What are the scopes available for enabling trace flags? Not every flag might fit all these scopes, but what are the possible scope targets?

Answer: global, session, and query

Explanation: We can enable trace flags globally, at a session level, or at a query level. Not all flags can be enabled in all these scopes. Ref:

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
Data type convert help - Hi Gurus, I am just trying to convert data type on a sql script. ----From this format to and convert(date,a.myDate) between '2020-11-08' and '2020-11-16' ---- To this format (need help on this one with correct syntax) and a.myDate = convert (date, between '2020-11-08' and '2020-11-16') --It works when I don't use 'between' ! and a.myDate […]
SQL Server 2016 - Administration
Execute against all databases - Hi Everyone I have the below script which is very useful for single database usage. (Credit to the author) How can I make this execute against all my user databases?   Thanks SET NOCOUNT ON SELECT 'USE' + SPACE(1) + QUOTENAME(DB_NAME()) AS '--Database Context' select ' IF NOT EXISTS (select * from sys.database_principals where name […]
SQL Server 2016 - Development and T-SQL
Azure Data Studio doesn't yield any results when I run it - Recently I've noticed that Azure Data Studio (ADS) doesn't produce any results when I run it. I'm working on a SQL Script to update some lookup tables. I've been putting in lots of PRINT statements, performing SELECTs at various places, etc. Then when I get to a point of where I want to test it, […]
Datediff (exclude holidays - no function) - I'm counting the days between two dates using DateDiff.  In my query I'm excluding weekends, now, I need to excluded the company holidays. How can I accomplish this without a function and just do it within the query? I have a holiday table that lists all of the company holidays. Calcs. the start date and […]
Finding number of SELECT statements pr. tabel/view with Query Store - Hi guys. I have a question regarding Query Store. I want to check how much each table is used in my database in order to do some cleanup (number of select statements on tabels and views) Normally i would do this with the Transaction log, but unfortunately I have only set this up to log […]
SQL 2012 - General
encapsulating DECLARATIONS, UNION ALL, and SELECTS into CTE - I'm having trouble getting this to fit into a usable CTE (the below is returning the expected data but I need to use it as a CTE for flexibility and OOP)... any clues?: DECLARE @period INT = (SELECT period FROM [a2hr].[payroll].[fnGetPrevPeriodYear](GetDate())), @year INT = (SELECT year FROM [a2hr].[payroll].[fnGetPrevPeriodYear](GetDate())), @PRStartDate Date, @PREndDate Date SELECT top 1 […]
SQL Server 2012 - T-SQL
How to get the detailed record and summary value at the same time - there are LineNo, itemNo and qty fields in one table, I want to the accumulative qty (totalQty) for each item and want to the totalqty shown as below picture, I just know one way to get the the result , could you please help me how many ways to get the result, it seems that […]
SQL Server 2019 - Administration
Creating a new SQL Server Instance in a Failover environment - I am having a real hard time trying to create a new instance for a database using SQL Server 2019 Failover cluster. I am trying to follow these directions. I am stuck on Step 10 which is Instance Configuration. Normally when I create an instance in a regular SQL Server I just give it an […]
SQL Server 2019 - Development
SQL JSON Ouptput - I have table with code type , code & Value. I want out in json like this way. In this example Code type test 1 . I try to do union which not allowing and i dont want to put code type instead i want my own name.   { { "Test1" [ { "code" […]
Sum field with where clause based on a RecordId - I'm going to blush when I hear the answer to this.  Think I'm over tired.  I made this simple example that hopefully explains my problem.  Thanks! DESIRED RESULT (line in italics) 1, 20210806, 200, 0, 0 2, 20210807, 200, 0, 0 3, 20210808, 200, 600, 3 4, 20210809, 200, 0, 0 5, 20210810, 200, 400, […]
SQL Azure - Administration
Migration to Azure SQL Managed Instance Business Critical Tier from VM's - Hello All, Currently we are planning to migrate from two production Azure SQL Server VM's to Azure SQL Managed Instance and I was doing some reading on SQL Managed instance Business Critical tier and I had few questions which I would like to ask the experts here. As always appreciate all the inputs. I have […]
Reporting Services
Microsoft Visual Studio - Hello, I am using Visual Studio 2019 Reporting Services to generate report. I want to add other Table to my current table. Then I got an error message. Please see attachment and help. Thanks Frank
SSRS Switch with an Or? - Hello, I've been searching and can't find any answers to how (or even whether) this can be done so I'm hoping a regular here can help. In SSRS I'm trying to build a SWITCH statement that has two options on the result.  Something like this: SWTICH( Parameter = 1,"A" OR "B", Parameter = 2,"C" OR […]
Integration Services
Create one loop for 27 tables - Hi there, everyone. I know this might sound stupid, but I need to ask it anyway. I have to get data across from one server to another via SSIS. They all use the same logic in that there is a data SQL truncate task, a dataflow task that uses source and destination OleDB. Then there […]
Performance tuning - We have a SSIS package that runs a web service that is a vendor's API. Basically the process it passes a list of bus routes, and then for each routes, it find stops in routes, calcualte the corners direction, and finally get students' stop detailed information and save in database. so there are a lot […]
 

 

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

 

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