257 reputation
29
bio website
location Rochester, NY
age 38
visits member for 2 years, 7 months
seen Jan 8 at 13:34

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
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?
Feb
24
comment PostgreSQL 8.4: How to tell if a procedural language is installed or not?
Thanks; exactly what I was looking for.
Feb
24
asked PostgreSQL 8.4: How to tell if a procedural language is installed or not?
Jan
19
awarded  Yearling
Jan
14
awarded  Popular Question
Dec
7
comment How do I set and get custom database variables?
Thanks for the info.
Dec
7
accepted How do I set and get custom database variables?
Dec
7
comment How do I set and get custom database variables?
Hmmm. No way to do that from a SQL query in the database?
Dec
7
asked How do I set and get custom database variables?
Dec
6
awarded  Commentator