sqlsathistory

Nr: 148

Back to Main list

SQLSaturday #148 - Shanghai 2012

Start Time (24h)	Speaker	Track	Title
00:00:00	Bill Graziano	Track 1	Writing Faster SQL
00:00:00	Han Wong	Track 1	Introduction to SQL Data Sync
00:00:00	Niko Neugebauer	Track 1	T-SQL Enhancements in SQL Server 2012
00:00:00	Miguel Angel Granados	Track 1	Data Quality Fundamentals
00:00:00	Mark Stacey	Track 1	PowerPivot
00:00:00	Matt Horn	Track 1	Cube Management with stored procs and agent jobs
00:00:00	Hui Wang	Track 1	SQL Server 2012 ??????? /SSAS 2012 new features
00:00:00	Wee Hyong Tok	Track 1	What’s New in SQL Server Integration Services 2012

SessionID: 10464

Writing Faster SQL

Back to calendar

Event Date: 30-06-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Bill Graziano

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.

SessionID: 14948

Introduction to SQL Data Sync

Back to calendar

Event Date: 30-06-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Han Wong

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.

SessionID: 15405

T-SQL Enhancements in SQL Server 2012

Back to calendar

Event Date: 30-06-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Niko Neugebauer

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.

SessionID: 19387

Data Quality Fundamentals

Back to calendar

Event Date: 30-06-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Miguel Angel Granados

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?

SessionID: 20109

PowerPivot

Back to calendar

Event Date: 30-06-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Mark Stacey

Title: PowerPivot

Abstract:

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

SessionID: 20155

Cube Management with stored procs and agent jobs

Back to calendar

Event Date: 30-06-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Matt Horn

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

SessionID: 27621

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

Back to calendar

Event Date: 30-06-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Hui Wang

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

Abstract:

introducing new features in SQL Server 2012 Analysis Services

SessionID: 27786

What’s New in SQL Server Integration Services 2012

Back to calendar

Event Date: 30-06-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Wee Hyong Tok

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!

This site is open source. Improve this page.