Nr: 15
SQLSaturday #15 - Jacksonville 2009
SessionID: 28724
What Is PASS?
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1001
Speaker: Andy Warren
Title: What Is PASS?
Abstract:
SessionID: 31458
RESTful Data
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1002
Speaker: Chris Eargle
Title: RESTful Data
Abstract:
REST is an architectural style that allows for a layered, scalable, and cacheable enterprise information system. With ADO.NET Data Services, a database can be surfaced to a service as a REST-style resource collection that is addressable with natural URIs and can be interacted with using the usual HTTP verbs: GET, POST, PUT, and DELETE.
This session will describe RESTful Data, the benefits it conveys, and its uses. Then we will set up a data service using an existing database that developers would then access rather than accessing the database directly.
SessionID: 31774
SQLServer 2008 and Geography
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1026
Speaker: Michael Stark
Title: SQLServer 2008 and Geography
Abstract:
Demonstration of using the new Geography datatype in SQLServer 2008. The implementation will showcase in Virtual Earth and .net 3.5 Listview.
SessionID: 34929
SQL Server Statistics
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1001
Speaker: Andy Warren
Title: SQL Server Statistics
Abstract:
Why does SQL Server need statistics? How and when are they created and maintained? How do you know when they are incorrect or out of date? How much difference do they make in query plans? We'll answer all of those questions and more! You'll leave the session with a firm understanding of the working of statistics and what you need to know to keep them in great condition.
SessionID: 35004
Introduction to SQL Server Analysis Services(SSAS)
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1016 (Auditorium)
Speaker: Brian Knight
Title: Introduction to SQL Server Analysis Services(SSAS)
Abstract:
SessionID: 35005
Lunch (served outside)
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1016 (Auditorium)
Speaker: Brian Knight
Title: Lunch (served outside)
Abstract:
Lunch served outside
SessionID: 35038
Disaster Recovery: Preparing for the Storm
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1003
Speaker: Brandie Tarvin
Title: Disaster Recovery: Preparing for the Storm
Abstract:
A non-technical discussion on the methods a business should use to prepare for the inevitable disaster. This discussion includes things you can do to prevent disasters as well as what things to have into place for when the disaster occurs. It goes beyond the usual "back up SQL Server" thoughts.
SessionID: 35041
T-SQL 101 - English to T-SQL Queries
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1001
Speaker: Brandie Tarvin
Title: T-SQL 101 - English to T-SQL Queries
Abstract:
A beginner's level session on how to write the basic SELECT statement and the functions that can make your life either easier or harder.
SessionID: 35050
Patterns And Practices For Successful Architecture
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1003
Speaker: Bayer White
Title: Patterns And Practices For Successful Architecture
Abstract:
What are the steps for successfully architecting a solution? What makes software projects successful? Have you heard these questions before? Bayer White can show and tell you what makes software projects successful from gathering requirements to providing a stable architecture! This presentation will give you a better idea as to the processes that should be followed and artifacts that should be produced to be make a project 360 degrees successful.
SessionID: 35075
Things Go Wrong
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1026
Speaker: Kent Waldrop
Title: Things Go Wrong
Abstract:
During this session Kent Waldrop will discuss some of his personal experiences with the ups and downs of an IT career. Some of the subjects covered will be watching out for never, never land; flying high; crashing; “coming back”; dealing with personal problem and trying to guard your self.
SessionID: 35076
Transact SQL Frequently Asked Questions
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1009 (Auditorium)
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: 35084
LINQ for SQL
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1002
Speaker: David Fekke
Title: LINQ for SQL
Abstract:
This presentation gives developers and SQL Server professionals an overview of the Language Inline Query (LINQ) syntax in .NET 3.5 that can be used to query SQL Server databases.
SessionID: 35118
SSIS - Beginner's Walkthrough
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1016 (Auditorium)
Speaker: Eric Wisdahl
Title: SSIS - Beginner's Walkthrough
Abstract:
This session will step the attendees through the basics of SSIS by setting up a sample solution to import data from a variety of sources. We will look at some of the more common control flow tasks as well as the various components of the data flow task. The sample solution created will be based, at least in part, on questions from the audience.
SessionID: 35119
SSIS - A Beginning Framework
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1002
Speaker: Eric Wisdahl
Title: SSIS - A Beginning Framework
Abstract:
Most developers would agree that every SSIS solution will have the same fundamental outline. A basic framework will expedite the process by handling the common tasks between the systems while allowing the developer to concentrate on the task at hand. This framework will consist of many items, including but not limited to setting up package configurations, logging, audit trails, error handling, naming standards, etc.
This session will present an example framework which can be used as the basis for future SSIS Package development.
SessionID: 35151
SQL ServerBeyond S Roadmap 2008
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1009 (Auditorium)
Speaker: Jean-Claude Armand
Title: SQL ServerBeyond S Roadmap 2008
Abstract:
This session will cover SQL Server 2008 adoption momentum in addition to the scheduled 2 SQL Server release that are currently schedule to be release during the next 36 months. As part of this session we will discuss in details of the upcoming release of SQL Server Kilimanjaro release and schedule around SQL11.
SessionID: 35155
SQL Server 2008 Fast Track Data Warehouse
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1009 (Auditorium)
Speaker: Jean-Claude Armand
Title: SQL Server 2008 Fast Track Data Warehouse
Abstract:
This session will provide an overview and guide to SQL Server Fast Track Data Warehouse, a new set of reference architectures created for scale-up (SMP) SQL Server based data warehouse solutions. It includes a summary of the resources available in the reference configuration, the distinguishing features of the approach, and the steps necessary to take full advantage of the new architectures.
SessionID: 35180
Using Sql To Generate Sql
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1001
Speaker: Jonathon Moorman
Title: Using Sql To Generate Sql
Abstract:
An overview of the system objects that can be utilized to create new database objects. We will investigate the catalog views and object functions with an eye towards creating utility scripts and templates to make the day-to-day work of a database developer easier.
SessionID: 35254
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1001
Speaker: Kendal Van Dyke
Abstract:
SessionID: 35255
XML Features in SQL 2005
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1009 (Auditorium)
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: 35256
Transactional Replication Deep Dive
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1026
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: 35258
IIS, ASP\ASP.NET, SQL Security HowTo
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1026
Speaker: Kendal Van Dyke
Title: IIS, ASP\ASP.NET, SQL Security HowTo
Abstract:
SessionID: 35304
Introduction to SQL Server Reporting Services
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1026
Speaker: Brian McDonald
Title: Introduction to SQL Server Reporting Services
Abstract:
Never created a report in Reporting Services 2005? Don't fret! In this session you will learn the basics on creating reports using SQL Server Reporting Services 2005. Topics will include the architecture of reporting services, creating a report using the wizard, creating reports from scratch, as well as deploying them to the server for general usage.
SessionID: 35307
Upgrading DTS to SSIS
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1003
Speaker: Mike Davis
Title: Upgrading DTS to SSIS
Abstract:
See the methods available to convert DTS to SSIS. Get an understanding how to convert Active X scripts in your DTS packages to SSIS packages. Watch a demonstration of the software available to discover your packages, convert them, and apply best practices. Learn how to scope out your DTS conversion project.
SessionID: 35308
Making your SSIS Packages Dynamic
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1003
Speaker: Mike Davis
Title: Making your SSIS Packages Dynamic
Abstract:
Learn how to use SSIS features such as Configuration Files, Configuration Tables, Parent to Child Configurations, Expressions, and Variables to make your SSIS packages Dynamic. Stop the deployment headache by creating packages that can be updated remotely and do not need to be redeployed when a change is needed. Learn how to update multiple packages with a single change.
SessionID: 35309
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1003
Speaker: Michael Flora
Abstract:
SessionID: 35320
Save Time and Merge It
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1009 (Auditorium)
Speaker: Michael Antonovich
Title: Save Time and Merge It
Abstract:
SessionID: 35321
Identifying and Removing Duplicate Records
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1001
Speaker: Michael Antonovich
Title: Identifying and Removing Duplicate Records
Abstract:
Perhaps you inherited a database with one or more tables having duplicate potential keys or maybe even entire duplicate records or maybe you generated a recordset from a SELECT statement that has duplicate records. In any case, you have a problem. You need to identify which tables have duplicate records or duplicate index values, isolate those records, and then delete only the duplicate records from the table. This session will focus on the functions and methods that you can use to identify and remove duplicate data from your tables
SessionID: 35354
Advanced SQL Querying Techniques
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1016 (Auditorium)
Speaker: Plamen Ratchev
Title: Advanced SQL Querying Techniques
Abstract:
This session will focus on analytical ranking functions in SQL Server 2005/2008 and their use, implementing paging, string concatenation with XML PATH, pivoting, unpivoting, and separating elements in a string/column.
SessionID: 35355
T-SQL Enhancements in SQL Server 2008
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1016 (Auditorium)
Speaker: Plamen Ratchev
Title: T-SQL Enhancements in SQL Server 2008
Abstract:
SessionID: 35356
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1016 (Auditorium)
Speaker: Plamen Ratchev
Abstract:
SessionID: 35376
On Demand Report Subscriptions
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1026
Speaker: Pam Shaw
Title: On Demand Report Subscriptions
Abstract:
This session will explore subscriptions which are the scheduled delivery process defined within Reporting Services. We will explore what is required to create subscriptions, what options are available and how we can manipulate these for use on demand. We will review some practical applications that would require use of on demand subscriptions.
SessionID: 35377
Tips Tricks for dynamic Reporting Services Repor
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1016 (Auditorium)
Speaker: Pam Shaw
Title: Tips Tricks for dynamic Reporting Services Repor
Abstract:
SessionID: 35406
The DBA Script Thumb
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1003
Speaker: Rodney Landrum
Title: The DBA Script Thumb
Abstract:
SessionID: 35422
Introduction to query optimization
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1001
Speaker: Scott Gleason
Title: Introduction to query optimization
Abstract:
SessionID: 35448
Troubleshooting SQL Server
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1009 (Auditorium)
Speaker: Steve Schneider
Title: Troubleshooting SQL Server
Abstract:
SessionID: 35501
What is new for Data Mining in SQL 2008
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1002
Speaker: Vikas Hawaldar
Title: What is new for Data Mining in SQL 2008
Abstract:
The presenter will describe basic building blocks of Data Mining process. These building blocks will be mapped on to the features available in SQL 2005 and then shortcoming on SQL 2005 will be discussion. After that the new features in SQL 2008 Data Mining will be demoed to present how the Shortcoming in 2005 were improved in 2008 and what new power in added in 2008 data mining.
SessionID: 35502
Advanced SSAS development using MDX
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1002
Speaker: Vikas Hawaldar
Title: Advanced SSAS development using MDX
Abstract:
SessionID: 35504
Building a Data Warehouse using SQL Server 2008
Event Date: 02-05-2009 - Session time: 00:00:00 - Track: Room 1002
Speaker: Wes Dumey
Title: Building a Data Warehouse using SQL Server 2008
Abstract: