sqlsathistory

Nr: 39

Back to Main list

SQLSaturday #39 - New York City 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	Adam Jorgensen	Room B	Performance Tuning Analysis Services
00:00:00	Adam Jorgensen	Room B	Zero to Cube in 60 Minutes
00:00:00	Andrew Brust	Room B	Self-Service Business Intelligence-MS PowerPivot
00:00:00	Andy Leonard	Room A	Introduction to Incremental Loads
00:00:00	Andy Leonard	Room A	Applied SSIS Design Patterns
00:00:00	Charles Hyman	Room B	A complete BI project in 90 minutes or less
00:00:00	Charles Hyman	Room E	Whats involved in getting certified, Q A Session
00:00:00	David Waugh	Room D	Response Time Analysis of SQL Server Performance
00:00:00	Derek Comingore	Room B	Delivering Rapid Business Value with Microsoft BI
00:00:00	Derek Comingore	Room A	SQL Server PowerPivot for IT Pros
00:00:00	Don Demsak	Room E	Introduction to MSSQL Server 2008 R2 StreamInsight
00:00:00	Grant Fritchey	Room A	More Unecessary Query Tuning
00:00:00	Jim O'Neil	Room D	Dallas: Microsoft's Data Marketplace
00:00:00	Kevin Goff	Room D	Building an OLAP cube with SSAS 2008
00:00:00	Kevin Goff	Room A	SSRS 2008 and R2 Report Gallery
00:00:00	Matt Van Horn	Room C	Developing with SQL Azure
00:00:00	Matt Van Horn	Room D	SSRS Interactive Reports
00:00:00	Paul Nielsen	Room C	A step back in time - Temporal Database Designs
00:00:00	Roman Rehak	Room C	SQL Server 2008 Reporting Services Programming
00:00:00	Scott Weinstein	Room C	Easy Integration without SSIS - Using MS PowerShel
00:00:00	Thomas LaRock	Room D	SQL Server 2008 Audit
00:00:00	Sunil Kadimdiwan	Room E	Visualize your data on Maps Charts: SSRS 2008 R2
00:00:00	Thomas LeBlanc	Room E	3rd Key Normal Form: That's crazy talk!!!
00:00:00	Slava Kokaev	Room C	Building a BI Web Portal with SSRS, SSAS, ASP.NET

SessionID: 28517

Performance Tuning Analysis Services

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room B

Speaker: Adam Jorgensen

Title: Performance Tuning Analysis Services

Abstract:

Now that your cube building experts, you’re going to want to make sure it is tuned and running in tip top shape. This presentations takes real world experience and boils it down for a concise view of what drives SSAS performance, what you can do to make it more efficient, and techniques for making that as hassle free as possible. Learn the tools and techniques for finding problem queries and driving more performance from your SSAS environment.

SessionID: 28518

Zero to Cube in 60 Minutes

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room B

Speaker: Adam Jorgensen

Title: Zero to Cube in 60 Minutes

Abstract:

Overcome the barriers of traditional training and seminars with this Quick Start to building a cube. This all demo session will get you started and answer many questions you have about building cubes the right way, the first time.

SessionID: 28649

Self-Service Business Intelligence-MS PowerPivot

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room B

Speaker: Andrew Brust

Title: Self-Service Business Intelligence-MS PowerPivot

Abstract:

Ever wonder why there’s no “light” version of SQL Server Analysis Services (SSAS)? Find yourself wishing that SSAS offered an in-memory operation model akin to some of its competitors? And why are OLAP cubes nearly impossible for end-users to build while comparable capabilities have existed for relational databases for at least 15 years? Enter Microsoft’s product code-named “Gemini,” a component of the upcoming SQL Server 2008 R2 release, that joins together SSAS, Excel and SharePoint to make end-user analytics feasible, fun, publishable and discoverable by IT. Andrew Brust will show you how it all works in this not-to-miss session.

SessionID: 28652

Introduction to Incremental Loads

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room A

Speaker: Andy Leonard

Title: Introduction to Incremental Loads

Abstract:

This session if for SSIS developers and DBAs. Attend and learn more about Transact-SQL and SSIS design patterns for loading data incrementally. The session includes two demos: Incremental Loads in Transact-SQL; and Incremental Loads in SSIS.

SessionID: 28653

Applied SSIS Design Patterns

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room A

Speaker: Andy Leonard

Title: Applied SSIS Design Patterns

Abstract:

This session is for experienced SSIS developers. Attend and learn the Parent-Child SSIS design pattern, how to leverage less-than-well-documented characteristics of SSIS to centralize logging, and how to pass variable values between parent and child packages by value and by reference.

SessionID: 29553

A complete BI project in 90 minutes or less

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room B

Speaker: Charles Hyman

Title: A complete BI project in 90 minutes or less

Abstract:

