I've been creating a database for a client and it requires the creation of some fields which are of type varchar(10). Nothing weird there I'm sure you'll agree. In creating these tables I'm using SQL Server Management Studio and I've found a little bug. If you create a column, enter...

I've been creating a database for a client and it requires the creation of some fields which are of type varchar(10). Nothing weird there I'm sure you'll agree. In creating these tables I'm using SQL Server Management Studio and I've found a little bug. If you create a column, enter...

I recently blogged about a small but frustrating bug in SQL Server relating to creating new columns of type varchar . Douglas Reilly linked to my blog posting about the bug , and it consequently got picked up and placed at the top of the Dr. Dobb's Database Update e-mail. Well - it's shocked...

Well, Red Gate have done it again , they've come up with another fantastic product ! This time they've addressed and area which has been ignored for a *long time* with a tool which will help you refactor that *horrible* SQL code you crank out on a daily basis. SQL Refactor is an Add-In to Microsoft...

We're not talking about swallows (African, European or otherwise) but Database Migrations that ship with Ruby on Rails. There's a cool bit of functionality which lets you stores database schema and incrimental changes in code files as well as a framework which offers the ability to roll the database...

This post is more for my memory than anything else but ... I've had issues restoring a SQL 2005 database from a backup today using the SQL Workbench with the following error message: - The backup set holds a backup of a database other than the existing 'MyDatabase' database. RESTORE DATABASE is terminating...

Okay, so rule number one of user interface design is consistency - make sure people don't have to learn new things too often and be sure to use the same design (bad or otherwise) everywhere. So why in gods name did the SQL Server team feel the need to replace the File Browser with their own mess of an...

Okay, so rule number one of user interface design is consistency - make sure people don't have to learn new things too often and be sure to use the same design (bad or otherwise) everywhere. So why in gods name did the SQL Server team feel the need to replace the File Browser with their own mess of an...

This post is more for my memory than anything else but ... I've had issues restoring a SQL 2005 database from a backup today using the SQL Workbench with the following error message: - The backup set holds a backup of a database other than the existing 'MyDatabase' database. RESTORE DATABASE is terminating...

We're not talking about swallows (African, European or otherwise) but Database Migrations that ship with Ruby on Rails. There's a cool bit of functionality which lets you stores database schema and incrimental changes in code files as well as a framework which offers the ability to roll the database...