In questo articolo parleremo di Microsoft SQL Server.

SQL Server nasce inizialmente da uno sforzo congiunto di Microsoft, Sybase and Ashton-Tate che nel 1989 creano tale prodotto avente come target OS/2.

Dopo alcune vicessitudini Microsoft si smarca da Sybase e SQL Server versione 6.0 è la prima versione per Windows NT che non ha più dipendenze di copyright da Sybase.

Read More

My Big Company asked me to develop a small-sized application using C# and WebForms. The Customer was a big Italian Bank, and it asked for that technology: I was chosen because of my Java seniority, but I was zero on .NET knowledge

Read More

In questo articolo della serie SQL Server, vedremo come creare  in modo dinamico delle istruzione per impostare delle policy di sicurezza. Creeremo da zero una stored procedure chiamata sp_FixOverallGrant che in modo dinamico imposterà i profili di sicurezza per due utenze, una in lettura e scrittura (EBRB0_APP) ed una in sola lettura (EBRB0_USR).

Read More

1. Download this patch for the visual studio 2008 SP1
2. Download the documentation file from this link http://code.jquery.com/jquery-1.4.1-vsdoc.js
3. Take a rest near the Coffe machine and convert there your co-workers

Abbiamo già introdotto alcune tecnologie accessorie intorno al C++ e ad Arduino. Tra le evoluzioni più interessanti di cui vogliamo parlare oggi, c’è ne sono alcune che potremo sfruttare per Arduino, ed altre che sono meri spunti di riflessione. Andiamo ad iniziare!

Read More

LINQBridge is a re-implementation of all the standard query operators in Framework 3.5's System.Linq.Enumerable class. It's designed to work with the C# 3.0 compiler, as used by Visual Studio 2008. LINQBridge comprises a LINQ to Objects API for running local queries. (It doesn't include an implementation of LINQ to SQL, nor LINQ to XML; a good compromise can be to force Framework 3.5 out to just the server machines, allowing LINQ to SQL to be used where it's needed most).

via linqbridge - Re-implementation of LINQ to Objects for .NET Framework 2.0

There are a lot of legacy project out of there. Some customer will ask you to add a simple .NET 2.0 web service to a big application, and they will not switch to C# 3.5 for that.

Read More

Nei mesi passati ho avuto l’opportunità di lavorare come software architect per un progetto basato su .NET e C#.

Da molti anni non bazzicavo in ambito Microsoft, e quindi è stata una utile palestra. Ho pensato di scrivere questo piccolo manuale per sviluppatori java con la ventura di dover diventare… C#-enabled.

Read More

 

 Dapper is a single file you can drop in to your project that will extend your IDbConnection interface. [...]

A key feature of Dapper is performance. The following metrics show how long it takes to execute 500 SELECT statements against a DB and map the data returned to objects.

Read More

Inversion of Control (IoC) is a very good idea.

But as the clever Joel Spolsky  noted, sometimes you need to be a super-natural hero to use it:

… I try not to be judgemental (HAHA!), but I think that people who use IoC containers are (A) very smart and (B) lacking in empathy for people who aren't as smart as they are. Everything makes perfect sense to them, so they have trouble understanding that many ordinary programmers will find the concepts confusing. It's the curse of knowledge. The people who understand IoC containers have trouble believing that there are people who don't understand it. …

I have trouble using Spring in at least two projects. On the third, it was a disaster, because a single software-architect-guy keeps passing around the Spring context factory as method parameter, getting beans from it!
Read More

 Come evitare iniezione SQL: lato SQL Server (SP_EXECUTESQL)

In generale va evitato nel modo più assoluto la scrittura di query sql diamiche.

Va evitato cioè  l’uso lato SQL Server di sp_executesql e EXEC

Read More