theQuery571 => select * from ( select piddl_content.*, piddl_contentgroups.piddlcontentgroup_id, piddl_contentgroups.piddlcontentgroup_publication, piddl_contentgroups.piddlcontentgroup_name, piddl_contentgroups.piddlcontentgroup_maxcontentcount, doc_id, doc_headline, doc_byline, doc_location, doc_pool, doc_published, doc_modified, doc_expires, doc_url, doc_section, doc_sort, doc_summary_short, doc_summary_med, doc_summary_long, doc_address, doc_image, doc_text, section_id, section_publication, section_type, section_url, section_name, section_site, section_language, doc_editor_name, webinar_master.*, case when piddlcontent_type = 'document' and section_type in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show') then doc_modified when piddlcontent_type = 'document' and (section_type is null or section_type not in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show')) then doc_published when piddlcontent_type = 'webinar' then webinar_date_begin else piddlcontent_createDate end as piddlcontent_pubdate, sub_listpublications.listpub_list from informationweek.dbo.piddl_content piddl_content left join informationweek.dbo.piddl_contentgroups piddl_contentgroups on piddlcontent_contentgroupid = piddlcontentgroup_id left join informationweek.dbo.msg_messages msg_messages on piddlcontent_keyid = msg_id and piddlcontent_type = 'message' left join informationweek.dbo.msg_threads msg_threads on msg_thread = thread_id left join doc_documents with (nolock, index(IX_doc_documents_3)) on piddlcontent_keyid = doc_id and piddlcontent_type = 'document' left join doc_sections on doc_section = section_id left join lightreading.doc_editors doc_editors on doc_documents.doc_author = doc_editors.doc_editor left join informationweek.lightreading.webinar_master webinar_master on piddlcontent_keyid = webinar_id and piddlcontent_type = 'webinar' left join informationweek.lightreading.sub_listpublications sub_listpublications on piddlcontent_keyid = listpub_id and piddlcontent_type = 'mailinglist' where piddlcontent_publication in ('darkreading') and 1=1 and piddlcontent_isActive = 1 and (piddlcontent_type <> 'document' or (piddlcontent_type = 'document' and doc_id <> '' and doc_id is not null and section_id <> '' and section_id is not null and section_visible = 1 and doc_pool in ('Public') and doc_published is not null and doc_published <= getdate() and section_language is null )) and 1=1 and piddlcontent_type in ('document') and doc_section in (311,312,314,316,317,331,335,367,443,452,478,479,480,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,513,514,515,516,517,518,519,544,609,610,611,613,617,618,649,651,654,695,702,704,706,715,716,734,741,751,753,755,757,758,759,760,764,765,766,769,771) and piddlcontent_id in (select distinct piddlcontenttag_piddlcontentid from informationweek.dbo.piddl_contenttags where piddlcontenttag_tagid in (649)) and year(case when piddlcontent_type = 'document' and section_type in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show') then doc_modified when piddlcontent_type = 'document' and (section_type is null or section_type not in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show')) then doc_published else piddlcontent_createDate end) = 2019 and month(case when piddlcontent_type = 'document' and section_type in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show') then doc_modified when piddlcontent_type = 'document' and (section_type is null or section_type not in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show')) then doc_published else piddlcontent_createDate end) = 3 ) as this_recordset order by piddlcontent_pubdate desc Business Technology News and Commentary - Dark Reading

Dark Reading is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

News & Commentary

Content tagged with Authentication posted in March 2019
What the Transition to Smart Cards Can Teach the US Healthcare Industry
Commentary  |  3/21/2019  | 
Healthcare information security suffers from the inherent weakness of using passwords to guard information. Chip-based smart cards could change that.
Stealing Corporate Funds Still Top Goal of Messaging Attacks
News  |  3/19/2019  | 
Cybercriminals focus on collecting credentials, blackmailing users with fake sextortion scams, and convincing privileged employees to transfer cash. The latter still causes the most damage, and some signs suggest it is moving to mobile.
Shifting Attacks Put Increasing ID Fraud Burden on Consumers
News  |  3/8/2019  | 
Card-present fraud is down, but attackers continue to find new strategies, and consumers are paying the price.
Debunking 5 Myths About Zero Trust Security
Commentary  |  3/7/2019  | 
Rather than "trust but verify," a zero trust model assumes that attackers will inevitably get in if they aren't already. However, several misconceptions are impeding its adoption.
4 Ways At-Work Apps Are Vulnerable to Attack
Commentary  |  3/7/2019  | 
Collaboration applications make users and IT teams more efficient. But they come with an added cost: security.
Fighting Alert Fatigue with Actionable Intelligence
Commentary  |  3/6/2019  | 
By fine-tuning security system algorithms, analysts can make alerts intelligent and useful, not merely generators of noise.
Artificial Intelligence: The Terminator of Malware
Commentary  |  3/5/2019  | 
Is it possible that the combination of AI, facial recognition, and the coalescence of global mass-hack data could lead us toward a Skynet-like future?
Startup Armor Scientific Launches Multifactor Identity System
News  |  3/4/2019  | 
Company aims to replace usernames and passwords by combining GPS location, biometrics, and keys issued through a blockchain-based network.


COVID-19: Latest Security News & Commentary
Dark Reading Staff 7/1/2020
Ripple20 Threatens Increasingly Connected Medical Devices
Kelly Sheridan, Staff Editor, Dark Reading,  6/30/2020
DDoS Attacks Jump 542% from Q4 2019 to Q1 2020
Dark Reading Staff 6/30/2020
Register for Dark Reading Newsletters
White Papers
Video
Cartoon
Current Issue
The Threat from the Internet--and What Your Organization Can Do About It
This report describes some of the latest attacks and threats emanating from the Internet, as well as advice and tips on how your organization can mitigate those threats before they affect your business. Download it today!
Flash Poll
Twitter Feed
Dark Reading - Bug Report
Bug Report
Enterprise Vulnerabilities
From DHS/US-CERT's National Vulnerability Database
CVE-2020-15478
PUBLISHED: 2020-07-01
The Journal theme before 3.1.0 for OpenCart allows exposure of sensitive data via SQL errors.
CVE-2020-6261
PUBLISHED: 2020-07-01
SAP Solution Manager (Trace Analysis), version 7.20, allows an attacker to perform a log injection into the trace file, due to Incomplete XML Validation. The readability of the trace file is impaired.
CVE-2020-15471
PUBLISHED: 2020-07-01
In nDPI through 3.2, the packet parsing code is vulnerable to a heap-based buffer over-read in ndpi_parse_packet_line_info in lib/ndpi_main.c.
CVE-2020-15472
PUBLISHED: 2020-07-01
In nDPI through 3.2, the H.323 dissector is vulnerable to a heap-based buffer over-read in ndpi_search_h323 in lib/protocols/h323.c, as demonstrated by a payload packet length that is too short.
CVE-2020-15473
PUBLISHED: 2020-07-01
In nDPI through 3.2, the OpenVPN dissector is vulnerable to a heap-based buffer over-read in ndpi_search_openvpn in lib/protocols/openvpn.c.