Listening to “More or Less” on Radio 4 the other day, here are the items I remember..
1.What does the statistics “Ebola is up to 90% fatal” mean?
The meaning is based on CFR (Case Fatality Rate) – the ratio of reported cases to those reported cases which are fatal. The 90% figure came from a single outbreak in the Congo.
The CFR average all outbreaks since 1976 is between 60-65%.
The CFR for the current outbreak has dropped from 54% to 52% – a bit different that 90%!
2. What does the statistics that “a quarter of guide dogs working in London had been hit by a bike” mean?
The actual numbers come from a survey done for London and of 33 guide dog owners in London who responded, 14 said they had been involved in a collision. First the sample size is very small, second the person who came up with the number admitted it might be wrong as they were not good with maths!
The program reported that there are 320 registered people with guide dogs in London and all we can say is that 14 of those have been hit i.e. at least 4%!
Database product installation FAQ update to include Cancun http://www.smooth1.co.uk/installs/dbinstalls.html.
Also Cancun New Features document started http://www.smooth1.co.uk/db2/cancun.html
Database product installation FAQ http://www.smooth1.co.uk/installs.html
Currently SQL Server,DB2 10.5,Oracle 184.108.40.206,SAP ASE 16.0,Informix 12.10.FC4
DBA Survivor – Become a Rockstar DBA .
All DMVs are under sys schema.
Wait stats for memory
Wait stats for CPU
Documented at http://msdn.microsoft.com/en-us/library/hh212945.aspx
Securing the Tabular BI Semantic Model whitepaper http://msdn.microsoft.com/en-us/library/jj127437.aspx
Securing your tabular model http://blogs.msdn.com/b/cathyk/archive/2011/11/21/securing-your-tabular-model.aspx
Getting started with Tabular Model in SQL Server 2012 http://www.mssqltips.com/sqlservertip/2821/getting-started-with-tabular-model-in-sql-server-2012–part-1/
Roles (SSAS Tabular) http://msdn.microsoft.com/en-us/library/hh213165.aspx – includes row filters and dynamic security.
Perspectives – like views http://msdn.microsoft.com/en-us/library/hh230816%28v=sql.110%29.aspx
BISM – Tabular Security Model http://paultebraak.wordpress.com/2011/09/04/bism-%E2%80%93-tabular-security-model – more on row filters.
Implement Dynamic Security by Using Row Filters http://msdn.microsoft.com/en-us/library/hh479759%28v=SQL.110%29.aspx
SQL Server 2014 Buffer Pool Extension onto SSD – http://www.smooth1.co.uk/sqlserver2014/bpe_ssd.html
Informix 12.10.xC4 is out! http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.po.doc/new_features_ce.htm … Limit session locks and use multi-tenant databases!