SQL Down Under Presentations

The recent SQL Down Under Code Camp that was held on the 7th and 8th of October contained presentations from some of the leading figures in the Australian SQL Server community. Many of the presentations over the two days were recorded and have been made available to download as an mp3. Listed below is each of the presentations from this event that are available.

Darren Gosbell – An introduction to MDX (~37MB)
Geoff Orr – Introduction to table partitioning (~28MB)
Grant Paisley – A better way to add business process to Reporting Services (~39MB)
Greg Linwood – A methodology for troubleshooting and tuning SQL Server (~35MB)
Greg Linwood – Managing Indexes for Database Administrators (~48MB)
Greg Low – Introduction to Visual Studio Team Edition for Database Professionals (DataDude) (~34MB)
Peter Myers – An introduction to data mining in SQL Server 2005 (~38MB)
Rob Farley – Windowing and ranking functions (~33MB)
Trevor Andrew – What SMO offers developers and DBA’s (~26MB)

Batching a Delete Operation

A colleague of mine dropped me a IM asking how they could delete data from a table in batches of 10,000 records.  The following is an example of a solution that can be used to perform a delete operation in specified batches.  The solution could also be easily modified to allow an update operation to be performed in a batch.

WHILE 1 = 1
BEGIN
BEGIN TRAN
SET ROWCOUNT 10000
DELETE FROM table WHERE ind = 1
IF @@ROWCOUNT < 1
BREAK
COMMIT TRAN
END

IF @@TRANCOUNT > 0
COMMIT TRAN

Earn More per hour as a Developer

Adam Cogan and Steve Herzberg are holding a one day course in Brisbane on how to Earn More per hour as a Developer. In this course Steve and Adam will dispel a number of the myths about client interactions and what the client is really seeking from their IT provider.  This session is definitely one not to be missed.  I was lucky enough to see a small extract of this presentation with Adam and Steve at Tech-Ed and the tips I picked up in the half hour session were invaluable and I was able to apply these strategies straight away in order to help negotiate several new contracts. The workshop is being held on Monday the 23rd of October.  For more details and to register refer to Earn More per hour as a Developer.

October QLD SQL Server User Group

Unfortunately Greg Low is unavailable to present the planned session on Full Text Search, Blobs and XML.  However hopefully we will be able to re-schedule Greg’s presentation for early next year. In Greg’s place I will be presenting on Engineering 101 for the SQL DBA.

The deployment decisions for SQL Server are no longer as simple as deciding whether you will run enterprise or standard edition and whether the server will have single or dual CPU’s. There are now decisions such as RAID 5 or RAID 1+0, 32 or 64-bit CPU’s and whether to use virtualization or not? Often the list of options is like a menu from a foreign restaurant as there are lots of choices that you think you like the sound of and others that, well frankly, you have no idea what they are! This session is designed to assist with the intersection between the role of Database Administrator and System Engineer. This session will explain some of the options available and how these options affect SQL Server and explain what those ‘Three Letter Acronyms’ that you have to choose from actually are.

This presentation will cover the following topics:

– SQL Server I/O basics and I/O characteristics
– The affect that I/O performance has on SQL Server
– How to determine the optimal RAID configuration for you SQL Server instance
– General storage configuration best practices
– Monitoring and baselining I/O subsystems

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

Add this event to your Outlook Calendar

If you will be attending, please RSVP via email to peter @ wardyit.com to help us plan refreshments (normally pizzas and drinks).

November 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 November WARDY IT Community Dinner is being held on Monday the 20th of November.  To RSVP to be at this event send an email to peter @ wardyit.com.

Note: The November Community Dinner is one week later than usual as I will be in Seattle presenting at the PASS Community Summit on the second Monday in November.

WHERE Mecca Bah | 19-21/1000 Ann Street | Fortitude Valley | http://www.meccabah.com/bris/home.html
WHEN Monday 20th November | 6:30PM
RSVP Friday 17th November
Please note that you are responsible for the cost of your own dining.

Add this event to your Outlook Calendar

Engineering 101 Presentation

At the SQL Server Code Camp I presented a session titled ‘Engineering 101 for the SQL DBA’.  Often the list of I/O options for SQL Server is like a menu from a foreign restaurant as there are lots of choices that you think you like the sound of and others that, well frankly, you have no idea what they are!  This session was designed to assist with the intersection between the role of Database Administrator and System Engineer and explain some of the options available and how these options affect SQL Server.
A PDF of the PowerPoint deck can be downloaded from http://www.wardyit.com/presentations/WARDYITSolutionsEngineering101.pdf.