July SQL Server user group meeting.
- Two, one month, Pluralsight passes
- One, £20 Amazon voucher from SpectrumIT
18:00 - Doors Open
18:15 - Introductions
18:30 - SpectrumIT
A word from our Sponsors
Ian & Steve from SpectrumIT (primary user group sponsor) will be dropping along to say hello and give a short presentation on who SpectrumIT are and some general background on the job market at the moment and how they can help you if you're looking to make the step up.
19:00 - Chris Webb (@Technitrain)
What’s New for BI in Excel 2013?
Excel 2013 is an exciting release for Microsoft BI, and in this session we’ll take a look at all the new BI-related features in it: the PowerPivot engine integrated directly into Excel; Power View integrated as a new type of worksheet; web-based reporting with Excel Services in Sharepoint 2013; new features for users connecting to SSAS (Tabular and Multidimensional); and many other new features and functions. It’s so exciting you’ll want to upgrade right away!
Chris Webb is a UK-based independent consultant specialising in Analysis Services, PowerPivot, MDX and DAX. He is a co-author of “Expert Cube Development with SQL Server 2008 Analysis Services”, “MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase” and “SQL Server Analysis Services 2012: The BISM Tabular Model”. He blogs on Microsoft BI topics at http://cwebbbi.wordpress.com/
20:00 - Richard Douglas (@SQLRich)
Natural Born Killers, performance issues to avoid
You’ll learn simple tricks to write better code, scripts, and tables. Plus, you’ll gain a deeper understanding of common database development and administration mistakes, and how you can avoid them. Plus, you’ll learn how to take corrective action when:
•The optimizer isn’t using all available processors
•The database engine fails to report all the resources a query has used
•The optimizer uses the wrong plan
•Database tables cause memory issues.
Richard Douglas MCITP, MCTS, MCP is a Systems Consultant for Dell where he specialises in SQL Server providing solutions and system health checks to organisations across the EMEA region. Richard has recently taken on the responsibility of being Editor in Chief of the community site www.SQLServerPedia.com which provides articles on SQL Server and a blog syndication service, other duties see him regularly presenting webinars to both US and EMEA audiences.
21:15 - Raffle & End