Skip to main content

Moving Tempdb

So somebody setup sql server and you now want to move tempdb to another drive? Easy. Fire up Query Analyser and run the commands: ALTER DATABASE tempdb MODIFY FILE (name = ‘tempdev’, filename = ‘new-file-path‘) ALTER DATABASE tempdb MODIFY FILE (name = ‘templog’, filename = ‘new-file-path‘) Replace the new-file-path with the full path and filename […]

Moving Reporting Services 2005 using RSConfig

Moving Reporting Services 2005 database from one SQL Server Instance to another The development environment I’m currently working in uses two servers. IIS with Reporting Services 2005 on box1, and SQL Server 2005 on box2. For whatever reason, I was unable to get Reporting Services to install correctly on box1 with box2 as the SQL […]

Snippet: Show full column names and data types for all user tables in a database

SELECT QUOTENAME( sysobjects.name ) + ‘.’ + QUOTENAME( USER_NAME( sysobjects.uid ) ) + ‘.’ + QUOTENAME( syscolumns.name ) AS [Name] , TYPE_NAME( syscolumns.xusertype ) AS [Type] , syscolumns.prec AS [Precision] , syscolumns.scale AS [Scale] FROM syscolumnsINNER JOIN sysobjects ON syscolumns.id = sysobjects.idLEFT OUTER JOIN systypes ON systypes.xtype = syscolumns.xtypeWHERE sysobjects.xtype = ‘U’

Multiple domain names, one geeklog

Geeklog (the software driving this site) requires you to set the home url in config.php. I use multiple domain names here: juliankuiters.id.au julian-kuiters.id.au synthesisone.com so I wanted to configure geeklog to allow visitors to use the website through each of these domans. Geeklogs default behaviour is to prefix the value of $_CONF[‘site_url’] from config.php to […]

About time!

A long time coming, but finally I’ve gotten round to installing something I can post to from work and home without hassle. Ugly, yes I know. (Where’s the pink?) A new theme will come soon enough. Until I feel creative, you’ll have to put up with articles, snippets and the occasional frustrated punishing post. Till […]