Activity overview
Latest activity by ben_b
Internal Usage Survey
Hi RedgateWe have 25 toolbelt licenses used by people across 6 different teams.I was wondering if you have any sort of digital survey I can use internally that would establish1 - Who is using what....
Search across multiple servers
we have been discussing Microsoft Purview at my place for a little while. It is a confusing product and takes a long time to get your head around it.One of the primary use cases for the Purview da...
1. Run this query, save results to excel and then send to the business analyst to fill in the description
SELECT TABLE_SCHEMA AS SchemaName,
TABLE_NAME AS TableName,
COLUMN_NAME AS ColumnName,
'' AS [Description goes here]
FROM
INFORMATION_SCHEMA.COLUMNS
ORDER BY SchemaName,
TableName,
ColumnName;<br>
2. Once you have the description from the BA, plug them into this query exec sp_addextendedproperty
@name = N'MS_Description'
,@value = N'Description supplied by the business analyst'
,@level0type = N'Schema', @level0name = 'dbo'
,@level1type = N'Table', @level1name = 'The table name goes here'
,@level2type = N'Column', @level2name = 'The column name goes here'
3. Run SQL doc and it should produce what you need This all said, I've not actually tried it myself yet. / comments
1. Run this query, save results to excel and then send to the business analyst to fill in the description
SELECT TABLE_SCHEMA AS SchemaName,
TABLE_NAME AS TableName,
COLUMN_NAME AS C...
Hello the below link explains how you can use sp_addextendedproperty within SQL server to add explanations to column and tables and store this information in the database... You can then use red-gate SQL doc to use that information to generate a data dictionary in Word/PDF/HTML https://www.red-gate.com/hub/product-learning/sql-doc/documenting-a-sql-server-data-catalog-in-html-and-git-markdown?product=sql-doc One potential alternative tool is Microsoft Purview - it should mean that you can add table/column descriptions using a web UI (as asset descriptions within Purview Data Catalog)... although I have not actually used Purview yet so remains unproven to me as of today. cheers Ben / comments
Hellothe below link explains how you can use sp_addextendedproperty within SQL server to add explanations to column and tables and store this information in the database... You can then use red-gat...
as an update, in case someone has similar use case, I am now looking at two options: 1. 'analyse data' feature in excel 2. 'column profiling' feature in power bi. struggling to get the Power BI to work but will do some more testing. more information below: https://support.microsoft.com/en-us/office/analyze-data-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4 https://sqlskull.com/2021/02/28/profile-data-in-power-bi/ / comments
as an update, in case someone has similar use case, I am now looking at two options:1. 'analyse data' feature in excel2. 'column profiling' feature in power bi.struggling to get the Power BI to w...
Data Profiling Tools
I feel like this comes up for me every couple of years for me.We want to get data owners / stewards to look at specific "critical data elements" and use their industry expertise to feedback data qu...
OK, thanks @Ben_P - useful to know [image] / comments
OK, thanks @Ben_P - useful to know
Azure Synapse support across red-gate products
Hi All. I've searched the forums and found a few answers (some of which were recent but some of which were a couple of years old), but I was hoping to get all the information in one place and conf...
Best of luck Annabel, you'll be a great mum [image] / comments
Best of luck Annabel, you'll be a great mum
Kathi did a great job. I remember she did one on Kerberos / SSRS that i'd struggled with for ages. Congrats on the new role [image] / comments
Kathi did a great job. I remember she did one on Kerberos / SSRS that i'd struggled with for ages. Congrats on the new role