I’m itching to dig more into the SQL Server 2016 optimizer enhancements, but I’m going to complete my comparison of indices between the two platforms before I get myself into further trouble with my favorite area of database technology. <–This is sooo me. Index Organized Tables Index Organized Tables, (IOT) are just another variation of a primary b-tree index, but unlike a standard table with an index simply enforcing uniqueness, the index IS the table. The data is arranged in order to improve performance and in a clustered primary key state. This is the closest to a clustered index in SQL…
-
-
I make some odd New Year’s Resolutions and mine for 2017 was to add some smart home solutions to our home that made sense. I’ve seen what can happen if you don’t plan these types of projects out well, (looking at you, Mark Rittman!) and the insanity that ensues! The following smart home goals were made: Main lights Prime power outlets thermostat music center Roku/TV The following technology would be used to accomplish the goals: Echo Dot, (3) Phillips Hue Bridge, (2) and lightbulbs, (8) TP-link smart plugs, (2) Ecobee Lite 3 Thermostat Raspberry Pi and Python Code The Echo…