sqlsathistory

Nr: 59

Back to Main list

SQLSaturday #59 - New York City 2010

Start Time (24h) Speaker Track Title
00:00:00 Michael Coles Track 6 High Performance SSIS Dimensional Datamart Loads
00:00:00 Allan Hirt Track 4 Failover Clustering with Windows Server 2008 R2
00:00:00 Allan Hirt Track 2 So Many High Availability Options, So Little Time
00:00:00 Ayad Shammout Track 3 PowerPivot for Excel and SharePoint 2010
00:00:00 Ayad Shammout Track 3 Building a High Availability SQL Server 2008 R2
00:00:00 Chuck Kelley Track 5 Data Vault and the Data Warehouse
00:00:00 Don Demsak Track 6 OData For DBAs
00:00:00 Don Gabor Track 6 Building Business Contacts at IT Conferences
00:00:00 Grant Fritchey Track 2 DMV's as a Shortcut to Procedure Tuning
00:00:00 Hilary Cotter Track 6 Transactional Replication Fundamentals
00:00:00 Jana Sattainathan Track 3 Partitioning in SQL Server 2005/2008
00:00:00 Joseph D'Antoni Track 5 Deploying Data Tier Applications with SQL 2k8 R2
00:00:00 Joseph D'Antoni Track 5 MDW-What's going on in my server?
00:00:00 Karen Lopez Track 2 Database Design Contentious Issues
00:00:00 Kevin Goff Track 1 Cool Reporting Features in SSRS 2008R2
00:00:00 Kevin Goff Track 1 Three cool packages in SSIS 2008
00:00:00 Linchi Shea Track 5 Notes on Linked Servers
00:00:00 Matt Van Horn Track 1 SSRS Interactive Reports
00:00:00 Mark Kromer Track 1 Light-up BI Dashboards with Cool Visualizations
00:00:00 Roman Rehak Track 4 SQL Server Development Tips and Tricks
00:00:00 Robert Pearl Track 2 I/O I/O It's Why My Server's Slow - Waits Queues
00:00:00 Scott Weinstein Track 5 Keeping your SQL Code DRY
00:00:00 Scott Weinstein Track 4 Get your database under version control
00:00:00 Steve Jones Track 4 The Modern Resume: Building Your Brand
00:00:00 Thomas LaRock Track 1 Performance Tuning Made Easy
00:00:00 Steve Simon Track 2 12 ways to write POORLY performing MDX queries
00:00:00 Steve Simon Track 4 Handling data anomalies with Data Profiling Tasks
00:00:00 Aaron King Track 6 The Benefits of SQL Azure
00:00:00 William E Pearson III Track 3 Attribute Discretization in Analysis Services
00:00:00 William E Pearson III Track 3 Getting Started with MDX

SessionID: 28460

High Performance SSIS Dimensional Datamart Loads

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Michael Coles

Title: High Performance SSIS Dimensional Datamart Loads

Abstract:

Performance-driven SSIS ETL solutions require a mix of both SQL and SSIS developer optimizations. In this session attendees will learn SQL code and SSIS data flow optimizations, tips and best practices that are specifically geared to obtain the best performance from your enterprise ETL solution. This session is specific to Datamart ETL, but much of the information presented can be applied to any SSIS solution.

SessionID: 28611

Failover Clustering with Windows Server 2008 R2

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Allan Hirt

Title: Failover Clustering with Windows Server 2008 R2

Abstract:

Forget a good portion of everything you know about clustering - Windows Server 2008 changes the game. Come see how the changes and improvements affect clustered SQL Server deployments. In addition to Windows, both SQL Server 2005 and SQL Server 2008 will also be discussed. The focus will be on SQL Server 2008 and how its changes to the setup, upgrade, and patching processes (among other things) impact the configuration and administration of a clustered SQL Server 2008 instance. Live demos will be shown, and one copy of Allan’s latest book, Pro SQL Server 2008 Failover Clustering, will be given away.

SessionID: 28612

