SQLSaturday #148 - Shanghai 2012

Event Date: 06/30/2012 00:00:00

Event Location:

  • Microsoft (China) Shanghai GGW office
  • 虹桥路3号
  • Shanghai, Shanghai, China

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: Writing Faster SQL

Abstract: 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.


  • Bill Graziano

Track and Room: Track 1 - N/A

Title: PowerPivot


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


  • Mark Stacey

Track and Room: Track 1 - N/A

Title: Introduction to SQL Data Sync

Abstract: 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.


  • Han Wong

Track and Room: Track 1 - N/A

Title: Cube Management with stored procs and agent jobs

Abstract: 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


  • Matt Horn

Track and Room: Track 1 - N/A

Title: T-SQL Enhancements in SQL Server 2012

Abstract: 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.


  • Niko Neugebauer

Track and Room: Track 1 - N/A

Title: SQL Server 2012 ??????? /SSAS 2012 new features

Abstract: introducing new features in SQL Server 2012 Analysis Services


  • Hui Wang

Track and Room: Track 1 - N/A

Title: Data Quality Fundamentals

Abstract: 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

Track and Room: Track 1 - N/A

Title: What’s New in SQL Server Integration Services 2012

Abstract: 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

Track and Room: Track 1 - N/A


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Hui Wang

??MVP,???????????? ?2002-2008 ?????:???????????????????????????????????? TechEd ?????????????????????,????????????

Mark Stacey

Twitter: - @MarkGStacey

Contact: http://MarkGStacey.net

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

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

Twitter: - @SQLMiguelG

Contact: http://www.granadostroncoso.com.mx

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

Contact: http://weblogs.sqlteam.com/billg/default.aspx

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

Matt Horn is a BI developer with Pragmatic Works South Africa

Niko Neugebauer

Twitter: - NikoNeugebauer

LinkedIn: Niko Neugebauer

Contact: http://www.nikoport.com

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.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page