Nr: 8
SQLSaturday #8 - Orlando 2008
SessionID: 34919
Data Scrambling
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: SQL Developers
Speaker: Andreas Etelkozi
Title: Data Scrambling
Abstract:
Data Scrambling is aimed to assist DBA-s to represent schema, data volume and characteristics of data without divulging PII and other real data. Data scrambling provides a realistic data environment for demonstration, training or testing purposes. This presentation will give an understanding of the levels, problems and possible solutions of Data Scrambling, together with a practical demonstration.
SessionID: 34944
SQL Server Statistics
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Performance
Speaker: Andy Warren
Title: SQL Server Statistics
Abstract:
This is a beginner to intermediate level session that will show you how and why statistics are created, how the impact query plans, how to maintain statistics, and what to do when statistics works against you due to uneven data distribution.
SessionID: 34950
Intro to SQL Server 2008 Full Text Searching
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: General DBA II
Speaker: Robert Cain
Title: Intro to SQL Server 2008 Full Text Searching
Abstract:
Microsoft SQL Server 2008 contains the functionality you need to issue full-text queries against plain character-based data in SQL Server tables. Full-text queries could include words and phrases or multiple forms of a word or phrase.Come learn how to setup your own full text searches in your applications. Give your users search capabilities into their data. It's as easy as 1-2-3!
In this session, the attendees will learn not only how to use the standard full text search functionality, but how to customize the built in list of “noise words”, to be able to add and remove words that should or should not be ignored. In addition attendees will also learn how to customize the thesaurus for their own needs. DBAs will also find helpful queries
SessionID: 35025
Using LINQ to SQL in Your Applications
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: SQL Developers
Speaker: Brandon Kelly
Title: Using LINQ to SQL in Your Applications
Abstract:
LINQ (Language Integrated Query) is a powerful new technology built into the Microsoft.NET 3.5 platform that allows developers to query object graphs (including DataSets, XML and SQL Server databases) with a familiar and easy-to-use query syntax right from their application code. Learn how to setup a LINQ project, retrieve strongly-typed object graphs from SQL Server (including child relationships and object dependencies) and bind this data to an ASP.Net webpage, a Windows Form or a Silverlight/WPF application.
SessionID: 35042
Disaster Recovery: Preparing for the Storm
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: General DBA
Speaker: Brandie Tarvin
Title: Disaster Recovery: Preparing for the Storm
Abstract:
A presentation on preparing ahead of time for the ultimate loss of data due to hurricanes, floods, fires, theft or even server crashes. This session will cover various options for protecting your databases and the pros cons of each.
SessionID: 35043
The Nitty Gritty of Database Backups
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: General DBA
Speaker: Brandie Tarvin
Title: The Nitty Gritty of Database Backups
Abstract:
A beginner level session on the available types of SQL database backups and how their choices affect your database recovery. This focuses on how to implement backups and how to come to a decision on which backup / recovery policy is best for your workplace.
Note: This session is not the same as Disaster Recovery - Preparing for the Storm
SessionID: 35054
SQL Compact Data Sync
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Performance
Speaker: Nikita Polyakov
Title: SQL Compact Data Sync
Abstract:
Intro to SQL Compact and Data Sync services. In this presentation we go over benefits of SQL Compact not only on a mobile device, but as an amazing alternative to locally cached data for occasionally connected devices like laptops. We will also go over Sync Services for SQL Compact.
SessionID: 35063
Getting Started with SQL Server Profiler 2005
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Performance
Speaker: Jack Corbett
Title: Getting Started with SQL Server Profiler 2005
Abstract:
SessionID: 35064
ASP.NET Databinding 101
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: SQL Developers
Speaker: Chris Rock
Title: ASP.NET Databinding 101
Abstract:
This session will show the attendee how easy it is to quickly display your data on a web page with a minimum amount of code. We will cover displaying, editing, deleting and inserting data.
SessionID: 35078
Transact SQL Frequently Asked Questions
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Sharepoint
Speaker: Kent Waldrop
Title: Transact SQL Frequently Asked Questions
Abstract:
MVP Kent Waldrop takes a quick tour of a few of the SQL issues that come up frequently in the MSDN Transact SQL forum. Some of the topics covered include set oriented processing, pitfalls of user defined functions, working with string lists, filtering by date and time and more.
SessionID: 35096
Report Viewer Controls in Reporting Services 2008
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Reporting Services
Speaker: Darren Herbold
Title: Report Viewer Controls in Reporting Services 2008
Abstract:
Learn how to create a web-based reporting dashboard in Reporting Services 2008.
This session will show you how to use the 2008 Report Viewer controls inside an
ASP.NET page while also demonstrating the use of parameters supplied through the
client interface. Examples ASP.NET and C#.
SessionID: 35112
SSIS Configurations, Expressions and Constraints
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Eric Wisdahl
Title: SSIS Configurations, Expressions and Constraints
Abstract:
This session will look in depth at some of the more powerful aspects of Integrations Services: Expressions, Package Configurations, and Precedence Constraints. A short tutorial will show the users how to build up a package structure to allow logging to a remote location determined through configurations as well as capturing errors, destroying the error file if no errors are present and emailing a configurable user if any errors are found.
SessionID: 35163
Understanding Indexes for Single-Table Queries
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Performance
Speaker: Jeffrey Garbus
Title: Understanding Indexes for Single-Table Queries
Abstract:
SessionID: 35164
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Performance
Speaker: Jeffrey Garbus
Abstract:
The sequel to "understanding single-table index optimization," you will learn all about SQL Server joins, and how they are optimized.
SessionID: 35183
Upgrading Analysis Services 2005 to 2008
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Jen Underwood
Title: Upgrading Analysis Services 2005 to 2008
Abstract:
1. Present upgrading a real Analysis Services 2005 cube to Analysis Services 2008 (not Adenture Works)
- Show some of the new Analysis Services 2008 features
- Demonstrate a few performance improvement examples side by side (most likely MDX queries using Mosha's MDX Studio to walk through the details of specific improvements.
SessionID: 35199
Database development using Team System 2008
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: SQL 2008
Speaker: Jim Blizzard
Title: Database development using Team System 2008
Abstract:
Ever make a bunch of changes to your database then lose track of what you’ve changed? Frustrated with trying to come up with consistent, “meaningful” test data to test your applications? Wish you could unit test your database? Ever forget to make a backup copy of your stored procedure before you made that one line change (that happens to crash the system)? Tired of feeling like you’re not part of the team? We’ll take a look at how Team System can help ease the pain of database development and change management.
SessionID: 35207
SQL Server 2008: The Need for Speed!
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: SQL Developers
Speaker: Joe Homnick
Title: SQL Server 2008: The Need for Speed!
Abstract:
SessionID: 35228
Virtualizing SQL Server
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: General DBA
Speaker: Jonathan Kehayias
Title: Virtualizing SQL Server
Abstract:
Virtualization is a hot topic these days, and SQL Server is often considered for virtualization. This session will cover the various technologies available for virtualizing SQL Server, how to determine whether or not a SQL Server is a canidate for virtualization, as well as alternatives to virtualizing SQL for Disaster Recovery scenarios.
SessionID: 35229
Server Monitoring made Simple with SQL 2008
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: General DBA
Speaker: Jonathan Kehayias
Title: Server Monitoring made Simple with SQL 2008
Abstract:
SessionID: 35251
Protecting Your SQL Server from Treasure Seekers
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: SQL 2008
Speaker: Brian Kelley
Title: Protecting Your SQL Server from Treasure Seekers
Abstract:
In this presentation, we'll look at ways of securing SQL Server and coding secure means of data access for an organization's sensitive data. This presentation will cover all audiences, from system administrators, to database administrators, to developers. We'll look at features common across SQL Server 2000/2005/2008 as well as some of the newer features and how to use them for SQL Server 2005 and 2008.
SessionID: 35266
XML Features in SQL 2005
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: SQL 2008
Speaker: Kendal Van Dyke
Title: XML Features in SQL 2005
Abstract:
XML in SQL 2000 wasn't very exciting and it was easy to dismiss it altogether by just relying on developers to handle any XML needed within the application. SQL 2005 changes the game and this session will show you how to use the new XML data type, do basic XML operations on XML data, and showcase the changes to FOR XML that make it so much more useful. This isn't a session to convince you to use XML, but to show you what you can do with XML if you do need to use it!
SessionID: 35267
Transactional Replication Deep Dive
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: General DBA II
Speaker: Kendal Van Dyke
Title: Transactional Replication Deep Dive
Abstract:
At some point in every DBA’s career they’ll be probably be asked to work with transactional replication but most DBAs don’t look under the covers once they’re done walking through the setup wizards. In this session we’ll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies.
SessionID: 35279
What Greeen and Sustainability Mean to SQL
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: SQL 2008
Speaker: Kathy Malone
Title: What Greeen and Sustainability Mean to SQL
Abstract:
Professionals, and Why You Should Care.
SQL Professionals have the opportunity to be in the front lines in the Green and Sustainability effort.
"Green and Sustainability" encompasses more than just energy conservation, although on that front the new tools in SQL Server 2008 are huge contributors to the Green effort to reduce bits sent across the pipe.
When you add keystroke saving and time saving to the Green and Sustainability effort, SQL Server 2008 can contribute significant metrics to the war on bits (can you say SSIS and SSRS)!
Come to this interactive session to brainstorm with other interested people, hear how Green starts with how you do what you do (Be Green); hear about the opportunities associated with green (Build Gr
SessionID: 35280
Introduction to Reporting Services 2008
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Reporting Services
Speaker: Devin Knight
Title: Introduction to Reporting Services 2008
Abstract:
This session gives an introduction to Reporting Services while focusing on the features that are new in 2008. It will demo the new report designer layout and how to use the Report Builder 2.0. We will also cover the tablix and newly added Dundas visualizations.
SessionID: 35324
Using Excel Services with SharePoint
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Sharepoint
Speaker: Michael Antonovich
Title: Using Excel Services with SharePoint
Abstract:
This session will look at publishing Excel spreadsheets to the web using SharePoint and Excel Services. It will show how to view the Excel spreadsheet in a web browser and how to publish portions of the spreadsheet in a web part on a standard web page. It will look into creating parameterized views of the data as well as how to use data connections from other data sources such as SQL Server to provide a data source for the worksheet content.
SessionID: 35325
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Sharepoint
Speaker: Michael Antonovich
Abstract:
SessionID: 35337
Advanced SQL Server 2005 Reporting Services
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Reporting Services
Speaker: Neil Marchadie
Title: Advanced SQL Server 2005 Reporting Services
Abstract:
In this presentation I would present some of the more arcane aspects of SSRS including advanced charting, using custom code in reports, subreports and navigation internally and externally in Reporting services. I have been a trainer in the past and I've found it best that when I've made presentations my usual rule is to not allow any questions during the presentation, this avoids "presentation hi-jacking" by some attendees. I aim at having at least the last quarter hour for questions. I aim for above all an instructional and entertaining time.
SessionID: 35338
SQL Server 2008 SSRS Changes
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Reporting Services
Speaker: Neil Marchadie
Title: SQL Server 2008 SSRS Changes
Abstract:
This presentation would be aimed at current users of SQL Server 2005 SSRS focusing on the improvements and differnces in the latest iteration of SSRS. Substantial changes in the BIDS layout would be covered along with the new enhancements in SSRS 2008. I have been a trainer in the past and I've found it best that when I've made presentations my usual rule is to not allow any questions during the presentation, this avoids "presentation hi-jacking" by some attendees. I aim at having at least the last quarter hour for questions. I aim for above all an instructional and entertaining time.
SessionID: 35343
Modeling People and Organizations
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Patrick Thompson
Title: Modeling People and Organizations
Abstract:
This session will go through some common approaches and issues associated with representing people and organizations. It will include reviews of some common models (for example, X.500 based models and PIM inspired models such as VCard) and discuss the implications of current dominant scenarios, particularly social applications together with various strategies for representing and integrating this data with a relational database.
SessionID: 35360
T-SQL Enhancements in SQL Server 2008
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: SQL 2008
Speaker: Plamen Ratchev
Title: T-SQL Enhancements in SQL Server 2008
Abstract:
SessionID: 35362
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Performance
Speaker: Plamen Ratchev
Abstract:
SessionID: 35371
Building a Polished Cube
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Pam Shaw
Title: Building a Polished Cube
Abstract:
In this session we will explore the steps needed to create a user friendly cube. This will cover the analysis process, a very brief overview of the data mart processes and finally the cube itself. Within the cube we will focus on steps that will ensure a better experience for the user.
SessionID: 35379
Tips and Tricks for Reporting Services
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Reporting Services
Speaker: Pam Shaw
Title: Tips and Tricks for Reporting Services
Abstract:
SessionID: 35394
Slowly Changing Dimensions
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Robert Hatton
Title: Slowly Changing Dimensions
Abstract:
Nearly every Data Warehouse, Data Mart, or OLAP Cube is challenged by changes over time. How do you report on a store that was in a different territory last year? What do you do when a product changes categories?
This session will show you how to design SQL Tables and Analysis Services dimensions that will accurately model changes over time.
SessionID: 35401
DBA Repository, 2008 SSRS Overlay and Gantt Chart
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Reporting Services
Speaker: Rodney Landrum
Title: DBA Repository, 2008 SSRS Overlay and Gantt Chart
Abstract:
This idea delivers a series of SSRS 2008 reports added to the DBA Repository. One is a working Gantt chart for reporting on SQL Server Agent schedules. I like to call this an "overlay" report, like the old days of the overhead projector where transparencies could be combined in chart form to show time-differentiated values or conicidence. This is vital to a DBA so that he or she can see when jobs overlap on all servers that may cause contention for resources. This is ideal for creating the best-fit schedule for existing jobs or answering scheduling decisions with future jobs. The presentation will cover the follow technologies specific to the popular DBA Repository: SSIS (2008), Reporting Services (2008), and new gauge and range style repor
SessionID: 35403
The SQL DBA Green Thumb
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: General DBA
Speaker: Rodney Landrum
Title: The SQL DBA Green Thumb
Abstract:
SessionID: 35409
Why DBAs Should Learn PowerShell
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: General DBA II
Speaker: Ronald Dameron
Title: Why DBAs Should Learn PowerShell
Abstract:
I will detail my reasoning why a DBA would benefit from learning PowerShell.
I will demonstrate how a DBA can use PowerShell in conjunction with SQL, WMI, and SMO to automate repetitive tasks and better manage their workload.
SessionID: 35411
Test Data Generation Practices
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: SQL Developers
Speaker: Ryan Dorrell
Title: Test Data Generation Practices
Abstract:
SessionID: 35413
Optimizing SSIS PackagesUsing Sql Server 2008
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: General DBA II
Speaker: Ryan Fonnett
Title: Optimizing SSIS PackagesUsing Sql Server 2008
Abstract:
SessionID: 35440
The Modern Resume - Building Your Brand
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: General DBA II
Speaker: Steve Jones
Title: The Modern Resume - Building Your Brand
Abstract:
SessionID: 35441
Damned If You Do, Damned If You Don't: Legal Liabi
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: SQL 2008
Speaker: Suzanne Meehle
Title: Damned If You Do, Damned If You Don't: Legal Liabi
Abstract:
You may be liable for the data you keep. You will be liable for the data you destroy. We will discuss the brave new world of e-discovery, liability, and effective database and data retention policies. In addition, you will receive practical guidance on protecting yourself and your company from legal liability and your data from theft and inadvertent disclosure.
SessionID: 35463
Getting With it With With (and Over On It, Too)
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: General DBA II
Speaker: Terry Bomberger
Title: Getting With it With With (and Over On It, Too)
Abstract:
SessionID: 35496
Databinding in Silverlight 2
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: SQL Developers
Speaker: Kenneth Tucker
Title: Databinding in Silverlight 2
Abstract:
We will talk about the different databinding modes and how to validate data. In this demo we will create a wcf service to send data to a silverlight app. We will bind this data to controls and a datagrid
SessionID: 35509
Building a Data Warehouse using SQL Server 2008
Event Date: 25-10-2008 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Wes Dumey
Title: Building a Data Warehouse using SQL Server 2008
Abstract:
Intersested in learning about data warehousing? SQL Server 2008? Come to this session and learn about both. We will specifically look at the new features for data warehousing with SQL Server 2008.