I will be attending the Adelaide SQL Server User Group on Thursday the 9th March 2006 to present on the SQL Management Object (SMO).
Author Archives: WARDY IT Solutions
Below is a link to an article that I wrote which was recently published by SQL Server Central (http://www.sqlservercentral.com/) on using SED.
Effective as of December 31 2005 support for all versions of Microsoft SQL Server 7.0 transitioned from Mainstream Support to Extended Support.
The following feature comparison matrix illustrates the SQL Server 2005 features as well as the Maximum RAM and Processors by edition
Below is a link to an article that I wrote which was recently published by SQL Server Central (http://www.sqlservercentral.com/) on the the issues with dealing with NULLs
The December edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
The following Microsoft KB article details how to shrink a Transaction Log using DBCC SHRINKFILE http://support.microsoft.com/kb/272318/en-us.
The SQL Server 2005 System Table Map shows the system tables included in SQL Server 2005, and the relationships between them.
The following VBScript code snippet can be used to script all SQL Server Jobs on a SQL Server instance:
There are other tools such as SQLPing (sqlsecurity.com/DesktopDefault.aspx?tabid=26) that can be used to scan an IP address range for SQL Server instances.