Connect with us

E-Business

SQL Server 2016: Database for Mission-Critical Intelligence

Published

on

database.jpg
Kindly share this post

The world around us, every business and nearly every industry, is being transformed by technology.

This disruption is driven, in part, by the intersection of three trends: a massive explosion of data, intelligence from machine learning and advanced analytics, and the economics and agility of cloud computing.

While databases power nearly every aspect of business today, they were not originally designed with this disruption in mind.

Traditional databases were about recording and retrieving transactions such as orders and payments very reliably, very securely and efficiently.

They were designed to enable reliable, secure, mission-critical transactional applications at small to medium scale, in on-premises datacenters.

Databases built to get ahead of today’s disruptions do very fast analyses of live data in-memory as transactions are being recorded or queried.

They support very low latency advanced analytics and machine learning, such as forecasting and predictive models, on the same data, so that applications can easily embed data-driven intelligence.

They allow databases to be offered as a fully managed service in the cloud, in turn making it easy to build and deploy intelligent Software as a Service (SaaS) apps.

They also provide innovative security features built for a world where a majority of data is accessible over the Internet. They support 24×7 high-availability, efficient management and database administration across platforms.

They therefore enablemission critical intelligent applications to be built and managed both in the cloud and on-premises. They are exciting harbingers of a new world of ambient intelligence.

PROS Holdings, Inc., a revenue and profit realization company that helps B2B and B2C customers achieve their business goals through data science, tells us more on the tool.

Royce Kallesen, senior director of Science and Research at PROS said, “Microsoft R’s parallelization and enhanced memory management on the server integrated with SQL Server provides much faster results on a common platform with built-in security.”

They have realized over 100x faster advanced analytics using SQL Server and built-in Microsoft R Server.
 
In addition to faster analytics, the real-time in-memory processing capabilities of SQL Server are industry leading.

“This technology allows up to 100x faster analytics with updatable in-memory columnstores. In addition, as the only commercial database that leads simultaneously in both transaction processing (per the TPC-E benchmark) and data warehousing (per the TPC-H benchmark), SQL Server allows customers to realize incredible performance against massive data sets and gain real-time insights – across all workloads, new and existing applications.
 
“KPMG observed approximately 60 percent reduction in execution time and 10x table-compression gains for one of the main analytical procedures by leveraging Columnstore Indexes and Parallel Insert functions in SQL Server 2016,” said Michael S. Sellman, executive director, Global IT Services, KPMG LLP.

According to Chris Stolte, co-founder and chief development offficer of Tableau, Inc., “an average 190%+ interactive query performance improvement enables our customers to visually explore large datasets in real-time, even against transactional databases.”

With unique hybrid capabilities, any SQL Server deployment or app can span private clouds, hosted clouds and our public cloud, Microsoft Azure. New Stretch Database technology allows customers to dynamically, transparently and securely stretch their transactional data to Azure, creating a massive database with great price performance. Customers can also use new AlwaysOn Availability Groups to enable disaster recovery at low cost.

Security has never been more important, and we’re humbled to be the industry’s least vulnerable database, six years running, according to the National Institute of Standards and Technology (NIST) public security board.

Several capabilities in SQL Server 2016 help protect data at rest and in memory (Always Encrypted), encrypt all user data with low performance overhead (Transparent Data Encryption), mitigate attacks with support for Transport Layer Security version 1.2, and allow developers to build applications that restrict access and protect data from specific users with Dynamic Data Masking (DDM) and Row Level Security (RLS).

DocuSign helps organizations build entire approval workflows without a single sheet of paper or filing cabinet in sight, so security and reliability are critical, as they are with every business today.

Docusign partnered with Microsoft to help secure their customers’ data, realize insights with SQL Server analytics and BI capabilities and receive world-class support. Hear directly from their Chief Architect and Vice President of Platforms, Eric Fleischman: “With all of these capabilities built-in, SQL Server 2016 delivers not just a relational database, but an entire data platform for your business with incredible TCO.  Today customers can save up to $10 million over three years versus Oracle, running transactional, data warehouse, data integration, business intelligence and advanced analytics workloads.*

Microsoft is delivering on a vision that no other company can match across data, intelligence and cloud.


Kindly share this post

Nigeria CommunicationsWeek believes that technology makes life more exciting and helps improve the lives of people around Nigeria and indeed the world. So since 2007, we have devoted our energy to independent reportage of technology and how they affect lives.

Continue Reading
Advertisement
Comments

E-Business

Microsoft Server Hack Likely Solo Actor, Thousands at Risk

Published

on

Kindly share this post

A widespread cyberattack targeting Microsoft’s (MSFT.O) server software used by thousands of government agencies and businesses for internal document sharing was likely orchestrated by a single actor, a cybersecurity researcher said on Monday.

Microsoft Server Hack Likely Solo Actor, Thousands at Risk

Microsoft issued an alert on Saturday warning of “active attacks” on on-premise SharePoint servers.

The company clarified that SharePoint Online, part of the Microsoft 365 cloud suite, was not affected by the exploit, which is considered a “zero-day” vulnerability due to its previously undiscovered nature.

“Based on the consistency of the tradecraft seen across observed attacks, the campaign launched on Friday appears to be a single actor. However, it’s possible that this will quickly change,” Rafe Pilling, director of Threat Intelligence at Sophos, a British cybersecurity firm.

That tradecraft included the sending of the same digital payload to multiple targets, Pilling added.

Microsoft said it had “provided security updates and encourages customers to install them,” a company spokesperson said in an emailed statement.

