Comments
Sort by recent activity
I spent a lot of time with the SQL Data Catalog team, showed the product to my team at the day job, and provided some feedback based on other products I've seen. I enjoyed working with the team and the product and I'll probably write a new talk for next year about data cataloging. / comments
I spent a lot of time with the SQL Data Catalog team, showed the product to my team at the day job, and provided some feedback based on other products I've seen. I enjoyed working with the team an...
In the US, we have GDPR-like regulations emerging on a state by state basis. California is first, but 22 other states are in motion now too. Which means we could end up with 50+ different regulations (+ depends on what the federal government, DC, Puerto Rico and Guam do) to contend with. That's a lot to track manually, but a tool like this will help a lot. One of the big complications is what is personally-identifiable information. Under current regulations, your name alone is not PII, and your phone number alone is not PII, but together they are PII. That's hard to do with simple table scanning, but I think I'd add a label of "partial PII", and have a Powershell script which analyzes the results of a scan for these two elements, and then recategorizes them as PII. In my line of work, we also have use-by-source concerns. An oversimplified example is as a mortgage company, we deal with a lot of real estate agents, and we need to make sure we have both the correct licensing information as well as the correct contact information. We buy the licensing data from one source, and the only permissable use is for license verification. We'd also like to market to real estate agents to remind them that we offer great customer service. For this, we need to buy another list of data which doesn't guarantee (or even have license data at all). I can categorize data in different tables or databases with a use policy in a way which is documented with the other classifications, in one place.
/ comments
In the US, we have GDPR-like regulations emerging on a state by state basis. California is first, but 22 other states are in motion now too. Which means we could end up with 50+ different regulat...
Don't forget there is a github repo of snippets people had been contributing to, https://github.com/gvohra/sqlpromptsnippets. Maybe RedGate needs to have an "official" repo? / comments
Don't forget there is a github repo of snippets people had been contributing to, https://github.com/gvohra/sqlpromptsnippets. Maybe RedGate needs to have an "official" repo?