2005 SQLCMD Scripting
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.
Speaker focus
Hue Holleran is a professional consultant specialising in database-centric solutions and specifically SQL Server since v4.2 and Oracle since v7 - and all versions since! After more than 20 years as a consultant to over 100 organisations and some of the largest global brands in various industries - he has established a reputation for leading teams leveraging modern tools and technologies in innovative and practical ways.
Being old enough to remember all too well developing database solutions in 'C' on a mainframe and DBase and FoxBase+ in the 1980's and Oracle and SQL Server in the 1990's - Hue is one of the first developers of that "modern" approach: client/server!
Having frequently presented on various topics since presenting for Microsoft at all UK venues for the launch of Visual Studio 6 in 1998, Hue's current focus is on leveraging the database's enterprise capabilities to implement truly robust and resilient systems that retain excellent performance even in the most challenging of environments.
Other sessions from this conference