The September edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
The SQL Script below can be used to remove non-printable characters from a string such as CRLF etc.
The SQL Server 2005 September CTP has been released and is available for download from BetaPlace and MSDN.
In order to determine the datetime that the statistics of an index where last updated the STATS_DATE function can be used.
If you are using or looking to use SQL Server Analysis Services to measure Key Perfromance Indicators then Microsoft Business Score Card Manager may be worth a look.
The Microsoft SQL Server 2005 Upgrade Advisor is a tool that can be used to analyze a SQL Server 7.0 or 2000 database servers.
If you have been unable to attend one of the Australian SQL Server User Group meetings, or are interested in one of the topics that have been presented
The following Microsoft Knowledge Base article describes the process to Shrink the SQL Server TEMPDB database
The following Knowledge Base article describes the process to manually uninstall SQL Server when ADD/Remove Programs will not uninstall SQL Server.
The June edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.