sqlsathistory

Nr: 37

Back to Main list

SQLSaturday #37 - Philadelphia 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	A.J. Mee	Business Intelligence	Microsoft Business Intelligence Overview for 2010
00:00:00	Adam Jorgensen	Business Intelligence	PowerPivot for Excel and SharePoint 2010
00:00:00	Bill Wolff	Database Development-.NET	Accessing SQL Server Data with .NET
00:00:00	Bill Wolff	Database Development-.NET	Accessing SQL Server Data in SharePoint 2010
00:00:00	Dan Clark	Business Intelligence	Adding Spatial Data Visualization to SSRS Reports
00:00:00	Dean Richards	DBA	Tuna Helper for SQL Server DBA's
00:00:00	Hilary Cotter	DBA	SQL Server Performance Tuning
00:00:00	Jim Moran	Database Development-TSQL	Developing Recursive Queries
00:00:00	Joshua Lynn	Database Development-TSQL	T-SQL Development techniques for performance
00:00:00	Kevin Goff	Business Intelligence	Integrating SSRS 2008 reports with SharePoint
00:00:00	Kevin Goff	Business Intelligence	Building an OLAP cube with SSAS 2008
00:00:00	Mark Scott	Database Development-TSQL	Application Lifecycle Management for Databases
00:00:00	Matt Van Horn	Business Intelligence 2	SSRS Interactive Reports
00:00:00	Vince Napoli	Business Intelligence 2	Developing a BI / DW Environment using SSIS
00:00:00	Paul Begley	DBA	High Availability Solutions for SQL Server 2008
00:00:00	Raj More	DBA	So help me Codd
00:00:00	Said Salomon	Database Development-TSQL	Overview of SQL 2005 Service Broker
00:00:00	Sharon Dooley	Database Development-TSQL	New Toys for Developers in SQL Server 2008
00:00:00	Terry Weiss	Database Development-.NET	Pushing Data to a Web Client Using Comet
00:00:00	Joe Toscano	DBA	SQL Server 2008 Policy Managment Overview
00:00:00	Matt Van Horn	Database Development-.NET	Developing with SQL Azure
00:00:00	Matt Van Horn	Database Development-.NET	Pivot Data Visualization

SessionID: 28501

Microsoft Business Intelligence Overview for 2010

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: A.J. Mee

Title: Microsoft Business Intelligence Overview for 2010

Abstract:

With the upcoming releases of Office 2010, SharePoint 2010, and SQL Server 2008 R2, Microsoft continutes to introduce new innovations to its Business Intelligence story. Come join A.J. Mee, Senior Technical Specialist at Microsoft, for a comprehensive look at the net-new changes to the Microsoft BI platform this year. We will cover such highlights as PowerPivot, Master Data Services, PerformancePoint Services 2010, and Report Builder 3.0. Content will include live, instructor-led demos of selected functionality.

SessionID: 28515

PowerPivot for Excel and SharePoint 2010

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Adam Jorgensen

Title: PowerPivot for Excel and SharePoint 2010

Abstract:

This will be an introduction and lessons learned from early adopters on PowerPivot for Excel and SharePoint 2010. We'll explore the new features and scalability that this new feature brings to the end user, developer, and BI analyst. Session is very demo focused and interactive.

SessionID: 29057

Accessing SQL Server Data with .NET

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Database Development-.NET

Speaker: Bill Wolff

Title: Accessing SQL Server Data with .NET

Abstract:

Bill will demonstrate the latest Microsoft patterns and practices for SQL Server data access. This includes LINQ query syntax, Entity Framework data modelling, REST web services using WCF Data Services, and client side data models with WCF RIA Data Services.

SessionID: 29058

Accessing SQL Server Data in SharePoint 2010

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Database Development-.NET

Speaker: Bill Wolff

Title: Accessing SQL Server Data in SharePoint 2010

Abstract:

