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

NITDA Advocates AI, Security Integration for Sustainable Development

Published

on

Kindly share this post

Kashifu Inuwa, CCIE, the Director General of the National Information Technology Development Agency (NITDA), has emphasised that integrating intelligence, security, and sustainability is critical to driving Nigeria’s digital transformation and global competitiveness.

Inuwa made the remarks on Tuesday in Kano while delivering a goodwill message at the opening of the 19th International Conference (CONNOVATE 2025) of the Nigerian Computer Society (NCS), themed “Intelligent, Secure, and Sustainable Innovations for a Connected World.”

Represented by Engr. Salisu Kaka, Director of E-Government and Digital Economy Development, Inuwa said the three elements were now indispensable drivers of national progress. He highlighted the need for their convergence to unlock new opportunities in Nigeria’s technology sector, citing Estonia’s X-Road platform — which enables 99% of government services online — as a global model.

“In Nigeria, trust is the ultimate currency in our high-stakes digital environment, where scams and cybercrime are prevalent. Security builds and protects this trust,” Abdullahi said.

He stressed that while security provides the foundation, intelligence builds the structure, pointing to Artificial Intelligence (AI), Machine Learning (ML), and data analytics as tools for addressing Nigeria’s complex challenges. Warning that “innovation without security is unsustainable,” he likened it to “a high-performance race car without brakes.”

The DG urged the next wave of Nigerian startups to go beyond digitising existing processes to creating new value, citing AI-powered wealth management and ML-driven remote diagnostics as examples.

He further highlighted the various Federal Ministry of Communications, Innovation and Digital Economy (FMCIDE) initiatives supporting this vision, including the National Centre for Artificial Intelligence and Robotics (NCAIR), the Computer Emergency Readiness and Response Team (CERRT), the Nigeria Data Protection Act (NDPA) 2023, the national digital identity programme, interoperable payments, and human capital initiatives such as the 3 Million Technical Talent (3MTT) and Digital Literacy for All (DL4ALL) programmes.

Inuwa cited example with International Federation for Information Processing (IFIP) President, Antony Wong, that called for stronger protection and strategic use of data in the Global South to safeguard indigenous knowledge. He stressed the importance of legal clarity on data ownership as Nigeria’s cultural heritage in medicine, ecology, and art is digitised and incorporated into AI systems. Wong praised Nigeria’s role in the recent World Intellectual Property Organization (WIPO) treaty protecting genetic resources and traditional knowledge.

Delivering his welcome address, the NCS President, Dr. Muhammad Sirajo, said the conference would serve as a platform for IT professionals to address critical issues, including intelligent systems, fintech, sustainable energy, and innovations in agriculture, health, education, and national planning.

“This conference will provide an interdisciplinary platform for researchers, practitioners, and educators to present and discuss recent innovations, trends, and solutions for improving technological systems,” Sirajo said.

The week-long event includes plenary sessions, a doctoral consortium, a youth and entrepreneurship forum, the Fellows Forum, the Annual General Meeting, an IT quiz competition for students, and an induction ceremony for new members. It will conclude with the election of new national executives, a dinner, and an awards night honouring contributions to the ICT sector.

 


Kindly share this post
Continue Reading

E-Business

AfDB Adopts AI to Fast-track Africa’s Development Blueprint

Published

on

Kindly share this post

The African Development Bank (AfDB) is betting big on Artificial Intelligence (AI) as a catalyst for delivering Africa’s ambitious Agenda 2063.

With hands-on training in tools like ChatGPT and Google Gemini, the Bank believes the results could redefine how the continent plans, measures, and delivers its development goals.

Through its Joint Secretariat Support Office, the AfDB has provided technical and financial support to the 5th annual training workshop for African Union member states, focusing on the use of AI to track and implement the second ten-year plan (2024–2033) of Agenda 2063.

The five-day workshop, held in Lusaka, Zambia, was co-organised by the African Union Commission and the African Capacity Building Foundation.

Participants from across the continent rolled up their sleeves for hands-on training with emerging AI platforms like Ailyse, Google AI Studio, and Perplexity.

The goal of Africa’s multilateral development finance institution is to turn complex development data into actionable insights that can drive smarter decisions, faster interventions, and more accountable governance.

