Inaugural QLD VSTS Users Group

The Queensland VSTS Users Group is a new User Group in Brisbane that has been started by Anthony Borton of VSTS Tech Brekkie fame. This User Group will focus on Visual Studio Team System (VSTS) and Team Foundation Server (TFS). The VSTS Users Group will meet on the first Friday morning of each month. Breakfast will be served from 7:30AM with the meeting running from 8:00AM to 9:00AM.

The inaugural meeting is on Friday the 1st December from 7:30AM at Microsoft Brisbane Office, Level 9, Waterfront Place, 1 Eagle Street, Brisbane.

For more details regarding the group refer to Queensland VSTS Users Group.

SMO Execute SQL Script

One of the questions asked during my recent presentation at the PASS Community summit was how to execute a script that is contained in a file using SMO. Unfortunately we ran out of time to answer this question during the session.  So below is a VB.Net code snippet that can be used to execute a SQL Script using SMO:

Dim sr As StreamReader = New StreamReader(“C:\script.sql”)
Dim script As String = sr.ReadToEnd

Dim SMOServer As Server = New Server
Dim db As Database = SMOServer.Databases(“northwind”)
db.ExecuteNonQuery(script)

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

WHERE Kafe Meze | 1B Browning Street | West End
WHEN Monday 11th December | 6:30PM
RSVP Friday 8th December
Please note that you are responsible for the cost of your own dining.

Add this event to your Outlook Calendar

SSMS Scripting Objects

One of the questions asked in my SQL Server Automation & SQL SMO session at the 2006 PASS Community Summit was “when an object is being scripted in SQL Server Management Studio (SSMS) how can the permissions for the object be scripted”.  I had a mental blank and could not remember off the top of my head, as did everyone else in the session.  The permissions can be scripted in SSMS for an objects by using the Wizard in SSMS by Right Clicking on a database and selecting Tasks | Generate Scripts as illustrated below:

PASS Presentation

I have just finished presenting my SQL Server Automation & SQL SMO session at the 2006 PASS Community Summit. The session was extremely well received and one of the most popular for the slot despite being up against Ken Henderson.

A MP3 of the session that was recorded earlier this year can be downloaded here
A WMV of the Screen Capture and Audio can be downloaded here
The source code for the Samples in the session can be downloaded here

A DVD of all of the conference sessions including my SQL SMO one will be available for purchase latter this year from PASS.

New York VB SIG Resources

I presented last night at the New York Visual Basic SIG in preparation for the SMO session that at I am presenting at the 2006 PASS Community Summit, the world’s largest SQL Server conference. Below is a list of resources associated with this presentation:

The presentation that I performed on Thursday the 9th March in Adelaide (Australia) 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 New York. 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.

November QLD SQL Server User Group

At this month’s QLD SQL Server User Group we are lucky enough to have Mark Morton presenting on Cryptography in SQL Server 2005.

Please Note: This meeting is being held on Wednesday the 22nd of November instead of Thursday the 23rd of November.

SQL Server 2005 Cryptography. Subtitle: Alice and Bob alive and well in Yukon.
This session will be rapid journey through the history of Cryptography starting with secret writing during the Persian Wars and cumulating in the Cryptographic features to be found in SQL Server 2005. On the way we’ll meet Alice and Bob, Julius Caesar and Whitfield Diffie amongst others, discuss the uses and abuses of Symmetric and Asymmetric encryption and investigate how to implement, manage and code using the new Cryptographic tools found within SQL Server 2005.

About the Presenter
Mark Morton is a Senior Technical Trainer and Consultant with Dimension Data Learning Solutions Brisbane. He has been working with Microsoft technologies for too many years and is a regular presenter at TechEd.and other industry forums.

WHERE: Microsoft Brisbane Office, Level 9, Waterfront Place, 1 Eagle Street http://www.microsoft.com/australia/technet/usergroups.aspx 
WHEN: Wednesday, 22nd November | 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).