As much as we like to complain about it, Britain’s public transport system is amazing! We can probably get to 90% of the country any day we choose, more often than not at a choice of times throughout the day or night. For many years I have contentedly (or occasionally grudgingly) used this brilliant service [...]
It is really useful to be able to find a table or stored procedure with a particular string in it; and it’s actually really simple. For the example of a Stored Procedure, the contents are stored in INFORMATION_SCHEMA.ROUTINES and also syscomments and either can be queried: SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE ‘%foobar%’ [...]
Continue reading about Searching for a specific string in MSSQL objects
Since I first started going to Indian restaurants I realised the importance beer plays in the enjoyment of a good curry. There’s something about the coolness and crispness of a cold pint of lager which brings out the flavour of the spices whilst cooling the palette long enough to shovel a couple more mounds of [...]
Collation can be set on multiple levels on a server though is principally at the server level and at the column level on tables. If these collations are different, temporary tables created on the Master database will not be able to resolve with those on the database columns and queries will throw an error. Recently [...]
“It’s a dangerous business, going out your door” Bilbo Baggins said. “You step onto the road, and if you don’t keep your feet, there’s no telling where you might be swept off.” I love that sentiment that where you end up has a lot to do with chance, and so I sometimes like to add [...]
I don’t know how many of you have come across prickly pears before. Certainly they’re not the kind of fruit you see growing by the side of the road in England. But in Australia they’re not particularly uncommon – they were introduced in the late 1800’s and caused widespread ecological damage and undoubtedly pissed off [...]