Nr: 59
SQLSaturday #59 - New York City 2010
SessionID: 28460
Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 6
Speaker: Michael Coles
Abstract:
SessionID: 28611
Failover Clustering with Windows Server 2008 R2
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
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
Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 3
Speaker: Ayad Shammout
Title: PowerPivot for Excel and SharePoint 2010
Abstract:
SessionID: 28958
Building a High Availability SQL Server 2008 R2
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
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
- Introduce and discuss the data vault design technique
- Discussion data movement from a data vault to a dimensional model and
- Provide high performance ETL to implement them within SQL Server.
SessionID: 29939
OData For DBAs
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
Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 6
Speaker: Don Gabor
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
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
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
Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 3
Speaker: Jana Sattainathan
Title: Partitioning in SQL Server 2005/2008
Abstract:
SessionID: 30648
Deploying Data Tier Applications with SQL 2k8 R2
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?
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:
SessionID: 31189
Database Design Contentious Issues
Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 2
Speaker: Karen Lopez
Title: Database Design Contentious Issues
Abstract:
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Implementing Party/party role * Natural vs. Surrogate keys * Today's vs. Tomorrow's Requirements * SOAs, Ontologies, ESBs, New TLAs and Shoe Strings * What is Logical? What is Physical? Why Do We Care? * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
SessionID: 31336
Cool Reporting Features in SSRS 2008R2
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
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
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
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
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
Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 4
Speaker: Roman Rehak
Title: SQL Server Development Tips and Tricks
Abstract:
SessionID: 32679
I/O I/O It's Why My Server's Slow - Waits Queues
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
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
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
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
Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 1
Speaker: Thomas LaRock
Abstract:
SessionID: 33169
Event Date: 20-11-2010 - Session time: 00:00:00 - Track: Track 2
Speaker: Steve Simon
Abstract:
SessionID: 33171
Handling data anomalies with Data Profiling Tasks
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:
SessionID: 33781
The Benefits of SQL Azure
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
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:
SessionID: 33940
Getting Started with MDX
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.