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

Daily Coping Tip

Make sleep a priority and go to bed on time, turning off devices well before you turn in

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.

Finding Legal Data

Many of us have likely been asked about data science or machine learning in the last few years by someone in our organization. This has become a hot field, with many companies looking to try and find ways to use the technology to improve their work in some way. While I don't know how successful these projects have been successful in organizations, I know that some areas seem to be finding practical applications. Image recognition, translation, and even some application scoring systems have benefited from machine learning algorithms.

To build a successful model that works well, we need training data. Often lots of training data, and then have some metadata about how our training data might be applicable to a particular question. For example, if we have lots of pictures of dogs, we might need to tag the different breeds in order for a system to differentiate among them. If we want loan applications scored, we should have a corpus of documents that are already scored. This metadata allows the system to learn.

There is a company, Clearview AI, that markets itself as a facial recognition system. To build their model, they scraped images from YouTube and other Internet sources, without consent from Google or the subjects of the videos. This is interesting, as the data itself is publicly available, but gathering it into a database and using it for other purposes might run afoul of data privacy laws, like the GDPR.

I don't quite know how to feel about this use of public data. While I don't mind people viewing my pictures, I'm not sure that I like the idea of them being copied into a database for some other purpose. That might seem silly, or even strange, but I do think there is power in data and more power in more data. Allowing others to put my images in a database and use them, perhaps to train a model to recognize me, feels like overreach.

If you need data for your company, or your idea, what can you do? Many people just scrape Google, Facebook, etc., and get data. That might cause you some legal issues in some places, and you ought to be aware of the implications if you choose to do this, or you are asked to do this. I don't think this is how we want data to be gathered. I know there are some guidelines for responsible AI at Microsoft, but not necessarily rules in place for many companies. Hopefully that will change over time.

Steve Jones - SSC Editor

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

 
  Featured Contents

Navigating Trees With CTE

Glen Cooper from SQLServerCentral

Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any two nodes (i.e. vertices). Any node may be selected as its top node, with its […]

Tell us about how you monitor your databases

Additional Articles from Redgate

The 2021 State of Database Monitoring survey is now open, and we want to know how you’re currently tackling your server, instance, and database monitoring. By taking part, you’ll contribute to the sole industry-wide report on database monitoring, and provide insights into how SQL Server professionals manage their estates and what challenges they face. Plus, you’ll receive an advanced copy of the report and entry to a prize draw to win a $500 Amazon voucher.

SQL Window Functions in SQL Server, Oracle and PostgreSQL

Additional Articles from MSSQLTips.com

In this article we look at using Window Functions in SQL Server, Oracle and PostgreSQL to see the differences and similarities of the syntax.

From the SQL Server Central Blogs - Administering Relational Databases on Microsoft Azure: DP 300 study guide

prashan from PowerSQL By Prashanth Jayaram

I am excited to share an important milestone in my life. My third book, “Administering Relational Databases on Microsoft SQL“, is released. Co-authored with Ahmad Yaseen and Rajendra Gupta,...

From the SQL Server Central Blogs - Create a Polling Loop in PowerShell

Aaron Nelson from SQLvariant

This is one way to create a polling loop in PowerShell. I’m sure there are several options, but this one works well for the use case. Backstory I needed...

 

  Question of the Day

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

 

Numbers to Letters

What does this return?
SELECT ASCII (65), ASCII (66); 

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)

TSV

What is a .tsv file format?

Answer: A tab delimited format text file

