| A community of more than 1,600,000 database professionals and growing |
| | If only the US would follow ... I saw this blog from Allan Hirt and I wish the US would adopt something strong like this. I'd actually like this to apply to all organizations, but certainly critical services need to be secure. If you follow the link, you'll see that the UK government has warned their critical industries that if they do not have effective measures or safeguards against cyber attacks, they can be fined up to £17 million. That might not seem like a lot in some industries, but it should get some attention from executives. I'm not sure how many CxOs would keep their jobs if they incur that level of fine because they didn't implement strong security measures. For now the requirements apply to the energy, transport, water, and health industries. These are deemed essential by the UK government. The UK government is expecting that along with data privacy changes to ensure GDPR compliance, that these industries need to implement better cyber security to prevent or limit attacks. This is part of guidance from the European Parliment, and it's overdue. I just wish the US were as focused on pushing organizations to adopt security as a priority rather than an afterthought. Not that I want government to dictate specifics, but I do think that having a government authority that can stay up to date and evolve their view of what constitutes good security is a good idea. This could be similar to some sort of review and feedback situation that we have for auditing. Ultimately, I'd like there to be some group that can weigh in on good security practices for platforms and systems, probably with research and industry feedback, on what constitutes valid patch levels for systems and software. It would be valuable to know that your version of Windows or Debian or PHP or the database platform is insecure. Not that I want to create more of an upgrade treadmill, but using software means patching it. Perhaps this would drive more organizations to move to open source software, or perhaps more vendors to issue patches rapidly and lower their prices to compete. Maybe more importantly, it would press vendors of third party software to ensure they continue to develop security patches, perhaps even spelling out support lengths in contracts. The pressure to perform better would be useful in raising quality in the security area. One thing to note is that the intent isn't to fine companies, but ask them to make valid risk assessments and take appropriate measures (with input from regulators). For now, I'd say that most UK organizations ought to start taking security more seriously. Making changes in platforms to prevent attacks and limit downtime will require some planning and foresight. You might not be in an industry affected today, but in two or three years that could change. 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.9MB) 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 | | Write, format, analyze, and refactor SQL fast with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. Download your free trial | | | Database migrations inside Visual Studio Feeling the pain of managing and deploying database changes manually? Redgate ReadyRoll creates SQL migration scripts you can use to version control, build and release, and automate deployments. Try it free |
|
|
|
| | | bevan ward from SQLServerCentral.com Describe and provide a set-based method that takes a multiple character split term and returns as a table More » |
| All too often there’s a reluctance to use masked data since it’s perceived to be just X’s and N’s and therefore not useable. That’s not the case if you use Redgate’s Data Masker tool. More » |
| Additional Articles from Database Journal When using Transparent Data Encryption, you might wonder “What is the state of my transparent data encrypted database?” Read on to learn the many different states that a transparent data encrypted database might go through. More » |
| MarlonRibunal from SQLServerCentral Blogs Disclaimer: I’m one of the Technical Reviewers for this book. With the rising demand for cloud computing and wide adaptation of... More » |
|
|
| | Today's Question I am installing a new instance of SQL Server 2017 on a host that has SQL Server installed. Which previous versions of SQL Server could already be on the host and have SQL Server 2017 install safely? |
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: Installation. We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): What happens when I run this code in an AdventureWorks database? WITH mycte AS ( select id, price FROM (VALUES (999, 0.00) , (9999, -1.00) , ((SELECT p.ProductID FROM Production.Product AS p WHERE productid = 321) , (SELECT p.ListPrice FROM Production.Product AS p WHERE productid = 2) ) ) a(id, price) ) SELECT * FROM mycte Answer: A result set with 3 rows and two columns is returned Explanation: The VALUES clause can use a query to get an item in the value, but only a scalar can be returned by the query. This means each element needs a separate query. Ref: Table Value Constructor - click here » Discuss this question and answer on the forums |
|
|
| | Khaled Dev from SQLServerCentral.com Some times when we have two databases new_db and old_db , and we want to rapidly synchronize old_db , this script will help us to do the job. More » |
|
|
| Database Pros Who Need Your Help |
| |
| 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 |
|
|