AbibuTamu, lead programme co-ordinator at the AfDB, said AI was now an indispensable tool for Africa’s future.

“These tools are not only revolutionizing how data is collected, analysed, and reported, they are also enabling more targeted policy interventions and efficient resource allocation,” Tamu told delegates.

Agenda 2063, dubbed “The Africa We Want,” is the African Union’s 50-year blueprint for inclusive growth and sustainable development. The second 10-year plan prioritises industrialisation, digital transformation, and sustainable livelihoods.

With AI now in the mix, African policymakers can track progress in real-time, spot bottlenecks before they choke projects, and reallocate resources where they are needed most.

The AfDB’s backing underscores a broader strategy of boosting both human and institutional capacity that propels African states to harness the digital revolution.

Beyond technical skills, the Lusaka workshop doubled as a peer-learning platform, with countries sharing real-world success stories on integrating AI into national planning and reporting.

“If Agenda 2063 is Africa’s long-term roadmap, this AI training is about upgrading the continent’s GPS that ensures leaders not only know the destination, but also have the intelligence to navigate every twist and turn on the way,” said Tamu.


Kindly share this post
Continue Reading

E-Business

Firm Shares Tips for Safer Remote Working

Published

on

Kindly share this post

It is holiday season in many parts of the world. These days though, going on holiday does not always mean turning your back on office life – hybrid work cuts both ways.

Today’s widespread connectivity—available at airports, train stations, restaurants, hotels, and most indoor public spaces—makes staying connected easier than ever, with free Wi-Fi in many locations and reliable 4G or 5G coverage elsewhere, helping to facilitate a seamless blend of work and leisure even while on holiday.

This increase in connectivity among travellers has not gone unnoticed by cyber criminals. Kaspersky experts analysed nearly 25,000 free Wi-Fi spots in Paris ahead of the Summer Olympic Games and Paralympic Games. The analysis revealed that almost 25% of these networks had weak or no encryption, making users vulnerable to personal and banking data theft.

Travellers often have their guard down. The unfamiliar surroundings of a new location or a different language can throw up a useful smokescreen for a cyberattack, meaning additional care needs to be taken when logging on. Fortunately, a few smart tools and habits can help you stay protected while enjoying the flexibility of remote work.

Use a VPN for secure connections

A VPN is one of the most effective ways to safeguard users’ online activity, especially when working from unfamiliar locations. By encrypting Internet traffic, a VPN ensures that hackers can’t intercept sensitive data like login credentials or financial details. This is particularly important when accessing work emails or company files on public Wi-Fi, where cybercriminals often lurk.

Switch to an eSIM for reliable, secure mobile data

Another useful digital tool that provides a seamless way to stay connected using local mobile networks with no physical SIM card required is the eSIM. This is a game-changer for international travellers who want to avoid sky-high roaming charges or the hassle of hunting down temporary SIM cards in foreign countries.

With an eSIM, a user can download a local data plan before you even arrive at your destination, ensuring instant connectivity the moment you land. This eliminates the need to rely on unsecured Wi-Fi hotspots, significantly reducing your exposure to cyber threats.

Plus, many eSIM providers allow you to manage multiple profiles on a single device, making it easy to switch between work and personal data plans without juggling multiple phones.

Services like Kaspersky eSIM Store enables users to purchase and activate data plans in advance, track usage and top up as needed, all from a single app.

Enable two-factor authentication (2FA)

When travelling, people often leave devices unattended. To protect against unwanted people logging in, travellers should ensure two-factor authentication (2FA) is enabled on all critical accounts and that passwords are used on all devices.

Final tips for a secure workation

Even with a VPN, eSIM and 2FA in place, your devices still need strong defenses against malware, phishing scams and ransomware. Cybercriminals often target remote workers who may let their guard down while travelling, making real-time protection essential.

Modern antivirus software does more than just scan for viruses, it actively blocks malicious downloads, warns you about phishing attempts and even secures your passwords and financial data.

For the most robust security, consider a solution like Kaspersky Premium, which combines antivirus protection, a VPN and password management into a single, easy-to-use package.

By combining a VPN, eSIM and strong antivirus, you can work from anywhere with confidence, whether you’re sending emails from a poolside or joining a video call from a festival tent.

 


Kindly share this post
Continue Reading

Trending