by andrew novick | Nov 16, 2020 | SQL coding
It’s time to mail your holiday cards. Whether it’s Christmas, New Years, Chanukah, or something else, there are going to be billions of cards sent in the next few weeks. One of the tasks that my wife and I face each year is getting all the addresses...
by andrew novick | Dec 1, 2016 | SQL coding, SQL Performance, Talks and Seminars
in-memory-tables-with-natively-compiled-t-sql-blazing-speed-for-oltp-and-more The SQL Server 2014 and 2016 Hekaton project brings us In-Memory tables and Natively Compiled T-SQL objects that run at amazing speed. What you can accomplish is astounding. This...
by andrew novick | Sep 19, 2016 | Past Events, Presentations, SQL coding, Uncategorized
Download the presentation: entity-attribute-value-eav-the-antipattern-too-great-to-give-up-andy-novick The Entity-Attribute-Value (EAV) is a design pattern for relational databases that uses an extreme form of normalization to achieve flexibility and the ability to...