The SQL Server 2005 September CTP has been released and is available for download from BetaPlace and MSDN.
Author Archives: WARDY IT Solutions
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.
The VBScript below can be used to read a list of SQL Server instances from a text file and execute a SQL Script againt each of the instances:
WARDY IT Solutions will be presenting a course titled ‘A DBA’s Guide to SQLDMO’ in Brisbane on the 31st September 2005.