Interesting Snippets from 2015-12-03

• HyperLogLog in Pure SQL

  The HyperLogLog Probabilistic Counter is an algorithm for determining the approximate number of distinct elements in a set using minimal RAM. Distincting a set that has 10 million unique 100-character strings can take over gigabyte of RAM using a hash table, while HyperLogLog uses less than a megabyte (the "log log" in HyperLogLog refers to its space efficiency). Since the probabilistic counter can stay entirely in RAM during the process, it's much faster than any alternative that has to write to disk and usually faster than alternatives using a lot more RAM.

• The Ultimate list of Top SQL Monitoring Tools

  Because SQL Monitoring is a vast domain and includes many areas of database monitoring and management, we have searched and compiled a list of SQL monitoring tools nearly in every niche and need. From automatic monitoring, performance management, instant alerts to configuration management , this list contains the best SQL Monitoring tools you need for on-premises Microsoft SQL Server instances to SQL Azure databases.

[/snippets] permanent link