Session Details -
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.
|
|
|
Hue Holleran
|
|
|
|
Hue Holleran is a professional consultant specialising in database-centric solutions and specifically SQL Server. After 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 mid 1980's and 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 enterprise capabilities of SQL Server 2005 to implement truly robust and resilient systems that retain excellent performance even in the most challenging of environments.
Hue is currently consulting in one of those challenging environments with world-leading utilities supplier, Actaris. Many systems with daily loads of 100's millions of records and retained record volumes in the billions - a significant and enjoyable challenge!
|