blog community

September 2007 - Posts

• Object references and SQL

  While it might seem strange or even impossible to work with objects in SQL it is possible. I stumbled upon this recently while I was investigating a way to automatically drop and recreate indexes on a SQL 2000 server. DECLARE @object INT EXEC sp_OACreate Read More... Posted Tuesday, September 25, 2007 2:04 PM by BertrandR | 1 Comments

• Writing better SQL scripts

  Many organisations that have a platform for application hosting that includes different environments for development, testing and production use SQL scripts to migrate between environments. As a DBA I see a lot of these scripts and a lot of them are written Read More... Posted Thursday, September 13, 2007 2:19 PM by BertrandR | 1 Comments

• Installing multiple instances of SQL server without rebooting

  Figured I'd make my first post not just an introduction, but also give some usefull information on SQL cluster installations that isn't documented very well. Let's start with the introduction. I am Bertrand Rohrbock, 25 years old and working Read More... Posted Tuesday, September 11, 2007 9:09 AM by BertrandR | 8 Comments Filed under: Clustering, SQL 2005, Introduction