So Many High Availability Options, So Little Time

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Allan Hirt

Title: So Many High Availability Options, So Little Time

Abstract:

Are you confused by the various SQL Server high availability technologies? Do you understand what each one does and where each one may or may not benefit you? Do you know the basics of what you need to implement highly available SQL Server instances and databases? If these burning questions speak to you, so will this session. Whether you are an accidental DBA, new to SQL Server, or looking to brush up your skills, this session will cover the different methods of making SQL Server available, compare and contrast them, as well as and cover the top things you need to do to ensure uptime. Where appropriate, demos will be shown.

SessionID: 28957

PowerPivot for Excel and SharePoint 2010

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Ayad Shammout

Title: PowerPivot for Excel and SharePoint 2010

Abstract:

In this session, I will cover PowerPivot - a data analysis add-in that delivers computational power directly within MS Excel 2010. By combining native Excel 2010 functionality with PowerPivot’s in-memory engine, I will interactively explore and perform calculations on very large data sets. This session gives the user the freedom to learn the many uses of PowerPivot from importing, modeling, analyzing and pivoting millions of records to publishing to SharePoint. I will show how IT staff can track and monitor user generated PowerPivot workbooks in SharePoint and explore PowerPivot Management Dashboard.

SessionID: 28958

Building a High Availability SQL Server 2008 R2

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Ayad Shammout

Title: Building a High Availability SQL Server 2008 R2

Abstract:

If you are new to SQL Server 2008 R2, you will learn how to utilize Clustering and Mirroring technologies together to achieve High Availability and minimize data loss in the event of a disaster. In this session, I will show how we minimize downtime while migrating from SQL Server 2005 Cluster to SQL 2008 R2. This session includes real life deployment and upgrade scenarios to achieve high availability and disaster recovery, the lessons learned, and the best practices. Technologies covered include Failover Clustering on Windows Server 2008 R2 and SQL 2008 R2 Database Mirroring.

SessionID: 29552

Data Vault and the Data Warehouse

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Chuck Kelley

Title: Data Vault and the Data Warehouse

Abstract:

Data vaults are new constructs for the Data Warehouse. This session will

  1. Introduce and discuss the data vault design technique
  2. Discussion data movement from a data vault to a dimensional model and
  3. Provide high performance ETL to implement them within SQL Server.

SessionID: 29939

OData For DBAs

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Don Demsak

Title: OData For DBAs

Abstract:

An introduction for DBAs to OData - A Web protocol for querying and updating data that provides a way to unlock your data and free it from silos that exist in applications today.

SessionID: 29942

Building Business Contacts at IT Conferences

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Don Gabor

Title: Building Business Contacts at IT Conferences

Abstract:

Networking is challenging for many technical people, but approaching and talking to colleagues is one of the most valuable take-aways you can get at an IT conference. In this 1-hour SQLSaturday workshop, conversation expert and best-selling author Don Gabor will guide you through the networking process—including remembering names—and show you how to make professional connections that will pay off for years to come.

SessionID: 30263

DMV's as a Shortcut to Procedure Tuning

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Grant Fritchey

Title: DMV's as a Shortcut to Procedure Tuning

Abstract:

Dynamic Management Views (DMV) expose a wealth of information to the database administrator. However, they also expose information that is vital to the database developer. More often than not people gather performance metrics through server side traces. This session will show how to gather information from the DMVs for currently executing, and recently executed queries. The session will demonstrate combining this information with other DMVs to get more intersting information such as the query plan and query text. I'll show where you can get aggregate information for the queries in cache to determine which queries are being frequently accessed or using the most resources. Indexes used, fragmentation and more.

SessionID: 30320

Transactional Replication Fundamentals

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Hilary Cotter

Title: Transactional Replication Fundamentals

Abstract:

SessionID: 30421

Partitioning in SQL Server 2005/2008

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Jana Sattainathan

Title: Partitioning in SQL Server 2005/2008

Abstract:

