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.

5h
comment Group ranges of values in access
Not sure if ms-access supports case (my version doesn't)
7h
answered sql - SELECT from two tables based on the same id and grouped
7h
comment Is it normal for SQL Paging to take Longer (x15~x20) than Getting All Data?
Not sure how I could answer a questions with comments and variable names in Polish
8h
revised Group ranges of values in access
edited tags
8h
answered Group ranges of values in access
8h
revised Group ranges of values in access
added 21 characters in body
2d
comment Suitable way to access SQL database from Web Server
Anything but the simplest DAL tends to degenerate into a treacherous morass (especially Entity Framework.) Have a look at Dapper, it's what Stack Overflow uses
Mar
27
comment What does Gandalf mean by "Secret Fire", "Flame of Anor" and "Flame of Udun"?
@Jim2B: After his death, Gandalf went beyond the space and time of Arda, see Letters, #156, pp 202–3. He was sent back by the Creator.
Mar
27
awarded Popular Question
Mar
26
awarded Nice Answer
Mar
26
awarded Good Answer
Mar
23
awarded Guru
Mar
22
revised DROP...CREATE vs ALTER
added 10 characters in body
Mar
20
awarded Curious
Mar
19
comment Count data using multiple date ranges
Right, in this case it is. But when you read this query in a year or so, you'll have to double-check the type of the date column
Mar
18
comment Count data using multiple date ranges
@a_horse_with_no_name: Updated to use clicks, though Valentin seems to have figured that out by himself :)
Mar
18
comment Count data using multiple date ranges
Looks much better, filter is great syntactic sugar! The query assumes date is a column of type date and not timestamp. That assumption has burned me at times
Mar
18
revised Count data using multiple date ranges
added 16 characters in body
Mar
18
revised Count data using multiple date ranges
added 8 characters in body
Mar
18
answered Count data using multiple date ranges
1 2 3 4 5