Nr: 69
SQLSaturday #69 - Philadelphia 2011
SessionID: 28476
High-Speed Dimensional Data Loads With SSIS
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: BI Track #2 (106)
Speaker: Michael Coles
Title: High-Speed Dimensional Data Loads With SSIS
Abstract:
SessionID: 28477
Sell Yourself!
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Prof Devel / Dev (113)
Speaker: Michael Coles
Title: Sell Yourself!
Abstract:
In today's economy job seekers need to take advantage of every opportunity. In this session attendees will learn how to take advantage of unprecedented opportunities to market themselves to potential employers (and the world at large!) We'll cover topics including fine-tuning your resume, managing your online presence and responding to the toughest interview questions. We'll also discuss how you can turn simple steps, like asking your interviewer questions and sending a follow-up note, into unparalleled opportunities to close the deal.
SessionID: 28592
Advance T-SQL technique to optimize a code.
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Dev Track #2 (111)
Speaker: Alex Grinberg
Title: Advance T-SQL technique to optimize a code.
Abstract:
In this session I'll demonstrate how T-SQL code can be improved using latest features for
SQL Server 2005 and up, such as CTE (Common Table Expression), OUTPUT clause, Ranking functions, EXCEPT, INTERSECT, XPath query, MERGE statement and others.
SessionID: 29031
Knowing Tempdb
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: DBA Track #2 (109)
Speaker: Bharat Kenjale
Title: Knowing Tempdb
Abstract:
System database call tempdb, which is used for storing temporary objects and has been a key component of SQL Server since its inception. The role of tempdb has been brought to the forefront with a plethora of new features and optimizations that depends upon temporary objects. Session will discuss on
-> How SQL Server uses tempdb for internal and user created temporary objects
-> How to troubleshoot and avoid common tempdb issues
-> How to monitor and tune tempdb performance
-> How configuration best practices can increase the performance and availability of tempdb
SessionID: 29055
Accessing SQL Server Data with .NET
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Dev Track #1 (110)
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 (oData), and client side data models with WCF RIA Data Services.
SessionID: 30195
Using Confio Ignite 8 for Production Failures
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: DBA Track #2 (109)
Speaker: Dale Cunningham
Title: Using Confio Ignite 8 for Production Failures
Abstract:
SessionID: 30289
Rolling upgrade 2008 R2 Cluster /SQL 2008 R2
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: DBA Track #1 (108)
Speaker: Greg Seidel
Title: Rolling upgrade 2008 R2 Cluster /SQL 2008 R2
Abstract:
Reduce downtime of SQL 2008 failover over clusters by applying service packs and cumulative updates using Rolling Upgrades.
SessionID: 30316
Slinging data with SQL Server Replication
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: DBA Track #1 (108)
Speaker: Hilary Cotter
Title: Slinging data with SQL Server Replication
Abstract:
SQL Server replication is a native SQL Server component used to move data from one server to another, and sometimes back again. It's most popular use case is to offload reporting from bogged down OLTP servers - it can also be used for scale out solutions, transforming data, consolidating data, moving data closer to its consumers, proving high availability solutions and disaster recovery.
SessionID: 30472
SQL Server Service Broker – An Overview
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Dev Track #2 (111)
Speaker: Janis Griffin
Title: SQL Server Service Broker – An Overview
Abstract:
Service Broker can be used to simplify messaging between applications and assist in asynchronous programming by queuing messages and/or events. This presentation will explain how to use the Service Broker services, discuss its many components and show why you’ll benefit from using it. Several case studies will illustrate an elegant way to maintain data across multiple servers and show how to reduce dependencies between related programs and/or data structures.
SessionID: 30473
Query Tuning - Getting it Right the First Time!
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Dev Track #2 (111)
Speaker: Janis Griffin
Title: Query Tuning - Getting it Right the First Time!
Abstract:
SessionID: 30635
Building your first SQL Cluster
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Misc / Vendor (121)
Speaker: Joseph D'Antoni
Title: Building your first SQL Cluster
Abstract:
Interested in high availability, but don't know where to start? This session will start at the ground level and work through all the requirements of building a SQL Cluster environment, including Windows steps, storage steps, and networking needs. Of course, SQL Server will be included in this process.
SessionID: 30636
Deploying Data Tier Applications with SQL 2008 R2
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Dev Track #1 (110)
Speaker: Joseph D'Antoni
Title: Deploying Data Tier Applications with SQL 2008 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: 30904
Table Partitioning: Implementing a sliding window
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Dev Track #1 (110)
Speaker: Joe Toscano
Title: Table Partitioning: Implementing a sliding window
Abstract:
SessionID: 31359
SSRS 2008R2 Reporting Gallery
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: BI Track #1 (105)
Speaker: Kevin Goff
Title: SSRS 2008R2 Reporting Gallery
Abstract:
In this presentation, I'll show 10 rather cool looking reports created in SSRS 2008R2 - everything from sparklines to heat maps, from Tablix-drilldown reports to advanced charts, from performance gauges to new page/group control features in R2. Since no presentation can cover the creation of all ten, I'll let the majority of the audience decide which to cover.
SessionID: 31361
Business Intelligence with SharePoint 2010
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: BI Track #1 (105)
Speaker: Kevin Goff
Title: Business Intelligence with SharePoint 2010
Abstract:
SharePoint 2010 provides many opportunities to render data from business intelligence applications. In this presentation, I'll show examples of building BI content in SharePoint 2010 using PerformancePoint Services, Excel Services, SSRS, and PowerPivot. Because I'm covering many applications, I won't be able to cover any one topic too heavily. But at the end of the presentation, the attendee will see several examples of how BI applications can use SharePoint 2010
SessionID: 31770
Spatial Data and Windows Azure
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Dev Track #1 (110)
Speaker: Mihail Mateev
Title: Spatial Data and Windows Azure
Abstract:
SessionID: 31941
Building your first cube in SQL Server
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: BI Track #2 (106)
Speaker: Mark Kromer
Title: Building your first cube in SQL Server
Abstract:
Learn about the value of building multi-dimensional cubes for reporting on your data in SQL Server. Learn how and where to go to get started with building cubes in SSAS, PowerPivot and the new ways to build semantic models in SQL Server Denali, starting at level 101 for beginners.
SessionID: 31942
Migrate SQL Server Apps to SQL Azure Cloud DB
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Dev Track #1 (110)
Speaker: Mark Kromer
Title: Migrate SQL Server Apps to SQL Azure Cloud DB
Abstract:
SessionID: 31943
Light-up BI Dashboards with Cool Visualizations
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: BI Track #2 (106)
Speaker: Mark Kromer
Title: Light-up BI Dashboards with Cool Visualizations
Abstract:
We will dive into discussions lots of demos on techniques you can leverage for your own Microsoft SQL Server SharePoint BI solutions. I'll show examples and how 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.
SessionID: 32037
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: DBA Track #1 (108)
Speaker: Muthu Ramanathan
Abstract:
SessionID: 32038
Parallel Data Warehousing
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: BI Track #1 (105)
Speaker: Muthu Ramanathan
Title: Parallel Data Warehousing
Abstract:
Overview
Architecture
Query plans
Demos
SessionID: 32140
Intro to SSIS
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Misc / Vendor (121)
Speaker: Vince Napoli
Title: Intro to SSIS
Abstract:
SessionID: 32158
Modeling Hierarchies in SQL
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Prof Devel / Dev (113)
Speaker: Patty Pickup
Title: Modeling Hierarchies in SQL
Abstract:
The dictionary defines a hierarchy as “any system of persons or things ranked one above another.” Classic examples that you may want to model in a database are an org chart or a bill of materials. A less well-behaved example is the dependency of database objects (sysdepends). These examples will be used to explain HIERARCHYID, recursive CTE (Common Table Expressions) and the Adjacency List Model.
SessionID: 32331
TDD – Thwarting Database Defects
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Prof Devel / Dev (113)
Speaker: Dennis Lloyd and Sebastian Meine .
Title: TDD – Thwarting Database Defects
Abstract:
It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them.
This presentation introduces tSQLt, a framework for automated database unit testing. You’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain.
SessionID: 32365
Database design tips and tricks
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: DBA Track #2 (109)
Speaker: Raj More
Title: Database design tips and tricks
Abstract:
I will talk about designing structures that hold data for the business
- Designing Lookup tables and Data Tables.
- Surrogate keys and exceptions thereto.
- The differences between Logical models and Physical implementation.
We will wrap up with an Interactive design session.
SessionID: 32399
Become Bilingual! Oracle for the SQL Server DBA
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: DBA Track #1 (108)
Speaker: Randy Knight
Title: Become Bilingual! Oracle for the SQL Server DBA
Abstract:
SessionID: 32400
Visual Studio 2010 Database Projects
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Dev Track #2 (111)
Speaker: Randy Knight
Title: Visual Studio 2010 Database Projects
Abstract:
Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren't databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been.
SessionID: 32678
I/O, I/O It's Why my Server's Slow - Waits Queue
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: DBA Track #2 (109)
Speaker: Robert Pearl
Title: I/O, I/O It's Why my Server's Slow - Waits Queue
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: 32868
Concurrency Control
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: DBA Track #2 (109)
Speaker: Sebastian Meine
Title: Concurrency Control
Abstract:
SessionID: 32904
Women In Technology Panel Discussion
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Prof Devel / Dev (113)
Speaker: Sharon Dooley
Title: Women In Technology Panel Discussion
Abstract:
Increasing the role of women in technology has a direct impact on the women working in hi-tech, but the effects can go far beyond that. How do female tech workers influence innovation and product development? How do men benefit from having more women working in technology? Can the presence of women in tech affect a company’s bottom line? What does it mean for women and their families when they have access to hi-tech jobs? This session is open to both men and women. The panelists will present brief remarks and then the floor will be open for the audience to ask questions of the panelists.
SessionID: 33650
Data Encryption and Key Management in SQL
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: DBA Track #1 (108)
Speaker: Said Salomon
Title: Data Encryption and Key Management in SQL
Abstract:
Overview of data encryptions and key management that is built into SQL 2005 and later. Topics that will be cover include: transparent column data encryption techniques, Transparent Data Encryption (TDE) new in 2008, use of keys (symmetrical and asymmetrical), what is a database master key, use of certificates in combination with key management, how to backup and safeguard keys.
SessionID: 33864
Table Vars and Temp Tables-What you NEED to know!
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Dev Track #2 (111)
Speaker: Wayne Sheffield
Title: Table Vars and Temp Tables-What you NEED to know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, 'When do I use one or the other and what are the various impacts of doing so?"
SessionID: 34249
Beyond Plateaux: Optimize SSAS via Best Practices
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: BI Track #2 (106)
Speaker: William E Pearson III
Title: Beyond Plateaux: Optimize SSAS via Best Practices
Abstract:
SessionID: 34252
Entity Strategies: Structuring Your Consultancy
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: Prof Devel / Dev (113)
Speaker: William E Pearson III
Title: Entity Strategies: Structuring Your Consultancy
Abstract:
SessionID: 34253
Many-to-Many: Multiple Calendars in a Single Cube
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: BI Track #2 (106)
Speaker: William E Pearson III
Title: Many-to-Many: Multiple Calendars in a Single Cube
Abstract:
Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to many organizations, including financial services firms and the like. After all, having customer calendars in their cubes' date dimension means sales and marketing managers can analyze - and report upon - data according to the fiscal calendar of the customer, as well as within the context of their own. In this session, we look at a way we can accomplish this by implementing a SQL Server Analysis Services "many-to-many" dimension scenario.
SessionID: 34515
Intro to SQL Reporting Services
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: BI Track #1 (105)
Speaker: Matt Van Horn
Title: Intro to SQL Reporting Services
Abstract:
I will offer a 100 level into to Reporting Services and show you how to build reports using the Business Intelligence Development Studio 2008. We will cover all the basics that you will need to know to build a real report currently knowing nothing about reporting services.
SessionID: 34516
SSRS Interactive Reports
Event Date: 05-03-2011 - Session time: 00:00:00 - Track: BI Track #1 (105)
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.