SQLServerCentral.com Articles tagged Documentation

Document First, Code Later

Mon, 10 Sep 2012 06:00:00 UT

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.

More Tips for New (and old) DBAs

Fri, 03 Jun 2011 06:00:00 UT

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.

Want to work faster with SQL Server?
If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download the SQL Toolbelt here.

Oiling the gears for the data dictionary

Thu, 17 Feb 2011 07:00:00 UT

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.

SQL Server CRUD-Generation from System Views

Mon, 26 Jul 2010 06:00:00 UT

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

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial.

Database Documentation: Joining up the Dots

Mon, 15 Mar 2010 06:00:00 UT

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.

SQL Server Third Party Application Requirements Document / Checklist

Mon, 08 Feb 2010 07:00:00 UT

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.

More Tips for New (and old) DBAs

Fri, 03 Jun 2011 06:00:00 UT

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.

A Dearth of Comments

Mon, 05 Jan 2009 07:00:00 UT

Steve Jones talks about one of the least favorite things for IT people: documentation. How much do you really need to do?

A Dearth of Comments

Mon, 05 Jan 2009 01:58:43 UT

Steve Jones talks about one of the least favorite things for IT people: documentation. How much do you really need to do?

A Dearth of Comments

Mon, 05 Jan 2009 01:50:07 UT

Steve Jones talks about one of the least favorite things for IT people: documentation. How much do you really need to do?

Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

A Dearth of Comments

Mon, 05 Jan 2009 01:36:59 UT

Steve Jones talks about one of the least favorite things for IT people: documentation. How much do you really need to do?