Generating Art
Using metadata to drive software is very useful, which means that having clean data and lots of metadata can help create better software.
2021-03-30
70 reads
Metadata
2020-09-30
153 reads
What’s in that database? Getting information about routines
There is a lot of information held in SQL Server metadata about your SQL Server procedures, triggers, views and functions. Some of it is valuable, other nuggets are useful and a few are rather dull but worthy. It really all needs to be tied together to tell the full story, especially if you are not able to, or do not want to, query the metadata directly.
2019-12-02
SQL Server Metadata Functions: The Basics
To be able to make full use of the system catalog to find out more about a database, you need to be familiar with the metadata functions. They save a great deal of time and typing when querying the metadata. Once you get the hang of these functions, the system catalog suddenly seems simple to use, as Robert Sheldon demonstrates in this article.
2016-03-28
6,652 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,631 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
12,224 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
12,296 reads
Extended Properties Introduction
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
2013-09-27 (first published: 2011-03-17)
24,037 reads
List all Columns in Server Part 2
Generates a list of Server, Database, Table , Column Names and properties
2011-02-08 (first published: 2011-01-31)
1,373 reads
List all columns in server
I came across a project which required a list of all columns within a server and thought I would post it here in case anyone else had this requirement.
2010-09-30 (first published: 2010-09-28)
1,568 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Kemang CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Kemang Sel. No.60, RT.4/RW.2, Bangka, Kec. Mampang Prpt., Kota Jakarta...
BCA KCP Panglima Polim Raya CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec....
BCA KCP Pejaten CSTelpon : 0853-73737551
Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No. 98F & 98G,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers