|
Thursday, February 13, 2003
Database of the Future: A Preview of
Yukon and Other Technical Advancements
Designing for Performance: General
Database Optimizations
Securing Your SQL Server: Security
from Every Level
Lunch Hour Presentation: Top Tips for Developers
Using SQL Server 2000
Designing Efficient User-Defined
Functions in SQL Server 2000
Data Transformation Services:
Achieving Re-usability
The Need for Speed
Optimum Error Handling and Auditing
within DTS
Max Rows/Sec: How to Optimize Data Loading
Performance
Merge Replication: Strategizing,
Parts I and ll
Pedal to the Metal: Maximize your
SQL Server’s Performance
SQL Live! Sessions
Thursday, February 13, 2003
Database of the
Future: A Preview of Yukon and Other Technical Advancements
David Campbell, Product Unit Manager, SQL Server Engine,
Microsoft
The next major release of SQL Server, code named
Yukon, promises airtight security and fast, scalable data
access at your finger tips. David Campbell has been working
on the development of Microsoft SQL Server for over 7 years
and he wants to share his vision of the future of data access
with you. You will hear about technical advancements in the
areas of programmability, manageability, scalability, availability,
and business intelligence. Come see what's looming in the
horizon in the fast-changing landscape of data access development.
9 a.m.
Designing
for Performance: General Database Optimizations
Kimberly L. Tripp, SYSolutions
Regardless of client application choice, the ideal database
environment should include numerous backend server operations
in order to achieve optimal performance. Attend this session
and find out what backend server areas can improve performance
the most! We will look at database design techniques including
vertical and/or horizontal partitioning, adding redundant
foreign keys and using constraints to improve performance
as well as data integrity.
10:30 a.m.
Securing
Your SQL Server: Security from Every Level
Girish Chander, Microsoft
NTFS File Security, File Encryption, IPSec, SSL, Multiprotocol
Encryption, Object Permissions, Object Permission Inheritance
for Stored Procedures/Functions/Views, Object Obfuscation,
Server Roles, Database Roles... So many places for different
levels of security and so many options from which to choose!
In this session we will cover the broad range of places where
security features can be utilized and what they best protect
against.
11:45 a.m.
Lunch
Hour Presentation: BI for Everyone: Leveraging the benefits
of BI across the Enterprise
Kamal Hathi, Group Manager, SQL Server data warehousing
team
Microsoft has made Business Intelligence and Data Warehouse
much more easily approachable technologies by providing a
set of comprehensive tools in the box with SQL Server along
with the core relational database. In conjunction with Microsoft
Office, these provide the basis for making BI both affordable
as well as easier to implement at all levels of the Enterprise
and in all sizes of companies. We will cover how current technologies
can be leveraged
12:45 p.m.
Designing
Efficient User-Defined Functions in SQL Server 2000
Fernando G. Guerrero, QA plc, UK
The possibility of creating user-defined functions in SQL
Server 2000 represents exciting possibilities to any SQL Server
developer. Most systems don’t exploit this interesting
feature to its maximum, and this session will provide innovative
examples on how to use them to solve specific programming
problems. We will look at how to work around some limitations
of UDFs, and how to convert views and stored procedures into
UDFs. We will also look at how to use UDFs in non-standard
situations, such as Joining table-valued UDFs to other inline
or table-valued UDFs and other tables, or updating, deleting
and inserting data through UDFs. Debugging UDFs is not as
obvious as you might think, and we will look at how to detect
their usage in SQL Profiler.
2 p.m. Performance &
Development
Data
Transformation Services: Achieving Re-usability
Trey Johnson, Encore Development
Join us for an advanced discussion on techniques that leverage
the re-use of DTS package logic across multiple packages,
providing for a sustained investment and efficiency with DTS.
This session will begin with the hurdles for re-usability
in the DTS environment, then move into removing the barriers
to re-use through the review of real world solutions, creating
global functions, common code, and encapsulated packages.
We’ll discuss the creation of a common library for producing
a suite of re-usable functions, and how to appropriately implement
the object-based solution in a DTS environment. We’ll
also look at techniques that allow for the DTS developer to
construct a re-usable package for delivering common functionality.
We’ll conclude with the exploration of dynamically loading
common functions from source code files using DTS and the
Windows scripting Host to build global re-used functions.
2 p.m. Business
Intelligence & Replication
The Need for
Speed
Robert Patton, PurchasingFirst
No query can run fast enough. In this session developers you’ll
learn tips and tricks to make your everyday jobs and everyday
code run more effectively. Often developers place all of their
focus in the execution plan to tune specific queries. Instead
of relying on tuning specific queries, write better queries!
Come and learn when and how you should limit rows, use output
parameters, how to build a better WHERE clause and how to
avoid many of the more common pitfalls such as: optimizer
hints, string concatenation, and cursors. From this session
you are more likely to achieve better execution plans and
more.
3:15 p.m. Performance
& Development
Optimum
Error Handling and Auditing within DTS
Trey Johnson, Encore Development
DTS is a powerful and flexible tool for delivering data through
the Microsoft Data Warehousing Framework. As compound processes
are developed, a higher dependence on optimal error handling
and general auditing is required. Learn through this session
how to blend customized error handling and auditing with the
standard (and not always documented) features within DTS.
This session will provide the attendee with a clear picture
of the right and wrong ways to build these mission critical
elements into their DTS package framework.
3:15 p.m. Business
Intelligence & Replication
Max Rows/Sec:
How to Optimize Data Loading Performance
Gert E. R. Drapers, SQLDev.Net
You have 100 million rows of data to INSERT or UPDATE in your
database each night, do you know how? What is the best data
loading strategy, how do you do index maintenance, how do
you perform UPSERTS, how much space do you need to merge two
databases? These are all real world questions and issues you
will face when dealing with high volumes of data. This session
will provide you with a practical set of guidelines for space
calculation (for tables and indexes), index maintenance (load
in to vs. drop-recreate), BLOB loading, optimal data loading
techniques and how to merge large amount of changes in to
existing tables!
4:30 p.m. Performance
& Development
Merge
Replication: Strategizing, Parts I and ll
Mike Hotek, Independent Consultant
SQL Server 2000 offers many features for high availability
and fault tolerance. Replication not only allows you to achieve
a level of fault tolerance and high availability, it can also
be used to scale an environment and distribute data so that
it is closer to end users or can be taken with them in mobile
applications. In this two part talk, we are going to cover
the basics of merge replication, moving towards the advanced
features it offers to your environment. We will cover deployment
issues, architecting hierarchies, disaster recovery capabilities,
and also delve directly into the merge metadata.
4:30 p.m. & 5:45 p.m. Business
Intelligence & Replication
Pedal
to the Metal: Maximize your SQL Server’s Performance
Gert E. R. Drapers, SQLDev.Net
Do you understand what Performance Monitor is trying to tell
you? Go beyond the query-based culprits of poor performance;
learn to apply queuing and wait theory to determine the bottlenecks
within your SQL Server environment. This session will detail
how to combine the theory of queues and waits with the information
supplied by performance counters, virtual tables, DBCC commands
and SQL Trace to identify hotspots in your environment.
5:45 p.m. Performance
& Development
|
