406 reputation
2416
bio website blog.zygonia.net
location Perthshire, Scotland
age 47
visits member for 2 years, 10 months
seen Apr 3 at 16:08

About Me:

I work as a professional software developer for a UK web hoster and internet services company and spend most of my time building provisioning and web based self-service systems for IIS, Apache and Citrix XenServer.

My Curriculum Vitae can be viewed on Stack Overflow Careers.

Stuff I like to listen to at last.fm

You can get in touch here: kevin #.# kenny #@# zygonia #.# net (you know what to do with the # and spaces).

Have rejoined this Facebook nonsense so come and abuse me here: https://www.facebook.com/kevin.kenny.12


Mar
31
awarded  Yearling
Feb
26
awarded  Popular Question
Feb
6
awarded  Famous Question
Feb
1
awarded  Popular Question
Jan
23
comment Why does CAST(1 AS SIGNED INTEGER) return a BIGINT on MySQL?
@Phil - yeah I read that too, and indeed that behaves as expected i.e. doing SELECT 1+1 results in a BIGINT. But it still doesn't explain away why CAST() behaves contrary to the documentation (as I understand it) and produces a BIGINT even if asked to cast to SIGNED INTEGER or UNSIGNED INTEGER on a single scalar value.
Jan
23
comment Why does CAST(1 AS SIGNED INTEGER) return a BIGINT on MySQL?
@Phil - I did read that over and over. Why does it say SIGNED [INTEGER] in the section The type for the result can be one of the following values:. Is a SIGNED INTEGER in the context of a CAST not in fact a 32 bit integer?
Jan
23
asked Why does CAST(1 AS SIGNED INTEGER) return a BIGINT on MySQL?
Jul
26
awarded  Popular Question
Jun
28
awarded  Nice Question
Mar
21
awarded  Notable Question
Jan
11
awarded  Popular Question
Dec
11
accepted Downgrading SQL Server 2008 R2 Standard to Web Edition
Dec
11
comment Downgrading SQL Server 2008 R2 Standard to Web Edition
That's pretty much the conclusion I was coming to. I was hoping to avoid having to uninstall Standard then re-install Web Edition. Thanks for confirming this.
Dec
11
asked Downgrading SQL Server 2008 R2 Standard to Web Edition
Dec
1
comment Recommended page file size for SQL 2008R2 on Windows 2008R2
@SQLKiwi - thanks for the info.
Oct
16
comment Preventing users who are dbo from dropping their own databases
@AaronBertrand - using a trigger didn't seem very elegant. I just wondered if the security infrastructure in SQL Server could enforce this instead. But if you folks think this is the optimal approach then I'm happy.
Oct
16
comment Preventing users who are dbo from dropping their own databases
@AaronBertrand - no, they are just dbo in their own database.
Oct
16
answered Is there a way to query SQL Server 2005/2008 for location of its log files?
Oct
16
comment Preventing users who are dbo from dropping their own databases
@ShawnMelton - possibly, but I have to spend time trawling the background trace logs pinpointing when they did and then proving it was their finger trouble. It's one less thing I want to have to do.
Oct
16
asked Preventing users who are dbo from dropping their own databases