287 reputation
412
bio website
location Rochester, NY
age 39
visits member for 3 years, 1 month
seen Oct 27 at 15:18

I am a professional geek, working in enterprise data systems. I fill the role of systems engineer, architect, developer, project manager, etc... a one-stop enterprise IT kinda guy.

I develop in .NET, MVC, and IIS on Windows platforms; on *nix I favor to develop in PHP with some Cake.

For database systems I favor MSSQL, MySQL, and I'm moving into PostgreSQL for BI/ Warehousing.

Security is near and dear to my heart; a well-designed security system puts a satisfied smile on my face.

Scalability is important to me; planning for the future is one of my greatest strengths.

Thats me! Computer geek extraordinaire!


Oct
6
comment Service Broker received an error message on this conversation
@RogerF.Wolf I technically don't have to. I ended up removing that validation to see if it was the problem; it wasn't. I do like the idea of having well-defined messages, though.
Oct
6
awarded  Notable Question
Sep
30
asked Service Broker received an error message on this conversation
Aug
20
comment Is there a means to set the owner of all objects in a PostgreSQL database at the same time?
Besides creating dynamic sql that you have to regurgitate, there is nothing "wrong" with his answer other than it being arguably more complicated; I have no power over your confidence, but after working with this rdbms for several years now, I definitely have confidence in it.
Aug
20
comment Is there a means to set the owner of all objects in a PostgreSQL database at the same time?
...and, apparently, updating the owner of all objects in a database, for which there is still not a practical means of doing, going on 3 years later. BTW, I have tested this in 8.4, 9.1, and 9.3, without issue. To the reader, YMMV, but it worked for me.
Aug
13
awarded  Popular Question
Jul
18
awarded  Popular Question
Jul
2
awarded  Curious
Jun
3
awarded  Notable Question
Oct
27
awarded  Popular Question
Sep
10
comment Cannot shrink transaction log
@AaronBertrand generally that's true but this literally gets written to once a week, in one transaction from one file; even if we lost a day's worth of data, we'd just re-import the file.
Sep
10
accepted Cannot shrink transaction log
Sep
10
comment Cannot shrink transaction log
Yeah I turned on autoshrink to see if it made a difference, and I'd already given up on point-in-time recovery at this point. Since the db is also fully backed up every day, I suppose it will not hurt to go to simple mode.
Sep
10
asked Cannot shrink transaction log
May
29
accepted Profiling a PostgreSQL function
May
29
asked Profiling a PostgreSQL function
May
29
asked Query result with X rows discarded
May
20
awarded  Caucus
May
20
awarded  Constituent
Feb
24
accepted PostgreSQL 8.4: How to tell if a procedural language is installed or not?