Nr: 1
SQLSaturday #1 - Orlando 2007
SessionID: 30671
Index Selection for SQL Server 2005
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 202
Speaker: Jeffrey Garbus
Title: Index Selection for SQL Server 2005
Abstract:
This session will cover index types, physical storage structures, and how the server uses and chooses indexes. This is a portion of a class that has been presented directly to Microsoft at their Redmond Campus (Note: 80 min session preferred)
SessionID: 34937
Transactional Replication for Beginners
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 307
Speaker: Andy Warren
Title: Transactional Replication for Beginners
Abstract:
SessionID: 34947
How to Become a DBA
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 138
Speaker: Michael Antonovich
Title: How to Become a DBA
Abstract:
Like many jobs in IT it seems that everyone only wants to hire senior people with a kazillion years of experience. So how you do find openings for the 'Junior DBA' positions that are out there and what skills should you have to start with? How do you build those skills without having the job first? And what is life as a DBA really like? We'll try to answer all of those questions and more at this session.
SessionID: 34948
Using CASE in TSQL
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 307
Speaker: Michael Antonovich
Title: Using CASE in TSQL
Abstract:
Most languages support an extended version of the IF/THEN syntax and in TSQL it's CASE. It's syntax is a little finicky and to add to the confusion there are two different ways to use it! We'll look at how to use it both ways and show how it contrasts with the IF/THEN syntax. This is a beginner level session.
SessionID: 34976
Amazon for Everyone, Data Mining SQL 2005
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 220
Speaker: Barry Ralston
Title: Amazon for Everyone, Data Mining SQL 2005
Abstract:
SessionID: 34981
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 307
Speaker: Brian Knight
Abstract:
SessionID: 34982
SQL Server 2008 New Feature Overview
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 138
Speaker: Brian Knight
Title: SQL Server 2008 New Feature Overview
Abstract:
Learn what's new in SQL Server 2008 for the DBA, Developer and BI professional. This session is demo-packed with the best features of why you should upgrade to SQL Server 2008.
SessionID: 34983
Hacking SQL Server
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 202
Speaker: Brian Knight
Title: Hacking SQL Server
Abstract:
In this presentation Bayer White plays the part of a developer protecting his application and Brian Knight attempts to hack his application using SQL Injection and cross-site scripting. Then, Bayer will show you how to protect yourself from the hacker and then Brian tries again. Back and forth the chess match goes until someone wins!
SessionID: 35028
SQL Server 2005: Sql Management Objects (SMO)
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 303
Speaker: Brandon Kelly
Title: SQL Server 2005: Sql Management Objects (SMO)
Abstract:
SessionID: 35052
Persisting and Tracking Workflows using Sql Server
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 228
Speaker: Bayer White
Title: Persisting and Tracking Workflows using Sql Server
Abstract:
SessionID: 35067
Using DDL Triggers
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 303
Speaker: Chris Rock
Title: Using DDL Triggers
Abstract:
In this session we'll create a database object (table, proc, functions) backup system using DDL Triggers in SQL Server 2005. This system is beneficial to both DBA's and developers.
SessionID: 35085
Using Microsoft Dynamics GP Stored Procedures
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 220
Speaker: David Eichner
Title: Using Microsoft Dynamics GP Stored Procedures
Abstract:
How to utilize the Microsoft Dynamics GP SQL Stored Procedures for interacting with backend ERP database through fully validated sql stored procedures. Allows for high speed integrations or real-time integrations between Microsoft Dynamics GP and other database applications.
SessionID: 35099
How to Use a Staffing Firm Effectively
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 138
Speaker: Declan Link
Title: How to Use a Staffing Firm Effectively
Abstract:
This is a vendor session presented by Stratus Technologies and will discuss the value that staffing firms can provide to both employees and employers. Picking the right staffing firm can make a difference on how long it takes to find a job, how good that job is, and how well it pays. Bring your lunch and learn how this part of our industry works!
SessionID: 35105
Comparing SQL Server 2005 to Oracle 10g
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 202
Speaker: Donnie Reynolds
Title: Comparing SQL Server 2005 to Oracle 10g
Abstract:
This session will compare architectural differences and similarities between these two RDBMSs.
This technical session is an excellent migration tool for Oracle DBA's now working in Microsoft shops. It is also a valuable education for anyone wanting to understand how these two architectures really work.
SessionID: 35143
Establishing Infrastructure Standards for SSIS
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 228
Speaker: Joseph Memmo
Title: Establishing Infrastructure Standards for SSIS
Abstract:
This session will provide you a framework of Best Practices in establishing standards for SQL Server Integration Services for an enterprise environment from a IT infrastructure prospective. Items discussed will include establishing deployment standards, Package Store options, portability, naming conventions, execution options, and securities concerns.
SessionID: 35148
SQL Server 2008 Data Warehousing Enhancements - 1
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 138
Speaker: Jean-Claude Armand
Title: SQL Server 2008 Data Warehousing Enhancements - 1
Abstract:
SessionID: 35149
SQL Server 2008 Data Warehousing Enhancements - 2
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 138
Speaker: Jean-Claude Armand
Title: SQL Server 2008 Data Warehousing Enhancements - 2
Abstract:
SessionID: 35159
Relational Division -- The Forgotten Operator
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 138
Speaker: Joe Celko
Title: Relational Division -- The Forgotten Operator
Abstract:
1. Dr. Codd's Basic Eight Relational Operators
- Why it really should not have been in the Basic Eight
- Date's Version of Codd's Relational Division
- Celko's Version of Codd's Relational Division
- Relational Division with Remainder
- Relational Division without Remainder
- Todd's Relational Division
- Romley's Relational Division
- Related things you can do
SessionID: 35160
SQL Programming Style
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 202
Speaker: Joe Celko
Title: SQL Programming Style
Abstract:
SessionID: 35167
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 202
Speaker: Jeffrey Garbus
Abstract:
SessionID: 35191
MDX: From WITH To WHERE
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 228
Speaker: Jessica Moss
Title: MDX: From WITH To WHERE
Abstract:
This session will discuss the basic syntax of mdx queries, query-scoped calculated measures, and common functions that can be used in MDX queries. This session is best suited for people who are familiar with Analysis Services cubes and multidimensional concepts. They are interested in learning how to write custom MDX queries to obtain data from their OLAP cubes.
SessionID: 35195
ADO.NET Synchronization Services in .NET 3.5
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 220
Speaker: Joe Healy
Title: ADO.NET Synchronization Services in .NET 3.5
Abstract:
SessionID: 35198
Intro to VSTS DB
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 220
Speaker: Jim Blizzard
Title: Intro to VSTS DB
Abstract:
In this session we’ll take a lap around Visual Studio Team System for DB Pros to see how it can help you sleep better at night. 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? Come see how VSTS DB can solve your problems!
SessionID: 35235
Working with an XML Data Structure in SQL 2005 and
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 228
Speaker: Jose Fuentes
Title: Working with an XML Data Structure in SQL 2005 and
Abstract:
Here we will go though the process of designing and using a new model that is becoming increasingly popular. People are increasingly tearing down their data structure for a more robust option. We have all seen the needs of our end users. They want another field to capture data, what did this involve? This involved getting the new column inserted into the database as well as views and stored procedures and such. Now granted we are going to go though two possible ways of doing the code (non-stron
SessionID: 35237
SOA Using SQL Server 2005 Service Broker
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 303
Speaker: Judy Pipia
Title: SOA Using SQL Server 2005 Service Broker
Abstract:
This session will introduce the Service Broker in SQL Server 2005. During this session we will discuss an overview of Service Broker architecture and delve into the objects needed to create a Service Broker solution. Finally, we will build a sample solution from start to finish using the Adventureworks database.
SessionID: 35245
CLR User Defined Functions - Real World Examples
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 202
Speaker: Jon Winer
Title: CLR User Defined Functions - Real World Examples
Abstract:
This exciting session will talk about why CLR UDF's are a good choice in many cases, why using UDF's will simplify your code, and then go into setting up environments for testing and debugging. We'll also be discussing a few hard learned tips and tricks that will help you when you start using UDF's.
SessionID: 35270
XML Features in SQL 2005
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 307
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: 35314
SQL Server 2005 Compact Edition in Action
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 220
Speaker: Michael Wells
Title: SQL Server 2005 Compact Edition in Action
Abstract:
Looking for reliable local store that you can easily deploy embedded within your application? Wanting to know what programming options are available today, and what’s coming? In this session you’ll see the different data access models including ResultSet and TableDirect. I’ll also discuss and demo the different deployment options available for SQL Server Compact Edition.
SessionID: 35340
How XML Changes Database Design
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 303
Speaker: patrick thompson
Title: How XML Changes Database Design
Abstract:
What should database design look like given the deep integration of SQL and XML in SQL Server 2005? This session will look at topics such as normalization, dependency analysis, SQL and XML schema integration and the implications for application, service and message design. The speaker worked on both Hailstorm and WinFS and will describe some of the problems that have influenced the current state of the art.
SessionID: 35368
Tips and Tricks for Reporting Services
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 307
Speaker: Pam Shaw
Title: Tips and Tricks for Reporting Services
Abstract:
SessionID: 35428
XML in SQL Server 2005
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 228
Speaker: Scott Farriss
Title: XML in SQL Server 2005
Abstract:
This session will provide basic to more advanced techniques when dealing with XML in SQL Server. We will walk through the XML data type, binding schemas, processing, and returning XML. The session will also focus on how .NET developers will work with their SQL developer counterparts to create more seamless applications.
SessionID: 35429
.NET CLR Basics
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 220
Speaker: Shawn Weisfeld
Title: .NET CLR Basics
Abstract:
In this session we will introduce the .NET CLR inside of SQL Server 2005. We will discuss why you might want to use the CLR verses traditional SQL and the pros and cons of it. Finally we will demonstrate the creation of a CLR Stored Procedure.
SessionID: 35484
Integrating Data Mining with SSIS
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 303
Speaker: Trey Johnson
Title: Integrating Data Mining with SSIS
Abstract:
SessionID: 35485
SSIS Patterns and Practices
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 303
Speaker: Trey Johnson
Title: SSIS Patterns and Practices
Abstract:
Integration Services fulfills the core needs of ETL within the Enterprise. It’s not you're old DTS; but you can learn the techniques that will make it successful for you today. Curious now and want to know just how the technology is being applied to this paradigm as well as alternatives? Join us for this in-depth session of exploring querying of federated data sources; learning integration of Data Mining in the pipeline; and coming to know the blend of out-of-the-box and custom extensions to mak
SessionID: 35497
Linq
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 202
Speaker: Kenneth Tucker
Title: Linq
Abstract:
LINQ defines standard query operators that allow code written in LINQ-enabled languages to filter, enumerate, and create projections of several types of collections using the same syntax. In this talk I will cover the basics of Linq to SQL
SessionID: 35506
Introduction to SQL Server Integration Services
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 307
Speaker: Wes Dumey
Title: Introduction to SQL Server Integration Services
Abstract:
This session will cover an introduction to SSIS. Attendees will learn about SSIS and see sample data flows that can be created in SSIS, reading from a variety of sources and writing to different database and file outputs.
SessionID: 35507
Designing Data Warehouse Practices with SQL Server
Event Date: 10-11-2007 - Session time: 00:00:00 - Track: Room 228
Speaker: Wes Dumey
Title: Designing Data Warehouse Practices with SQL Server
Abstract: