Getting Started with Azure Purview for Data Governance
In this article we will explore how to get started with Azure Purview and then explore some of the features within Purview Studio.
2021-06-28
data governance
Effective Data Governance: Being Grown Up About Data
William Brewer explains how to make data governance a continuous organizational activity, based on well-established standards and practices, rather than a knee-jerk response, and which skills and tools will help you achieve compliance, including SQL Data Catalog for discovery and classification of data held in SQL Server.
2020-12-16
Presenting the Facts about Data Breaches
If you're faced by an investigation team, after a data breach, it is no use putting on your 'Mr. Sincerity' face and making vague statements. They want documented facts.
2020-11-14
132 reads
Data Governance, DevOps, and Delivery
Data governance must be included in DevOps practices. William Brewer explains how to define business policies and standards to ensure compliance with privacy regulations and bring data governance to...
2018-06-29
2,318 reads
Data Governance, DevOps, and Delivery
Data governance must be included in DevOps practices. William Brewer explains how to define business policies and standards to ensure compliance with privacy regulations and bring data governance to all aspects of continuous delivery.
2018-06-13
2,693 reads
Questions about Data Governance that You Were Too Shy to Ask
A company’s data is one of its most valuable and important resources. Managing and protecting that data are big responsibilities, and a data governance processes must be put into place to avoid misuse and to meet regulations. In this article, William Brewer answers questions you may have about data governance but were too shy to ask.
2018-02-19
4,962 reads
Containers for enhanced Data Governance and Compliance
Complex data environments sometimes need new techniques to properly manage the information. See how Windocks can help with containers and SQL Server.
2017-07-25
304 reads
RE: INSERT GetDate() into open table
TIA,There is no way I know of to automatically (unless anyone else knows better??) insert the current datetime in to a table open within EM unless the COLUMN has a default constraint set using the SQL getdate() function.Your other options are:- Write a SQL INSERT statement such as below which captures the current datetime using the getdate function: INSERT […]
2005-04-12
1 reads
RE: What is your ''''Rule of Thumb'''' for db file size.
My rule of thumb is 1 and 1 for databases under 100-200 Gb. After that, it all depends ... on size, storage, activity, application availability ...
2005-04-08
2005-04-05
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers