Scripting is essential for many tasks: eg. automating tasks and streamlining installs and performing changes on remote databases. Solid scripting is essential in larger organisations - all changes are deployed to production in this way. Improving your scripting not only makes you more productive but can also make a difference to your pay packet - giving you access to these larger and more formal environments! On the surface, scripting is not the most exciting of concepts BUT the world has changed significantly since isql grew up and became SQLCMD and many uses that we could only once dream of are now made possible with SQLCMD. If you've not used SQLCMD yet - be prepared for a surprise - I can guarantee you that once you leave this session you'll have the "by default, open new queries in SQLCMD mode" option permanently checked! This session will be useful to you even if you can only "string together a handful of SQL queries" - as that's all scripting is at the simplest level! This session goes well beyond the concepts and shows tried-and-trusted techniques used every day by the session's presenter.
(no tags)
Presented by Hue Holleran at SQLBits II