A quick start guide using the latest tools to show from FLAT files through ETL to FACTS to DIMENSIONS to A CUBE to SCORECARDS and DASHBOARDS. How to quickly navigate SSIS, SSAS , SSRS and a taste of PROCLARITY.

SessionID: 29554

Whats involved in getting certified, Q A Session

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room E

Speaker: Charles Hyman

Title: Whats involved in getting certified, Q A Session

Abstract:

This session is an OPEN-FORUM type session where Charles Hyman, MCT will discuss and answer questions about obtaining Microsoft Certifications. Roadmaps to certification will be discussed, and he will be able to answer your specific questions and concerns about most of the certification paths. ( Certification 'goodies' may be available )

SessionID: 29806

Response Time Analysis of SQL Server Performance

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room D

Speaker: David Waugh

Title: Response Time Analysis of SQL Server Performance

Abstract:

Using Response Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Response Time based performance analysis to solve the most difficult performance related issues. Designed for the SQL Server DBA, Developer or anyone concerned with performance.

SessionID: 29834

Delivering Rapid Business Value with Microsoft BI

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room B

Speaker: Derek Comingore

Title: Delivering Rapid Business Value with Microsoft BI

Abstract:

The days of long, inefficient Business Intelligence (BI) and data warehousing projects are coming to an end. Customers need to ability to reap quick business value for their investments. In this session we will take a tour of methodologies, techniques, and technologies that enable a quick return on investment for the Microsoft BI platform.

SessionID: 29836

SQL Server PowerPivot for IT Pros

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room A

Speaker: Derek Comingore

Title: SQL Server PowerPivot for IT Pros

Abstract:

As Microsoft readies SQL Server PowerPivot customers should understand how to best leverage the new managed self-service technology. In this session we will focus on the server side experience, the architecture of SharePoint 2010 with Gemini server components, management dashboards, Reporting Services/PowerPivot syneriges, and demos. The next-generation business intelligence software is coming, make sure your organization is prepared to embrace it.

SessionID: 29944

Introduction to MSSQL Server 2008 R2 StreamInsight

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room E

Speaker: Don Demsak

Title: Introduction to MSSQL Server 2008 R2 StreamInsight

Abstract:

Complex Event Processing (CEP) is one of the emerging architecture styles in distributed systems. Microsoft SQL Server 2008 R2 includes an exciting new platform called StreamInsight for building rich data processing over real-time event streams. This technology is ideal for applications that need to process high volumes of event stream data with no latency. Additionally, StreamInsight allows developers to create applications that execute continuous queries over a stream of data.

SessionID: 30265

More Unecessary Query Tuning

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room A

Speaker: Grant Fritchey

Title: More Unecessary Query Tuning

Abstract:

Pronounced muck, this session walks you through common but recurring coding problems, how to identify them, and how to solve them. Based on the book, SQL Server 2008 Query Performance Tuning Distilled, this session covers the information that query developers—which includes DBAs, application developers, report writers, and other data management professionals—need to know about in order to prevent recurring problems caused by poorly written or poorly configured code. Topics include things as simple as getting the data types correct, including the schema in defining objects, and avoiding operators in search conditions. More advanced topics are also discussed.

SessionID: 31010

Dallas: Microsoft's Data Marketplace

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room D

Speaker: Jim O'Neil

Title: Dallas: Microsoft's Data Marketplace

Abstract:

At PDC 2009, Microsoft announced "Dallas", a Data-as-a-Service offering that leverages the Windows Azure cloud computing platform. "Dallas" makes well-known and vetted public and commercial data sets from entties such as the Associated Press and Data.gov available to the development and data analysis communities. This session explores getting started with "Dallas" and accessing its data sets programmatically and via Excel 2010's PowerPivot feature.

SessionID: 31353

Building an OLAP cube with SSAS 2008

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room D

Speaker: Kevin Goff

Title: Building an OLAP cube with SSAS 2008

Abstract:

Are you interested in seeing an OLAP database and OLAP cube built from start to finish? - Would you like to see some examples of different dimension types? - Would you like to see how you can use SSIS and XMLA to maintain/incrementally update the OLAP cube? - Would you like to see an example of SSAS KPIs, roles and report actions? - And lastly, would you like to see an example that uses something OTHER THAN AdventureWorks or Northwind or Pubs? :) Then this session is for you!

SessionID: 31357

SSRS 2008 and R2 Report Gallery

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room A

Speaker: Kevin Goff

Title: SSRS 2008 and R2 Report Gallery

Abstract:

