My environment is basically 2008 or 2012 sql servers. I have about 80 databases.
I am using management studio.
when you select a database with management studio... is there anywhere to put comments or notes on what a database is.... example.
database name Accounting
can I right click and add a notation that would say something like. "Accounting database was created in December of 2009 and is used for record keeping for the year 2009 associated with hog trading"
if not... whats the best way that someone can access databases with studio and see a description of the database
I would like to get away from excel and have the databases be self identifying and documented.
Correct, no affect on performance, zilch.
You can add as many different extended properties as you want, just give each a unique name:
Description / Description2 / ...
Description_Developer / Description_DBA
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted? Many believe this is the case.
Let us try to examine for ourselves with an example.
To get started, use the following script, wh…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …