PDF of Schedule
Writing Faster SQL
This session will focus on how you can write faster queries. It’s based on all the different “interesting” approaches I’ve seen and fixed as a consultant. It will cover indexing and how to use indexes efficiently, writing efficient WHERE clauses, handling dynamic SQL in reports, tips and tricks to avoid table scans, reducing query compiles and a dozen other approaches to improve the response time of your applications.
PowerPivot, while being an Excel add-in, was built by the SQL team, and is one of the most powerful data integration tools in the Microsoft stack. In this session, you will learn how to combine data from web services, tables and cubes to build a powerful model, and visualise it in Excel. An introduction to Time Intelligence using DAX will lead us on to the new features in version 2, and we will move from the Date table to relationships, perspectives and KPIs.
As an added bonus, you will see how to pull the model into Visual Studio, decorate it with new attributes, and show the visualisations in other tools such as PowerView
Introduction to SQL Data Sync
The SQL Data Sync is a cloud-based data synchronization service, which provides uni-directional and bi-directional data sync, allowing data to be easily shared between SQL Azure and on-premises SQL Server databases as well as between multiple SQL Azure databases, within the same or different data centers.
Cube Management with stored procs and agent jobs
In this session we will explore creating a SSAS solution without the need for tools such as SSIS We will cover using stored procedures, agent jobs and XMLA to perform tasks such as loading your star schema, Processing Dimensions and Cubes as well as managing SSAS partitions
T-SQL Enhancements in SQL Server 2012
SQL Server is an amazing tool, which has all imaginable components for Creating, Editing, Moving, Analizing and Reporting data.
The most important and the most commonly used of them all is the T-SQL, the Transact-SQL implementation by Microsoft.
This session will focus on some of the new programability features that will be available in SQL Server 2012, that will make lifes of the developers much easier, like SEQUENCE object, OFFSET functionality, new conversion functions (TRY_CONVERT), new logical and conversion functions like IIF and CONCAT.
SQL Server 2012 ??????? /SSAS 2012 new features
introducing new features in SQL Server 2012 Analysis Services
Data Quality Fundamentals
If your data starts to appear more than once in the databases of different business systems, that are not cloning. Better attend this talk and I'll tell you how to avoid this situation by using SQL Server 2012 Data Quality Services to identify who's Hu?
Miguel Angel Granados,
What’s New in SQL Server Integration Services 2012
In this session, you will learn about the new features of Microsoft SQL Server Integration Services in SQL Server 2012. Using customer scenarios,we show the many improvements that have been made to increase developer productivity. You will learn how SSIS 2012 makes it easier for you to deploy, configure, manage and monitor SSIS packages.If you’re wondering what’s in store for SSIS,you won’t want to miss this session!
Wee Hyong Tok,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
??MVP,???????????? ?2002-2008 ?????:???????????????????????????????????? TechEd ?????????????????????,????????????
Mark Stacey founded the Aphelion Software Group, and works tirelessly to cross the business/technical boundaries in Business Intelligence, working in both SharePoint and SQL. He has published two books on BI - Sharepoint 2010 BI and Visual Intelligence and frequently speaks at both SQLSaturday and SharePoint Saturday events. Mark is one of the few Microsoft PDW trainers, and has trained in Africa, India and Europe on the PDW, as well as all over the world on other technologies
Han Wong is a Program Manager on the DocumentDB team. Han is passionate about all things data particularly big data analytics. Products that he has worked include Power BI, SQL Server Integration Services, SQL Data Sync and SQL Server Migration Assistant.
Miguel Angel Granados
Graduated in Computer Science from the Metropolitan Autonomous University. Along my career I had been working for different kind of industries that go from financial to Automation, passing through health care, biodiversity research and teaching.
In the past I worked as a developer, project leader, architect, DBA, teacher and IT consultant. Actually I work for Teia, an important Microsoft partner, and collaborate with PASS as Mexico City chapter leader.
Bill Graziano is a SQL Server consultant that specializes in tuning OLTP systems and database administration. He’s a SQL Server MVP and serves on the Board of Directors for PASS (The Professional Association for SQL Server). He runs a SQL Server web site for DBAs and developers at www.SQLTeam.com. Bill has presented at PASS and numerous regional and local events around the country.
Wee Hyong Tok
Wee Hyong Tok is a Program Manager on the SQL Server Integration Services team. Since joining the team in 2008, he has worked on many aspects of the product. Prior to joining Microsoft, Wee Hyong is a Microsoft Most Valuable Professional (MVP), and frequently presents at various technology conferences.
Matt Horn is a BI developer with Pragmatic Works South Africa
Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.