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 |
Understanding and Troubleshooting Blocking in SQL2000 |
| Jasper Smith, SQL Server MVP. |
| This talk will cover the common causes of blocking
in SQL2000, tools and techniques for identifying blocking issues and ways to
overcome these along with an overview of SQL Servers locking behaviour which
will lay the foundation for the rest of the talk. Common scenarios will be
explained and suggested solutions and workarounds presented. |
19:15 -
19:30 | |
| Break |
| |
19:30 -
20:00 |
New version of SQL Lite Speed. |
| Peter Stevens, SQLTools.co.uk |
| A look at Version 3 of SQL Lite speed, a truly
fantastic utility for SQL Server that significantly reduces the size and
time of backups. |
20:00 -
20:15 |
RAID Levels and Hardware update. |
|
Tony Rogerson, SQL Server MVP |
|
Tony will explain the common RAID levels, striping and what an online spare
is. He will update you on available hardware, SCSI and ATA; also will bring
you up to speed on the latest backup media. |
20:15 -
20:45 |
Fragmentation Everywhere! Stop it now!!! |
|
Tony Rogerson, SQL Server MVP |
|
Fragmentation can lead to not only poor performance but increased locking
giving rise to the possibilty of increased deadlocking. This presentation
talks through fragmentation from two perspectives - on the logical partition
in NTFS and inside the database itself. I think you will be suprised at some
of the ways fragmentation can occur. You will also be given recommendations
and scripts to keep fragmentation in your database system to a minimum. |