| A community of more than 1,600,000 database professionals and growing |
| | Is Security Catching On? This is a good sign, as a poll shows people want security over convenience, especially younger people. Surprisingly this is also true for older people, who likely don't trust much of our new technology. This is the first time that a majority of poll respondents haven't been happy to have some easy password acceptable or the convenience of linked accounts. More and more people are embracing biometrics and using password managers with separate passwords for services, especially those that involve sensitive data. That's a change for the better, since security is important if we are to continue to grow and enhance the use of digital services in our world. I think many of the issues with security are because of people near my age, the generation that has grown up as technology has. We've embraced and extended the very rudimentary systems that existed before Internet use and mobile devices became widespread. We also learned to build services in a way that gets them up and running without considering security from the beginning. Many of us grew up with computers that were either on or off, without any security implemented. We learned to network with completely open shares, and didn't bother with access control. This is the same way many developers learned to build SQL Server applications using the sa account, not wanting to spend time learning the (basic) intricacies of SQL Server security. As we deal with an ever growing number of data breaches (over a thousand last year), it seems that many of the people working in technology, likely from my generation, still have not learned to build security early into an application. We add security later, after we've gotten a prototype or minimally viable product released. In many cases, we might never build security until we suffer some sort of incident. That's the wrong time to start looking at limiting access. With the GDPR being enforced this spring, there will be plenty of pressure on companies to avoid being in the headlines for a data security issue. I'm hoping that customers will continue to put pressure on organizations to adopt better security measures. Between customers and new legislation in various countries, I'd hope that more managers would understand that security is important and make it a priority for their staff. Most technical people want better security, even at the expense of a little inconvenience. These changing times might just allow us to get our wish. 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.8MB) 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 | | | Don’t just fix SQL Server problems, prevent them from happening SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial |
|
|
|
| | | John F. Tamburo from SQLServerCentral.com Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success. More » |
| Additional Articles from MSSQLTips.com Biml or Business Intelligence Markup Language is an open-source XML dialect to generate Integration Services (SSIS) packages. Take a look at this Biml tutorial to learn how you can use Biml to generate SSIS packages. More » |
| When CEOs consider the benefits of DevOps and whether or not they should introduce it, their viewpoint will be influenced by their ongoing concerns with lowering costs and increasing revenues. As a result, factors like gaining a faster time to market and creating higher quality products will be top of the agenda. It’s a different story for CIOs because their focus is more on processes that can increase the throughput of the IT department, or how skilled IT staff can be recruited and retained. More » |
| Arun Sirpal from SQLServerCentral Blogs When you create a “logical” Azure SQL Server (I say logical because we are not really physically creating anything) there... More » |
| Grant Fritchey from SQLServerCentral Blogs I love when I get the opportunity to present at SQLSaturday events. Even more than that, I love when I... More » |
|
|
| | Today's Question (by Steve Jones): If I connect to SQL Server 2016 and I have never run SET CONTEXT_INFO, what is returned from this code? SELECT CONTEXT_INFO() |
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: context_info(). 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-761 Querying Data with Transact-SQL Prepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. 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 from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by J. Drew Allen): What is returned when you run the following query? SELECT SUBSTRING('ABCDE', 0, 1) Answer: '' Explanation: According to click here If start is less than 1, the returned expression will begin at the first character that is specified in expression. In this case, the number of characters that are returned is the largest value of either the sum of start + length- 1 or 0. Since start + length - 1 = 0, it returns a zero-length string or ''. » Discuss this question and answer on the forums |
|
|
| | Patrick Slesicki from SQLServerCentral.com Here's a script that crawls the registry to find installed instances, services, and service accounts. Must be a sysadmin to run. Please leave coments. More » |
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums. My Backup Jobs Aren't Working - Permission Issue? - I set up a pair of Job Agents to backup the database for a web application weekly and daily the SQL... Index Framentation - Hi, I have tables in databases with avg_fragmentation of 86% and a page count of 26 and even less page count... Prevent SQL from locking at the table level - Hello, Is there any way to limit SQL to locking only at the row level and never at the table level? I... Fill in gaps between 2 dates - Hi All, Need some help in filling up gaps between 2 dates. Scenario : I have Product Location balance snapshot for specific dates ... License dev server - We have our prod server where our we have SSIS installed. Our development team creates packages and update our DBs.... What Extended Events should I use? - I have a scenario where a production SQL server appears to be completely clearing both the plan and buffer caches... Trying to get an SFTP process for SSIS - Hi, I have been looking all over the web for this. I realize that SSIS does not, on its own handle... Parse a string help - I have a string that I need to parse. The text will vary but the format always the same. Example Text: ... Manipulate a field that contains a specific format - Hi, Please can anyone assist with my SQL problem? Here's an example of the contents of a single field: abcdef 01/01/2018 08:15:13 This is... Logical Inquiry and Calculation - Hello there, First of all I thank all the members for their sharing. I was hanging in the question I mentioned below. ... SQL Agent Job - Carry on Failure - Hi I have script that I run to fix orphaned user accounts on a instance - If I run the script in... how to let the recovery model set forever as simple - Dear Friends my sql server is with recovery model set to simple, but every day it is changing to full. how does... Generate UserName from Existing table - Hi Guys, I have one new challenge to generate UserName from the table, below i provide some sample data CREATE... Migrating only database structure having lakhs of objects - Good Morning Experts, We have a request to elevate only the database structure from Dev to QA. Size of database is... Blank rows in Excel export - Hi I have a report that calls a sub report multiple times - All works fine until I export to Excel... Check the configuration and deployment settings for SSIS, SSRS and SSAS - I am working on a tricky project where I do not have any access to the current systems. As a... Using CTE with Parameters in OLEDB Data Source in SSDT (or why is SSDT so braindead?) - <FRUSTRATED RANT> Another title for this post could be "Why is SSDT so braindead?" or "Does Microsoft have a clue about... Need advice on how to process Access DBs with different table structures into SQL Server - I'm looking for some guidance on how to use SSIS to process Access database files into SQL Server. I know... Typically, how often does an ETL process affect (through an update or an insert) a Fact table as a result of activity in a Dimension table? - Hey guys, Thanks in advance for your help. I'm going to try to describe the above situation, and it may conclude... How do you have an append query run automatically based on a new record in table? - Hope I explain it clear enough for people to understand what I'm trying to accomplish. I have tbl1 that gets populated... |
|
| 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 |
|
|