Browse by Tags

Changing the Data Files Location after Installation
10 August 2008 10:28

The other day i wanted to change the "Data Files" location for a 2005 database engine installation and a 2005 Analysis Services installation which you can specify under the advanced options during installation. I quickly found out that there appears to be no documented ways to do this other than uninstall SQL Server and install again specifying a new... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, Tips, Analysis Services, Database Engine

SSAS 2005 – Server side tracing starter kit
07 April 2008 22:32

Analysis services 2005 (SSAS) added the ability to trace server side events and i have used this feature a number of times. To date i had always used the profiler gui to do the SSAS tracing but today i found myself needing to initiate and manage a trace with scripts. The good news is that it can be done! It did take a while to piece together how to do it though... Read More...

by ACALVETT | 1 comment(s)

Filed under: Tools, Tips, Performance, SSAS 2005, Analysis Services