| A community of more than 1,600,000 database professionals and growing |
| | | Classifying Sensitive Data Our databases store all kinds of data in them, depending on the purpose of your database. Most of us create tables and store data in response to some requirement or necessity in our organizations. Our decisions should be driven by good design principles, and I'd hope they are, but we do need to find a place to put all the data that our system will receive. Depending on the sensitivity or personal nature of data, we may have to alter the way we store data (perhaps encrypt it) or alter the security for parts of the system. This is almost an ad hoc, deal with it at that time task. The exceptions might be when I've had to conform to a regulatory statute, such as SOX, PCI, HIPAA, etc. In those cases, I've often had to ensure the entire database is protected in some way that ensures it meets the requirements of the statute. The time when I have had to think about individual columns of data is usually when building a development database where potentially sensitive information can't be transferred to development machines. In that case, because of the effort of changing data, I'll try to build scripts that change out individual columns and ensure that sensitive data doesn't get copied. However, the data that may be deemed sensitive for one company, isn't always classified that way for another. At least that's been my experience. I shared some of this with the Redgate Foundry, who is running research into data classification. They're looking for people to share opinions, but the project has me curious. I've always felt intuitively we could classify data in tables, but perhaps that's too simplistic a way of looking at the problem. I know that legal groups struggle with some this problem with email and file server documents. Classifying the content in different ways is a challenge. Is it the same in databases? I'm not sure. I don't know if there complex rules needed or if this is a simple problem that we easily solve and rarely deal with. I'm curious from those of you that deal with highly regulated industries. Is data classification something that you work with often? How do you decide the data classes and does this impact your administration of the database? If you don't classify the data, do you worry about the sensitivity of the bits in your database? Let us know today. 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.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 | | | | Write, format, and refactor SQL effortlessly 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 tab coloring you’ll never deploy to the wrong environment again. Download your free trial |
| | | | New SQL Clone: Now supporting databases up to 64TB Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free |
|
|
|
| | | | | Bogdan SAHLEAN from SQLServerCentral.com In this article, we'll explore a less used feature of SQL Server: filegroup restoring, feature that has an interesting consequence because database can become inconsistent without any warning and standard checks don't reveal any issue. More » |
| | Additional Articles from Database Journal Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function. More » |
| | dustinryan from SQLServerCentral Blogs The theme of day 2 of the Microsoft Data Insights Summit was sessions, sessions, sessions! There were a ton of... More » |
| | Koen Verbeeck from SQLServerCentral Blogs A couple of weeks back I blogged about my progress in the “Microsoft Professional Program in Data Science” curriculum. I’ve... More » |
|
|
| | | Today's Question (by Steve Jones): I have a Agent job with a T-SQL step that is scheduled to run once a day (only one schedule attached to this job). There are no alerts attached to the job. The job is disabled, but the schedule is enabled. What information is captured about the job history after the scheduled run time? |
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: Agent jobs. 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 | | Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. In this ebook, we introduce new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TemDB configuration, query store, and Stretch Database Get your copy from Amazon today. | e |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I want to disable database mirroring from the mirror server. When I try to access the properties of the mirror database, the selection is grayed out. From T-SQL, how do I disable the mirroring session for me Sales database on the SQL01 instance in SQL Server 2016?
Answer: ALTER DATABASE Sales SET PARTNER OFF Explanation: The SET PARTNER OFF syntax is used to remove mirroring. Ref: Remove Database Mirroring - 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. How can get sequence Log (Object log) history, - How can get sequence Log (Object log) history, date ,minimum and max values for a day wise in Oracle Or... Help needed in resolving dead lock - Hello All, We are getting frequent deadlocks on one of sql server instance. Any help\suggestions will be greatly appreciated. Below is the deadlock... Dacpac error- SQL Server detected a logical consistency-based I/O error - Hi, Below error raised when apply dacpac in sql server16 database Publishing to database 'SHIPMATETEST' on server '103.231.40.95'. Initializing deployment (Start) Initializing deployment (Failed) ***... DBCC Check hanging, killed but does not roll back. - Hi everyone. I have a problem with a Killed session. The command Issued was DBCC CHECKDB () WITH NO_INFOMSGS, ALL_ERRORMSGS (Ola Halengrens... Re-installing a SQL Server Instance - Hi, I have a need to completely uninstall and re-install SQL Server from several servers but I'd like to preserve as... 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... replacing hard coded value with column name fails the query - Below I've commented out what is failing to work. By fail, i mean no result set. when i substitute o.Datekey for '2017-05-17'... Tempdb - Why I could not able shrink Tempdb even free space available in Tempdb. Please find attached screenshot . What happens when Trial expires? - I recently inherited an instance where the trial had already expired. This happened around 3 months ago and we had... Change SQL Server IP - Hello all, I Have a Server with 2 network cards. One is 1Gb network and Other is 10Gb. The installed SQL Server... If statement in T-SQL - Hi guys, I am trying to display item_name with a new category, which says the following term ( i have pasted my... related query - Take a look at he picture. We have many jobs. How can I write a SELECT statement that would tell me... How to calculate cost of flight and hotel and transfer per every program ? - How to design database for tourism company to calculate cost of flight and hotel per every program tour based on... Parallelism (Repartition Streams) 55% in exec Plan, can I fight it ? - Hi, I just saw that symbol in my plan for complicated sp and don't get it if I can improve anything... Got a weird one for ya.... - Have a sproc that is throwing an error when trying to do an Insert statement. Gives the "Invalid Object Error"... Unable to understand the Query Logic - Hi While I was browsing for some interesting puzzles on t-sql I found the below one. but I am unable to understand... Data Driven Subscriptions without SQL Enterprise - Introduction Do you have SQL Reports that need to go to different people but each person's report has different parameters? Don't... Select In Xml Field - Hello, I have problem with select. I need to have a value of NumberSerializedLabels in this xml structure in another column.... Extract column from flatfile - Hello, I have to extaract a column from faltfile , whose characters /length is "55575". How is that possible? it is then... need expression to return '2017-06-01 00:00:00.000' in exactly that format - for starters, how can i just pass hardcoded value to the variable. I need, at the very least, for testing... |
|
| 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 |
|
|
