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 |
Finding and Resolving Performance Problems |
| Tony Rogerson, SQL Server MVP. |
| Using skills homed in the field, Tony will show how you can use SQL Profiler to identify areas that cause performance problems, be it IO or blocking. We will then look at Query Analyser and functionality available to help diagnose performance faulty SQL. |
19:15 -
19:30 |
|
| Break |
| |
19:30 -
20:00 |
SQL Lite Speed |
| IMCEDA |
|
Litespeed for SQL server
- Litespeed Overview
- Compression of data
- Encryption of data
- Live product demo
- Q and A
|
20:00 -
20:45 |
A Look at Partitioned Views |
| Eric Allsop |
| As tables grow they become increasingly difficult to work with. As queries take longer to run the indexing strategy becomes more complex. However, the management of these indexes also becomes increasingly difficult as the table grows. Partitioned views offer a simple but very effective way of overcoming these problems. |