The Opportunity Earlier this year I received an email from Jonathan Gennick, an editor at Apress books. The subject of the email was “Tech edit a book” and he asked if I was familiar with SQL Server on Linux. I excitedly replied “yes…I think I’m your guy for this”. In 2017, I had the opportunity to tech edit another book on SQL Server on Linux and had to back out of that project and this was a fantastic second chance to still be able to work on a topic I really want to participate in and help move forward.
In-Memory OLTP – a potential game changing technology Every once in a while a technology comes out that has the potential to change things dramatically. In-Memory OLTP (Hekaton) is one of them. The design team set out with a goal of reaching an order of magnitude improvement over existing technologies and techniques. To do so they had to rethink key facets of the relational database system, latching, locking, logging and statement compilation.
Here are my unedited chapter notes: Chapter 1 Chapter 2 Collation – current version requires BIN2 on character index columns. Best to do so at the column level. Supports only sorting, comparison and grouping. Will remove the need for case sensitive code on tables and columns but not data. Collate database_default to handle tempdb collation of temp objects. Research more. Interpreted SQL via interop useful for ad hoc or migration of code.
Via Twitter in October Benjamin Nevarez @BenjaminNevarez solicited help for book reviewers for his new book “Microsoft SQL Server 2014 Query Tuning & Optimization” I jumped at this opportunity as Benjamin is a great author with significant SQL Server experience and this new book further solidifies his place in the community. Query processing and its inner workings are extremely dense technical concepts that Benjamin is able to present to the reader in a very approachable readable manner.
Well, this is my first blog post…I’ve said I was going to do this for a long time and it’s finally here. Via Twitter a in October Benjamin Nevarez @BenjaminNevarez solicited help for book reviewers for his new book “Microsoft SQL Server 2014 Query Tuning & Optimization” I jumped at this opportunity two reasons, first Benjamin is an exceptional author and two I want to start contributing to the community. I feel that reviewing books can help others decide on how to spend their valuable time and hard earned money.