It was not clear who was behind the ongoing hack. The FBI said on Sunday it was aware of the attacks and was working closely with its federal and private-sector partners, but offered no other details.

Britain’s National Cyber Security Centre did not immediately respond to a request for comment.

The Washington Post said unidentified actors in the past few days had exploited a flaw to launch an attack that targeted U.S. and international agencies and businesses.

According to data from Shodan, a search engine that helps to identify internet-linked equipment, over 8,000 servers online could theoretically have already been compromised by hackers.

Those servers include major industrial firms, banks, auditors, healthcare companies, and several U.S. state-level and international government entities.

“The SharePoint incident appears to have created a broad level of compromise across a range of servers globally,” said Daniel Card of British cybersecurity consultancy, PwnDefend.

“Taking an assumed breach approach is wise, and it’s also important to understand that just applying the patch isn’t all that is required here.”


Kindly share this post
Continue Reading

E-Business

Flaw in Microsoft SharePoint Sparks Global Cybersecurity Concern

Published

on

Kindly share this post

A Microsoft SharePoint server software flaw is causing widespread concern across the global cybersecurity landscape, exposing thousands of organisations to hackers exploiting a new vulnerability.

This critical vulnerability exposes government agencies, universities, and energy firms who are at risk of cyberattacks. The flaw, now being actively exploited by unidentified hackers, allows attackers to gain deep, remote access to on-premise SharePoint servers.

The U.S. Cybersecurity and Infrastructure Security Agency (CISA) has confirmed that the vulnerability can enable malicious actors to access internal files, change configurations, and even execute remote code, effectively giving them high-level control over compromised systems.

Microsoft has also acknowledged the breach and released a security patch aimed at stopping the ongoing attacks. The firm urged users to apply the patch immediately, saying it is working to roll out additional protections, according to a statement reported by Bloomberg.

Despite these efforts, cybersecurity researchers warn that systems may remain vulnerable if attackers have already infiltrated networks, stolen authentication keys, or implanted persistent backdoors before patches were applied.

The United States hosts the highest number of these vulnerable systems, followed by the Netherlands, the United Kingdom, and Canada.

The Washington Post reported that the breach has already impacted a range of institutions, including U.S. federal and state agencies, academic institutions, energy companies, and a telecommunications firm in Asia.

This latest incident adds to a growing list of cybersecurity challenges facing Microsoft. In March, the company revealed that Chinese state-backed hackers had targeted its cloud-based services to infiltrate both U.S. and international organisations.

Last year, the U.S. Cyber Safety Review Board sharply criticised Microsoft’s internal security culture as ‘inadequate’ after a separate breach compromised its Exchange Online mail systems and exposed communications of high-level officials.


Kindly share this post
Continue Reading

E-Business

NIMC Enrolls 122m for NIN, Cuts Extortion by 40 Percent

Published

on

Kindly share this post

National Identity Management Commission (NIMC) has said that it has reduced incidents of extortion and unofficial charges in the identity enrolment process by over 40 per cent.

NIMC Enrolls 122m for NIN, Cuts Extortion by 40 Percent

Abisoye Coker-Odusote, director general of NIMC,

Abisoye Coker-Odusote, director general of NIMC, who disclosed this  at an event in Lagos at the weekend, attributed the drop to improved transparency in fee structure at the commission.

The CEO was represented by Lanre Yusuf, director, Information Technology and Identity Database, NINC.

The workshop, organised by the identity regulator in partnership with the Guild of Corporate Online Publishers, focused on repositioning Nigeria’s digital identity landscape and combating misinformation.

According to Coker-Odusote, the sharp reduction in illicit charges is a direct result of reforms introduced by NIMC to curb racketeering and unauthorised payments, which have for years plagued the national identity registration process..

“Enrolment for the National Identification Number remains free. We have standardised modification and authentication fees, and these are publicly disclosed. Our enforcement of a transparent fee structure has resulted in a 40 per cent drop in extortion and unofficial charges,” the regulator said.

She explained that prior to her assumption of office, complaints about exploitative fees at enrolment centres were widespread, fuelling public distrust in the system.

However, she noted that the commission had since prioritised transparency and stakeholder accountability, ensuring that Nigerians no longer have to pay above the legally mandated fees. “We are addressing deep-rooted issues that once undermined public confidence in the enrolment process,” she said.

The NIMC chief added that the commission had introduced digital tools to reduce human interference in the registration process.

These include the NINAuth mobile app, the Self-Service NIN Enrolment and Modification app, and Contactless Biometric Solutions, all designed to make the system more efficient, secure, and user-friendly.

Coker-Odusote also reiterated the commission’s commitment to inclusion, stressing that no Nigerian should be left behind in the country’s digital identity transformation.

According to her, over 7,167 front-end enrolment agents and partners have been revalidated and retrained to serve the public professionally, with strict monitoring mechanisms now in place.

In addition, NIMC has deployed grievance redress officers across all 36 states to handle complaints from Nigerians about enrolment centres and agents, with a 24/7 toll-free line available to report any misconduct.

The reforms are part of broader efforts by the Commission to build a unified, secure, and people-centred digital identity system that facilitates access to government services, financial inclusion, social protection, and national planning.

Coker-Odusote called on media partners to support the Commission in disseminating accurate information, countering misinformation, and raising awareness about the benefits of digital identity.

“We are asking our partners in the media to help us combat fake news and promote transparency in the identity ecosystem. We need to ensure every Nigerian understands their rights and knows that their identity is key to accessing opportunities and services,” she said.


Kindly share this post
Continue Reading

Trending