March 2006 - Posts

• Touring Italy

  I will be on leave from the 30th of March until the 26th of April. During this time I will be touring Italy with my wonderful wife Jay Dee. Unfortunately as a result there will no SQL Server newsletter for March and no blog posts until I return from leave. Read More... Posted Thursday, March 30, 2006 2:36 AM by admin | (Comments Off)

• Generating a Calender Table

  Often the use of an auxiliary table can assist you to write more efficient code than a solution that doesn’t. Auxiliary tables are great at solving problems that you may be tempted to use a cursor to solve in the place of a set based solution. The following Read More... Posted Tuesday, March 28, 2006 9:10 AM by admin | (Comments Off)

• QLD SQL Server User Group - SMO Presentation

  I will be attending the Queensland SQL Server User Group on Thursday the 27th April 2006 to present on the SQL Management Object (SMO). Below is a synopsis for the presentation as well as the details of where the presentation will be held. For more details Read More... Posted Sunday, March 26, 2006 6:13 PM by admin | (Comments Off)

• SQL Server 2005 SP1 CTP

  The Community Technology Preview (CTP) of SQL Server 2005 Service Pack 1 is now available for download from http://www.microsoft.com/sql/ctp_sp1.mspx . As well as providing fixes and enhancements SP1 also delivers new functionality for database mirroring Read More... Posted Friday, March 17, 2006 2:27 PM by admin | (Comments Off)

• RMO Example

  A question that was asked during the SMO presentation in Adelaide last week was how to use the Replication Management Object (RMO) in SQL Server 2005 to programmatically control replication. The VB.Net snippet below configures the replication publisher Read More... Posted Tuesday, March 14, 2006 3:47 PM by admin | (Comments Off)

• Camtasia Movie of SQL SMO Presentation

  The SQL Server Automation & SQL SMO 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 ). The wmv produced recorded the entire Read More... Posted Monday, March 13, 2006 9:17 PM by admin | (Comments Off)

• MP3 of SQL Server Automation and SQL SMO Presentation

  The SQL Server Automation & SQL SMO presentation that I performed on Thursday the 9th March in Adelaide for the Adelaide SQL Server User Group was recorded as an mp3 and is available for download from http://www.wardyit.com/presentations/WARDYITSolutionsAdelaideSQLSMO.mp3 Read More... Posted Monday, March 13, 2006 2:31 PM by admin | (Comments Off)

• Adelaide SMO Presentation Resources

  The PowerPoint deck and demo code from the SQL SMO presentation that was presented in Adelaide this afternoon is available for download from http://www.wardyit.com/presentations/WARDYITSolutionsAdelaideSQLSMO.zip and from http://www.sqlserver.org.au/resources/ViewResource.aspx?resourceId=53 Read More... Posted Thursday, March 09, 2006 3:29 PM by admin | (Comments Off)

• DMO to SMO Mapping

  Many of the SQL Distributed Management Objects (DMO) properties have been renamed in the SQL Server Management Object (SMO). The following link contains details on those DMO properties that have been renamed and removed from SMO http://msdn2.microsoft.com/en-us/library/ms162159.aspx Read More... Posted Wednesday, March 08, 2006 1:21 PM by admin | (Comments Off)

• DMO and SMO AutoShrink

  The following SQLDMO and SMO VBScript code snippets can be used to check each database on a SQL Server instance and identify any databases where the AutoShrink database option is enabled. Note the DBOptions Class in SQLDMO has been moved to DatabaseOptions Read More... Posted Tuesday, March 07, 2006 4:02 PM by admin | (Comments Off)