July 2006 - Posts

• July SQL Server Newsletter

  The July 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/jul2006.htm Read More... Posted Monday, July 31, 2006 2:56 PM by admin | (Comments Off)

• SQL Server 2005 BOL July Update

  A new version of SQL server 2005 Books Online has been released and can be downloaded from http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx . For a list of all of the changes in this version refer to the "New and Updated Books Read More... Posted Saturday, July 22, 2006 10:26 AM by admin | (Comments Off)

• SSMS Script One File For Each Object

  A common question in the sqlserver.programming and sqlserver.server newsgroups is “where is the option to generate one file for each object when scripting an object from SQL Server Management Studio (SSMS)?”. Unfortunately the option is not available Read More... Posted Friday, July 21, 2006 2:51 PM by admin | (Comments Off)

• Data Dude CTP4

  The Community Technology Preview (CTP) of Visual Studio 2005 Team Edition for Database Professionals (aka Data Dude) is available and can be downloaded from http://www.microsoft.com/downloads/details.aspx?familyid=C2FFA0E9-B68E-4411-9C9014697AC8FB95&displaylang=en Read More... Posted Wednesday, July 19, 2006 10:04 PM by admin | (Comments Off)

• Itzik Ben-Gan at SQL Down Under

  Itzik Ben-Gan will be in Australia in early October to deliver the course Advanced Transact-SQL Programming and Query Tuning for SQL Server 2000 and 2005 . Whilst Itzik is in Oz he will also be presenting at the SQL Down Under Code Camp in Wagga Wagga. Read More... Posted Tuesday, July 18, 2006 9:05 PM by admin | (Comments Off)

• August WARDY IT Community Dinner

  The WARDY IT Community Dinner is held on the second Monday of the month and is a great opportunity to share knowledge, information and experiences with other IT professionals in South East Queensland. The August WARDY IT Community Dinner is being held Read More... Posted Saturday, July 15, 2006 10:55 AM by admin | (Comments Off)

• Reporting Services database expects version C.0.8.43

  When you upgrade SQL Server 2005 to SP1 you may receive the following error when you initialise Reporting Services: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.8.40'. Read More... Posted Wednesday, July 12, 2006 10:52 AM by admin | (Comments Off)

• Default Database Script

  Often the sp_help_revlogin ( http://support.microsoft.com/kb/246133/ ) Stored Procedure is used to transfer logins from one server to another. In the June WARDY IT Newsletter ( http://www.wardyit.com/newsletters/jun2006.htm ) we showed how to build on Read More... Posted Wednesday, July 12, 2006 10:27 AM by admin | (Comments Off)

• SQL Down Under Code Camp

  Greg Low has just announced the SQL Down Under Code Camp on the SQLDownUnder mailing list and also on his blog . The SQL Down Under Code Camp will be held over the weekend of the 7th and 8th of October at Charles Sturt university in Wagga Wagga. More Read More... Posted Sunday, July 02, 2006 11:01 PM by admin | (Comments Off)

• June SQL Server Newsletter

  The June 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/jun2006.htm Read More... Posted Saturday, July 01, 2006 6:56 PM by admin | (Comments Off)