Starting with SQL Server 2005, Microsoft has made a significant effort to truly streamline partitioning data to be on par with industry leading databases like Oracle. The potential was not fully harnessed by the SQL Server community primarily due to the lack of any user interface associated with partitioning and due to lack of cohesive documentation. For many, Kimberly Tripp’s white paper on “Partitioned Tables and Indexes in SQL Server 2005” is generally regarded as a primary guiding source that bridges the void in MS documentation. Come and get a quick start on partitioning. It is simple, efficient. Manageability and performance come part and parcel.

SessionID: 30648

Deploying Data Tier Applications with SQL 2k8 R2

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Joseph D'Antoni

Title: Deploying Data Tier Applications with SQL 2k8 R2

Abstract:

Data Tier Applications (DAC Packs) are a new feature in SQL 2008 R2, that alllow developers to better simplify environmental management. In this demo, I will define the requirement surrounding DAC packs, then build and deploy a sample.

SessionID: 30649

MDW-What's going on in my server?

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Joseph D'Antoni

Title: MDW-What's going on in my server?

Abstract:

A deep dive into the configuration and utilization of the Management Data Warehouse feature in SQL Server 2008. This session will discuss how MDW is configured, managed and utilized. Also, how to generate reports and to customize data collection for your environment.

SessionID: 31189

Database Design Contentious Issues

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Karen Lopez

Title: Database Design Contentious Issues

Abstract:

SessionID: 31336

Cool Reporting Features in SSRS 2008R2

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Kevin Goff

Title: Cool Reporting Features in SSRS 2008R2

Abstract:

In this presentation, I'll show about a half-dozen different report examples in SSRS 2008R2. Each report demonstrates different features in SSRS 2008R2 that are sure to please different business users. These new features include sales heat maps, sparklines, performance gauges, better page control, uses for the Tablix control, better charting, and new features for SharePoint 2010 integration.

SessionID: 31340

Three cool packages in SSIS 2008

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Kevin Goff

Title: Three cool packages in SSIS 2008

Abstract:

If you know the basics of SSIS, and/or you simply want to see some intermediate-advanced examples, this session is for you. I'll spend about 20 minutes walking through 3 different SSIS packages that show tricks for using the data flow pipeline, scripting, multicast, aggregations, merge joins, package configurations, FTP, dynamic expressions, and even the dreaded Excel destination component. These packages are based on a 2-part article of mine that was published in CoDe magazine this year.

SessionID: 31502

Notes on Linked Servers

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Linchi Shea

Title: Notes on Linked Servers

Abstract:

SessionID: 31615

SSRS Interactive Reports

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 1

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

Light-up BI Dashboards with Cool Visualizations

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Mark Kromer

Title: Light-up BI Dashboards with Cool Visualizations

Abstract:

Discussion demos on techniques you can leverage to create cool dashboards with compelling visualizations for office-based users and mobile users. This session will be geared toward SQL Server professionals with .NET code samples that can be easily re-used in your SQL Server BI applications.

SessionID: 32629

SQL Server Development Tips and Tricks

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Roman Rehak

Title: SQL Server Development Tips and Tricks

Abstract:

This session will cover many common issues, challenges and problems encountered when developing for, or administering SQL Server as well as examining best ways to modify, script and copy database objects from development to production environment. Session materials for the attendees will include custom utility tools and stored procedures written by the speaker for simplifying SQL Server development and database update deployment.

SessionID: 32679

I/O I/O It's Why My Server's Slow - Waits Queues

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Robert Pearl

Title: I/O I/O It's Why My Server's Slow - Waits Queues

Abstract:

Based on the popular cover-story article appearing in SQL Server Magazine, Robert Pearl expands on ways to measure SQL Server's performance and present the information in a readable and useful format. He will bring us useful tips for getting and analyzing I/O information, and troubleshoot performance bottlenecks.

In addition, Robert will scratch the surface and introduce performance tuning using a methodology called Waits and Queues, with respect to I/O. By using this methodology one can identify the best opportunities to improve performance, the so called “biggest bang for the buck”. These performance improvements are likely to have a significant return on the performance tuning time investment.

