September 2007 - Bertrand Rohrbock

Bertrand Rohrbock

Sort by: Most Recent | Most Viewed | Most Commented

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...

Published 25-09-2007 14:04 by BertrandR
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...

Published 13-09-2007 14:19 by BertrandR
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...

Published 11-09-2007 9:09 by BertrandR

Filed under: Clustering, SQL 2005, Introduction