| A community of more than 1,600,000 database professionals and growing |
| | Securing the Things I would venture to guess that a lot of the data that will be produced in the next few years will come from various "things" that are implemented by companies, users, and governments. We tend to refer to the Internet of Things (IoT) as those computing devices that are small, specialized, and connected computing device that sends data elsewhere. Sensors, special purpose devices, and more make of the IoT spectrum, including many industrial and manufacturing hardware. Computers grew by leaps and bounds from approximately 250 worldwide in 1955 to one million in 1980 and 30 million by 1986. In 2015, the world saw 238 million computers sold worldwide. If we add smartphones, we had around 120 million sold in 2007 and 1.4 billion sold in 2015. Tablets add to this, but really, the large market is going to be IoT devices. 15 billion connected in 2015 with an estimate of 75 billion by 2025. I would wager that is going to be a low prediction. One of the major concerns with these devices is security, and with good reason. There have been hacks against many of these devices, and few have been designed or sold with security in mind. Quite a few devices assume a strong network perimeter inside of an organization, but history has shown us that these barriers aren't always secure. What might be more disconcerting is that many of the hacks originate inside of the network boundary, whether from insiders or compromised devices. There's a nice write up on the need for security with IoT. Microsoft recently proposed that we regulate privacy and security for the IoT devices. Many of these devices will generate data that we will use as data professionals. In fact, I expect a tremendous amount of data to be generated. If devices are hacked, we may end up with lots of suspect data. Even devices are secure, they may fail or have intermittent errors. How to we detect errant data and remove it from our data sets? How can we be sure anomalies aren't just problems or failures in the device (or network)? These will be challenges for us moving forward. I don't know that I think specific regulation is required, but I'd like to see some sort of framework devised. I think encryption should be required, as well as guidelines for the security of connections and data management. Perhaps a list of valid technologies could be used, growing and changing over time, including removing older items that might be outdated. For example, DES shouldn't be allowed in any new deployments, and it really should be removed from old ones, though with some grace period. That means a regular investment in software development and upgrades that evolves our systems over time. Especially with regard to data security. 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 ( 4.4MB) 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 | | New SQL Monitor Reporting Module SQL Monitor now includes a new Reporting module. It allows you to create customized reports, combining the individual server performance metrics available in SQL Monitor with summary information on your entire SQL Server estate. These reports can then be exported to pdf and emailed to you on a scheduled basis. Download SQL Monitor now and get a 14 day free trial |
| | Could your SQL coding be more efficient? Data Platform MVPs and SQL Server experts share their tips on how to standardize formatting whilst stripping out the repetition of coding with SQL Prompt. Over these 20 short videos we will help you write better, shareable SQL faster. Check out the tips |
|
|
|
| | | Paulo de Jesus from SQLServerCentral.com Setting up R in SQL 2016 proved to be trickier than expected, but here is how to avoid the frustrations. More » |
| Additional Articles from SimpleTalk Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is that it is a rather complicated topic to fully understand and the cost of getting collation wrong can be great. If only one could ask certain questions on forums or at conferences without blushing. Help is at hand, because Robert Sheldon once again makes the complicated seem simple by answering those questions that you were too shy to ask. More » |
| What is data classification? Why go to the effort of classifying your data? Jonny Roberts explains. More » |
| Grant Fritchey from SQLServerCentral Blogs One of my favorite things about being a technologist is constantly learning new things, but, this can lead us to... More » |
| 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 » |
|
|
| | Today's Question (by Steve Jones): When I run this query, I get an error. DECLARE @json NVARCHAR(MAX) = ' { "City" : "Denver", "Team" : "Broncos", "Offense" : { "QB" : "Siemian", "RB" : "Anderson" "WR" : "Thomas" }, } ' SELECT JSON_VALUE(@json, 'strict $.team') The error is: Msg 13609, Level 16, State 2, Line 14 JSON text is not properly formatted. Unexpected character '"' is found at position 130. Why? |
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: JSON. 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 | SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): If I run this: seq(10, 20) I get this: 10 11 12 13 14 15 16 17 18 19 20 What if I want 10 12 14 16 18 20 How do I code this? Answer: seq(10, 20, 2) Explanation: I can use the third argument to specify an increment. In this case, by using 2, I get the numbers from 10 to 20, incrementing from 10 by 2. Ref: seq - 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. Application Slow on Test Instance - Hi Everybody, I have latency on my Application (Test). I have 2 servers : - 1 Application Server : Server with IIS - 1 Database Server... SQL Server 2016 on Windows Server 2016 Core - Error Accessing Configuration Manager - Hi, Background: Windows Server 2016 Core SQL Server 2016 Enterprise (obviously 64-bit) Windows Failover Cluster SQL Failover Cluster I am attempting to connect to SQL Server... Need counts of orders by month and year - Hello Everyone, I'm hoping someone could help me out, so here's my scenario: I have a table that tracks orders from... Parent-Child records - Goodmorning, Ihave a table that stores par Schema design , many-to-many M:N - Basically trying to get my head around how to enforce primary / foreign key constraints on what is essentially a many-to-many... Best way to handle a table-based queue? - NOTE: This is NOT a Service Broker question. The table defined below is accessed by concurrent jobs that select the next... Troubleshooting MEMORY ALLOCATION EXT wait type - I am getting this wait type on my DB Server, please let me know the reason y it caused and... Need help with this query - I am wondering if someone can look at this query and tell me if this can be optimized. There are... AlwaysOn - adding secondary problem - Hello SSC, I am having trouble with adding a secondary replica to my availability group. Once I choose the server/instance to... SQL server 2014 is very slow - Based on this report(performance monitor) can any one tell why the Sql server is running slow. many application have slow... Updating multiple columns in a single statement for a table according to non-matching column names - I need to populate a table containing customers’ ageing with the remaining amounts in each of four columns. The customer’s... Not able to pass Parameters in Stored Procedure through SSRS - Hello Sir I have created a stored procedure (fetching data from wonderware Historian).I want to pass parameter @Para from SSRS.But its... Query displaying redundant data for a menu item, menu has choices, but displays menu item multiple times with different choices - Ugh, I know that topic was ugly...Ill try to explain this as best I can...I am writing a report for... Drop Service Master Key or Change Password? - Hi All, I'm rusty with admin and definitely new to master keys. I'm working on a database that has a service... Need Suggestions on Best way to Query Data - Greetings, I have a table that has 2 columns, TransTableDetail_Trans_To and TransTable_Description. the TransTableDetail_Trans_To column lists store numbers that can repeated... Batches and Transactions - I have a stored procedure that has multiple commands: Inserts, deletes, creates temp tables. I put Begin Transactions .... Commit in... SQL Server SSIS Packaage Error Code 1073741819. - Dear All, We have faced the following Error Recently in SSIS Package Scheduling. Error Code : The step did not generate any output.... Simplify the SSRS URL - I'd like to make it easier for my users to access the SSRS root folder. Is it possible to replace the... SSIS precedence constraint, check my logic please - All, I'm an SSIS newbie, putting together an SSIS package to push data from a source server to several destination servers. ... CLUSTER Error: Could not find any IP address that this SQL Server instance depends upon??? - Hi all I've got a sql 2005 active/passive cluster on win2k3 servers. In cluster admin under sql server 2005 group resources... |
|
| 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 |
|
|