Explanation: The .tsv file is a tab delimited format, similar to a csv. In this case, a tab separates data fields in a row oriented format. Ref: Tab Separated Values - https://en.wikipedia.org/wiki/Tab-separated_values#:~:text=A%20tab%2Dseparated%20values%20(TSV,line%20of%20the%20text%20file.

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
SQL Server rename - Instead of SQL Server name I am thinking to use dns cname for connection string etc. Would this be possible to setup with named instances? If yes would there be any issues? My understanding is it can cause issues for connecting with SSIS and linked server?
SQL Server 2017 - Development
T-SQL code help - Hello! I am designing one query where I have to convert the value from one currency to another. The problem is for I have to calculate a value with following conditions: In that transaction row, if the current row currency (A) is not equal to the posting currency (B) then I will have to go […]
read value return from URL on page - Hi folks, I have a peculiar problem I am trying to find a solution to. We have developed a process of importing data which requires validating against a web server URL, which returns either a 0 or a specific string on a page. There is nothing else on the page, no graphics, HTML, or CSS, […]
SQL Server 2016 - Administration
fn_dump_dblog - Hi All I have been trying to figure out what has caused a spike in the size of a particular log backup. ' I am seeing entries for LOP_MODIFY_COLUMNS & LOP_MODIFY_ROW I found this in attempt to get an understanding... LOP_MODIFY_COLUMNS: Designates that a row was modified as the result of an Update command. LOP_MODIFY_ROW: […]
AG db Synchronized but not accessible - Hello experts, We have a report of a failed login for an application. The error is like this one: Login failed for user 'sql_login'. Reason: Failed to open the explicitly specified database 'mydatabase'. [CLIENT: ] This database is in an Always On Availability Group. The db is accessible on the secondaries, but not on the […]
Using Cluster Aware Update - Applying Windows Update to SQL Server part of AG - Is there any official Microsoft documentation around why Cluster aware update cannot be used to patch sql servers that are part of Availability group? I am completely aware of steps needed to patch sql server in AG using different methods.
SQL Server 2016 - Development and T-SQL
Problem using While to loop from record - Hello, I have build this While Statment to loop for record based on primary key DOSTAMP for later create an insert statment for each dostamp(In practice, for each document that have this primary key). I do something wrong because some dostamp are repeated on the print test This is my SQL While loop : DECLARE […]
Administration - SQL Server 2014
Database patching on SQL server 2014 reporting services - We have SQL server installed and it is up to date with respect to patching. Recently, we have installed reporting service on the same default instance. Please let me know how we can patch reporting services only. When I tried to apply SP3, I can see the whole instance along with database engine is getting […]
Camunda & Database - Hi Experts, We are planning to implement camunda BPNM and the SQL server is going to be our production one running all application database. Can anyone enlighten me whether Camunda will be a memory hog and will cause performance issues ? TIA  
SQL Server 2019 - Administration
BMC Remedy Service Desk Integration with Sailpoint - I am working on a new project and need some information. We are going to integrate sailpoint with BMC Remedy Service desk. we would like to give access to user through Remedy, Where we provide access request and then sailpoint provision them to the defined (groups or entitlements). I would like to get more knowledge […]
SQL server 2019 installation CU 10 where to upload and install on my server - Hello where can I find to apply latest CU thank you
sql server 2019 standard edition intallation question - for installation sql server standard edition for instance id should I put server name? lets say I have as 12345inv  server name would that work? because by default it goes mssqlserver when i installed wasnt able to log in to the sql serverer so I un installed and not sure how what to put for […]
SQL Server 2019 - Development
Help with a query - Hi all! I want to create a stored procedure that returns a result based on the value of some DateTime parameters. Table format is: CREATE TABLE [dbo].[Contracte]( [id] [int] IDENTITY(1,1) NOT NULL, [NrContract] [int] NOT NULL, [DataContract] [datetime] NOT NULL, [idOrganizator] [int] NOT NULL, [idExcursie] [int] NOT NULL, [idUser] [int] NOT NULL, CONSTRAINT [PK_Contracte] PRIMARY […]
Reporting Services
SSRS not delivering all reports at the same time. - I have several data driven subscriptions running throughout the day delivering anywhere from 1 to 50+ reports to a file share. On those subscriptions that deliver 30+ reports, randomly it will deliver all but a handful and then deliver the rest when the next subscription runs. I have looked at the Execution logs and see […]
Connecting
connect to mdf file of localDB - Potentially dumb question.  There is 1 x ldf & 1 x mdf for DB1.   LocalDB.  How do I connect to these?  I am unfamiliar with localDB. If I run [sqllocaldb.exe i] - there are 2 other instances but not those using the log & data files I want to look at. Is there a way […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. 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

 

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