The first SQL Supper with our hosts 7Digital
Nearest Tube : Old Street.
18:00 Registration, hello & welcome
18:15 A lap around SSDT - Jamie Thomson
SQL Server Data Tools (SSDT) database projects bring SQL Server development into the modern era. Come along and learn how SSDT database projects can accelerate your SQL Server development and deployments.
Jamie has been a SQL Server MVP since January 2006 due largely to his contributions to the SSIS user community. He is a freelance SQL Server developer based in London.
19:30 Bitmap and Bloom Filter Indexing in SQL Server - Tony Rogerson
We look at how you can role your own indexing strategies to complement SQL Server's B+Tree; this session will refresh you on how SQL Server Indexes work, bitwise operations. We will then look at how Bloom Filters and Bitmap Indexing can be used to dramatically improve the performance of certain query patterns within SQL Server. Session is based partly on the blog series on Bloom Filters: http://tinyurl.com/bloomfilter
Tony started his career in 1986 developing on the IBM mainframe using PL/1, CICS, DB2 and Application System. Sept 2013 marks 20 years of SQL Server experience from version 4.21a through to 2014; he has been a SQL Server MVP since 1998. Tony recently completed his masters in Business Intelligence and is taking a Data Science PGCert at the University of Dundee.