Querying SQL Server 2017 Ver.17.3 using SQLOPS

 There are already system databases. Make sure that the server has started. Start it if it has not started in Control Panel, or otherwise.

I have a default instance of SQL Server 2017 Verion 17.3 and I connect to it as described here.

Launch SQLOPS from its shortcut and click New Connection as shown

SQLServer17SQLOPS_0

The New Connection window opens as shown.

SQLServer17SQLOPS_1

Enter the items as shown.

SQLServer17SQLOPS_3

Click Connect.

You are connected as shown.

Click New Query to open a new query window as shown.

SQLServer17SQLOPS_6

Type S and a drop-down list appears.

SQLServer17SQLOPS_7

Complete a query as shown:

SELECT @@version

SQLServer17SQLOPS_8

Click Run and review the result as shown:

SQLServer17SQLOPS_9

Right click the result, copy and paste it in Notepad as shown:

Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64)  Aug 22 2017 17:04:49  Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro Insider Preview 10.0 (Build 17025: ) (Hypervisor)

Note: It was mentioned that you type in msdb as a database. In fact just localhost is all that is neccessary to connect.

BitcoinLib to work in Python

Python is well placed to work with Bitcoin. GitHub site has the required libraries.  Bitcoinlib is available at GitHub.

You need to get this file (bitcoin-master.lib)from GitHub site

https://github.com/cryptean/bitcoinlib

You can install using pip as shown below.

pipinsallbitcoin

The following library items are added:

BitcoinLibPython_1

The cost of a 'Satoshi'

It depends on the day and time you want to know the conversion rate. Satoshi is the unit of Bitcoin.

Satoshi_1 from site below

You can get the conversion rate here:

https://99bitcoins.com/satoshi-usd-converter/

I just tried to find today (8/29/2018 around 5.00 PM Hawaiian time).

Satoshi

The Unique Identification Authority (Aadhaar) of India is getting a lot of traction overseas

The Unique Identification Authority (Aadhaar) of India is getting a lot of traction overseas

Developed in India the Unique Identification Authority (Aadhaar) has been working hard with the idea that this is the true and correct way to address the needs and aspirations of one of the most populated country India.

This is how Bill Gates rationalized Aadhaar:

"Earlier, in his lecture on 'Technology for Transformation' organised by NITI Aayog on November 2016, Gates had said that Aadhaar is something that had never been done by any government before, not even in a rich country"

The next image from @uidai summarize bio-metric identification is accessed for demographic information. It has the most massive demographic information in the world.

My previous post on UIDAI is quite old, almost 5 years ago and at that time there were over 1 billion entries  and presently:

1.2 billion people have an Aadhaar number. Over 1.2 B people registered according to UIAI web site, end of February 2018. Aadhaar download can be obtained from the online services. Today, some 1.2 billion people have an Aadhaar number, accounting for more than 99% of India's total adult population.Jul 1, 2018

According to a tweet from Aadhar, IIT Bombay is developing a Aadhaar-like digital database for Morocco with their Modular Open Source Identity Platform (MOSIP) application suite

Read more at:
//economictimes.indiatimes.com/articleshow/65603423.cms?utm_source=WAPusers&utm_medium=twittershare&utm_campaign=socialsharebutton&from=mdr&utm_source=contentofinterest&utm_medium=text&utm_campaign=cppst
https://etapps.indiatimes.com/gcm_webnotification.cms

Philippines may also be on the same bandwagon:

https://www.financialexpress.com/aadhar-card/philippines-plans-to-copy-indias-success-in-aadhaar-biometric-id-system-to-get-poorest-on-map/1296124/

You now have SQL Server Agent in SQL Operations Studio

SQL Operations Studio is the lightweight tool to carry out administrative tasks on a SQL Server Instance. SQL Server Agent is a tool in SQL Server Management Studio that does a lot of work created as Jobs.

In the July 2018 Preview, Microsoft has introduced SQL Server Agent by way of an extension so that SQLOPS can be used to work with SQL Server Agent without using the SQL Server Management Studio making it a lot easier and productive.

You can install the July 2018 version needed as shown here:
https://hodentekmsss.blogspot.com/2018/08/install-latest-version-of-sql.html

You can work with SQL Server Agent by installing the extension as shown here:

https://youtu.be/_y2dqfjfGIY