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
59 reads
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
59 reads
2020-09-30
130 reads
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
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
To finish this short series on extended properties a look at documenting sets of database objects
2011-04-05
8,524 reads
Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties
2011-03-29
11,344 reads
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
11,487 reads
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)
21,981 reads
Generates a list of Server, Database, Table , Column Names and properties
2011-02-08 (first published: 2011-01-31)
1,361 reads
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,544 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers