How Wrong is Stack Overflow?
Steve has a few thoughts on a rant about Stack Overflow. An experienced developer thinks much of their information is wrong and things are getting worse.
2023-08-09
222 reads
Documentation
Creating Documentation
Who should create documentation for software? In many companies, it's the developers. In fact, in Redgate, often our developers are tasked with updating articles for products on our documentation site. We do have a streamlined process that has developers can submitting changes in some format (markdown? ) and an automation process that automatically updates the […]
2023-04-26
173 reads
Reading and Writing your Database's Documentation using JSON
One of the problems to which I keep returning is finding the best way to read and apply documentation for databases. As part of a series of articles I'm doing for Redgate's Product Learning, I've been demonstrating how to maintain a single source of database documentation, in JSON, and then add and update the object […]
2021-06-28 (first published: 2021-05-28)
3,325 reads
Document the output of all the SPs in HTML fashion
A script to document the output columns of all the SPs in a given database, with a HTML formatted document
2015-09-24 (first published: 2015-09-08)
1,882 reads
Registered server documenter
Returns server and instance information via a registered server query, regardless of SQL version.
This script is more of how to get the data, and not so much about the data returned by my choice of columns.
Tested on 2008+
2015-08-28 (first published: 2015-08-07)
1,295 reads
Documenting your SQL Server Database
One of the shocks that a developer can get when starting to program in T-SQL is that there is no simple way of generating documentation for routines, structures and interfaces, in the way that Javadocs or Doxygen provides. To embed the documentation in the source is so obvious and easy that it is a wrench to be without this facility. Phil Factor suggests a solution.
2015-05-18
9,083 reads
2016-08-10 (first published: 2015-05-05)
5,294 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.
2014-09-30 (first published: 2012-09-21)
8,027 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.
2014-04-25 (first published: 2011-02-17)
14,410 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.
2010-02-08
2,823 reads
Blogs
Get Configuration Change History From the SQL Server Error Logs
By SQLPals
Get Configuration Change History From the SQL Server Error Logs There...
A NEW’er Solution For An Old Problem: How To Gain Access To SQL Server When No DBA Around
By SQLPals
How To Gain Access To SQL Server When No DBA ...
Forums
Managing some particular dimensions in a data warehouse based on medical records
Hi, I need to design a data warehouse solution to manage medical records about...
Gentlest of Reminders, Don't Stop Learning
Comments posted to this topic are about the item Gentlest of Reminders, Don't Stop...
table with varcahar(max)
Gurus, there is a table which is very slow to query , it has...
Ask SSC