Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Monday, July 24, 2017

Speaking @ PASS Summit 2017

SQLblog.com - The SQL Server blog spot on the web
Speaking @ PASS Summit 2017

After years and years talking about Business Intelligence and Business Analytics, this year at PASS I’ll be speaking about Application Development and how to make the best use of the data platform that Microsoft created so far.

I’ve started talking about the impedance mismatch at the beginning of my career and now, after 15 year of Business Intelligence, Big Data, Analytics, Data Warehousing, I’m back talking about it again, but this time there is a new amazing approach to the problem: microORM.

MicroORM are ORM that only take care of one thing: mapping database result-set to classes and nothing more. I love the idea because it allows developers and DBAs to leverage all the power of RDBMS whilst, at the same time, remove all the boring and error-prone plumbing code. As Van Halen said, it is just the “Best of Both Worlds”.

As a result, MicroORM are, in my opinion, just perfect in a Micro-Services scenario. They make things simple, but not simpler, while preserving performance and making a developer just more productive (give that he/she must know how to query a database, something that is mandatory IMHO).

More specifically I’ll talking about Dapper.NET a microORM I’ve learned to love in the last years, and that I use everyday:

Dapper: the microORM that will change your life

ORM or Stored Procedures? Code First or Database First? Ad-Hoc Queries? Impedance Mismatch? If you're a developer or you are a DBA working with developers you have heard all this terms at least once in your life…and usually in the middle of a strong discussion, debating about one or the other. Well, thanks to StackOverflow's Dapper, all these fights are finished. Dapper is a blazing fast microORM that allows developers to map SQL queries to classes automatically, leaving (and encouraging) the usage of stored procedures, parameterized statements and all the good stuff that SQL Server offers (JSON and TVP are supported too!) In this session I'll show how to use Dapper in your projects from the very basis to some more complex usages that will help you to create *really fast* applications without the burden of huge and complex ORMs. The days of Impedance Mismatch are finally over!

See you at PASS 2017!

No comments: