18 years experience
My data roots are relational.
I believe strongly in a solid, 3NF data model as the basis for most transaction-based systems.
While No...
My data roots are relational.
I believe strongly in a solid, 3NF data model as the basis for most transaction-based systems.
While NoSQL solutions have become problem-solvers in their own niche areas, the relational model is well-proven and I believe will continue to be a mainstay component option for system backing stores.
When modeling data for a relational engine, I believe that making the right choices at the data layer pays off in the long term by making your system not only more performant, but also more adaptable.
Learn the rules of 3NF! Apply them! Reap eternal rewards!
I've developed software on every major release of MSSQL since version 6.5. I'm proficient in designing, developing and debugging stored procedures and functions, ad-hoc queries, SSIS packages, and reports in SSRS.
I've used Entity Framework and LINQ extensively in my development work.