February 2007 - Posts

• February SQL Server Newsletter

  The February 2007 edition of the WARDY IT Solutions 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/feb2007.htm Read More... Posted Monday, February 26, 2007 1:07 PM by admin | (Comments Off)

• Enabling a Trace Flag

  In SQL Server 2000 setting a trace flag was really obvious. In Enterprise Manager you could right click on a Server and select properties and then add a Startup Parameter. In SQL Server 2005 the process to set a trace flag is not quite as obvious, as Read More... Posted Saturday, February 24, 2007 11:25 AM by admin | (Comments Off)

• March WARDY IT Community Dinner

  The WARDY IT Community Dinner is a great opportunity to network with other IT professionals in order to share knowledge, information and experiences. The March WARDY IT Community Dinner is being held on Monday the 19th of March. To RSVP to be at this Read More... Posted Saturday, February 24, 2007 11:17 AM by admin | (Comments Off)

• SQL Server 2005 SP2 RTM Released

  SQL Server 2005 Service Pack 2 is now available for download from http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx#EZB . Included with the Service Pack is an updated version of Books Online as well as the Feature Pack. Read More... Posted Monday, February 19, 2007 8:51 PM by admin | (Comments Off)

• Perth SQL Server UG Resources

  Last night I delivered the presentation Engineering 101 for the SQL DBA (the one with the 'legendary' USB key RAID demo) at the Perth SQL Server User Group. This presentation focuses on how the I/O subsystem can affect the performance of SQL Server. This Read More... Posted Saturday, February 10, 2007 7:10 AM by admin | (Comments Off)

• SSMS Export Maintenance Plan

  When you connect using the Server type Database Engine in SQL Server Management Studio there is no way to export a Maintenance Plan. However if you connect using the server type Integration Services you are able to export a Maintenance Plan using the Read More... Posted Tuesday, February 06, 2007 5:31 AM by admin | (Comments Off)

• SQL Server High Availability

  In the latest edition of .Net Rocks Allan Hirt discusses high availability in SQL Server 2005. This episode provides a great insight to the things that you need to be aware of when developing solutions for high availability. The show also provides a great Read More... Posted Thursday, February 01, 2007 3:13 AM by admin | (Comments Off)

• January SQL Server Newsletter

  The January 2007 edition of the WARDY IT Solutions 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/jan2007.htm Read More... Posted Thursday, February 01, 2007 3:01 AM by admin | (Comments Off)