The popular SharePoint 2010 platform is built on SQL Server and ASP.NET. It can used as an information hub for multiple data sources including SQL Server. Learn how to store data in SharePoint lists, manage external SQL data with Business Connectivity Services, build CRUD forms with InfoPath, process business flows with SharePoint Designer and Visual Studio workflows, integrate complex reports with Reporting Services, index business data with FAST search, sync data offline with SharePoint Workspace, and manage data file backups.

SessionID: 29822

Adding Spatial Data Visualization to SSRS Reports

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Dan Clark

Title: Adding Spatial Data Visualization to SSRS Reports

Abstract:

One of the great features of SQL Server 2008 is its native support for spatial data types. Spatial data represents information about the physical location and shape of geometric objects. These objects can be point locations or more complex objects such as countries, roads, or lakes. In addition, with the upcoming release of SQL Server 2008 R2, you can add maps and map layers to your report to help visualize data against a geographic background. This session looks at how you can take advantage of this support for spatial data to enhance your location based applications in new and interesting ways. You will learn how to load and query spatial data in SQL Server as well as how to present the data to uses through Reporting Services reports.

SessionID: 29874

Tuna Helper for SQL Server DBA's

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Dean Richards

Title: Tuna Helper for SQL Server DBA's

Abstract:

Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait type data, column selectivity, and several more that will help you succeed on future tuning projects.

SessionID: 30318

SQL Server Performance Tuning

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Hilary Cotter

Title: SQL Server Performance Tuning

Abstract:

Solving performance problems is one of the most difficult tasks of a DBA. The goals of this session are:

Learn a methodology for diagnosing and resolving SQL Server Performance problems. Determine if your hardware is adequate for the workload you are placing on it. Understand how to use the free tools that Microsoft offers to zero in on your stressed hardware components, and the sql server queries and stored procedures which are stressing them. Grasp the power of indexing, and minimize locking.

SessionID: 30884

Developing Recursive Queries

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Database Development-TSQL

Speaker: Jim Moran

Title: Developing Recursive Queries

Abstract:

In this session, we explore how recursion simplifies some programming tasks and how recursive queries can be developed in Microsoft SQL Server using Common Table Expressions. We will begin with a brief introduction to recursion with the classic factorial example and extend this to the set-based issues encountered in SQL development. Then, we will present several real-world problems where recursive solutions can be used in place of temp tables and cursors.

SessionID: 31058

T-SQL Development techniques for performance

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Database Development-TSQL

Speaker: Joshua Lynn

Title: T-SQL Development techniques for performance

Abstract:

Not all SQL performance problems should be solved by throwing more hardware and more indexes at the database. A better query will always outperform any hardware only solution since a better query will still run faster on better hardware than a poorly written one. Load your T-SQL development toolbox with tips, tricks, and techniques to make your sloth like database applications dance and sing.

SessionID: 31348

Integrating SSRS 2008 reports with SharePoint

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Kevin Goff

Title: Integrating SSRS 2008 reports with SharePoint

Abstract:

This presentation will:

• Walk through the admin/config steps for deploying SSRS 2008 reports to Microsoft Office SharePoint Server 2007.
• Cover the report management features in MOSS 2007
• Show how to use report web parts and how to modify the appearance of deployed reports through CSS
• Time permitting, I'll cover deployment of reports to SharePoint 2010, using the most recent beta.

SessionID: 31350

Building an OLAP cube with SSAS 2008

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Business Intelligence

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

Application Lifecycle Management for Databases

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Database Development-TSQL

Speaker: Mark Scott

Title: Application Lifecycle Management for Databases

Abstract:

This session will deal with techniques for maintaining SQL Server databases in an orderly fashion. We will discuss design decisions that make databases easier to maintain. We will talk about code management and change control to keep the database current – even in multi-user environments. We will talk about simpler, reliable deployment strategies. And we will explore testing frameworks to assure the changes are safe. By using field proven techniques and the tools in Visual Studio and SQL Server Management Studio, we can ease the process of maintaining custom databases while remaining flexible enough to meet the changing needs of our organizations.

SessionID: 31625

SSRS Interactive Reports

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Business Intelligence 2

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

