| A community of more than 1,600,000 database professionals and growing |
| | | Lax Security is Harmful for Employment Manure rolls downhill Since I live on a horse ranch with some slight hills, I can attest this to be true. At least, it's true for horses and it's true for short distances. Manure isn't very friction free and often ceases movement quickly. The same isn't likely true for bull droppings, but I haven't done much testing in that area. Most of us would agree that those that are negligent in their jobs, especially with regard to security, ought to be punished. In some cases, this should lead to termination, though I think many of us technical people would prefer that management who doesn't budget resources for security be the ones punished. I mentioned manure rolls downhill, and this article on the after effects of data breaches bears that out. Not only were there record numbers of issues last year, but the typical cost is nearly $4million. That's likely some very expensive breaches and lots of relatively inexpensive ones, but even the low cost ones probably feel expensive to small companies that experience them. In the lists of breaches I've seen, lots of smaller firms (retail, law, etc.) are included, and tens of thousands of dollars might be expensive for them. One thing that article points out, there are an increasing number of C-level executives being terminated after breaches. I'd like to think that's good, but I'm somewhat pessimistic that the next hire will find ways to improve security. There are lots of impediments to fundamental change in more organizations, so I suspect this trend leads more to short term employment for CIOs and others, and likely higher demands for salaries because of the risk of security issues inside the company. The further puts pressure on budgets, which is another impediment to better security. Note that it's not just IT execs, but non-IT staff as well. Maybe I'll be wrong and this will make a difference. Of course, IT staff are let go as well, often blamed for issues. There will always be some security issues, but I urge those of you with privileged accounts and access to sensitive data to be careful with your credentials and work to improve security when you see issues. Get written documentation when someone doesn't allow security changes, in addition to noting your requests. This might not stop a data breach, but perhaps it will give you a better chance of not being blamed for security incidents. 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.0MB) 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 | | | | | Redgate University Self-paced online training courses with easy to follow classes on getting started, exploring advanced features, and making the most of Redgate products. Learn the fundamentals, best practices, and top tips from the experts - Redgate’s Microsoft Data Platform MVPs and engineers.
Start Learning |
|
|
|
| | | | | Danilo Dominici from SQLServerCentral.com In this level we examine how to add disks to separate our data, log, and tempdb files. More » |
| | Press Release from Redgate Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks". More » |
| | Additional Articles from SimpleTalk JSON is a viable option for transferring data between systems. It has the ability to include schema information along with the data which is an advantage over CSV files. In this article, Phil Factor demonstrates how he takes advantage of JSON when exporting or importing tables. More » |
| | Bert Wagner from SQLServerCentral Blogs Watch this week’s episode on YouTubeI’m not advocating that you start using SQL injection to start stealing other people’s data. However,... More » |
| | Wayne Sheffield from SQLServerCentral Blogs What were you thinking? Have you ever been working on some code from another person, and you end up scratching your... More » |
|
|
| | | Today's Question (by Steve Jones): I've got an R data frame (pass.videos) that has a number of data items about the PASS videos stored on a flash drive. I want to get an idea of the structure of the data set with data types and a sample of values. What function should I use? |
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: R Language. 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 | Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload. Pick up your copy of this great book today at Amazon today. |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): What is returned from this code? DECLARE @s VARCHAR(10) = '1' SELECT @s += 1 SELECT @s
Answer: 2 Explanation: Two is returned here. The string is implicitly converted to an int (1) and then 1 is added to it (2) and then this is converted back to a string. Ref: CAST and CONVERT - 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. login failure error for syspolicy_purge_history job on multiple instances server - I have built two instances on SQL 2017. One is default instance, The other is a named instance for example... Sort comma separated value in SQL Table - Hi, How do I sort a previously comma separated value in the alphabetical order ? Astrakhan, Azerbaijan, Kazakhstan, Russia Land, Sakhalin, Uzbekistan,... Lack of clustered index generally a good idea? - https://use-the-index-luke.com/blog/2014-01/unreasonable-defaults-primary-key-clustering-key This is my first exposure to this concept. What is you guys' take on this? It sounds like it MAY... when to use clustered vs nonclustered indexes - When should you use clustered vs non-clustered indexes? Which is better for large tables? Entity-Attribute-Value is evil ? how to avoid... - Hi all consider the following scenario:I have a FILE table with known attributes (size, creation date, ...)The user needs to add... sql server 2016/2017 books etc. - Is there a good book or material to learn the product from a DBA perspective. I will probably take the... Holiday Calender. Second Table has calculated column which add days which are not in weekends and not in holidays - Hello Gentlemen Your kind support Question: to create two new tables mentioned below conditions Table 1 named Calendar Table 2 named DataBT. 1- Calendar table... adding each row incremental - Hello, sadly i am at my witts end with this complicated problem, and i know you guys are smart than i... Request code review for UDF: ContainsControlChar and CleanString - Hi, I have a lot of dirty data in my upstream data sources. I've written two UDFs to assist in my... Inquiry about saving formatted data - Hi All, I need to save formatted (bold,italic,fonts,colors, etc.)html documents to a table in database, my concern is i don't want... sql performance question - Hi All, Recently, I have undergone a computer based exam where in they asked below question.Need some inputs from experts. Below correlated... Left Join with View taking more time in SQL Server - The below query is taking twenty seconds to display 53,000 records. This query has five left joins with views. But... subtract 2 tables - TABLE A year title country age 2018 MR UK 50 2018 MS UK 40 TABLE B year title country age 2018 MR UK 10 2018 MS UK 20 2018 Sir UK 20 How can i... Is it possible to restore database with smaller size than source? - Our production database is 700 GB but only 400 GB is used. Our destination server has only 500 available space.... Two column body - Forgive my ignorance as it has been several years since I have built a report in SSRS. I have a... Keeping the headers in each tab in SSRS 2008 - Anyone have a fix for this one? We're trying to run a report and have a page break on the city... My subreport only shows 1 record, even when there are more. Why? - I've got a main report, which is a detail report. And a smaller report, that's used by the main report... Agent Job/SSIS Performance Issues Post-Upgrade to SQL Server 2016 - I upgraded seven packages from SQL Server 2008 to 2016. The packages run fine when running each one individually from... SSIS - Error: Failed to acquire connection - A situation caused an error. I need to fix that. Error - Error: Failed to acquire connection "MyDBConnection". Connection... I/O error 23(Data error (cyclic redundancy check) - I have encountered the below error message when i try to do sql query. Server: Msg 823, Level 24, State 2,... |
|
| 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
