meta user
network profile
| bio | website | blog.zygonia.net |
|---|---|---|
| location | Donegal, Republic of Ireland | |
| age | 46 | |
| visits | member for | 1 year, 11 months |
| seen | Mar 30 at 15:58 | |
| stats | profile views | 15 |
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.
You can also follow my haverings on Twitter App.net if you've nothing better to do.
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).
|
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 |
|
Sep 17 |
comment |
MDF and LDF contents in SQL Server Why not try what you suggested (deleting the .ldf log file and creating a new one) and see what happens. When you've done that please come back, tell us what you found and flag or @ reply me. Thanks. |
|
Sep 17 |
awarded | Famous Question |
|
Aug 26 |
comment |
High rise in SQL Server CPU after adding a DB I have asked the dba.se mods if they would like this question migrated. However, your question is somewhat vague and is going to be hard to answer without knowing more about the application that consumes this database and about the internals of the database itself. |
|
Aug 9 |
accepted | Enabling InnoDB on an existing MySQL production server |
|
Aug 8 |
revised |
Enabling InnoDB on an existing MySQL production server added 3 characters in body |
|
Aug 8 |
comment |
Enabling InnoDB on an existing MySQL production server Sorry, 5.1.59 to be precise. |
|
Aug 8 |
comment |
Enabling InnoDB on an existing MySQL production server This particular MySQL server was built from source and the built-in InnoDB wasn't compiled in. When I executed SHOW ENGINES; InnoDB wasn't listed and skip-innodb wasn't in the server's my.cnf file. However since asking the question I've now got the plugin version installed and running and so far so good. |
|
Aug 8 |
awarded | Commentator |
|
Aug 8 |
comment |
Enabling InnoDB on an existing MySQL production server @RolandoMySQLDBA - No plans to do that, they can stay as MyISAM tables. |
