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

Daily Coping Tip

Spend less time sitting today. Stand, walk, move more.

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.

Open APIs

The US Supreme Court ruling in Oracle v Google was released recently, with Google winning and removing, or reducing, copyright protection for APIs. That means if you use the same method names, parameter names, etc. as some other software, it is unlikely that the vendor for that software can sue you or force you to change. I think that makes sense, as in many cases, someone might accidentally copy an API in something like PowerShell. Already I've seen companies and individuals build "Get-ClusterName" calls.

I don't know all the ins and outs of this case. It's complex, and I've seen some notes that Google had permission from Sun Microsystems to use Java. After Oracle bought them, apparently things changed, but I'm not sure how this agreement was structured or the legalities of how things evolved.

In any case, I'm glad Google won. I think the specification of an API isn't something that should be protected and limited. If a company implements a list of method names and parameters, I don't feel those deserve protection. The actual code that runs should be protected, but the names in the interface shouldn't be. This might mean that if I interfaced with, say a piece of retail software that had "GetOrder", "NewOrder", etc., and I wanted to switch from vendor A to vendor B, I could without modifying my app.

This prevents lock-in, which isn't something I want to see enforced in software. In fact, for things like medical software, I'd want the same API for all of them. This is something that I think will encourage interaction of software, and likely reduce costs for many types of COTS systems that allow connections from PowerShell, bash, and other scripting systems. I think this also helps developers that might work across platforms or systems and could use the same code structures to switch from one to the other.

This also means that vendors implementing APIS need to do a good job with their software. They can't hold customers hostage with their system over the cost of reworking code the connects with their software. I think that pressure to be better, whether in features, security, or in all ways, is important for software to evolve and improve.

Steve Jones - SSC Editor

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

 
 Featured Contents

An Introduction to Azure Data Explorer

Sucharita Das from SQLServerCentral

Introduction Big data consists of very large datasets, which can be structured, unstructured, and semi-structured. Data may be coming from various data sources in real-time or in batches. The traditional tools and technologies we have used in the past are not capable of processing and storing all this data in an efficient way. We need […]

Never, Ever, Ever Start T-SQL Comments with Two Dashes

Additional Articles from Brent Ozar Unlimited Blog

In this article, Brent Ozar explains why you should avoid starting T-SQL comments with two dashes.

Creating Database Build Artifacts when Running Flyway Migrations

Additional Articles from Redgate

This article provides PowerShell automation scripts for running Flyway database migrations. These scripts use SQL Compare to automatically generate all the required database build artifacts in the version control system, for each Flyway deployment.

From the SQL Server Central Blogs - Checking for SQL Server Updates with dbatools

alevyinroc from FLX SQL

It turns out I was doing this all wrong for months. For the longest time, I’ve been checking my SQL Server instances to see what needs patching with Test-DbaBuild...

From the SQL Server Central Blogs - TIL: Backup-DbaDatabase

Kevin3NF from Dallas DBAs

(This post comes from one of our Junior DBAs – @SQLDork) I’m learning how to use dbatools. Today’s command: Backup-DbaDatabase I’m using the 64-bit PowerShell ISE (running as administrator),...

 

 Question of the Day

Today's question (by Evgeny Garaev):

 

Database snapshots

Can you detach and re-attach a database snapshot on SQL Server 2019?

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)

Parquet

What is the Parquet format for data files?

Answer: A columnar oriented file format

