Tech·Ed North America 2011
- Atlanta, GA
- May 16 - 19, 2011
- Speakers at Tech·Ed North America 2011
Featured
-
Efficient T-SQL Querying with Itzik Ben-Gan- Itzik Ben-Gan
- Database & Business Intelligence
- 200 - Intermediate
- DBI310
- Day 3
- May 18, 2011 from 10:15AM to 11:30AM
-
3
This session covers a group of calculations in T-SQL that can help in addressing a wide variety of querying tasks. It first describes the limitations and shortcomings of traditional, or classic, T-SQL constructs that are used to address common querying tasks. It then explains how T-SQL evolved, and keeps...
-
Managing Master Data with MDS and Microsoft Excel- John McAllister
- Database & Business Intelligence
- 200 - Intermediate
- DBI204
- Day 2
- May 17, 2011 from 8:30AM to 9:45AM
-
0
Master Data Services (MDS) was released in Microsoft SQL Server 2008 R2 and enables organizations to do a better job of managing key data assets. In the next release of SQL Server,it will be even easier to manage data by using Excel as the user interface. In this session we cover the basics of MDS and... -
Enriching Your BI Semantic Models Using Data Analysis Expressions (DAX)- Kasper de Jonge, Ashvini Sharma
- Database & Business Intelligence
- 400 - Expert
- DBI408
- Day 4
- May 19, 2011 from 1:00PM to 2:15PM
-
0
Data Analysis Expressions (DAX) is a new calculation language introduced in Microsoft SQL Server 2008 R2 within PowerPivot. DAX is an extension to the Excel formula syntax and offers information workers an intuitive yet powerful tool to add business logic to their PowerPivot applications. In SQL Server... -
Microsoft SQL Azure Advanced Administration: Backup,Restore and Database Management Strategies for…- David Robinson
- Database & Business Intelligence
- 300 - Advanced
- DBI313
- Day 2
- May 17, 2011 from 5:00PM to 6:15PM
-
2
The cornerstone of any enterprise application is the ability to backup and restore data. In this session we focus on the various options available to application developers and administrators of SQL Azure applications for archiving and recovering database data. We look at the various scenarios in which... -
Microsoft SQL Server Code-Named "Denali" AlwaysOn Series,Part 2: Building a Mission-Critical High…- Justin Erickson
- Database & Business Intelligence
- 400 - Expert
- DBI404
- Day 3
- May 18, 2011 from 8:30AM to 9:45AM
-
0
In this session we walk you through the steps to deploy a high availability solution using AlwaysOn. This is a demo-heavy presentation and the experts from the product development team walk you through a high availability solution architecture and deployment,explain key architectural concepts and recommend... -
BI Power Hour- Carolyn Chau, Allan Folting, Pej Javaheri, Matt Masson, Julie Strauss, Manpratap Suri
- Database & Business Intelligence
- 200 - Intermediate
- DBI201
- Day 3
- May 18, 2011 from 5:00PM to 6:15PM
-
0
The legacy continues. The Microsoft Business Intelligence team is excited to once again present the BI PowerHour. In this entertaining session,we dazzle you with new demonstrations that expose the lighter side of Business Intelligence exposing the flexibility and power of the Microsoft BI Platform. If... -
Introducing the Next Generation Design Tools for Microsoft SQL Server Analysis Services- Julie Strauss
- Database & Business Intelligence
- 200 - Intermediate
- DBI203
- Day 3
- May 18, 2011 from 10:15AM to 11:30AM
-
0
Microsoft SQL Server code-named “Denali” brings the simplicity and power of the PowerPivot technologies to corporate BI,and at the same time drives forward the PowerPivot self-service capabilities that we introduced in SQL Server 2008 R2. We give you a tour of building corporate BI Semantic Models... -
Columnstore Indexes Unveiled- Eric Hanson
- Database & Business Intelligence
- 300 - Advanced
- DBI312
- Day 2
- May 17, 2011 from 8:30AM to 9:45AM
-
0
This talk describes a new data warehouse SQL query acceleration feature in Microsoft SQL Server code-named "Denali" based on a new type of index called the columnstore. This new index,combined with enhanced query processing features,improves data warehouse query performance by hundreds to thousands... -
Enterprise Data Mining with Microsoft SQL Server- Mark Tabladillo
- Database & Business Intelligence
- 300 - Advanced
- DBI326
- Day 4
- May 19, 2011 from 2:45PM to 4:00PM
-
0
This presentation presents Microsoft SQL Server Data Mining (SSDM) for SQL Server Professionals based on the speaker's past presentations for SQL Saturday. Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business... -
Advanced Dashboard Creation Using PerformancePoint Services- Jason Burns
- Database & Business Intelligence
- 300 - Advanced
- DBI321
- Day 4
- May 19, 2011 from 10:15AM to 11:30AM
-
2
Dashboards are most powerful when they provide a tailored experience for users, integrated into existing business processes. Microsoft SharePoint provides limitless opportunities for creating a custom Business Intelligence experience for users. This session covers the basics of working with PerformancePoint...
