I am Presenting at PASS 2006

I woke up this morning and sitting in my Inbox was the following email:

Congratulations! We are pleased to inform you that your abstract has been selected for presentation at the 2006 PASS Community Summit, November 14-17, 2006 in Seattle, Washington.

So I will be heading over to Seattle in November to present the SQL Server Automation and SQL SMO presentation that I have been presenting at the Australian SQL Server and .Net User Groups.  The PASS Community Summit is the largest SQL Server event in the world and more details regarding the summit can be found at http://www.sqlpass.org/events/summit06/.

Sydney .NET Users Group Resources

On the 21st of June I presented at the Sydney .NET Users Group on SQL Server Automation & SQL SMO.  Below is a list of resources associated with this presentation:

A PDF of the PowerPoint deck can be downloaded from http://www.wardyit.com/presentations/WARDYITSolutionsSQLSMOSydney.pdf

The PowerPoint deck and demo code can be downloaded from http://www.wardyit.com/presentations/WARDYITSolutionsSydneySQLSMO.zip

The presentation that I performed on Thursday the 9th March in Adelaide for the Adelaide SQL Server User Group was recorded using Camtasia (http://www.techsmith.com/camtasia.asp).  This presentation is similar to the one presented in Sydeny.  The wmv produced recorded the entire presentation including the audio, so if you missed the presentation on Wednesday night (or would like to see it again) it is available for download from http://www.wardyit.com/presentations/WARDYITSolutionsAdelaideSQLSMO.wmv.  The wmv is approximately 49mb.  Camtasia records the entire screen so the PowerPoint deck and code examples are all available to be viewed so it is just like being at the presentation.

An mp3 of the presentation performed in Adelaide is also available for download from http://www.wardyit.com/presentations/WARDYITSolutionsAdelaideSQLSMO.mp3.  The mp3 is approximately 16mb.

Inside SQL Server 2005

Inside SQL Server has been the *bible* for SQL Server ever since the SQL Server 6.5 version of the book by Ron Soukup was published. As SQL Server 2005 is such an expansive product the SQL Server 2005 publication has been broken into three books.  The first two books Inside Microsoft SQL Server 2005: T-SQL Programming and Inside Microsoft SQL Server 2005: T-SQL Querying are now available from your favourite bookseller.  The third volume covering the Storage Engine is expected to be available in late October this year.

Congratulations Greg Low!

Greg Low of Readify, QLD SQL Server User Group (QSSUG), QLD MSDN User Group (QMSDNUG) and SQL Downunder fame has just been awarded a Silver Medal for his global reach as a Microsoft Regional Director (one of only two Regional Directors in Australia).  This is defiantly something to be congratulated especially considering that Greg was only appointed as a Microsoft Regional Director earlier this year.  It is great to see that all of the contributions that Greg has/is making in the SQL Server and development community in Asia Pacific is being recognised.  Once again congratulations Greg!

Format Numbers in Accounting Format

Typically the formatting of data is something that should be performed at the front-end however there are times when there is a need to format data on the back-end.  The following example illustrates how a number stored in a table can be formatted in accounting format ie. $000,000.00.

CREATE TABLE dbo.currency
col1 INT

INSERT dbo.currency SELECT 1000
INSERT dbo.currency SELECT 10
INSERT dbo.currency SELECT 999999

FROM dbo.currency



(3 row(s) affected)

Did you miss the WARDY IT Community Dinner last night?

Last night was the second WARDY IT Community Dinner which was help at the Punjabi Palace Indian restaurant at West End. If you missed the dinner then you missed a fantastic night and a great opportunity to share knowledge, information and experiences with other IT professionals in South East Queensland.  The conversation ranged from laptop bags and Oracle forms to how to solve all of the world’s problems including sheep shearing with AI software.  So if you are interested in socialising with other professional as well as having the opportunity to bounce ideas off others in the industry ranging from company directors to developers and business analysts then why not attend the next WARDY IT Community Dinner?

The WARDY IT Community Dinner is held on the second Monday of the month and the July dinner is on Monday the 10th of July.  To RSVP to be at the next WARDY IT Community Dinner send an email to peter @ wardyit.com.

WHERE Story Bridge Hotel – Deery’s Restaurant | 200 Main Street | Kangaroo Point | http://www.storybridgehotel.com.au/contact.php
WHEN Monday 10th July | 6:30PM
RSVP Friday 7th July
Please note that your are responsible for the cost of your own dining.

Add this event to your Outlook Calendar

Sydney .NET Users Group

I will be in Sydney next Wednesday (21st of June) presenting at the Sydney .NET Users Group on SQL Server Management Objects (SMO). So if you are in Sydney next week why not not pop along as Darren Neimke from Readify will also be presenting at this event.

For more details regarding the Sydney .NET Users Group refer to http://www.ssw.com.au/ssw/NETUG/Default.aspx.

Microsoft Sydney Office
1 Epping Road
Riverside Corporate Park
North Ryde NSW 2113 Australia

Add this event to your Outlook Calendar

SQL Server 2005 Everywhere

A CTP has been released for SQL Server 2005 Everywhere Edition. SQL Server Everywhere is a compact version of SQL Server 2005 designed to bring the features of SQL Server to any device from the desktop to mobile devices. The one thing to note is that this CTP only contains the runtimes for desktop development.  The CTP for SQL 2005 Everywhere can be downloaded from http://www.microsoft.com/downloads/details.aspx?FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en.

Recent Statements Executed

A common SQL Server question is how to identify recent statements that have been executed. To retrieve this information in versions of SQL Server prior to 2005 required having a SQL Server trace running or using a Third Party tool and there was no ‘easy’ way to retrieve this information retrospectively.  SQL Server 2005 introduced Dynamic Management Views (DMV’s) and Functions that can be queried to return internal data about the state of SQL Server. By using the DMV’s in SQL Server 2005 you can now easily identify the recent statements that have been executed and also compare the current duration versus an earlier execution of the statement in order to assist with performance tuning. The following query illustrates how to retrieve the recently executed statements and all of the query statistics associated with the execution:

SELECT qs.*, st.text
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
ORDER BY qs.last_execution_time DESC