Explanation: Parquet is an OSS format from the Apache foundation that is used in Hadoop. This is a columnar oriented format that allows better performance across certain types of  queries. 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
Replication - not all columns are updating - I've set up replication but I'm having difficulties in my testing. I've changed 3 fields in the publication database, but only 1 of those 3 fields updates in the subscriber database. I've verified that all 3 fields are in the article. I've looked at the replication sproc and it looks fine for _UPD and _INS […]
SQL Server 2016 - Administration
using sftp in SSIS - Hi, I have SSIS packages for my SQL 2016 that currently use the FTP Connection manager.  I need to switch these to use sftp instead of ftp and I'm seeing lots of articles stating that SSIS does not support this and most are using WinSCP or scripting to get around this issue.  I'm wondering if […]
Backup failed - I cant figure out why backup failed   Here is my error: Executed as user: NBHDHQDOMAIN\svcempsqlserver. ...0 for 64-bit  Copyright (C) 2016 Microsoft. All rights reserved.    Started:  12:40:50 PM  Progress: 2021-04-20 12:40:54.16     Source: {DCE40FB3-F026-44F4-8B33-183461DFFA93}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp...".: 100% complete  End Progress  Progress: 2021-04-20 12:40:57.51     Source: Maintenance Cleanup Task      Executing query "EXECUTE […]
automatically remove people from report subscriptions - Hi, How can we automatically remove people from report subscriptions when they are disabled or don’t exist in AD?  We have Reporting Services standard and data driven reports and we are trying to find a way to automatically remove users when they don't exist in AD anymore.  I have read up on the [sys].[sp_validatelogins] stored […]
Azure SQL Server Specs and Encryption - Hello~ I administer a database application (Azure SQL Server Back End/MS Access Front End) At the moment, we have only one server, and we recently encrypted a few sensitive fields in our db.  After a week of user testing with encryption, everything seemed fine, but of course, when we went live, things went terribly wrong […]
Login - Multiple AD groups - Hi All If a user belongs to 2 AD groups, both of which are logins in SQL Server. What determines which group the user is coming through when connecting to SQL. I'm trying to troubleshoot a possible permissions issue in SQL. User1 is part of ADGroup1 & ADGroup2. ADGroup1 & ADGroup2 are logins in SQL. […]
Profiler Trace - Hi, I am aware of capturing the trace for a single user database by adding the DB name in the column filters. If I have to filter the trace only for 2 user databases, how can I add one more database name in the column filter which says LIKE 'TESTDB' ( example) ? or just […]
Help with detecting and sending alerts for lengthy blocking - Over the weekend we had 2 ETL jobs that were causing unresolved blocking with each other. One reading data the other inserting and updating. The jobs had been running for 45 hours in the blocked state. This was only resolved after one of the processes was killed. I'm looking for some help with the best […]
Sp_server_diagnostics for WorkerThread - Hi there, I am seeing excessively high number of worker threads when running Sp_server_diagnostics. My question is around the 3 figures: "queryProcessing maxWorkers="704" workersCreated="756" workersIdle="206""and how to interpret them. As you can see from the above we are certainly exceeding the maxWorkers  but I'm trying to understand if workerIdle comes into play here. Does this […]
SQL Server 2019 - Administration
Polybase and External table - Hi - we have 2 SQL Server 2019 instances, both with Polybase installed. I created an external table in a database on instance A and pointed it to a table in a database on instance B. Steps take in database on instance A: create master key in user database create credential create datasource using that […]
Where To Set Up SQL Server - Background: We have MS Access database split with backend tables that we want to convert to SQL Server and still use MS Access front end.  We currently only have OneDrive and I know we can’t put SQL on OneDrive.  We do not have a network set up.  So we are looking for the best way […]
upgrade path to SQL 2019 - I read the upgrade path for standard edition to SQL server 2019, the oldest version is SQL server 2012 SP4.  If earlier than 2012 it may need a version of middle to upgrade first, then to 2019. If this is s side by side installation and upgrade, like to a new server with SQL sever […]
SQL Server 2019 - Development
Archiving data to a read only file - Hi there I have a table for which archiving functionality is required. Now I have thought of writing sonmething in t-sql to use BCP to write to csv or caret delimited file There is a requirement that this file be made tamper proof and read only. Apart from setting the file attribute to read only, […]
Filtering a hierarchy-related query - I've got a table with LOTS of data. It's a tree-structure (using hierarcyId datatype) and I want a query to get all of them UNLESS they have a parent that's flagged as "Inactive" in the database, then I want to skip everything that's inactive and below. I hope you get it. If possible I want […]
General
How to get the sum of hrs. logged for today, past 1 week, this month, & quarter. - Dear SQLServerCentral members, Hello, and good day.  Hope all is well. May I asked for the help of any one regarding this matter.  Here is the sample table I have with the client (Please see the attached file). Since there is only one table that has a datetime field (in SystemAppUse table) and whether it […]
 

 

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

 

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