18:30 - 19:30 - SQL Server Data Platform for beginners - Martin Bell
“I want to learn SQL Server, where do I start?” is a question I’ve been asked many times, and the answer is always the one SQL MVPs are renowned for “It depends”!!! SQL Server is no longer a system that you can know everything about; in fact even if you are considered an expert in one area, you will not know everything about that part. For me, it is this constant acquisition on knowledge that makes SQL Server such an interesting system to work with.
In this talk I will be looking at the basics of getting started with SQL Server from the installation of each component of SQL Server to managing the databases that run on it. How the bits fit together and some of the common pitfalls and mistakes you may make getting onto the first step.
Martin is an Independent Contractor and SQL Server DBA since 1998. A SQL Server MVP since June 2003 he is well known in the community running the Leeds, Edinburgh User Groups and helping to organize Community Conferences such as SQL Saturday Edinburgh, SQL Relay and SQLBits.
19:30 - 19:50 - Break
Time for pizza
19:50 - 20:50 - Microsoft BI 101 - On Premise and Cloud - Chris Testa-O'Neill
In this session, you will be introduced to BI and understand the key components and terminology that is used in the BI arena. You will also explore the components that are provided by Microsoft that make up a BI solution including SQLServer Integration Services (SSIS), SQL Server Analysis Services (SSAS), Master Data Services(MDS), Data Quality Services (DQS) and SQL Server Reporting Services (SSRS). You will understand the role that a data warehouse plays in a BI solution and how the cloud is playing a role in complementing BI Solutions
Chris Testa-O’Neill is a SQL Server Microsoft Most Valuable Professional(MVP), EMEA Production DBA and SQL Server Business Intelligence specialist at Insight. He is also a technical author, working on courses for SQL Server 2008 R2, 2012 and 2014 with Microsoft Learning. Chris runs the Manchester SQL Server User Group, SQLBits and founder of SQLRelay. Chris is a Microsoft Certified Trainer (MCT), MCDBA, MCTS, MCITP, MCSA, MS+CSE in all SQL Server Disciplines.