We’ve recently started using Selenium as a testing tool at work. The IDE is great, particularly for filling in forms during development, but I’m a stickler for automated testing. [Read More]

Assuming you use a decent naming convention in your database, it’s sometimes useful to be able to find a list of tables with a common column - for example if you want to write a script to clean out all data related to a specific item, referenced by foreign key... [Read More]

I found this great article by Ian Stirk on SQLServerCentral.com, regarding finding queries that are currently executing on SQL Server. The article contains the following VERY useful query: [Read More]

I’d forgotten the syntax for moving an object to a different schema: [Read More]

This is a query I use often to check what active connections exist for a specified database: [Read More]