Tuesday, December 11, 2018
Task Pane 
Remember Me
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?

[show results]
Category Information
Meeting Collateral - Canberra
PPTs etc from Canberra Presentations
Jump to:

4/20/2006 11:10:14 AM Author: whartonj
Canberra Aprill 2006 - The marriage of XML and relational data in SQL Server 2005 - Steve Lloyd
Hi Everyone,

Here are the slides from Steve's excellent session on SQL Server 2005 and XML. If you have any questions or want further clarification on areas covered in the presentation, feel free to contact me.

See you at next months meeting.

5/16/2006 7:31:50 PM Author: whartonj
Canberra May 2006 - Using XML To Pass Parameters and Send Multiple Rows At Once Into A Stored Procedure - Jeff Wharton
Hi Everyone,

Firstly, let me apologies for the delay in posting this info. Unfortunately in my rush to make my flight that night, I dropped my laptop going through security and only just got it back from the repair shop (cracked screen).

Note to self: Backup regularly!

Perhaps this was an omen as Geoff Orr will be doing a presentation at next months meeting on Backup in SQL Server 2005. I will post further details within the next couple of days.

As usual, if you have any questions about last months presentation, please feel free to email me.

6/14/2006 9:21:06 AM Author: whartonj
Canberra June 2006 - Backups by Geoff Orr
As we're all aware, implementing a Disaster Recovery plan is probably one of the most important roles of a DBA. Geoff's presentation provided an in-depth look into what can be done to assist DBA's (and developers) with implementing such a plan by using a DB structure that facilitates quick and easy DB Backup and Recovery.

Geoff demonstrated how using features such as partitioned tables, multiple database files and multiple filegroups can cut down the time required to backup your mission critical data and enable you to quickly bring a database back online after a disaster.
8/10/2006 11:56:24 AM Author: whartonj
Canberra August 2006 - SQL Management Object (SMO) - Peter Ward (WARDY IT Solutions)
Hi Everyone,

Here are the slides and code for the SMO presentation.

If you have any questions or want further clarification on areas covered in the presentation, feel free to contact Peter Ward on peter@wardyit.com.

See you at next months meeting.

11/15/2006 4:32:16 PM Author: whartonj
Canberra November 2006 - Design and Implementation Best Practices for Large Scale DW Systems in SQL Server 2005
Last night Nicholas Dritsas (Program Manager, SQL Server Customer Advisory Team) delivered what can only be described as a rip-snorter of a presentation at our User Group. As one member put it, "Nicolas's presentation yesterday afternoon was perhaps the best I have ever seen - either at SQL Server User Group, seminars, Tech-Ed etc." (Jeremy Selby, Data Management Section, Department of Education, Science and Training).

I would like to thank Nicholas for his informative and professional presentation; and for providing us with a copy of his deck.
3/27/2007 7:33:31 PM Author: whartonj
DBCC Commands in SQL Server 2005 / Microsoft Learning Offerings for SQL Server 2005 - Victor Isakov
Slides from Victor's presentation
3/27/2007 7:34:08 PM Author: whartonj
Designing and Managing Indexes for Performance (Greg Linwood - SQL Servants)
Slides from Greg's presentation
5/10/2007 8:52:49 AM Author: whartonj
Canberra May 2007 - Engineering 101 for the SQL DBA - Peter Ward (Wardy IT Solutions)
Here is the deck from Peter's presentation.

A MP3 and Windows Media video of the same session presented at SQL Server Open World 2007 can be downloaded from http://wardyit.com/resources.aspx

Key points to remember from this presentation:

* There is no one ‘right’ way to configure storage for optimal performance
* Understand the I/O characteristics
* More/Faster spindles
* Do not ‘over’ optimise
* Validate configurations prior to deployment
* Place log files on RAID 1+0
* Isolate log from data
* Consider configuration of TEMPDB
* Line the data files with CPU’s
* Don’t overlook SQL Server basics
* Don’t overlook storage configuration basics
7/5/2007 11:13:02 AM Author: whartonj
An Introduction to Dynamic Management Views in SQL Server 2005 - Dr Greg Low
Greg's presentation provided a great introduction to SQL Server Dynamic Management Views and how they can be used to simplify the management of SQL Server and assist with tracking down a range of problems associated with hosting SQL Server solutions.

A copy of his presentation can be downloaded from http://www.sqldownunder.com/GregLowTechEdDMVSessionMaterials.zip

Thanks Greg
7/11/2007 9:31:21 PM Author: whartonj
July 2007 - Secrets of Fast Detection and Recovery from Database Corruptions - Paul Randal (Microsoft)
Tonight Paul conducted an excellent session on the Secrets of Fast Detection and Recovery from Database Corruptions. Many thanks for staying up so late to conduct this session for us Paul. Much appreciated.

Here is a a copy of his deck and a video of the Tech.Ed Orlando 2007 version of the presentation can be viewed at http://www.microsoft.com/emea/itsshowtime/sessionh.aspx?videoid=549