May 2006 - Posts

• May SQL Server Newsletter

  The May 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/may2006.htm Read More... Posted Sunday, May 28, 2006 8:58 PM by admin | (Comments Off)

• SQL 2005 SP1 Available as Windows Update

  I am currently building a VPC image for a SQL Server training class that I am running next week and I have just gone to Windows Update to download all of the latest updates for Windows 2003 Server and look what I found. SQL Server 2005 Service Pack 1 Read More... Posted Friday, May 26, 2006 12:30 PM by admin | (Comments Off)

• Active Trace Flags

  If you ever need to identify the Trace Flags that are currently active you can simply execute the TSQL Statement below. The output will return each of the trace flags that are currently enabled. DBCC TRACESTATUS(-1) Read More... Posted Friday, May 26, 2006 10:10 AM by admin | (Comments Off)

• Tech-Ed 2006

  It looks like the Microsoft Australia Tech-Ed 2006 page ( http://www.microsoft.com/australia/teched2006/ ) was updated over the weekend with additional details including further track information. Also if you are looking at taking a taking an MCP Exam Read More... Posted Monday, May 22, 2006 8:23 AM by admin | 2 Comments

• Inaugural WARDY IT Monthly Community Dinner

  Last night was the first WARDY IT Monthly Community Dinner which was held at Ahmets Turkish restaurant at Southbank. The event was a great success and the feedback from the event was extremely positive with everyone looking forward to the next dinner. Read More... Posted Tuesday, May 16, 2006 11:28 AM by admin | (Comments Off)

• DNRTV with Adam Cogan

  I have recently been re-listening to some of the older .Net Rocks ( http://www.dotnetrocks.com ) episodes whilst travelling to a remote client site and one of the suggestions on episode #93 was for an 'audio shootout' to review the most popular ASP.Net Read More... Posted Tuesday, May 16, 2006 10:42 AM by admin | (Comments Off)

• UNPIVOT a Table

  The example below illustrates how to UNPIVOT a table. The example can be used in both SQL Server 2000 and 2005. CREATE TABLE dbo.TableToUnPivot ( SalesYear INT, Q1 INT, Q2 INT, Q3 INT, Q4 INT ) INSERT dbo.TableToUnPivot SELECT 2003, 1, 2, 3, 4 INSERT Read More... Posted Tuesday, May 16, 2006 10:06 AM by admin | (Comments Off)

• SQL Server 2005 Import Export Wizard

  A question I have been asked a lot lately is "where has the Import Export Wizard gone in SQL Server 2005". The wizard has not disappeared although it is no longer as obvious as it used to be. The easiest way to launch the Import Export Wizard is to execute Read More... Posted Wednesday, May 10, 2006 10:51 AM by admin | (Comments Off)

• WARDY IT Monthly Community Dinner

  There has been a lot of community discussion recently regarding the opportunities available for IT professionals to get together in a social environment to share experiences and advice regarding the challenges that we tackle everyday. With this is mind, Read More... Posted Saturday, May 06, 2006 12:19 PM by admin | (Comments Off)

• April SQL Server Newsletter

  The April 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/apr2006.htm Read More... Posted Monday, May 01, 2006 8:39 PM by admin | (Comments Off)