|
|
|
|
|
SQL-Programmer IX SP2 with TSQL Debugger 1 2 3 4 5 6 7 8 9 10 11 12 Personal Working Folders are another way to improve your productivity. Any object can be included in a PWF. You can then open the PWF which floats as a separate window into your development environment. If you need anything from the PWF, simply drag and drop it in the location you want it. Need to explicitly reference column names in a script, but don't want to type all of them? Just add that table to a PWF, highlight all of the columns, and drag/drop them into the script you are working on. Want a standard header for all stored procedures and triggers? You would think you could create a batch object with that header, add the batch object to a PWF, and drag/drop the header into a trigger or stored procedure. Unfortunately, batch objects can't be added to a PWF. You can get around this by creating a dummy stored procedure with that header and adding it to the PWF. You can download a very simple PWF that I created from the pubs database here.
No development tool would be complete without source code control. Raise your hand if you don't have every piece of SQL in your databases under source code control. Everyone of us is guilty of this to one degree or another. With SQL-Programmer, you have no excuse at all. You can configure it to link into Visual Source Safe, PVCS, or MKS Source Integrity. I know. Some of you are out there telling me that there is an excuse, because you don't have any of these in your environment. You lose that argument also, because SQL-Programmer packs its own source code control if you don't have or don't want to use one of these. When you enable source code control, SQL-Programmer will create 2 tables in your database: SQL_Programmer_In_Out and SQL_Programmer_History. The source code control process is seamless to the users. When you extract an object using either Access Manager or Explorer, it is automatically checked out. When you close the editor, it is automatically checked in and you are prompted for a comment.
SQL-Programmer IX SP2 with TSQL Debugger 1 2 3 4 5 6 7 8 9 10 11 12 |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
