Profile

Cover photo
Andrea Riva
Works at Agostini Group
Attended Liceo Scientifico "Pio X"
Lives in Carbonera, Treviso
1,978 followers|165,593 views
AboutPostsPhotos

Stream

Andrea Riva

Shared publicly  - 
 
you know you gotta watch out

So satisfied that Lauryn Hill's Miseducation gets such an important recognition (totally deserved)
Enshrining in the US Library of Congress was perhaps not what British once-rock band Radiohead had in mind when writing OK Computer, a classic dystopian album from 1997 about (among other sunny...
18
1
Anneliese Von Trapp's profile photo
Add a comment...

Andrea Riva

Shared publicly  - 
 
Gotta see this one :-)

Via +Lorenzo Breda
1
Add a comment...

Andrea Riva

Shared publicly  - 
 
This just in...

Pushbullet isn't bad at all, I expect Google to copy or buy them quite soon.
3
Add a comment...
 
Italians do it better? 

Well, not when it's time to develop a companion site to Expo 2015: starting from the pitiful name, and going on with supported languages language: Italian!

Not to talk about the client, which is the Ministry of Cultural Assets and Properties itself.

Not to talk about the cheap price, which is said to be around 5m Euros... (EDIT: the Ministry reports that the real implementation cost is 35.000€+VAT)

Not to talk about the social internet's reaction: to have some good laugh, use a translator and look for #verybello  tweets :-)
The website design? Sloppy and anonymous, like a blog with a low cost design. Simply don't waste your time and money investing on an awful website.
3
2
Gianluca B.'s profile photoAndrea Moro's profile photo
Add a comment...

Andrea Riva

Shared publicly  - 
 
For the lazy ones :-)
I'm a horizontal separator. Drag ─────────── to your bookmarks folders. For a vertical separator, click here. :). Made by @manski83, based on work by @VorteXLP ...
2
Add a comment...

Andrea Riva

Shared publicly  - 
 
A DB design problem

I have a table, OrderDetails, which represents the detail rows of a master Orders table.

Details of an order can reference both stock items (which are saved in an Items table, with fields: ID, Code, Description, UM) and uncoded "free" items, i.e. items whose Code, Description and UM are input by the user "on the fly".

I have structured OrderDetails this way:

- ItemType (1 for stock items, 2 for uncoded items)
- ItemID (foreign key relative to an ID in the Items table,
    which contains a special record with ID=1 for uncoded items)
- itemCode (30 chars)
- itemDescription (200 chars)
- itemUM (foreign key relative to an ID in the UM table, 
    which contains a set of default UMs)
- ID, qty, price, etc (irrelevant for the discussion)

While for coded items itemCode, itemDescription and itemUM are just a copy of the equivalent fields in the Items table,  as said above I want that for uncoded items the user is able to input code, description and UM freely, according to his/her needs. An uncoded item is therefore identified across the system not by an ID, but by its own instantiation, i.e. by the triple (itemCode, itemDescription, itemUM)

I expect OrderDetails to contain 100.000s or even 1.000.000s of records: when accessed by item, performance in joins and lookups can be become a bottleneck.

There are other tables which can reference items (both coded and uncoded), so joins could involve two or more tables, each containing 10.000s or 100.000s records.

There is at least a problem with the current design, i.e. even for a simple lookup, one needs two different SELECTs depending on the type of item he/she's looking for:

- SELECT ... WHERE itemType=1 AND itemID=XXX
- SELECT ... WHERE itemType=2 AND ItemID=1 AND itemCode='xxx' AND itemDescription='yyy' AND itemUM='zzz'

(TBH, the second SELECT would be enough for both types, if it's guaranteed that item's code, description and UM are kept identical across Items, OrderDetails and all other tables involving items, but I prefer to drop such assumption. So, for coded items ONLY, their identity is their ID, but NOT their code, description, UM)

A related problem of the second SELECT above is that, for performance's sake, indexes on itemCode and itemDescription are strongly suggested, but I don't like indexes on long string fields (itemDescription is 200 chars long).

I could think about various alternative designs, with different compromises between speed, space and code clarity, until I got the "A-ha!" solution I eventually settled on. I'm not describing it here NOW because I'm curious to read your opinions, I'll add it later.

So what would you do?

- throw the current design away, and substitute it with... ?
- change the current design, and if so how?
- keep the current design, and integrate it with... extra fields? extra tables? what?

Just one note: I know that they are trendy, but I'm not interested in noSQL solutions :-)
1
Federico “Edo” Granata's profile photo
 
Maybe +Davide Pagani​ has enough time to help you 
Add a comment...

Andrea Riva

Shared publicly  - 
 
Just caught a spam mail with an attached phishing bait, which apparently has just been released in the wild, with Italy as target.

