SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

A Data ID

It sounds good. A universal ID that can be used for your identifiable data, in case you happen to lose your paperwork. Paperwork? When will that term become lost to history? These days, less and less of anything is available as a physical media, and if it is, it's often because someone generates a copy from a printer. How secure or valid is that? After all, with Photoshop and other tools, we can reproduce almost anything that's indistinguishable from the original.

The UN wants a universal ID for humanitarian reasons. In case you can't get your personal documents because you're a refugees. They're lost, they're stolen, or just still in the desk drawer because you had to flee your residence. Digital representations of these papers might be the only way for many people to prove anything about their lives. Certainly a concern in today's world.

As we should know by now, anything that can be built in the digital world can be stolen. In fact, I'm fairly convinced that the vast majority of people that come up with good ideas don't know how to evaluate them in terms of the horrible ways that others will abuse the system. Creators are optimistic and look to solve problems. They're not nearly devious enough to think of the various permutations that a hacker mind might envision.

A universal way to track and verify identity information would be great. I already worry about losing track of digital assets, and some way to query a number of systems to verify I own them would be great. However, the security aspects worry me. Even having governments or the UN provide digital lockers that entail backups of records is problematic. Any centralized system can be abused, and certainly this data would be abused. Or leaked. We see data breaches from government all the time. Can you imagine losing control of passport verification at a large scale?

Each individual needs to come up with their own backup of precious documents, in a way that ensures they are encrypted and protected. However, we do need ways to authenticate and verify these digital assets. Maybe free signing certificates should be used when assets are provided to individuals, with public keys being disclosed by the government and escrowed by the UN, or maybe every other government. We ought to be able to verify a digital document in an open, transparent way, while leaving the storage to the individual. That would allow us to develop ways to protect our own assets, but ensure multiple entities can verify authenticity.

Steve Jones from SQLServerCentral.com

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


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 3.7MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

ADVERTISEMENT
Database DevOps

Database DevOps Demo Webinar

Learn how to automate your database deployments alongside your app code in this free demo webinar. Register now

Foundry

How might classification and better documentation improve data safety?

SQL Atlas is the latest prototype to come from the Redgate Foundry - find out more about what the tool does and try out the interactive demo for yourself. Try the free prototype

Featured Contents

 

Azure DWH part 14: PolyBase to access to non structured data

Daniel Calbimonte from SQLServerCentral.com

In this article, we will learn how to work with PolyBase using Azure SQL DWH. More »


 

Is It Time To Stop Using IsNumeric()?

Additional Articles from SimpleTalk

The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL. It seems to think a comma or a number with a 'D' in the midde of it is a number. Phil Factor explains that though IsNumeric has its bugs, it real vice is that it doesn't tell you which of the numeric datatypes the string parameter can be coerced into, and because it doesn't check for overflow. Phil comes to the rescue with a couple of useful alternatives, one of which works whatever version of SQL Server you have, and which tell you what datatype the string can be converted to. More »


 

Extending DevOps practices to SQL Server databases with Redgate, Git & Jenkins

Join Microsoft Data Platform MVP, Grant Fritchey, for our next Database DevOps demo webinar. He’ll be plugging Redgate’s tools into Git and Jenkins to show you how Redgate's Database DevOps solution helps you build, test and deploy your database changes alongside your app code. More »


 

From the SQLServerCentral Blogs - Backup Log to Nul– #SQLNewBlogger

Steve Jones from SQLServerCentral Blogs

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as... More »


 

From the SQLServerCentral Blogs - Start Your Engine’s with Startup Procedures

SQLRUs from SQLServerCentral Blogs

After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up... More »

Question of the Day

Today's Question (by Steve Jones):

What parameter for SQLCMD will give performance statistics in a compact way, with the values just separated by a colon?

Think you know the answer? Click here, and find out if you are right.


We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: SQLCMD.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

ADVERTISEMENT

Exam Ref 70-768 Developing SQL Data Models

Prepare for Microsoft Exam 70-768–and help demonstrate your real-world mastery of Business Intelligence (BI) solutions development with SQL Server 2016 Analysis Services (SSAS), including modeling and queries. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Get your copy today from Amazon.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I want to change the name of the share used by my SQL Server Filestream share. Where do I change this?

Answer: This changed in Configuration Manager, in the properties for the database engine service

Explanation:

In Configuration Manager, there is a FILESTREAM tab for the database engine service. This is where the share name is set.

Ref: SQL Server Properties (FILESTREAM tab) - click here


» 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 2016 : SQL Server 2016 - Administration

SQL Server Data Tools and Management Studio 17.x on Disconnected Networks - Hi All, Rumors have been circulating that if telemetry is blocked and there is no internet access, SQL Server Data Tools...


SQL Server 2014 : Development - SQL Server 2014

Select Statement Help - Hello All, I am needing help with creating a SQL query. I'm sure I am just over thinking it.  Below...


SQL Server 2012 : SQL 2012 - General

Transaction Logs in Status 2 for no apparent reason - I've got a SQL 2012 Server in a 3 Node Always On Configuration. Version: 11.0.5058, so SP2. We are finding...


SQL Server 2012 : SQL Server 2012 - T-SQL

Need to find a store procedure in a database - Hello Experts. Ive been trying to find the whole weekend a logic which is creating a xml file of this calculation:

Group by select - Hi,I need a help in writing a query. data looks like  ID           TAB NAME              Approved --------|------------------------|----------------------------- 1              AB                           1 1 &nbsp

Exclude weekends - Hi, I need to have a calculated field called EndDate and it should exclude weekends from the calucation . CREATE TABLE #Dates ( StartDate...


SQL Server 2008 : SQL Server 2008 - General

How to reduce the space /shrink SQL Server 2008 R2 Data file (MDF) and Log file (LDF) - Dear Guru's, I have read that using the DBCC ShrinkFile is not the best practice but our data and log files...


Data Warehousing : Analysis Services

Why did added partitions make cube processing slower? - We have a cube based on a 300 Million

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.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com