Database Management Articles
Redgate Software is further developing its SQL Search tool to integrate with Microsoft SQL Operations Studio. SQL Search is a popular tool Redgate developed and the version for SQL Server Management Studio and Visual Studio 2017 has been downloaded more than half a million times.
Posted May 10, 2018
Offered in partnership with Rackspace, Couchbase Managed Cloud is a fully-managed database service that allows IT teams to solve cloud and database infrastructure challenges and to reallocate resources toward business initiatives that drive growth. With Couchbase Managed Cloud, Couchbase combines powerful NoSQL technology with the capabilities and expertise of Rackspace, which provides transformation as a service across applications, data, security, and infrastructure, to deliver a single solution for a unified customer experience.
Posted May 10, 2018
Confluent, a provider of a streaming platform based on Apache Kafka has announced the Confluent Operator, an enterprise-grade solution to provision and manage Apache Kafka on Kubernetes for scalability and deployment flexibility. This enables enterprises to deploy Kafka as a cloud-native application on Kubernetes to simplify provisioning, automate management, and minimize the operating burden of managing Kafka clusters.
Posted May 10, 2018
NGINX will now support its NGINX Application Platform on Red Hat Enterprise Linux and Red Hat OpenShift Container Platform, allowing customer to better manage and scale their applications. Red Hat has emerged as a static provider of Linux, Linux containers, and Kubernetes as foundational technologies that provide applications with portability, enhanced security, and cloud-like efficiencies.
Posted May 09, 2018
Organizations worldwide are grappling with the requirements of the European Union's General Data Protection Regulation (GDPR) and it's no secret that finding ways to remain compliant has become one of the most visible challenges, and one that has dominated the conversation. What's more pertinent; however, is the root of the problem: outdated systems which organizations use to track and understand where their data lives. This has grown more difficult day-by-day, as the amount of data collected by organizations grows exponentially. GDPR is a good forcing function to spur them to dig into this problem before it gets worse.
Posted May 08, 2018
Agile approaches to projects have been touted by many organizations across the globe. IT shops frustrated over expensive projects falling well shy of their goals have been desperate for change. These anxious organizations race into trying Agile as a solution to their woes.
Posted May 08, 2018
The relational optimizer is a very complex component of the RDBMS that we too often take for granted. The optimization techniques of the major RDBMS products continue to be improved with every new release, too. Relational optimization has saved countless hours of work and, as long as we use it properly and code our applications with knowledge of what optimization can do, the RDBMS can be used for a wide variety of requirements and use cases. Don't lose sight of that as you wend your way through the hype out there regarding new types of database systems.
Posted May 08, 2018
To provide customers with the tools and insight to meet rapidly evolving business demands, Oracle NetSuite has introduced an intelligent cloud suite. By building capabilities based on artificial intelligence (AI) and machine learning (ML) within its cloud business management suite, Oracle says, NetSuite can deliver the insight, interaction and automation customers need to grow their businesses.
Posted May 07, 2018
We're all familiar with the IT "war room" scenario. When there's an issue, members of the IT team come together to troubleshoot and find a solution. For organizations with important applications, such as SQL Server running in virtual infrastructures, these IT teams are no strangers to the IT war room environment. In this case, input from the SQL Server system administrators and DBAs isn't considered (or even requested) when the infrastructure team implements it virtualization plan.
Posted May 07, 2018
Push Technology, a real-time intelligent data streaming and messaging provider, is releasing Diffusion Intelligent Data Platform version 6.1, introducing data lifecycle management and ownership functions. The new functions further simplify and reduce development time for companies building mission-critical business applications.
Posted May 04, 2018
The impact of cognitive computing technologies—including artificial intelligence (AI) and machine learning (ML)—is increasingly being felt in data centers and database operations of all sizes, across all industries. Research shows that AI and related cognitive technologies are no longer just experiments conducted by computer or data scientists—they are part of a real-world technology wave that is already showing tangible business results.
Posted May 02, 2018
GDPR has gone into effect. Rex Ahlstrom, chief strategy and technology officer at BackOffice Associates, a provider of information governance and data stewardship solutions, discussed what's at stake.
Posted May 01, 2018
Recently, the revised Markets in Financial Instruments Directions (MiFID II) launched in the EU. The sweeping regulatory changes will impact transaction reporting on all financial instruments traded in Europe and affect all U.S. firms that do business with European counterparts or customers. Firms will face new requirements in tracking data—including emails, texts, and documents related to every transaction—and will need to be able to quickly reconstruct trades and search across data silos, presenting a significant challenge. Here, Ken Krupa, CTO at enterprise database company MarkLogic, discusses the impact to U.S. firms, and how new regulations underscore the importance of increasing transparency, consumer protection, and data integrity.
Posted April 30, 2018
erwin has introduced the next generation of erwin DM NoSQL, which supports native integration with the Couchbase Data Platform for new enterprise applications and legacy RDBMS-based migrations. With this integration, erwin DM NoSQL provides native (non-relational) data modeling for document databases, automating the creation of platform-specific deployment scripts, to strengthen data governance. It also helps reduce the risks and costs associated with new platform adoption and accelerates the time-to-value, the company says.
Posted April 30, 2018
SentryOne has acquired Pragmatic Works Software (PWS), a provider of solutions for developing, testing, documenting, and monitoring the Microsoft Data Platform. According to SentryOne, the addition of the PWS product suite gives it a comprehensive offering for the Microsoft data professional, both on premises and in the cloud.
Posted April 30, 2018
With the General Data Protection Regulation (GDPR) deadline quickly approaching in May, many organizations are scrambling to get their customer information systems in order to meet the requirements. Any company that collects and processes the personal data of European citizens and residents—whether it is names, IP addresses, photos, videos, health and biometric info, or other types of data—will be impacted.
Posted April 26, 2018
For enterprises storing sensitive data in the cloud, an enhanced security strategy is key to monitoring and protecting that data. In fact, according to Oracle research, 40% of respondents say that detecting and responding to cloud security incidents is now their top cyber security challenge. As part of efforts to address this concern, four in 10 companies have hired dedicated cloud security architects, while 84% say they are committed to using more automation to effectively defend against sophisticated attackers.
Posted April 26, 2018
HCL Technologies (HCL), along with Sumeru Equity Partners (SEP), a technology and growth-focused private equity firm, have signed a definitive agreement to acquire Actian Corporation. The all-cash deal is valued at $330 million.
Posted April 26, 2018
An astounding array of new technologies and approaches have emerged on the database scene over the past few years that promise to turn the next 12 months into a time of unprecedented transformation for the database landscape. There are new developments, along with reinforcement of tried-and-true technologies, some of which may help make the jobs of data managers just a bit easier.
Posted April 25, 2018
IBM saw growth in just about all of its business sectors, including mainframe and midrange-class sales in the first quarter of 2018. Overall systems revenues—including systems hardware and operating systems software—were $1.5 billion, up 8%, driven by growth in IBM Z and Power, the company reported.
Posted April 23, 2018
DBAs can recover a database, tune SQL, and may even know how to write some PL/SQL when push comes to shove. And, yes, those are all great skills to have. But in 2018, DBAs need more, writes Matt Malcheski in a new IOUG SELECT article. Malcheski goes over the "hot topics," including blockchain, AI, and Internet of Things, and notes that DBAs of the future will need to understand not only the technical aspects of these and the other technologies but also must be able understand and add value to the functional data requirements necessary for all-encompassing solutions. "This is characterized in a data point from Gartner: By 2021, 40% of IT staff will be 'versatilists' holding multiple roles, most of which will be business rather than technology related."
Posted April 18, 2018
Hitachi Consulting, a subsidiary of Hitachi, Ltd., a Platinum level member of Oracle PartnerNetwork (OPN), and provider of consulting-led solutions and services, has been named an OPN Cloud Elite partner. Joining a small number of Oracle partners who have attained this designation, Hitachi Consulting earned the status by achieving a set of criteria that demonstrate its full investment in Oracle Cloud solutions.
Posted April 18, 2018
As the volume and complexity around data grows, it has become more critical than ever for organizations to develop a deep knowledge of their business context and to understand and quantify the value of that data.
Posted April 18, 2018
NuoDB, the elastic SQL database company for hybrid cloud applications, is releasing NuoDB Insights, a graphical dashboard of database and system metrics to help users understand the overall health of their distributed database domain. Customers can use this information to make decisions about how to optimize and troubleshoot their NuoDB database, its processes, and its associated resources.
Posted April 17, 2018
DataStax, provider of a distributed cloud database built on Apache Cassandra, has introduced DataStax Enterprise 6 (DSE 6). DSE 6 allows customers to maintain hybrid cloud flexibility with the benefits of a distributed cloud database on any public cloud or on-premises. This new release also increases performance for both reads and writes, which is critical for high-volume data ingestion requirements. With double the performance of Apache Cassandra, DataStax says, DSE 6 delivers twice the responsiveness and the ability to handle twice the throughput on the same infrastructure.
Posted April 17, 2018
Priority Software Ltd., a provider of ERP solutions, is releasing Priority v18.2, enhancing system openness and mobile capabilities, introducing a new document generator, and boosting support for regulations compliance.
Posted April 12, 2018
Couchbase has announced the latest release of its product for mobile data management, Couchbase Mobile 2.0. Available today, the new release offers enterprise developers SQL queries, full-text search, synchronization, and end-to-end security among other features to easily mobilize business applications to create exceptional customer experiences and a more effective workforce.
Posted April 12, 2018
For data architects, it is not unusual to use a data modeling tool to reverse-engineer existing solutions' databases. The reverse-engineering could occur for a functional reason, such as gathering information to evaluate a replacement option, or to comprehend a solution, seeking to work out what data should be extracted for a downstream business intelligence need.
Posted April 12, 2018
Women's issues have headlined the news media for the past several months. Many stories, ranging from the #MeToo movement to the "Brogrammer" email blast at Google, have shown that women in technology (WIT) face negative work conditions and social pressures. In light of that, it seemed appropriate to dive into the topic of WIT within the SQL Server community (aka, the Data Platform community) and gauge where we're at.
Posted April 12, 2018
Data lake is a newer IT term created for a new category of data store. But just what is a data lake? According to IBM, "a data lake is a storage repository that holds an enormous amount of raw or refined data in native format until it is accessed." That makes sense. I think the most important aspect of this definition is that data is stored in its "native format." The data is not manipulated or transformed in any meaningful way; it is simply stored and cataloged for future use.
Posted April 12, 2018
Bitcoin was the hot topic in financial and tech circles in 2017. The decentralized digital currency jumped from just under $1,000 at the start of the year to a $20,000 all-time high in December. The real game-changer here isn't Bitcoin, though, but the technology that powers it, known as blockchain. Despite volatility and suspicion marking the crypto-market, the blockchain concept could be a truly revolutionary innovation.
Posted April 12, 2018
IBM has launched three new consulting services offerings, as well as an IBM Blockchain Platform Starter Plan, a low-cost plan to help clients, developers, and startups to develop, operate, and govern networks on the IBM Blockchain Platform.
Posted April 11, 2018
MicroStrategy, a provider of enterprise analytics and mobility software, is releasing an enhanced version of its flagship software, boosting mapping capabilities and more. Version 10.11 introduces new out-of-the-box visualizations, intelligent recommendations for content, prompts for dossiers, a native MicroStrategy Library app for smartphones, and more.
Posted April 10, 2018
SentryOne has launched new professional services offerings aimed at helping companies save time and resources in resolving SQL Server performance issues. While SentryOne has always offered service to customers who needed to supplement their internal structure with a deeper level of expertise in deploying monitoring tools, Pro Services formalizes the different levels of engagement options and provides access to the company's database administration experts, said Scott Brooks, SentryOne vice president of customer success.
Posted April 10, 2018
NGINX, Inc. is releasing new capabilities and major enhancements to its Application Platform - an integrated suite of software technologies that simplify the adoption and deployment of microservices.
Posted April 09, 2018
ASG Technologies, a provider of solutions for information access, management, and control for the has introduced ASG-TMON Performance Analyzer (TMON PA) 11.0 to help organizations better manage IT resource performance and costs while intelligently planning for the future.
Posted April 09, 2018
GridGain Systems, provider of enterprise-grade in-memory computing solutions based on Apache Ignite, is launching GridGain Professional Edition 2.4, including a Continuous Learning Framework. The addition of this framework in the latest update includes machine learning and a multilayer perceptron (MLP) neural network that enable companies to run machine and deep learning algorithms against their petabyte-scale operational datasets in real-time.
Posted April 05, 2018