Microsoft recently added interesting features in SQL Server and Azure SQL Database for GDPR - a new important EU regulation on personal data management.
Product manager LinkedIn
Piotr is a business analyst, software architect and project manager with 15+ years experience and background in software development, databases. His specialties are data warehousing/BI and business applications.
GDPR is a great challenge for all companies that process EU citizens' data. This article defines what personal data is under GDPR and provides a convenient list of example fields or tables you should look into while preparing to GDPR compliance.
Most today's database engines do not support foreign keys across databases, servers and engines and that would be very useful to understand data. See how you can document them with Dataedo cross-database relations.
Too often, developers produce database documentation containing just a schema information - table and column names, without any descriptions. See a few examples.
Most popular database engines provide option to provide descriptions for schema elements. This article shows how to check if your database uses them.
Long awaited Dataedo 6.0 is finally here.
A few scenarios how you can leverage Dataedo repositories to manage documentation in complex database systems.
I believe you have seen a lot of confusing table and column names and wondered who made them. Here I'm considering the reasons why this happens.
See how easily and conveniently you can discover, browse and document table and column relationships in your databases.
We are proud to announce the release of beta of our ground breaking Dataedo 6.