Understanding published statistics.

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%!


DB2 10.5 Fixpack 4 Cancun.

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

Database product installation FAQ http://www.smooth1.co.uk/installs.html

Currently SQL Server,DB2 10.5,Oracle 12.1.0.2,SAP ASE 16.0,Informix 12.10.FC4


Currently reading…

 

DBA Survivor – Become a Rockstar DBA .

http://msdn.microsoft.com/en-us/library/ms191246(v=sql.120).aspx

All DMVs are under sys schema.

http://msdn.microsoft.com/en-us/library/ms188754.aspx

http://msdn.microsoft.com/en-us/library/ms179984.aspx

Wait stats for memory

- CMEMTHREAD

- LATCH_*

- LCM_M_*

- LOWFAIL_MEMMGR_QUEUE

- RESOURCE_SEMAPHORE_*

- UTIL_PAGE_ALLOC

Wait stats for CPU

- CXPACKET

- EXCHANGE

- EXECSYNC

SQL Profile

http://msdn.microsoft.com/en-us/library/ms175481.aspx

http://msdn.microsoft.com/en-us/library/ms190762.aspx

http://msdn.microsoft.com/en-us/library/ms190793.aspx

 


SQL Server 2012 Tabular Data Model

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

(DMV Question)

https://www.linkedin.com/groups/Is-there-DMV-find-all-66097.S.5895157457688211456?view=&item=5895157457688211456&type=member&gid=66097&trk=eml-b2_anet_digest-group_discussions-8-grouppost-disc-0&midToken=AQH48zvduqwTWw&fromEmail=fromEmail&ut=0zOeU5w-MNxCk1


SQL Server 2014 Buffer Pool Extension onto SSD.

SQL Server 2014 Buffer Pool Extension onto SSD – http://www.smooth1.co.uk/sqlserver2014/bpe_ssd.html


Informix 12.10.xC4 is out!

Informix 12.10.xC4 is out! Limit session locks and use multi-tenant databases!


Follow

Get every new post delivered to your Inbox.