Developing a BI / DW Environment using SSIS

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Business Intelligence 2

Speaker: Vince Napoli

Title: Developing a BI / DW Environment using SSIS

Abstract:

In this session, we will look at the concepts and practices used in implementing a Data Warehouse environment, features and capabiiities of SSIS, and how to take SSIS to meet your DW / BI needs. We start at a high conceptual level and walk you through implementing a sample DW using SSIS, showing examples of best practices along the way.

SessionID: 32164

High Availability Solutions for SQL Server 2008

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Paul Begley

Title: High Availability Solutions for SQL Server 2008

Abstract:

Review installation, configuration, and support issues related to multi-node Windows 2008 clusters for production databases, and Windows 2008 Hyper-V Clusters for test and development environments. This session will cover design decisions for networking, storage, and server selection for both environments, as well as best practices based on our experience in the field.

SessionID: 32363

So help me Codd

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Raj More

Title: So help me Codd

Abstract:

I will talk about Database design

• Normalization and Normal forms (1NF, 2NF, 3NF, BCNF)
• Insert/Update/Delete Anomalies and how to solve for them
• Techniques of normalization
• Who Dat?
• Denormalization
• Common Sense things to do when working with databases

SessionID: 32744

Overview of SQL 2005 Service Broker

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Database Development-TSQL

Speaker: Said Salomon

Title: Overview of SQL 2005 Service Broker

Abstract:

This session will be a basic review of SQL 2005 Service Broker. It will explain what SQL 2005 Service Broker is, and how can it be used. The presentation will include a number example applications and demos of basic SQL 2005 Service Broker.

SessionID: 32903

New Toys for Developers in SQL Server 2008

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Database Development-TSQL

Speaker: Sharon Dooley

Title: New Toys for Developers in SQL Server 2008

Abstract:

This presentation will cover some of the important features for developers in SQL Server 2008. Topics covered include the FILESTREAM attribute, Change Data Capture, the MERGE statement and Row Constructors. There will be demos for most of the topics.

SessionID: 33367

Pushing Data to a Web Client Using Comet

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Database Development-.NET

Speaker: Terry Weiss

Title: Pushing Data to a Web Client Using Comet

Abstract:

Pushing data to a web client over HTTP has always been a hassle. There are ways to do it using Flash or Silverlight, but they all require a component and/or separate install on the client as well as obscuring the semantic value of the data. Wouldn't it be nice if you could just use Plain Old Semantic HTML (POSH) and regular JavaScript to simplify client requirements? Comet (aka long-polling) allows you to open a channel to the client and push data from the server down asynchronously. This session will walk you through the Comet architecture using .NET and JQuery to push POSH or JSON data to a web client in a performant and scalable way.

SessionID: 33774

SQL Server 2008 Policy Managment Overview

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Joe Toscano

Title: SQL Server 2008 Policy Managment Overview

Abstract:

In presentation I’ll first cover the basics of Policy Management by looking at the components focusing on several simple examples. Then, we’ll discuss how Policy Management can be used to ensure your instances of SQL Server adhere to Microsoft’s recommended best practices for SQL 2000, 2005 and 2008. We’ll see how we can import the readily available and predefined SQL Server best practices into the Policy Management umbrella. Finally, we’ll look at the Enterprise Policy Management Framework which can be used to provide insightful and intuitive Reporting Services reports that can provide you with the policy adherence metrics for your SQL Server Instances across the enterprise.

SessionID: 34519

Developing with SQL Azure

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Database Development-.NET

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.

SessionID: 34520

Pivot Data Visualization

Back to calendar

Event Date: 13-03-2010 - Session time: 00:00:00 - Track: Database Development-.NET

Speaker: Matt Van Horn

Title: Pivot Data Visualization

Abstract:

Live Labs recently released Pivot a tool to visualize data which can allow uses to see patterns in data like never before. In this session I will provide a basic intro to Pivot and discuss how to use you existing database and the pivotcollectiontools(on codeplex) SDK that I have released to dynamically build Pivot Collections.

This site is open source. Improve this page.