Category Archives: Uncategorized

Output sub query as CSV when Joining tables (one to many relationship)

This will show you how to get something like this from a table join and then I’ll explain how the SQL works. Name csv UK London,Manchester,Birmingham USA New Your,Washington,Kentucky France Paris,Leon,Frejus Suppose we have two tables — Create base table CREATE … Continue reading

Posted in Uncategorized | Leave a comment

Creating and Migrating an encrypted database.

This is a simple tutorial on how to… Create a database Setting up encryption Add encrypted data to a table Migrate the encrypted database to another server The tutorial is supplied without warranty and David Bridge and David Bridge Technology Limited accept … Continue reading

Posted in Uncategorized | Leave a comment

Amazon Kindle – is it any good?

Is the Amazon Kindle any good. Should you buy one of the relatively cheap items or should you buy a Sony reader or an iPad or just use your computer? Continue reading

Posted in Hardware stuff, Other stuff, Uncategorized | 1 Comment

Copying / archiving data

Copy large amounts of data in the background without locks Continue reading

Posted in SQL Stuff, Uncategorized | Tagged , | Leave a comment

SQL Server partitioning (2008)

How to find out the number of rows in each file group in a sql server partitioned database Continue reading

Posted in SQL Stuff, Uncategorized | Tagged , | Leave a comment

SQL Server compressed backups

Backup compression is now available in all versions of SQL Server 2008 and was only in enterprise in 2005 but is it any good? Continue reading

Posted in SQL Stuff, Uncategorized | Tagged , , , | Leave a comment

Who owns the DB?

Database owner has total rights on a database. Who owns your databases and do they work for you? Continue reading

Posted in SQL Stuff, Uncategorized | Tagged , , | Leave a comment