SessionID: 32839

Keeping your SQL Code DRY

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Scott Weinstein

Title: Keeping your SQL Code DRY

Abstract:

Don't Repeat Yourself - it's the golden rule of good code, and with Common Table Expressions, Table Values Functions, and the APPLY operator, we'll show how well structured code can be created without stored procedures.

SessionID: 32840

Get your database under version control

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Scott Weinstein

Title: Get your database under version control

Abstract:

It's a given that the source code to your project's ETL, Cubes, User Interfaces, WCF services, etc are kept under tight version control. But many developers turn a blind eye to source code in their database - the critical views, stored procedures, and user defined functions.

With a few concepts and tools build into every version of SQL Server I'll show how to build simple and free version control for your project.

SessionID: 32946

The Modern Resume: Building Your Brand

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Steve Jones

Title: The Modern Resume: Building Your Brand

Abstract:

Learn practical ways that you can build your career brand and stand out from the crowd. Steve Jones, editor of SQLServerCentral and longtime DBA shares some of the ways in which he has successfully grown his career over the years. Learn some tips and tricks for social networking, blogging, volunteering, leadership, and resume hints to help you find a great job.

SessionID: 33070

Performance Tuning Made Easy

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Thomas LaRock

Title: Performance Tuning Made Easy

Abstract:

Performance tuning is hard, everyone knows that. Attend this session and learn how to define, measure, and analyze performance issues as well as implementing changes and also how to make sure those changes continue to have the desired effects. In short, I break down performance tuning into pieces that anyone can understand. Leave this session knowing what actions to take when you get back to work on Monday.

SessionID: 33169

12 ways to write POORLY performing MDX queries

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Steve Simon

Title: 12 ways to write POORLY performing MDX queries

Abstract:

OLAP cubes have become an important means of delivering valuable information from complex data within the Corporate Data Warehouse. Adequate information helps the corporate decision makers take the necessary steps to ensure that the enterprise is heading in the correct direction, especially in the tough and turbulent economic times. This beginner’s to intermediate level hands-on presentation is aimed at showing the attendee some of the pitfalls of poorly designed and poorly performing MDX queries and how many of the queries may be optimized to ensure that they are both efficient and effective.

SessionID: 33171

Handling data anomalies with Data Profiling Tasks

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Steve Simon

Title: Handling data anomalies with Data Profiling Tasks

Abstract:

Within the realm of the financial world, data is often sourced from a plethora of financial systems that more often than not have different formats and business rules. This poses many challenges to the integration of the data into corporate data warehouses. Metrics and tools to detect data anomalies (prior to insertion into the corporate data warehouses) were often difficult to create and often overlooked. This hands-on presentation will show the attendee how we have been able to revamp and revise our preload data validations, often removing many of our ‘early warning’ queries and replacing these with SSIS 2008 Data Profiling Tasks.

SessionID: 33781

The Benefits of SQL Azure

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Aaron King

Title: The Benefits of SQL Azure

Abstract:

This talk will focus on the benefits, features, and ease of use of SQL Azure. Learn how your projects can benefit from a hosted data storage and query processing service. See by example how to design your program to use SQL Azure. Real world topics and use cases will be covered including data sync and staying vendor independent while hosting your data in the cloud.

SessionID: 33939

Attribute Discretization in Analysis Services

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: William E Pearson III

Title: Attribute Discretization in Analysis Services

Abstract:

Attribute discretization is an oft-overlooked feature in Analysis Services that allows us to automatically create a manageable number of groups of attribute values that are clearly separated by boundaries. Discretization can help us to make it easier for information consumers to work with large numbers of possible attribute member values. In this session, we will discuss the varied options, the design (and other) considerations involved, and best practices surrounding the use of this capability.

SessionID: 33940

Getting Started with MDX

Back to calendar

Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: William E Pearson III

Title: Getting Started with MDX

Abstract:

In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.