Midlands SQL Server User Group, being held in The Briar Rose Pub in the centre of Birmingham on Thursday 16th February.
Session 1: Cursors are evil and shouldn't be used - with Dave Ballantyne
Session 2: Introduction to Powershell - with James Boother
6.00pm – 6:30pm Meet, Greet & Beer
6:30pm - 7:30pm Cursors are evil and shouldn't be used (Dave Ballantyne blog|twitter)
That’s
frequent advice given on forums when asking about performance problems.
Its correct advice, but how do you go about removing cursors and what
do you replace them with? That’s the tricky part! By deconstructing a
cursor based routine, Dave will demonstrate a number of TSQL techniques
and how they can be applied to generate a new routine with significantly
less overhead.
7:30pm - 8:00pm Break, Food & Beer
8:00pm – 9:00pm Introduction to Powershell (James Boother blog|twitter)
James will demonstrate what Powershell is, what it can do and why you should use it.
We'll
be putting on food for the event, so please do register so we know
numbers. If you then can't make it we'd really appreciate it if you'd
unregister and/or let us know.
When you get to The Briar Rose, go in through the Hotel entrance to the right, up to the 1st floor and follow signs to the conference room. Grab yourself a drink from the bar on your way!
If you need
any further details or have any requests for this or future Midlands
SSUG events, please let me (Alex Whittles) know, either on Twitter
(@PurpleFrogSys or @SSUGMidlands) or email SSUG@PurpleFrogSystems.com
See you in February!
Speaker profiles
Dave Ballantyne
Dave
is a freelance SQLServer database developer/designer and has been
working in the IT field for over 20 years. Tuning and optimizing
SQLServer processes is his particular talent. Dave regularly
contributes to online forums and is a regular speaker at UK events such
as SQL Bits and user groups. He also is founder of the Kent
.NET/SqlServer user group.
James Boother
James
Boother is the co-founder of LSS a Microsoft Gold Partner delivering
Dynamics CRM solutions. He's a passionate .NET and SQL developer working
on projects in re-insurance risk modelling through to e-commerce, a
formula 1 fan and Dad to three.