Perth SQL Server User Group

I will be presenting at the Perth SQL Server User Group on Thursday the 8thFebruary. In this session ‘Engineering 101 for the SQL DBA’ I will explain how to optimise the I/O subsystem to improve the performance of SQL Server. This is the session that I will be presenting at SQL Server Open World in Denmark. This session will also include the now famous RAID demo using 7 USB keys and a USB Hub.

For more details and to register for this session refer to http://www.sqlserver.org.au/Events/ViewEvent.aspx?EventId=235.

msdb.dbo.sp_define_log_shipping_monitor

When setting up Log Shipping on SQL Server 2000 you may receive the following error:

could not find msdb.dbo.sp_define_log_shipping_monitor

When you upgrade a SQL Server 2000 instance from SQL Server 2000 Standard Edition to SQL Server 2000 Enterprise edition the log shipping objects are not created, hence the error. In order to create the log shipping objects you need to run the log shipping installation script, instls.sql, which is located in the \Install folder of the SQL Server 2000 Enterprise edition CD.

February WARDY IT Community Dinner

The WARDY IT Community Dinner is held on the second Monday of the month and is a great opportunity to share knowledge, information and experiences with other IT professionals in South East Queensland. The February WARDY IT Community Dinner is being held on Monday the 12th of February. To RSVP to be at this event send an email to peter @ wardyit.com.

WHERE Sultans Kitchen Paddington | 163 Given Terrace | Paddington http://www.sultanskitchen.net.au/locations.html
WHEN Monday 12th February | 6:30PM
RSVP Friday 9th February
Please note that you are responsible for the cost of your own dining. 

Add this event to your Outlook Calendar

January QLD SQL Server User Group

This month we have Geoff Orr from FrontRow Data Solutions presenting on Implementing Partitioned Tables. Why not stay on after Geoff’s session for a chance to catch-up with other SQL Server professionals at the Pig ‘N’ Whistle on Eagle Street.

Implementing Partitioned Tables
In this session Geoff Orr will demonstrate how to implement and update partitioned tables. He will also show how partitioned tables can assist to manage very large databases (VLDB’s) and how to perform archive operations without the need to perform deletes.

About the Presenter
Geoff is an MCAD with over 20 years experience in IT in Australia and the UK. Geoff works in Database, Development and Business Intelligence. He has worked on systems as diverse as government grants, logistics, finance and even rubbish trucks. Geoff believes that data has its own story and loves databases. He has worked for Microsoft in Premier Support for SQL Server and now works as an Independent Consultant in partnership with Glyn Llewellyn and works closely with companies such as WARDY IT Solutions, Angry Koala and SSW.

WHERE: Microsoft Brisbane Office, Level 9, Waterfront Place, 1 Eagle Street http://www.microsoft.com/australia/technet/usergroups.aspx
WHEN: Thursday, 25th January | 5:30PM for a 6:00PM start

Add this event to your Outlook Calendar

Please RSVP via email to peter @ wardyit.com to help us plan refreshments (normally pizzas and drinks).

A Great Start to 2007

I hope that everyone had an opportunity to have a great festive season and that 2007 has started off well for you all.

2007 has certainly gotten off to a great start for me. Overnight I received my session evaluation results from the 2006 Pass Community Summit that I presented at in Seattle last November. The overall mean score for the session I presented was 4.68 out of 5. Meaning that out of the 107 sessions at the summit SQL Server Automation & SQL SMO was the 8th highest scoring session. Hopefully the session I am presenting at SQL Server Open World in Denmark in March scores just as well.