Leed Area SQL Server User Group: Thursday 29th May 18:30 - 21:00 : Leeds
Speaker: Martin Bell Whats New in SQL Server 2008 T-SQL
The next version of SQL Server 2008 is due out later this year and included plenty of new, improved and updated features including extensions to Transact SQL. This presentation will demostrate most of the new T-SQL features including:
Row Constructors
Merge
Hierarchy Id Data Type
Sparse Column and Column Sets
Grouping Sets
Filestream Storage
User Defined Table Type
Table Valued Parameters
Date and Time Functionality
Dependency Reporting
Martin Bell has been a freelance computer consultant in the UK for over 23 years. He has worked on many relational database systems and since 1998 has specialized in SQL Server. He was first awarded Microsoft MVP (SQL Server) status in June 2003. He runs the Scottish Area meetings of the UK SQL Server User Group and is a founding organiser of the SQLBits Community Conference.
Speaker: Jim Brayshaw Deploying database upgrades
A key aspect to building and releasing enterprise software is the capture, packaging, and execution of SQL server database changes. Together, we’ll explore some of the processes, approaches, and tools we (and you) use to enable automation around database scripts. We will cover version management, execution in the development environment, and packaging for deployment into new and existing test/live environments.
Jim Brayshaw joined UPCO in 2001, and leads the Microsoft Practice, delivering end-to-end solutions and consultancy to corporate business, ISV, and IT service clients throughout the UK. He has 18+ years experience of solutions delivery, and has specialised on the Microsoft platform since 1992. As well as technology expertise, Jim has played a leading role in the development of UPCOs agile development processes, service offerings, and lifecycle management products.