| A community of more than 1,600,000 database professionals and growing |
| | Believing the Data This is interesting to me. Let's leave aside the moral, ethical, or political sides of this. Let's just look at the data. A cop gave a ticket to a self driving car. Apparently the officer thought the car was within 10 feet of a pedestrian. The logs for the car show that it was 10.4 feet away. A negligible difference to me, but that might matter in a court of law. As we use digital data more and more to control vehicles, devices, even behavior, we are going to have problems, complaints, and unforeseen issues amongst humans and computers. Certainly our laws need reforming to deal with the digital world, but we also will have some cultural transformations to undertake. Much of our arbitration in the world has dealt with how well humans argue or debate topics. We are inconsistent, easily confused creatures, yet we often use our judgment and impressions to make decisions about whether we believe one individual over another. This has often been the case in law, even as more science with cameras, DNA, and other forensic techniques have tried to provide definitive proof one way or the other. As we use more digital devices, there will be, or should be, more logs and audit records of how systems behave. This worries me a bit in Machine Learning systems, but experts seem to believe we can unpack the rationale for decision making if necessary. In any case, we need to learn to trust and believe in the data, even if our eyes and instincts lead us to different conclusions. This doesn't mean that the data makes the decision, but we can't discard the data because we don't like it. Certainly context matters, and in the original case above, we'd want to consider velocity and acceleration, and possibly other factors to determine if the car was too close. Ultimately, I believe digital records will start to prevail in more circumstances than we might be comfortable with. We'll slowly change, and likely subsequent generations will trust data more than we do, perhaps even more than their senses. To me, this means that those of us that deal with data systems need to ensure there is extremely strong security and integrity of data records, and that we disclose algorithms and data processing techniques in a transparent way. Trust requires knowledge, which requires transparency. That's something we certainly need to improve on as an industry. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.1MB) podcast or subscribe to the feed at iTunes and Libsyn. 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 | | Become a more efficient SQL developer with SQL Prompt Learn how to write SQL faster and more efficiently with these exclusive short videos from Data Platform MVPs and SQL Server experts. With SQL Prompt you can strip out the repetition of coding and write SQL 50% faster. Check out the tips |
| | The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial |
|
|
|
| | | Samuel Vanga from SQLServerCentral.com Learn how to load fixed width flat files to staging tables in this article from Samuel Vanga. More » |
| Additional Articles from MSSQLTips.com How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or anything like a string starting with 'XYZ'? More » |
| Andy Warren from SQLServerCentral Blogs Robert Davis (@SQLSoldier) died on Monday. A great technical guy, he did a lot of writing and presenting and answering... More » |
| Mala Mahadevan from SQLServerCentral Blogs Today marks 3 days since we’ve lost Robert Davis a.k.a SQLSoldier, one of the pillars of SQL Family community. I was... More » |
|
|
| | Today's Question (by Steve Jones): I've installed a localized version of SQL Server on a localized host OS (i.e., Japanese SQL Server on Japanese Windows). I now want to upgrade SQL Server. What are my options? |
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: Upgrade. 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 | Pro Power BI Desktop This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have a database with CDC enabled on it. I detach this database and then attach it on a new instance. What happens to CDC? Answer: CDC is enabled in the database Explanation: If a CDC enabled database is restored to the same instance with the same name, it remains automatically enabled. Ref: CDC with other features - 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. Migration from SQL 2008 to 2017 - Hi All, I need some assistance in the process of migrating from 2008 to 2017. This is the first time doing... Convert Negative values -2.56 to (2.56) in excel - hi , I have a package right now which loads data from Table to a .csv flatfile. When loaded to excel... Removing stored procedures to move to cloud - I got an interesting email today about cutting back on the reliance of the applications on databases and plans to... High CPU usage % on master database - Hi, I have a server with over 1.000 databases and when I checked the most consuming CPU database I got a... SP1 and CU8 stop Database on SQL Server 2016 mail from working - Hi Everyone I ran into the following issue in my new production database running 2016 Enterprise Edition on Windows 2012... SQL Server Agent stops running after changing the default listening port - Dear Everyone I changed the default listening port for SQL Server 2016 standard edition on windows 2012 R2 then i... Database Mail stuck in INACTIVE status and will not change to RECEIVES_OCCURRING. Cannot send email from test or sp_sendb_mail - Hello All, I'm unable to get Database Mail to send email from SQL 2016 EE server. When I review test emails... Using CASE in Where Condition - Hello comunity I need to use in Where condition a Case statment to show only records where 1=1 or if 1=0... Query Help on PIVOT - Hello, Please help me with below query, need a row for each cell item, like cartestian product. Thanks for your help, Thanks... Client and Server cannot communicate...they do not posses a common algorithm - Hi, has anyone encountered this error when trying to connect from a SQL Server 2014 instance to a SQL Server 2008... Assigning VIEW SERVER STATE to an account (preferably WITHOUT LOGIN) - I'm looking at a function that has been passed to me, to assign VIEW SERVER STATE, because of the access... Best way to perform calculation stored as varchar - Hello, I'm working on a report for a customer where they have a formula stored in a varchar field such as... Use uniqueidentifier field in place of int - Hi All, I'm trying to populate a temp table. Here is the temp table: CREATE TABLE #SESDMVESEnrollData ( ContractNumber nvarchar(50) not null, ... Update Trigger - Hello all, I have a table: CREATE TABLE .( NOT NULL, NULL, NOT NULL, NULL, (max) NULL ) ON TEXTIMAGE I need to "group" two rows of data, but cannot seem to figure it out - my table is simple it has 1,000's of rows. one row is the account balance in USD, and the other row (and they are... Trying to reduce RID Lookups - Hi All I'm trying to help a colleague optimise an SQL query that looks for parts of a persons name across... How to find which SQL Server process was running at a particular time? - Good Morning Experts, We received an email from the operations team that they are seeing frequent high CPU alerts on a... SSRS Chart issue..Bars dont show up but data does - I have created a column chart in which the data is showing up properly on the x and y axis... Handling Lookup Fields In Dimension Table During Incremental Load - I'm trying to build out a data warehouse using the Kimball Methodology and I'm having trouble figuring out how to... Difference between varchar(max) and varchar(8000) - Hi, whats the actual difference between varchar(max) and varchar(8000). Is the difference applies same for nvarchar(max) and nvarchar(8000). Thanks in advance. |
|
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. | 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: [email protected] |
|
|