Tag Archives: sql

Bookmarks for August 23rd through September 1st

Posted on by

These are my links for August 23rd through September 1st:

SQL – Find all triggers in a MS SQL database.

Posted on by

This script will find all the triggers in a Microsoft SQL database, its come in handy when I’ve been trying to work out where in the system people have tied there code into. I’m not a huge fan of triggers as they tend to make things behave unpredictably, its even worse if you don’t know there is a trigger or where it is.

SELECT S2.[name] TableName, S1.[name] TriggerName, 
CASE 
WHEN S2.deltrig = s1.id  THEN 'Delete' 
WHEN S2.instrig = s1.id THEN 'Insert' 
WHEN S2.updtrig = s1.id THEN 'Update' 
END 'TriggerType' , 'S1',s1.*,'S2',s2.*
FROM sysobjects S1 JOIN sysobjects S2 ON S1.parent_obj = S2.[id] WHERE S1.xtype='TR'

Found this little script on this site.

Reading SQLite databases in Windows

Posted on by

sqlite2009-proI recently had to get some data out of a .db file from an Adobe Air application, a few quick searches on Google turned up that the file is, as I suspected, a SQLite database. (Way to go Adobe!)

A few searches later and I had found this neat little application called SQLite2009 Pro its a free download and works pretty well. It allows you to view the database structure and import/export data as well as run SQL queries against it. It also comes with a ODBC driver but I haven’t gotten that to work, but admittedly I haven’t read any of the docs yet.

For those of you wondering, the file I was reading is the database file for the SARS (South African Revenue Service) E@syFile software.

Website for picking Servers

Posted on by

dell-serverI’ve been tasked with the job of finding a new server for a client, normally I love this kind of job but today its really not going particularly well.

The problem? I know what the client wants/needs but explaining that to the companies with the servers is rather difficult. Either I have to sit on the phone with a sales droid who doesn’t know what they’re talking about or I have to go play with a website which doesn’t work the way I think it should or the worst, go through thousands of spreadsheets trying to puzzle out what goes with what.

So far Dell has the best website I know of for configuring servers, but it still doesn’t do it right because it makes you make decisions up front that if you’re “just shopping” you can’t really make upfront. Obviously this all depends on the way you will be doing your shopping, but let me go through the way I would like these stores to work.
Continue reading →