SQL Supper with our hosts 7Digital
Nearest Tube : Old Street.
18:00 Registration, hello & welcome
18:15 7 Digital Team - Database team working
Podge, Cam and Paul are going to talk about the adoption of quality driven, automated testing practices in the 7digital database team. The team of 6 now uses a mixture of extreme programming, Lean and Kanban practices to complement those already in place in development teams. Collaboration has already improved and wasted time has been reduced so our next step is to automate more testing. Paul will speak briefly about the practices that the development teams use and how the database team have adopted these, and why they're important. Cam will then take us through the various iterations of automated testing that got us to the automated testing framework we built to help us test the ETL processes for our new data warehouse project. Finally Podge will discuss the integration of all these practices that help us deliver continuously using continuous integration, source control and automated deployments.
Paul Shannon is Assistant Director of Technology at 7digital. He was pivotal in the adoption of Agile, Lean and XP practices at Codeweavers Ltd before moving to 7digital to lead the Content Ingestion Team, finally moving into tech strategy leadership there in 2012. Paul has led TDD workshops and lectures at universities, given talks at events around Europe and is responsible for recruitment and training at 7digital. He's also published two papers on Lean Software Development and XP, and is the founder of Agile Staffordshire.
Cameron has worked with SQL Server for almost 10 years and in IT for 11 years. He has appeared in various guises including IT Guy, Data Analyst, and Database Administrator for a range of organisations including call centres, estate agents and charities. He is currently working as one of the data architects at 7digital, work that incorporates BI development and uses SQL Server, SSIS, and SSAS.
Padraig (Podge) O’Brien is the database team lead and one of the data architects at 7digital. he has worked in SQL server for over 12 years across a wide range of industries from heavy industries to banking, He started out coding in VB6 and SQL server and while the languages changed SQL Server has been a constant, Currently his main focus is on business intelligence and data mining. He is also keen on alternative data technologies such as MongoDB.
19:30 David Peter Hansen (MCM) : 10 tips and tricks for better SSIS performance
Your SSIS packages are taking longer than they should, but you are not sure what to do about it. This session gave 10 tips and tricks for gaining better performance. Not only 10 reasons to why your packages are running slow, but also 10 ways to do something about it. Find out when to use T-SQL instead of SSIS transformations, why you should care about data types, what a blocking transformation is, why buffers are important, and much more.