If you missed Tech·Ed North America 2011, I have compiled a list of all the SQL Server videos for you.
Each one links directly to the video, have fun watching it all
Santosh Balasubramanian Database & Business Intelligence 300 – Advanced DBI302 Day 1 May 16, 2011 from 1:15PM to 2:30PM
In this session we talk about the new high availability solution that is being introduced in SQL Server code-named “Denali”. The session provides an overview of AlwaysOn and introduces the key new features and capabilities that will help businesses achieve the high availability SLA for mission…
Building Scalable Database Solutions Using Microsoft SQL Azure Database Federations
Cihan Biyikoglu Database & Business Intelligence 400 – Expert DBI403 Day 1 May 16, 2011 from 3:00PM to 4:15PM
SQL Azure provides an information platform that you can easily provision,configure and use to power your cloud applications. In this session we explore the patterns and practices that help you develop and deploy applications that can exploit the full power of the elastic,highly available,and…
Using Knowledge to Cleanse Data with Data Quality Services
Elad Ziklik Database & Business Intelligence 200 – Intermediate DBI207 Day 1 May 16, 2011 from 3:00PM to 4:15PM
SQL Server Data Quality Services (DQS) is a Knowledge-Driven Data Quality product aimed at the data stewards and IT professionals who seek to improve the quality of their business data. In this session,we describe the concept and main principles behind Data Quality Services from Microsoft,and demo…
Top 10 Reasons to Upgrade to Microsoft SQL Server 2008/R2 Reporting Services
Teo Lachev Database & Business Intelligence 200 – Intermediate DBI205 Day 1 May 16, 2011 from 3:00PM to 4:15PM
Rich in demos,this session presents top reasons to upgrade to Microsoft SQL Server 2008 and SQL Server 2008 R2 versions of Reporting Services. Use this information to convince your boss that it’s time to upgrade and remove past limitations. If you already use these versions,you might discover…
Tobias Ternstrom Database & Business Intelligence 300 – Advanced DBI318 Day 1 May 16, 2011 from 3:00PM to 4:15PM
In this session we walk through the new T-SQL-related features that are being delivered in the next version of SQL Server. We show off some cool demos as well as describe the use-cases that these language extensions enable.
Microsoft SQL Server Beyond Relational Landscape: Current and Future
Michael Rys Database & Business Intelligence 300 – Advanced DBI316 Day 1 May 16, 2011 from 4:45PM to 6:00PM
Many database applications today need to manage not only tabular relational data,but documents,images,objects such as spatial objects etc. In fact,80% or more of the data produced and stored are so-called unstructured documents and are often not stored in the database,but often need to be managed in…
Getting Started with Cloud Business Intelligence
Pej Javaheri, Tharun Tharian Database & Business Intelligence 200 – Intermediate DBI210 Day 1 May 16, 2011 from 4:45PM to 6:00PM
The cloud has many possibilities and advantages for your Business Intelligence deployments,enhancing and even simplifying your on-premises environments. In this demo-packed session,we go over the capabilities available to you in Windows Azure to help you deploy,execute and enhance your Business…
Creating Self-Service Analytic BI Applications with Microsoft SharePoint 2010
Peter Myers Database & Business Intelligence, Office & SharePoint 200 – Intermediate OSP205 Day 1 May 16, 2011 from 4:45PM to 6:00PM
SharePoint 2010 is the premier BI portal solution. In this session learn how business users can be empowered to create self-service analytic applications by harnessing the power of SharePoint. Topics cover an introduction to the Chart and Status List Web Parts and the three SharePoint service…
Automating Database Migration to Microsoft SQL Server
Welly Lee Database & Business Intelligence 300 – Advanced DBI307 Day 1 May 16, 2011 from 4:45PM to 6:00PM
Does your organization have Oracle,Sybase,MySQL or Access databases that you like to migrate to SQL Server or SQL Azure? Do you know that Microsoft offers a free tool to automate database migration? In this demo-heavy session,we examine how SQL Server Migration Assistant (SSMA) migrates other…
Teo Lachev Database & Business Intelligence 300 – Advanced DBI330 Day 1 May 16, 2011 from 4:45PM to 6:00PM
Your Business Intelligence solution is ready for prime-time but will it perform well? Join this session to learn techniques for testing the performance and scalability of Microsoft SQL Server Reporting Services (SSRS) and Microsoft SQL Server Analysis Services (SSAS).
A Lap around Microsoft Business Intelligence
Pej Javaheri, Herain Oberoi Database & Business Intelligence 200 – Intermediate DBI209 Day 1 May 16, 2011 from 1:15PM to 2:30PM
Familiar with the database functionality of Microsoft SQL Server or the collaboration functionality of Microsoft SharePoint,but have not had the chance to explore the broad and integrated Business Intelligence capabilities offered by across these products and Microsoft Excel? This session provides…
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
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…
T.K. Anand, Ashvini Sharma Database & Business Intelligence 200 – Intermediate DBI206 Day 2 May 17, 2011 from 10:15AM to 11:30AM
In Microsoft SQL Server 2008 R2,we introduced PowerPivot which is a self-service Business Intelligence experience that enables information workers to build,share and collaborate on their personal and team BI applications within the familiar environment of Excel and SharePoint. In SQL Server…
Abundantly “Crescent”: Demos Galore
Sean Boon, Carolyn Chau, Sabrena McBride Database & Business Intelligence 200 – Intermediate DBI208 Day 2 May 17, 2011 from 3:15PM to 4:30PM
What is Microsoft project code-named “Crescent” really capable of? How can it address the needs of your business? This session covers a variety of demonstrations against REAL DATA,across various industry verticals,to enable you to see what’s possible when deploying this new technology. If you like…
What’s New in Microsoft SQL Server Code-Named “Denali” for Reporting Services
Carolyn Chau Database & Business Intelligence 200 – Intermediate DBI211 Day 2 May 17, 2011 from 1:30PM to 2:45PM
Microsoft SQL Server code-named “Denali” introduces many new features and enhancements for both IT professionals and business users. This session provides an end-to-end introduction and demonstrations of all the new capabilities specific to Reporting Services including SharePoint…
Torsten Grabs Database & Business Intelligence 300 – Advanced DBI303 Day 2 May 17, 2011 from 5:00PM to 6:15PM
Microsoft SQL Server 2008 R2 introduces StreamInsight,a comprehensive platform for building event-driven applications. While typical relational database applications are query-driven,event-driven applications are characterized by continuously arriving new data,continuous processing of the incoming…
What’s New in Manageability for Microsoft SQL Server Code-Named “Denali”
Denny Cherry Database & Business Intelligence 300 – Advanced DBI304 Day 2 May 17, 2011 from 1:30PM to 2:45PM
Microsoft SQL Server “Denali” has many new features and enhancements. With a focus on manageability,this session tours new features including Contained Databases,Distributed Replay Utility,User Defined Roles,SQL Management Studio enhancements,and PowerShell. The session is demo-intensive and…
High Availability and Disaster Recovery Customer Panel: Architectures and Lessons Learned
Thomas Grohser, Prem Mehra, Sanjay Mishra, Ayad Shammout, David Smith, Michael Steineke Database & Business Intelligence 300 – Advanced DBI309 Day 2 May 17, 2011 from 3:15PM to 4:30PM
This session covers real-life customer deployment scenarios to achieve high availability (99.99+) and disaster recovery (regional and distant),lessons learned,and associated best practices. The content is not merely coverage of available functions and features of Microsoft SQL Server,but based on…
Eric Hanson Database & Business Intelligence 300 – Advanced DBI312 Day 2 May 17, 2011 from 8:30AM to 9:45AM
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…
David Robinson Database & Business Intelligence 300 – Advanced DBI313 Day 2 May 17, 2011 from 5:00PM to 6:15PM
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…
Using Cloud (Microsoft SQL Azure) and PowerPivot to Deliver Data and Self-Service BI at Microsoft
Harinarayan Paramasivan, Diana Putnam, Sanjay Soni Database & Business Intelligence 300 – Advanced DBI323 Day 2 May 17, 2011 from 1:30PM to 2:45PM
See a live demo of how Microsoft IT is distributing terabytes of data from the Enterprise Data Warehouse to various business and IT groups at Microsoft using SQL Azure cloud and on-premise platform. Learn about Data Services Layer (DSL) which is a distribution platform that provides a single…
Killer Real-World PowerPivot Examples
Grant Paisley, Daniel Yu Database & Business Intelligence 300 – Advanced DBI329 Day 2 May 17, 2011 from 5:00PM to 6:15PM
This session is jam packed with amazing PowerPivot report examples. This is *the* session to attend if you want to get the most out of PowerPivot visualizations. Essentially we look at multiple PowerPivot reports from different clients (Education,Retail,Banking,Airline) and show a variety of…
All Up Data Warehouse: From SMP to Parallel Data Warehouse
Dandy Weyn Database & Business Intelligence 300 – Advanced DBI332 Day 2 May 17, 2011 from 10:15AM to 11:30AM
Microsoft Data Warehousing brings you a solid offering that provides the right data warehousing solution for customer needs and workloads. In this session,learn about Reference Architectures using Fast Track Data Warehouse 3.0 and appliance-based implementations including Microsoft SQL Server…
Advanced Business Intelligence Solutions Using Microsoft Excel + Excel Services
Kevin Fan, Manpratap Suri Database & Business Intelligence 300 – Advanced DBI335 Day 2 May 17, 2011 from 10:15AM to 11:30AM
Learn how you can utilize the power of Excel and Excel Services BI features to easily create a compelling BI solution using the tools you already know.
Adam Machanic, Mike Wachal Database & Business Intelligence 400 – Expert DBI402 Day 2 May 17, 2011 from 3:15PM to 4:30PM
Understanding when to search for performance problems and how to tune your queries to correct them is one of the most persistent questions that face DBAs. Join Adam and Mike to explore a methodology for discovering and improving performance problems. Along the way you’ll see examples that take…
Adam Jorgensen Database & Business Intelligence 400 – Expert DBI407 Day 2 May 17, 2011 from 8:30AM to 9:45AM
The purpose of this session is to highlight issues,best practices and lessons learned from a select group of SQL Server Enterprise customers. Some example of the customer projects we cover in this session: AdCenter and their 6TB SSAS environment: two 3TB OLAP cubes,XBox Live and their planned…
Pej Javaheri, Carolyn Chau, Manpratap Suri, Allan Folting, Matt Masson, Julie Strauss Database & Business Intelligence 200 – Intermediate DBI201 Day 3 May 18, 2011 from 5:00PM to 6:15PM
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….
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
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…
Microsoft SQL Server Reference Architecture and Appliances
D. Britton Johnston, Bernardo Zamora Database & Business Intelligence 300 – Advanced DBI301 Day 3 May 18, 2011 from 5:00PM to 6:15PM
Learn what are the current and future SQL Server Appliances and References Architectures that allow customers to deploy OLTP,DW,BI and Database consolidation solutions in a very short time,with all the components configured and optimized. These appliances include all the Hardware,Software and…
Fast Track Data Warehouse Version 3.0 New Features and Best Practices
Michael Bassett, Anjan Das, Jim Hautala Database & Business Intelligence 300 – Advanced DBI308 Day 3 May 18, 2011 from 1:30PM to 2:45PM
This session depicts some of the new features and architecture changes present in version 3.0 of SQL Server Fast Track Data Warehousing. Best practices derived from HP’s extensive joint testing with Microsoft during the development of its current Fast Track reference architectures are also detailed.
Microsoft SQL Azure Performance Considerations and Troubleshooting
Henry Zhang Database & Business Intelligence 300 – Advanced DBI314 Day 3 May 18, 2011 from 1:30PM to 2:45PM
Become an expert on SQL Azure by learning how to best utilize the cloud database platform to your advantage. We show you the unique performance considerations to keep in mind when architecting your SQL Azure application. Learn the inside tips and tricks to quickly identify performance…
Microsoft SQL Server in Virtualization and Private Cloud
Guy Bowerman, Darmadi Komo Database & Business Intelligence 300 – Advanced DBI315 Day 3 May 18, 2011 from 10:15AM to 11:30AM
Come and learn how SQL Server fits into your company’s strategy on virtualization and private cloud. We talk talk about SQL Server feautures that are relevant in virtualization and private cloud deployment,why Hyper-V is better for SQL Server virtualization,the upcoming HP Database Consolidation…
What’s New in Microsoft SQL Server Code-Named “Denali” for SQL Server Integration Services
Matt Masson Database & Business Intelligence 300 – Advanced DBI317 Day 3 May 18, 2011 from 3:15PM to 4:30PM
This session shows off the new features of Microsoft SQL Server Integration Services in SQL Server code-named “Denali”. Using customer scenarios,we demonstrate the migration process and highlight the benefits of the new SSIS server architecture. We cover the many improvements made to increase…
Upsizing and Modernizing with the Microsoft BI Stack and Fast Track Data Warehouse
Kevin Cornett, Ilan Wajsman Database & Business Intelligence 300 – Advanced DBI320 Day 3 May 18, 2011 from 8:30AM to 9:45AM
In 2010,Stein Mart deployed a Microsoft SQL Server Fast Track Data Warehouse and launched an aggressive effort to become an information-based culture leveraging the Microsoft Business Intelligence stack. This session provides a detailed description of the infrastructure as it existed before and…
End-to-End PerformancePoint Services
Peter Myers Database & Business Intelligence 300 – Advanced DBI325 Day 3 May 18, 2011 from 3:15PM to 4:30PM
PerformancePoint Services 2010 (PPS) is the next generation performance management application from Microsoft. It delivers a design environment targeted at power users for creating and deploying sophisticated Key Performance Indicator (KPI),scorecard,report and dashboard definitions. The session…
Integrating Microsoft SQL Server Reporting Services with Microsoft SharePoint Technologies
Prash Shirolkar Database & Business Intelligence 300 – Advanced DBI328 Day 3 May 18, 2011 from 1:30PM to 2:45PM
Deep dive into how and why to integrate SQL Server code-named “Denali” Reporting Services (SSRS) with SharePoint 2010,including an overview of the new claims-aware shared service architecture,IT experience,performance enhancements,and end user functionality.
Microsoft SQL Server Analysis Services Design Challenges
Peter Myers Database & Business Intelligence 300 – Advanced DBI331 Day 3 May 18, 2011 from 8:30AM to 9:45AM
Microsoft SQL Server Analysis Services allows developers to produces cubes which,when designed well,can deliver intuitive,feature-rich and highly-performant data models. In many ways they are a key component to delivering Business Intelligence within the enterprise. To be clear,this session…
Let’s Get Visual: The Art of Report Design
Paul Turley Database & Business Intelligence 300 – Advanced DBI334 Day 3 May 18, 2011 from 3:15PM to 4:30PM
Do your users have the same old,mundane table reports they’ve been using for decades? Stop living in the past and make your reports pop. Learn to use design patterns,best practices and visuals that pack more usable information into fewer,more usable reports. Use Reporting Services and other…
Innovative Storage and Data Management Strategies to Power Your Microsoft Enterprise Applications
Alex Jauch, Robert Quimbey Database & Business Intelligence 300 – Advanced DBI336 Day 3 May 18, 2011 from 1:30PM to 2:45PM
In this session,hear about innovative storage and data management strategies that are being used by leading organizations around the world to build highly efficient,flexible and reliable IT infrastructure to support their business-critical enterprise software including Microsoft Exchange…
Justin Erickson Database & Business Intelligence 400 – Expert DBI404 Day 3 May 18, 2011 from 8:30AM to 9:45AM
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…
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
