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.
Category Archives: SQL Server
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.
The following Stored Procedure example demonstrates how optional predicates can be used in one statement based upon the parameters that are passed to the Stored Procedure.
The Februrary 2006 edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
I have recently been demonstrating SQL Sever Integration Services (SSIS) to a number of people and there seems to be some confusion on how the (SSIS) For Each Container can be used to to perform an operation on a collection.
A question I was recently asked is how the SQLDMO object can be used to register Servers and Server Groups in SQL Server Enterprise Manager.
In SQL Server 2000 Built-in nondeterministic functions were not allowed in the body of a user-defined functions (UDF).