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.
Monthly Archives: March 2006
I will be attending the Queensland SQL Server User Group on Thursday the 27th April 2006 to present on the SQL Management Object (SMO).
Often the use of an auxiliary table can assist you to write more efficient code than a solution that doesn’t.
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.
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 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.
The SQL Server Automation & SQL SMO presentation that I performed on March 9 in Adelaide for the Adelaide SQL Server User Group is available for download.
The PowerPoint deck and demo code from the SQL SMO presentation that was presented in Adelaide this afternoon is available for download.
Many of the SQL Distributed Management Objects (DMO) properties have been renamed in the SQL Server Management Object (SMO).
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.