SQLServerCentral: Content tagged Documentation

SQL Server Documenter

This script was designed to provide you with all the information needed to rebuild your server in case of a disaster. Current version work with 2005, 2008, 2008R2 and 2012. Read more...

By Rudy Panigas 2012/12/25 | Source: SQLServerCentral.com | Category: documentation

Rating:

|

Discuss |

Briefcase | 3,299 reads

SQL Server Documenter

This script was designed to provide you with all the information needed to rebuild your server in case of a disaster. Current version work with 2005, 2008, 2008R2 and 2012. Read more...

By Rudy Panigas 2012/12/25 | Source: SQLServerCentral.com | Category: documentation

Rating:

|

Discuss |

Briefcase | 3,299 reads

Phil Factor on the many advantages of building the code from the documentation. For one, it forces us to learn the language and concepts of the business processes before designing the schema. Read more...

By Phil Factor 2012/09/10 | Source: SQLServerCentral.com | Category: editorial

Rating:

|

Discuss |

Briefcase | 208 reads

Make a list of all tables in all data bases with creation date

This scripts allows to store all tables names in all databases for the current server, it stores also the creation date, this script can be runned ins SQL Server 2000 or later Read more...

By Kamel AL GAZZAH 2012/07/02 | Source: SQLServerCentral.com | Category: tables names

Rating:

|

Discuss |

Briefcase | 1,267 reads

More Tips for New (and old) DBAs

Following up on the popular article: Tips for New DBAs, author Craig Outcalt tackles three more issues including customer support and why you should learn T-SQL. Read more...

By Craig Outcalt 2011/06/03 (first published: 2009/01/12) | Source: SQLServerCentral.com | Category: career

Rating:

|

Discuss |

Briefcase | 19,847 reads

Oiling the gears for the data dictionary

Documenting the database is always a challenge, and there are many techniques you can use to help all the people on your team understand what all your tables are used for. David Poole brings us an easy way to implement a framework for documentation. Read more...

By David Poole 2011/02/17 | Source: SQLServerCentral.com | Category: documentation

Rating:

|

Discuss |

Briefcase | 7,532 reads

SQL Server CRUD-Generation from System Views

If you are not keen on repetitive typing, you can still rapidly produce production-quality documented code by planning ahead and using Extended properties, and system views. Phil Factor explains, with some Scary SQL Read more...

By Additional Articles 2010/07/26 | Source: SimpleTalk | Category: t-sql

Rating:

Rate this |

Briefcase | 3,004 reads

Database Documentation: Joining up the Dots

This week, a guest editorial from Phil Factor on how SQL Server database documentation falls woefully short of what is required and expected by most development teams. Read more...

By Phil Factor 2010/03/15 | Source: SQLServerCentral.com | Category: editorial

Rating:

|

Discuss |

Briefcase | 364 reads

SQL Server Third Party Application Requirements Document / Checklist

In August 2009 I wrote a tip concerning checklists for third-party applications running against Microsoft SQL Server. I thought it was a good time to revisit the topic and provide an added bonus: a requirements document that you can download and customize for your own uses. Read more...

By Additional Articles 2010/02/08 | Source: MSSQLTips.com | Category: documentation

Rating: (not yet rated) Rate this |

Briefcase | 2,498 reads

More Tips for New (and old) DBAs

Following up on the popular article: Tips for New DBAs, author Craig Outcalt tackles three more issues including customer support and why you should learn T-SQL. Read more...

By Craig Outcalt 2011/06/03 (first published: 2009/01/12) | Source: SQLServerCentral.com | Category: career

Rating:

|

Discuss |

Briefcase | 19,847 reads