January 2006 - Posts

• January 2006 SQL Server Newsletter

  The January 2006 edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list. For those not on the distribution list you can view the newsletter using the following URL http://www.wardyit.com/newsletters/jan2006.htm Read More... Posted Saturday, January 28, 2006 9:59 PM by admin | (Comments Off)

• Error occurred during the creation of the DTS Package

  This morning I received a call from a client who were receiving the error "Error occurred during the creation of the DTS Package" whenever they attempted to open the SQL Server 2000 DTS designer by either editing a package or attempting to create a new Read More... Posted Wednesday, January 18, 2006 4:12 PM by admin | (Comments Off)

• Move a Database to a new Location

  A database data or log file can be moved from one location to another using the following steps: -- 1) Detach the Database EXEC sp_detach_db test -- 2) Move the file that was detached to the new location -- 3) Attach the Database from the new location Read More... Posted Wednesday, January 18, 2006 2:18 PM by admin | (Comments Off)

• Free Software Utilities

  WARDY IT Solutions have just released two software utilities which we have made available for Free. We recently developed these utilities to assist us to solve specific problems that we have encountered. We have made these utilities available in order Read More... Posted Monday, January 16, 2006 1:33 PM by admin | (Comments Off)

• SQL Server System Administration Essentials

  I will be running the course ‘SQL Server System Administration Essentials’ in Brisbane on Monday the 20th March 2005. This course is a one day course which has been designed to assist students to develop the technical skills and confidence to manage Microsoft Read More... Posted Monday, January 16, 2006 1:12 PM by admin | (Comments Off)

• SQLSMO - Adelaide SQL Server User Group

  I will be attending the Adelaide SQL Server User Group on Thursday the 9th March 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 Monday, January 16, 2006 12:54 PM by admin | (Comments Off)

• SED and the Big Bad UNIX File

  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 to deal with large files that need to be edited or inspected prior to being imported using DTS. http://www.sqlservercentral.com/columnists/pward/sedandthebigbadunixfile.as Read More... Posted Wednesday, January 11, 2006 4:42 PM by admin | (Comments Off)

• SQL Server 7 Support

  Effective as of December 31 2005 support for all versions of Microsoft SQL Server 7.0 transitioned from Mainstream Support to Extended Support. For more details regarding the support options available if you are still running SQL Server 7 refer to http://support.microsoft.com/default.aspx?scid=kb;en-us;912251 Read More... Posted Monday, January 09, 2006 1:55 PM by admin | (Comments Off)

• SQL Server 2005 Maximum Capacity Specification

  The following feature comparison matrix illustrates the SQL Server 2005 features as well as the Maximum RAM and Processors by edition http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx . Read More... Posted Monday, January 09, 2006 1:00 PM by admin | (Comments Off)

• Male, Female and The Other One (NULL)

  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 NULL's specifically with the fact that a logical expression can return TRUE, FALSE or Read More... Posted Sunday, January 08, 2006 10:06 PM by admin | (Comments Off)