Andomar

Netherlands

Age: 41

I'm a software developer at a telco supporting line-of-business applications. We use a variety of technologies from ASP.NET to Perl. I've come to appreciate SQL more over time, and I now spend most of my time in the database.

If you'd like to learn SQL properly, consider the free SQL course from Stanford. For more free online courses awesomeness, check out the list of courses on Coursera and EdX.

1m
reviewed Approve suggested edit on Oracle SQL does not work for MS Access
1h
comment Error in php sql statement ($stmt2 is returning false but I dont know why)
Printing the value of $sql2 might help debug this problem
1d
awarded Necromancer
2d
comment Get First and Last Entry in Table by User within SQL Server
Might not be the fastest but certainly a correct way to write it, +1 :)
2d
comment Get First and Last Entry in Table by User within SQL Server
@VedranKopanja: You're right, whoops, I wrote partition by User instead of partition by UserName. And user is a T-SQL reserved word that typically returns dbo. Fixed in answer.
2d
revised Get First and Last Entry in Table by User within SQL Server
added 8 characters in body
2d
comment How to sum with condition?
I'm not sure what you mean. Perhaps you could add some example input data to your question.
2d
comment Get First and Last Entry in Table by User within SQL Server
@VedranKopanja: What is not working? Can you put your example on sqlfiddle.com?
2d
comment How to sum with condition?
Could you explain what you mean by "condition"?
2d
revised Get First and Last Entry in Table by User within SQL Server
added 196 characters in body
2d
answered Get First and Last Entry in Table by User within SQL Server
2d
comment command-line editing in MS sqlcmd on linux
If you use the -Q option to run queries from the command line, you can use bash editing
2d
answered How to sum with condition?
2d
comment Returning MAX function on query?
Wrap your query in select * from (... your query here ...) x where rownum = 1 (per Bacon Bit's suggestion)
2d
comment How to install tPostgres
That's easy. Just connect the Citrix Warp Core to the T-SQL accelerator and power up the Postgres bilitrium generator.
2d
comment How to safeguard a symmetric key in SQL Server
If you don't trust the DBA, don't ask the database to do encryption for you. Encrypt client side. (Note that the sysadmin of the client server can always access your data. You can't prevent that.)
2d
comment Postgres Partition Table Trigger inserting duplicate records
Triggers are evil. Move the logic to another place. For example, create a procedure that the client can call instead of doing an insert.
2d
comment Which columns (and order) to choose for a clustered index to maximize query performance
Why are you doing performance optimization at all? What's your goal?
2d
revised Import and overwrite duplicate rows
deleted 106 characters in body
2d
revised Import and overwrite duplicate rows
edited title
1 2 3 4 5