Come and join us for this great evening of developer focused content. These meetings are great opportunities to meet other SQL Server professionals, get your burning issues solved.
This event brings a new slot to our agenda - the open mike slot where you can bring your 5 minute canned demo or hints and tips and present it to the group with support from the other presenters for the evening.
6:00 - 6:30 Meet & Greet
6:30 – 6:45 Intro, whats in the news, Q&A – James Rowland-Jones, Christian Bolton & Tony Rogerson.
6:45 – 6:50 – Dev Nugget – James Rowland-Jones
6:50 – 6:55 – Admin Nugget – Christian Bolton
6:55 – 7:00 – Open Mike Slot – Tony Rogerson
7:00 - 7:45 Using Table valued parameters - James Boother.
7:45 - 8:10 Networking with Beer and Pizza
8:10 - 9:00 Brokering Innovation in SQL Server – Simon Munro
About Simon Munro
Simon is a solution architect working at Conchango, focusing on architecture within the Microsoft Technology stack. He has been working with SQL databases for nearly fifteen years on Oracle, Interbase and SQL Server, which he first used as version 4.21 on Windows NT. He has been architecting solutions mainly in financial services and retail – based on large databases with complex user interfaces and rigorous transactional requirements. While working on the development and .net side of applications his strong background in formal data modelling methodologies and great successes with well built SQL databases means that he sees SQL Server as more than just a persistence store for objects. Simon champions the use of database capabilities as a core part of a well implemented solution architecture and will speak his mind at every opportunity on the perceived irreconcilable differences and impedence mismatches between application developers and database professionals.
Brokering Innovation in SQL Server
It is not often that we see advances in SQL databases that push the technology into areas that they are well suited and when we do, they are often passed over by developers and DBAs in favour of sticking to the database status quo. SQL Service Broker is one of those technologies that is misunderstood and is, contrary to what we have come to expect from Microsoft, under hyped. It is a technology that helps solve real problems that database professionals are dealing with – including the ability to scale out databases and accompanying applications to cope with the business need of having reliable transactioning across a distributed platform.
So, years after its introduction in SQL 2005, SQL Service Broker is coming of age has proven itself as a stable, useful and important part of an organizations’ database platform - the database professionals out there just need to understand what that part is.
This session discusses the fit of SQL Service Broker within an overall solution architecture and contains enough practical code and demonstrations to allow attendees to leave with enough to start using it themselves. It also demonstrates the use of SQL Service Broker and the (new to SQL 2008) Filestream datatype to provide a performant, secure and reliable platform for distributing large binary objects amongst occasionally connected databases.
If you have heard about SQL Service Broker but haven’t really had a close look at it, you need to attend this session. If you have been wondering about what SQL Service Broker can be used for, you need to attend this session. And if you looking for solutions to keeping different, distributed SQL Server instances in sync in the enterprise, then you need to attend this session.
About James Boother
James Boother is the Managing Director and co-founder of Live Software Solutions a Microsoft Certified Partner focused on custom development solutions on the Microsoft platform. James is a passionate .net developer and development manager with experience in the insurance and publishing sectors among others. He is a keen squash and tennis player, formula 1 fan and devoted father of three.
Using Table Valued Parameters
For many years I’ve wanted to pass multiple rows of parameters into a stored procedure having to perform ghastly tasks to make this happen. SQL Server 2008 has come to the rescue with Table Valued Parameters which allow you to send a set of data straight into SQL Server. But, is this the silver bullet to the multi-row parameter problem? I’ll investigate this new capability both within SQL Server and in client code comparing it to existing methods to discover whether we now have the solution that I’ve been looking for. Join me for the journey!