True: technically speaking this is NOT a virus, but it IS malware, and it's frightening that after an hour only 1 antivirus out of 56 raises the red flag :-/
3
Add a comment...
Have him in circles
1,978 people
PARAMESWAR RAO BANDARU's profile photo
Omar Degoli's profile photo
Jasa “Jasa Pembuat Web” pembuatweb's profile photo
Gregory Devine's profile photo
Holomos B.'s profile photo
Raghd Hamzeh's profile photo
Andrea Dallan's profile photo
Tom Radford's profile photo
Leon Wessels's profile photo

Communities

7 communities

Andrea Riva

Shared publicly  - 
 
Well, ok, THANKS MICROSOFT!

Spent too many damned working hours to debug some mysterious authentication errors suddenly popping out when external Outlook clients were trying to connect to an Exchange 2010 using RPC over HTTPS (ie Outlook Anywhere).

The culprit, guess what, is a f****g Windows Update, KB3002657!!! 

Patch Tuesday is more and more becoming a day for the brave: for months now there has been some Tuesday patch creating havoc either at client or server level! which, imho, is far worse than designing something as ugly (UI-wise) as Win8... MS can't afford to become more unreliable than it already is, it just can't.

Anyway, in an environment with two AD controllers and an Exchange 2010 server, I started by uninstalling KB3002657 from the Exchange server only, and it looks like it's enough to solve my authentication problems.

See also:

http://windowsitpro.com/patch-tuesday/patch-tuesday-kb3002657-causing-authentication-problems-exchange-other-apps

http://www.thirdtier.net/2015/03/kb3002657-can-cause-outlook-auth-issues-with-exchange-2013/
Update: 2015-03-12 09:45 PST – Now that I've had a chance to sleep I've updated this post to include some of the specific errors we saw and gather some additional information from around the web. Hopefully it will help others diagnose this problem. We installed our Windows Updates this week and ...
2
Alessio Comai's profile photoAndrea Riva's profile photo
7 comments
 
Well, so far, so good...

- installed v2 patch on 2003 server (had to reboot, BTW)
- reinstalled original patch on Exchange server

and...

- Netgear NAS is serving AD authenticated shares again
- external Outlook users are not complaining

So it looks like the incident is over. Thanks again, Microsoft :-}
Add a comment...

Andrea Riva

Shared publicly  - 
 
Although it goes against the importance and value of diversity, the answer is a good thought experiment.

What do likable, pleasant people do differently? http://qr.ae/Eqo31
1
Add a comment...

Andrea Riva

Shared publicly  - 
 
:-)

Answer by Nicholas Snyder to Is it possible to buy a country? http://qr.ae/3Q3j5
1
Add a comment...

Andrea Riva

Shared publicly  - 
 
Wishing luck to these guys, who are trying to introduce a mobile payment system in Italy, which can also be used for person-to-person transactions.

Let's hope 2015 is the year things start moving.
 
Auguri a chi è stato con noi nel 2014 con la Beta e a tutti coloro che ci accompagneranno nel 2015 (e oltre!).
Buone feste da tutto il team di #Satispay

[live long and cashless]

#LiveCashless
 ·  Translate
View original post
1
Add a comment...

Andrea Riva

Shared publicly  - 
 
Early start... 0°C, sunrise, everything is in order... Let's begin again :-)
2
Roberta F.'s profile photoAndrea Riva's profile photo
2 comments
 
Come sempre... ma in inverno faccio bella figura, perchè sembra che sia molto presto, e in realtà erano già le 8.00 :-)
 ·  Translate
Add a comment...
People
Have him in circles
1,978 people
PARAMESWAR RAO BANDARU's profile photo
Omar Degoli's profile photo
Jasa “Jasa Pembuat Web” pembuatweb's profile photo
Gregory Devine's profile photo
Holomos B.'s profile photo
Raghd Hamzeh's profile photo
Andrea Dallan's profile photo
Tom Radford's profile photo
Leon Wessels's profile photo
Communities
7 communities
Education
  • Liceo Scientifico "Pio X"
  • Università degli Studi di Udine (Scienze dell'Informazione)
Basic Information
Gender
Male
Story
Tagline
Brutto ma buono!
Work
Occupation
Information Technology
Employment
  • Agostini Group
    IT Manager, 1990 - present
  • Ligabue Catering srl
    IT Manager, 2009 - present
  • Freelance
    1990 - present
  • ULSS 9 della Regione Veneto
    Freelance consultant, Project Management, 1990 - 2006
  • DBA Lab
    Freelance consultant, SW Development, 2006 - 2009
  • ...e qualche altra...
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Carbonera, Treviso
Previously
Treviso