Category: Data Architecture
-
Use TSQL to Generate SQL Server Schema Documentation
There are many tools that you can purchase to generate documentation, however, also costs money or requires an install on client machines or servers. I wanted something fast which would not leave a foot print or require weeks of negotiations to get installed. The T-SQL script generates an HTML document out of the schema results…
-
Learning Guide: Azure Data Solution Architecture Resources
set of curated resources that will get you started. The resources are split into a number of sections that roughly follow the order of your design decisions. With the wide variety of possible architectures, this post concentrates on a data reporting and analytics style of solution.
-
How to Create a Data Governance Framework: Best Practices and Key Components
Explore the comprehensive guide to Data Governance Process. Learn about best practices, key components, and how to implement a successful data governance framework. Boost your data quality and management strategy and insights.
-
Introducing Power BI Object-level Security
This walk-through and resource list will provide an introduction of Power BI’s Object-Level Security (OLS) and when combined with Row-Level security (RLS), you can secure and hide specific metrics, measures, tables, or columns from report viewers when using Roles.