Generate Job Schedule Descriptions
A SELECT statement which includes the alpha description of each job's schedule
2011-11-25 (first published: 2007-11-01)
4,545 reads
Richard Sutherland
Open Source SQL DDL Scripting Tool
Keeping track of your DDL is something that is critical and some sort of VCS system should be used. However pulling out your scripts from SQL Server sometimes entails a bit more than the standard scripting. New author Richard Sutherland brings us an open source project that can help you get this done. Complete with code.
2008-03-03 (first published: 2007-03-06)
10,130 reads
Script SQL Server DDL
Scripting SQL Server DDLRichard SutherlandIf you buy into the theory that all database objects should be contained in a source management system such as Visual SourceSafe, and that deployment of database projects should be done from the source management system, then the manner in which Microsoft's Visual Studio 2005 Team Edition for Database Professionals [a.k.a., […]
2007-08-20 (first published: 2007-02-03)
1,397 reads
Script SQL Database DDL
This tool scripts out SQL Server 2000/2005 database objects to individual files in a manner which mimics Microsoft's Visual Studio for Database Professionals [aka, "Data Dude"]. These files can then be placed under proper source management control. An entire database is scripted in one call.Alternatively, it provides a way to simply document the contents of […]
2007-03-12 (first published: 2007-02-15)
2,265 reads
Blogs
Stack Overflow & AI
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...
Checking Myself with GenAI
By Steve Jones
I had a suggestion from somone on a place where AI helps them and...
Redgate SQL Prompt in SSMS 21
Disclaimer: this post is not sponsored by Redgate 🙂 For those who’ve missed it,...
Forums
Deadlocks and Backups - Need help
Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...
Does Version Control Scare You
Comments posted to this topic are about the item Does Version Control Scare You
Unlimited Text
Comments posted to this topic are about the item Unlimited Text
Question of the Day
Unlimited Text
If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?
See possible answers