Track Sensitive Data with SQL Server Extended Properties (2019-08-09)

 SQLServerCentral Newsletter for August 9, 2019 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Track Sensitive Data with SQL Server Extended Properties]( - [Power BI Bubble Map, Shape Map and Filled Map Examples]( - [Find out exactly what SQL Monitor can save you]( - [From the SQL Server Central Blogs - Fantasy Football - A League of Our Own - Want to Play?]( - [From the SQL Server Central Blogs - Life Support 2008 – Audit Logons]( Question of the Day - [Modern Datatime Addition]( [Redgate SQL Provision]( The Voice of the DBA  The 2019 Home Lab Many of us won't grow and expand our career completely at our jobs. While some employers will provide training in the form of funds to buy books, take a class, or learn in some other way. I think most employers will understand that you are learning at work and need time to experiment and practice some skills. That isn't necessarily going to be enough time for you to learn and practice everything at work. Many of us end up doing some normal work at home, and we'll likely need to do some career growth at home as well. That means some sort of resources that are available to work with the data platform. These days I'd recommend a lab of some sort in Azure or AWS, but I know many of you are worried about costs and uncomfortable with building a lab on a service that might require a monthly charge. I think you can easily get away with a minimal or zero monthly charge, but I do understand your concerns. That means a home lab, and I wanted to ask this week what you have and need in your lab. I've [asked in the past](, but it's 2019, so let's revisit the question. I [wrote about this at Quora](, but what would you do today if you were starting? Or what is your current lab? For me, I have a desktop machine at home that really powers my lab. I run VMWare, but if I were more cost conscious, I'd just use Hyper-V or Virtual Box for full machine work. I think containers are the future and I'd suggest you [start learning about them](, but for now, have a virtualization method of setting up a machine and installing SQL Server. There are evaluation versions you can run for Windows, but certainly you can also just install SQL Server on your system. Developer edition is free, so no excuses here. While some might want complex setups for HA, DR, and other testing, for most of us, a developer edition, a little disk space, and some time will provide a lab where we can get things done. There are lots of [Stairway series]( here at SQLServerCentral, [tons of articles here]( and at [Simple Talk]( that you can follow along with, and [many questions in our forums]( that you might read the first post and try to answer on your own. If you have a lab, let us know how you set it up today. If you don't, maybe this is a good weekend to start thinking about how to set one up. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums]( [Redgate SQL Provision](   Featured Contents [Track Sensitive Data with SQL Server Extended Properties]( Ronny Smith-325261 from SQLServerCentral.com A major priority in our industry today is protecting and tracking sensitive data. See how you can utilize SQL Server Extended Properties to do just that. [Power BI Bubble Map, Shape Map and Filled Map Examples]( Additional Articles from MSSQLTips.com In this tip we look various map visualizations like Bubble, Shape and Filled Map visualizations you can use with Power BI. [Find out exactly what SQL Monitor can save you]( Additional Articles from Redgate Redgate’s SQL Monitor was named the most popular third-party monitoring tool in this year's State of SQL Server Monitoring Report. Find out exactly what SQL Monitor can save you and your company with the ROI calculator. From the SQL Server Central Blogs - [Fantasy Football - A League of Our Own - Want to Play?]( GRE (Gethyn Ellis) from The SQL DBA in the UK It feels daft me saying the football season is only 9 days away, when in fact The Ashes cricket series is only starting today at Edgbaston. The Ashes are... From the SQL Server Central Blogs - [Life Support 2008 – Audit Logons]( SQLRNNR from SQL RNNR Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance. Related...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Modern Datatime Addition What happens with this code? DECLARE @MyDate DATE = '2015-08-27' , @MyTime TIME = '15:33:21.057'; SELECT MyDateTime1 = CAST(@MyDate AS DATETIME2) + CAST(@MyTime AS DATETIME2); Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Creating External Tables When creating an external table in SQL Server 2017, I can specify a DATA_SOURCE parameter. What can I use as the value for this parameter? Answer: An external data source Explanation: The Data_Source parameter is designed to take the name of an external data source that you have already created. Ref: CREATE EXTERNAL TABLE - [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](. --------------------------------------------------------------- SQL Server 2017 - Administration [veeam backup permission issue]( - Hi, From Veeam we are taking SQL Server backup. we are using ABC\abcadmin credentias to take the backup. We got a below warning. Warning: [TDB]Unable to update SQL backupset for instance : Code = 0x80040e09 Code meaning = IDispatch error #3081 Source = Microsoft OLE DB Provider for SQL Server Description = The UPDATE permission was denied […] SQL Server 2017 - Development [Understanding schemas]( - I queried sys.tables, sys.all_views, sys.all_objects and .  The following appear to be views: 1.   tables 2.   all_views 3.   all_objects In all 3 of these cases what is the ‘sys’ part? Isn’t that a schema? I did a SELECT * on all_objects so I can view all objects. I have a few questions about the results of […] [Problems with creating a foreign key column]( - Here is the code I am using: ALTER TABLE Costpoint.ProjectCodes ADD CONSTRAINT FK_ProjectCodes_Employee FOREIGN KEY (projectMgrID) REFERENCES Employee(employeeID); I am getting the following error: Msg 547, Level 16, State 0, Line 33 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_ProjectCodes_Employee". The conflict occurred in database "Amargosa Hotel", table "dbo.Employee", column 'employeeID'. I […] SQL Server 2016 - Administration [Indexes are not replicated]( - I reconfigured the transactional replication on my database and i found indexes are not replicated to the subscriber in all the tables how to create the indexes on all the tables in subscriber with out effecting the replication [SSISDB is in recovery]( - Hello, so my SQL agent job SSIS Server Maintenance Job has slowly been getting slower and slower over the past week, then today it ran over 8 plus hours when suddenly the SSISDB transaction log filled up max (not the drive Thank GOD) but now the SQL agent job failed and the SSISDB is "In […] [Script to compare tables between two databases]( - Hi, I have same set of tables in Database A and Database B. If there any changes occurs to a table in Database A, then I have to make same changes in database B. Is there way to query and find the differences between tables in Database A & Database B? SQL Server 2016 - Development and T-SQL [SSIS and flat file column headings with special characters in them]( - Thanks in advance for any help! I have a csv file that has a header row in which the header column titles have some special characters in them. For example, the column for a diagnosis code (we are a healthcare organization) might have the heading "Diagnosis: Primary". For reasons I won't get into here, I […] [Group by and a list.]( - Suppose I want to do a count, grouped by an article and some columns I do not want to group on but I want some examples of the content. Is there a 'simple' solution for this. (Not using FOR XML) Example result. Counted  Article   Colors        […] [Macro in SSIS, pops up for user name password]( - Hi Guys, I am running a Macro file in SSIS VB script task. My macro pulls data from a https url and url requires user name and password. My package works fine in visual studio project solution but it pops up to enter user name and password. I need to schedule this package to run […] Administration - SQL Server 2014 [Suspend-ClusterNode and Move-ClusterGroup]( - Hello everyone , In a SQL Server Fci cluster Does this Powershell command Permit to transfer resources to the second node of my cluster Suspend-ClusterNode xxxxx -Drain -Whatif or I must run the command too Move-ClusterGroup “GROUPNAME” –Node “xxxxx ”  thanks [Always on Quorum and Listener]( - I have three cluster nodes configured for Always on Availability group, two nodes are in same location(node1 primary and node2 secondary with synchronous mode) and the third node(node 3 another secondary replica  in DR with Asynchronous) would be in DR location. Also, I have configured for automatic failover and trying to understand and ensure that […] SQL 2012 - General [How to Query an Excel file with mutiple cells for one single ID]( - Hi Folks, My first question here. This may be lengthy, sorry in advance:-) I am looking to read an excel file into a SQL Server table. The issue I am having is the data entry in the excel file was done in such a way that a person can have multiple pieces of software listed […] [BEGIN TRANSACTION, ROLLBACK TRANSACTION, COMMIT TRANSACTION]( - I do a lot of ad hoc update, insert, delete statements and was wondering if I should encapsulate using BEGIN... ROLLBACK... COMMIT to give me an out if something goes wrong like below: BEGIN TRANSACTION UPDATE B SET expired = -1 FROM GCDF_DB..BillingThirdNotice B INNER JOIN GCDF_DB..Certs C ON B.PeopleID = C.PeopleID WHERE C.certificationExpireDate < […] SQL Server 2008 - General [SQL Server Agent Job - Decision Extract Question and Purpose]( - Hello Support Forum, I've inherited a 2008 R2 server and after scrubbing through the maintenance Plan and Job setup, I came across a scheduled event with the purpose of conducting a "Decision Extract" for an entire Database (that you specify). I've looked at the Query and can follow it no problem but I'm unaware of […] Reporting Services [Creating bell curve in SSRS]( - Hi,  I have a report that shows how long we have spent on certain matters (I work for a solicitors). I round the amount of time spent on a matter to the nearest hour so we could have 5 matters where we spent 1 hour, 3 matters where we spent 2 hours, 1 matter […]   [RSS Feed]([Twitter]( This email has been sent to {EMAIL}. 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. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -