Removing Extended Properties
With the new labeling and classificiation options in SQL Server, there might be a need to remove these labels before deploying the database.
2020-07-31 (first published: 2018-12-20)
3,724 reads
extended properties
Scripting the Description of Database Tables Using Extended Properties
Stored procedures, for example, are very easy to document. The comment block at the beginning stays with the code and a CREATE or ALTER script contains everything to reproduce the proc. SQL Server tables, however, are more difficult to document. You can use Extended Properties to document columns and constraints, but working with Extended Properties is difficult at best. Phil Factor demonstrates ways to easily add Extended Properties to your build scripts.
2018-03-23
3,324 reads
Track Sensitive Data with SQL Server Extended Properties
A major priority in our industry today is protecting and tracking sensitive data. See how you can utilize SQL Server Extended Properties to do just that.
2019-08-09 (first published: 2017-11-27)
3,714 reads
Reading, Writing, and Creating SQL Server Extended Properties
There is a great gulf between wanting to document your database properly with extended properties and actually doing it. Extended Properties have many uses but they aren't easy to use. Phil Factor is on a mission to make it easier for ordinary mortals to use extended properties as intended, to aid the database development process.
2016-12-27
3,765 reads
How to Capture Deleted Records
This article shows a few techniques that help in capturing deleted records.
2016-12-19
11,539 reads
Deploying Databases to the Azure Cloud: an extended plea
Is there a sound technical reason why SQL Azure can't support extended properties?
2013-02-25
131 reads
Managing Data Dictionaries in DW and DSS Database Applications
Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.
2011-12-20
6,188 reads
Industrial-strength database documentation using Extended Properties
To finish this short series on extended properties a look at documenting sets of database objects
2011-04-05
8,278 reads
Modifying and deleting extended properties
Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties
2011-03-29
9,176 reads
Extracting Extended Properties
In this second article of a short series we look at using the Extended Properties which you have added to a database
2011-03-22
10,265 reads
Blogs
T-SQL Tuesday #176 One piece of advice that you wish Past you had
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
T-SQL Tuesday #176: One piece of advice for Past Steve
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
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