Are you ready for some HREC? (Hot Reporting Eye Candy) SQL Server 2008 and R2 offer great capabilities for more flexibile report output, better charting, and powerful data visualization features that business users require. This session will show a gallery of different reports that can be built with SSRS 2008 and SSRS 2008R2. (And yes, you'll also see some T-SQL and MDX code!)

SessionID: 31622

Developing with SQL Azure

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room C

Speaker: Matt Van Horn

Title: Developing with SQL Azure

Abstract:

This is a high level intro of how to develop for SQL Azure either using traditional ASP.Net IIS or Windows Azure as a host. I will go over the differences between SQL Azure and Azure Storage. Considerations that need to be made if using Azure Cloud Hosting with ASP.Net Authentication and session states as well as how to use SQL Azure as a Sql(Membership,Role,Profile)Provider. I will share the tips and tricks that I have discovered as I worked with SQL Azure.

SessionID: 31623

SSRS Interactive Reports

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room D

Speaker: Matt Van Horn

Title: SSRS Interactive Reports

Abstract:

I will show how to take advantage the interactive features of SQL Reporting Services to allow your users to drill down from summaries to the details that drive them. Address some of the simple to implement features that can make your existing reports much more useable to your end users. Topics to be covered include: Graphing, Interactive Sorting, Grouping, and Drilldown Reports.

SessionID: 32188

A step back in time - Temporal Database Designs

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room C

Speaker: Paul Nielsen

Title: A step back in time - Temporal Database Designs

Abstract:

Jane Smith's name has a typo and someone fixes it. Jane gets married and she takes a new last name. It too has a typo, but gets corrected. A temporal database can show who changed what when. But wait there's more, querying the table "as-of" the day before Jane's wedding should return 'Smith' because that was the valid data on that effective date. Temporal databases have a reputation as being difficult, but I'll demo a few design patterns and timely functions that can tame the beast of time. Specifically you'll see: AutoAudit, temporal columns, temporal foreign keys and joins, and temporal hierarchies.

SessionID: 32631

SQL Server 2008 Reporting Services Programming

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room C

Speaker: Roman Rehak

Title: SQL Server 2008 Reporting Services Programming

Abstract:

SQL Server 2008 Reporting Services provides rich and powerful programming framework. This session will give you an overview of many available options for programming Reporting Services. We will cover the Reporting Services Web Service, URL Access, ReportViewer and custom assemblies. We will also talk about integrating reports into both Windows and Web applications.

SessionID: 32838

Easy Integration without SSIS - Using MS PowerShel

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room C

Speaker: Scott Weinstein

Title: Easy Integration without SSIS - Using MS PowerShel

Abstract:

SSIS although powerful and feature rich has long been recognized as a poor developer's tool. Through the use of Powershell, code generation and the TPL, custom ETLs can be build giving you the flexibility of source code based ETL with the performance of SSIS. Specific scenarios covered will include parallel bulk transfers of data and star-schema population

SessionID: 33062

SQL Server 2008 Audit

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room D

Speaker: Thomas LaRock

Title: SQL Server 2008 Audit

Abstract:

With SQL Server 2008 you now have the ability to set up auditing with SQL Server Audit. Attend this session for an overview of SQL Server Audit, learn how to initially configure an audit for your server or databases, and examine the audit logs to report on the information that is captured.

SessionID: 33264

Visualize your data on Maps Charts: SSRS 2008 R2

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room E

Speaker: Sunil Kadimdiwan

Title: Visualize your data on Maps Charts: SSRS 2008 R2

Abstract:

Microsoft Reporting Services 2008 R2 has some exciting new features. In this session I will show you how you can create compelling and interactive reports that put your data on Maps and Charts. I will also show Report Manager look and feel changes with SharePoint-like interaction and menus and other features.

SessionID: 33718

3rd Key Normal Form: That's crazy talk!!!

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room E

Speaker: Thomas LeBlanc

Title: 3rd Key Normal Form: That's crazy talk!!!

Abstract:

Another DBA I work with has this Session Title on his whiteboard (Thanks Richard) at work. This session will be a step by step process of taking 2 different examples (Labatory and Fund Agreement) through normalization. The databases will be diagrammed and scripted out with primary, alternate and foreign keys, defaults, constraints and to Null or Not to Null. Some cool examples will be used to show just how powerful normalization can be and what SQL Server 2005/2008 features can enhance the delivery of information to the end user.

SessionID: 33843

Building a BI Web Portal with SSRS, SSAS, ASP.NET

Back to calendar

Event Date: 24-04-2010 - Session time: 00:00:00 - Track: Room C

Speaker: Slava Kokaev

Title: Building a BI Web Portal with SSRS, SSAS, ASP.NET

Abstract:

This presentation will show how to develop: BI driven web application with fully customizables and pesonalizables Dashboard’s based on ASP.NET 3.5, SRSS 2008 and SSAS 2008. To be used by all levels of management to monitor, analyze and control company business performance and activities.

As we work through you will see how to: •Develop Custom BI Application on .NET 3.5 platform; •Rollup LINQ Provider to SSRS for BI integration using C# 3.0 and T4; •Integrate BI into Web Application using ReportViewer and SSRS Web Services API; •Design flexible presentation layer for your Web App using ASP.NET 3.5 Web Parts; •Display the drill-through and drill-down reports using SSRS and VS 2008; •Design interactive executive Dashboards usin

This site is open source. Improve this page.