Nr: 3
SQLSaturday #3 - Jacksonville 2008
SessionID: 34938
Beginning Transactional Replication
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1402
Speaker: Andy Warren
Title: Beginning Transactional Replication
Abstract:
Replication is a very useful technology that often gets ignored because it seems to be a big scary black box. Join us for a beginner level session that looks at how to set up and use transactional replication for common scenarios and how to do with the few common problems you may run into using it.
SessionID: 34939
Mentoring Professional Development Plans
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1400
Speaker: Andy Warren
Title: Mentoring Professional Development Plans
Abstract:
This will be a very interactive session as we discuss professional development plans including why you should write it down, what to do when your manager doesn't care, finding time and funding to implement your plan, and what to do when your plan doesn't quite work out. We'll also discuss finding a mentor and the value that a mentor can add to your career.
SessionID: 34978
Backup and Recovery Basics
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1402
Speaker: Brian Knight
Title: Backup and Recovery Basics
Abstract:
An overview of how to plan for, implement, and monitor a sound backup and recovery strategy for your databases using SQL Server 2005. Using a simple, one server environment as an example, this session will look at the kinds of questions you should ask when creating backup and recovery plans, and how to know whether your backup and recovery plans are actually meeting the needs of your business.
SessionID: 34980
Finding a Job - Do's Dont's
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406
Speaker: Brian Knight
Title: Finding a Job - Do's Dont's
Abstract:
Presented by Comsys
SessionID: 35030
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 110
Speaker: Bryan Oliver
Abstract:
SessionID: 35032
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1400
Speaker: Bryan Oliver
Abstract:
SessionID: 35046
Introduction to SQL Reporting Services
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 110
Speaker: Brandie Tarvin
Title: Introduction to SQL Reporting Services
Abstract:
An overview of how to create basic reports using SQL Server Reporting Services 2005. This session will touch on how to create data sources, data sets, set report properties and use the most common features required for the basic report. The Adventure Works sample database will be used in the demonstration.
SessionID: 35057
ASP.NET Dynamic Data Web Application
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406
Speaker: Chris Rock
Title: ASP.NET Dynamic Data Web Application
Abstract:
This session will go over the new Dynamic Data Web Application available with the ASP.NET 3.5 Extensions.
Using Visual Studio 2008 we will build our model using LINQ TO SQL. Then we will see how easy it is to create a website based on our model that easily allows you to edit the data in your tables.
We're also going to look under the hood at what type of TSQL is generated from our LINQ TO SQL class.
SessionID: 35086
LINQ For SQL Server
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 110
Speaker: David Fekke
Title: LINQ For SQL Server
Abstract:
This session will be an introduction into how to use the .NET 3.5 Linq framework to query and modify data in SQL Server.
SessionID: 35087
Introduction to the Business Data Catalog
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1404
Speaker: David Fekke
Title: Introduction to the Business Data Catalog
Abstract:
This session is an introduction to the Office Sharepoint Server Business Data Catalog (BDC). The session will show to expose enterprise data from SQL Server into your MOSS environment. Learn about how to create the application definition xml that Sharepoint uses to view data from SQL Server and web services.
SessionID: 35097
Report Viewer Control for Web and Windows
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1404
Speaker: Darren Herbold
Title: Report Viewer Control for Web and Windows
Abstract:
SessionID: 35098
SQL Server 2008 Business Intelligence
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 1202
Speaker: Darren Herbold
Title: SQL Server 2008 Business Intelligence
Abstract:
SQL Server 2008 has taken a leap forward in BI. In this session you'll learn about the key new features in SQL Server 2008 for the business intelligence person.
SessionID: 35121
Comprehansive data protection for SQL Server
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1402
Speaker: Fadi Albatal
Title: Comprehansive data protection for SQL Server
Abstract:
We will explore how SQL Server SAN integration is designed to deliver comprehensive SQL Server database protection, rapid recovery and high availability. We will also discuss how SAN Smart Copies easily enable parallel processing for data mining, and testing and development environments.
SessionID: 35123
SQL 2008 Overview
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 1202
Speaker: Geoff Hiten
Title: SQL 2008 Overview
Abstract:
Find out what is really in the new SQL 2008 product. Learn what features are going to impact your job and your systems. Session is 50% Administrator content and 50% T-sQL Developer content.
SessionID: 35124
SQL 2008 Policy Based Management
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 1202
Speaker: Geoff Hiten
Title: SQL 2008 Policy Based Management
Abstract:
Learn how to scale your DBA efforts across your entire SQL Infrastructure and guarantee your systems work the way you want.
SessionID: 35171
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 110
Speaker: Jeffrey Garbus
Abstract:
Understand how the optimizer selects indexes, and how you can design accordingly.
SessionID: 35173
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1400
Speaker: Jeffrey Garbus
Abstract:
SessionID: 35196
ADO.NET Synchronization Services in .NET 3.5
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406
Speaker: Joe Healy
Title: ADO.NET Synchronization Services in .NET 3.5
Abstract:
SessionID: 35247
Protecting Your SQL Server from Treasure Seekers
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406
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 in both SQL Server 2000 and 2005 as well as some of the newer features and how to use them for SQL Server 2005.
SessionID: 35248
Trigger Happy Database Security
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1404
Speaker: Brian Kelley
Title: Trigger Happy Database Security
Abstract:
In this session we'll look at the use of triggers for security and auditing. DML, DLL, and logon triggers will all be covered. We'll look at both good and bad ways of implementing triggers as part of an overall security solution.
SessionID: 35268
XML Features in SQL 2005
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1400
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: 35272
FAQs from the MSDN Transact SQL Forum
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 110
Speaker: Kent Waldrop
Title: FAQs from the MSDN Transact SQL Forum
Abstract:
01 Count Occurrences
01 Repalce Function with no accounting for strings that end with spaces
02 Replace Function with sensitivity for strings that end with spaces
02 Looping
01 Filter based on State List
02 Filter based on State List with Numbers Table
03 Numbers Table
04 _Numbers Function
03 Last Day of the Month
01 Last Day of the Month
02 Nth Day m of the Month
03 Calendar Table Reference Information
04 String or Numeric Part
01 Split Left Hand
SessionID: 35281
First Day/Month a DBA
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1404
Speaker: Devin Knight
Title: First Day/Month a DBA
Abstract:
So you're starting your first DBA job because someone was willing to take a chance on you. You have thousands of questions and don't know who to ask. This session is for anyone looking for tips on how to get your first job, improve your skills and gain confidence as a DBA.
SessionID: 35282
Introduction to SSIS
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406
Speaker: Devin Knight
Title: Introduction to SSIS
Abstract:
In this session, Devin Knight shows you the basics of SQL Server Integration Services (SSIS) and how to use it in a real word example. He shows you how to create your first end to end SSIS package that loops through a series of files and loads them dynamically.
SessionID: 35333
Smokin' Mirrors - SQL 2005 Mirroring Technology
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1400
Speaker: Michael Mollenhour
Title: Smokin' Mirrors - SQL 2005 Mirroring Technology
Abstract:
SessionID: 35335
Reporting in Microsoft Dynamics GP
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1404
Speaker: Mark Polino
Title: Reporting in Microsoft Dynamics GP
Abstract:
SessionID: 35342
Modeling People and Organizations
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1402
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: 35363
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 110
Speaker: Plamen Ratchev
Abstract:
SessionID: 35364
SQL Server 2008 T-SQL Enhancements
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 1202
Speaker: Plamen Ratchev
Title: SQL Server 2008 T-SQL Enhancements
Abstract:
SessionID: 35369
Tips and tricks for dynamic Reports
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406
Speaker: Pam Shaw
Title: Tips and tricks for dynamic Reports
Abstract:
SessionID: 35370
Gain RANK in your queries with the ranking functio
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1400
Speaker: Pam Shaw
Title: Gain RANK in your queries with the ranking functio
Abstract:
In this session, we will explore the ranking functions that were part of the new feature set added with SQL 2005. These allow the addition of a ranking column to your result sets that can be used to manipulate data sets without the need of the dreaded cursors. We will explore Row_Number, Rank, Dense_Rank and NTile along with ways that they can greatly optimize queries. We will also see the use of CTE’s while demonstrating some of their uses.
SessionID: 35404
Building a DBA Repository with SSIS and SSRS
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1404
Speaker: Rodney Landrum
Title: Building a DBA Repository with SSIS and SSRS
Abstract:
Based on several popular articles in SQL Server Magazine, this session will cover the specifics of deploying a centralized DBA reporting solution using the combined powers of SSIS and SSRS. This session will focus on the current solution that uses SSIS variables and data flow objects to roll through potentially hundreds of SQL Server instances. Emphasis will be on the data it gathers and how that data can be formulated into queries, views, stored procedures and ultimately a series of useful SSRS
SessionID: 35426
Data Mining Concepts and Techniques
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1406
Speaker: Sherif Elfayoumy
Title: Data Mining Concepts and Techniques
Abstract:
SessionID: 35431
SQL Server CLR
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 1202
Speaker: Shawn Weisfeld
Title: SQL Server CLR
Abstract:
In this talk we will talk about all the things that the CLR can do in SQL Server (Stored Procedures, Triggers, Functions, etc.).
SessionID: 35480
Programming SMO for Fun and Profit!
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1402
Speaker: Tim Mitchell
Title: Programming SMO for Fun and Profit!
Abstract:
Managing numerous SQL Servers can be very difficult. Fortunately, Microsoft has provided a rich programmatic interface to allow DBAs to easily manage SQL Servers, databases, and objects. Using SMO objects, a code-savvy DBA can automate otherwise tedious manual tasks: you can create and monitor backups and agent jobs, stop and start services, administer users and logins, and much more, on all of your SQL installations with ease.
SessionID: 35481
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Classroom 1402
Speaker: Trey Johnson
Abstract:
SessionID: 35508
Building a Data Warehouse Using SQL Server 2005
Event Date: 03-05-2008 - Session time: 00:00:00 - Track: Auditorium 1202
Speaker: Wes Dumey
Title: Building a Data Warehouse Using SQL Server 2005
Abstract: