17:30 -
18:00 |
Network - Coffee |
| A chance to meet other SQL Server professionals on
a social level, what better way of networking and finding out what other
people are doing in the SQL Server space. |
| |
18:00 -
18:30 |
Problem Clinic and Security Update |
| Question and Answer discussion between all
attendees.. |
| Feel free to bring your questions or post them on
the user group board prior to the event. |
18:30 -
19:15 |
Error handling in SQL Server |
| Jacco Schalkwijk, SQL Server MVP. |
| Errors in SQL Server 2000 are sometimes not well
defined and exception handling is primitive compared with some other
languages. This talk demonstrates the sometimes unexpected behaviour of
errors in SQL Server and suggests best practices to properly handle them. |
19:15 -
19:30 | |
| Break |
| |
19:30 -
20:00 |
Performance Testing the Database |
| Paul Down, Embarcadero |
| Paul Down of Embarcadero Technologies will discuss Database Performance
Testing. He will introduce Embarcadero's latest offering, a performance
testing tool called Embarcadero Extreme Test. He will demonstrate how users
can automate database load generation as well as simulate reads / writes and
user connections to a SQL Server Database.
|
20:00 -
20:45 |
Exploring SQL Data Structures with DBCC PAGE |
|
Eric Allsop |
|
Understanding the underlying data structures that SQL Server uses can help
developers better design structures and improve IO performance. In this
session we will examine the basic data pages, indexes, the IAMs, GAMs and
SGAMs. We will use DBCC PAGE to examine what is actually stored on these
structures. |