Welcome to the second installment of my workshop series of articles.
This time, the workshop focuses on tools, for what is more important
to the master craftsperson than the tools used in the craft?
While most people are resigned to using Microsoft's default IDEs for
working with SQL Server (Query Analyzer, SQL Management Studio), both
utilize terribly subpar text editors which are just too clunky to work
with when dealing with complex procedures.
Enter EditPlus, the greatest text editor, ever. Evar. I've been using it since my Freshman year in college when a co-worker at iCan Services
introduced it to me. I've been using it for everything from
Prolog to Java to C# to DHTML to TSQL. With a little help from
some of the tools that ship with SQL Server, we can hook up EditPlus so
that working with TSQL is no longer a pain in the butt.
If you're tired of working with Query Analyzer and you're a cheap bastard like me, then this workshop is for you 😉
Please feel free to leave comments, questions, criticisms, error reports, and what not in the thread.