Database Management Articles
SQL Sentry, a developer of software for SQL Server database professionals, has secured a $25 million growth equity investment from Mainsail Partners. The company plans to use the capital infusion to accelerate its product development, sales and marketing, and expand and enhance its client services.
Posted June 16, 2015
Attivio, which calls itself the data dexterity company, is releasing Attivio 5, the next generation of its software platform. This new solution aims to solve major issues for business intelligence by offering self-service data discovery acceleration capabilities. "We want to help companies get the data that they need to make decisions at scale and do it more comprehensibly through a self-service interface so they don't need to hire technical resources," said Stephen Baker, CEO of Attivio.
Posted June 11, 2015
The latest release of Oracle Enterprise Manager offers enhancements designed to help customers manage, migrate, test and deploy applications and databases across hybrid clouds, with reuse of existing management tools and practices, from a single pane of glass.
Posted June 11, 2015
Pentaho is now offering support for integration with SAP HANA and Amazon Elastic MapReduce (EMR). Dubbed Pentaho 5.4, available now, the solution offers new capabilities that build on a pragmatic and future-proofed platform for big data orchestration and analytics at scale.
Posted June 10, 2015
Kevin Kline, director of engineering services at SQL Sentry, Microsoft SQL Server MVP since 2004, founding board member of PASS, and DBTA columnist, is hitting the road this summer to reach cities across the country with large SQL Server user groups. The reason for the road trip is two-fold, said Kline.
Posted June 09, 2015
If you've been managing databases for any length of time, you've probably had to contend with the "noisy neighbors" scenario. In this scenario, you have several applications, each with their own database residing on a single instance of SQL Server, which don't share the resources of the server nicely. To deal with this issue, you might want to investigate Resource Governor as an alternative.
Posted June 09, 2015
There's no doubt that the new wave of nonrelational systems represents an important and necessary revolution in database technology. But while we need to avoid being wedded to the technologies of the past and continuously innovate, ignoring the lessons of history is never a good idea.
Posted June 09, 2015
The landscape for database management systems is changing more rapidly these days than it has since the earliest days of the relational DBMS. Not only do we have an onslaught of NoSQL database systems of various different forms (column, document, key/value, and graph databases), but we also see a burgeoning market for in-memory database management, where the DBMS relies on main memory instead of disk for data storage, management, and manipulation. But there is another "category" of DBMS evolving that is known as "NewSQL."
Posted June 09, 2015
The concept of shadow or stealth IT in organizations is not new, but it is a topic that is becoming more relevant. According to Gartner's IT Glossary, shadow IT "refers to IT devices, software and services outside the ownership or control of IT organizations." As IT professionals, what is our role in shadow IT? Is shadow IT good or bad for an organization?
Posted June 09, 2015
By and large, it seems like today's IT professionals belong to one of two camps: either traditional on-premises IT or the cool, new age cloud. Sometimes, it can even seem like we are talking about two different species. After all, for many of us who come from the client-server era, cloud can be intimidating. Even worse, it can be a source of real anxiety; becoming obsolete is a constant risk in an industry that evolves as fast as ours.
Posted June 09, 2015
Larry Okeson, the owner of Software Search, is retiring after 36 years of being at the helm, and will be succeeded by Caroline Okeson, his daughter-in-law and senior recruiter/branch manager for Software Search.
Posted June 09, 2015
Hitachi Data Systems Corporation (HDS), a subsidiary of Hitachi, Ltd., has completed its acquisition of Pentaho, a data integration, visualization and analytics company. According to Hitachi, Pentaho will retain its existing brand and continue to operate independently as "Pentaho, a Hitachi Data Systems company" under the leadership of its CEO, Quentin Gallivan, who will now report to Kevin Eggleston, senior vice president of Social Innovation at HDS.
Posted June 04, 2015
Data integration requirements are growing more demanding. In today's computing environments, data must often be moved between on-premises systems and public clouds, between private and public clouds, between different hybrid clouds, or between different public clouds. A new report based on a survey conducted by Unisphere Research among 342 IOUG members looks at the current state of data integration in the cloud era, including the key issues, priorities and solutions being adopted by organizations. The "2015 IOUG Data Integration for Cloud Survey" was sponsored by Oracle.
Posted June 03, 2015
New and emerging companies are taking aim at data management challenges to help customers get more value from their data. Here, DBTA showcases the approaches of 10 companies we think are worth watching.
Posted June 01, 2015
SAP has announced the cloud edition of SAP Business Suite 4 SAP HANA (SAP S/4HANA), which adds new simplification and innovations across core business functions. In addition, the new release gives customers the opportunity to deploy real hybrid scenarios — combining on-premise and cloud solutions.
Posted May 28, 2015
The Pure Storage FlashArray 400 Series is now certified by SAP as an enterprise storage solution for the SAP HANA platform. The certification enables Pure Storage to participate in SAP's program for SAP HANA tailored data center integration using its certified solution.
Posted May 28, 2015
Embarcadero Technologies, a provider of software solutions for application and database development, has unveiled the new XE7 version of ER/Studio, its flagship data architecture suite.
Posted May 28, 2015
Many DBAs are now tasked with managing multi-vendor environments, and handling a variety of data types. Increasingly, DBAs are turning to strategies such as database automation to be able to concentrate more on the big picture of moving their enterprises forward.
Posted May 28, 2015
You would have to have been living under a rock for the past few years not to have heard of Bitcoin. Bitcoin is an electronic "crypto" currency which can be used like cash in many web transactions. At time of writing there are about 14 million bitcoins in circulation, trading at approximately $250 for a total value of about $3.5 billion.
Posted May 27, 2015
The end of life date for Windows Server 2003 is July 14, 2015. While the latest version of the operating system is now 10 years old, as of last summer more than 22 million servers around the world were still running production applications. Within the next few weeks, millions of enterprise IT professionals will be forced to decide if they are going to migrate off the OS or secure a custom support contract with Microsoft to manage the end-of-life OS.
Posted May 26, 2015
BMC is rolling out BMC Database Solutions with Next Generation Technology (NGT), targeted at DB2 for z Systems to meet 24x7 infrastructure demands and reduce database management costs.
Posted May 26, 2015
Chartio, a cloud business intelligence service, is introducing a new solution called Data Stores for transforming and storing data for business intelligence in a more agile way. Data Stores will enable administrators to use Chartio's Data Pipeline to rapidly transform data and store it in the cloud, making it more useful and accessible for end users.
Posted May 20, 2015
Rosslyn Analytics, a provider of big data cloud technology, has announced it is one of the first to offer companies analytics as a service on Azure. The big data cloud analytics platform, powered by Azure, provides self-service management from source to analytics and enables business and IT users to interact with, change, and analyze data using a combination of self-service data integration, cleansing and enrichment tools and machine learning and visualization technologies.
Posted May 20, 2015
Oracle is collaborating with Mirantis to enable Oracle Solaris and Mirantis OpenStack users to accelerate application and database provisioning in private cloud environments via Murano, the application project in the OpenStack ecosystem.
Posted May 20, 2015
Oracle is shipping a new big data product called Oracle Big Data Spatial and Graph. Spatial and graph analytics has been available as an option for Oracle Database for more than 10 years, and with this introduction the company is bringing spatial and graph analytics to Hadoop and NoSQL.
Posted May 20, 2015
DataStax, which provides an enterprise distribution of Apache Cassandra, has introduced DataStax Enterprise 4.7 (DSE 4.7), which the company says, is purpose-built for the stringent performance and availability demands of web, mobile and Internet of Things (IOT) applications. The new release includes advancements to integrated enterprise search, analytics, in-memory computing, and database management and monitoring to address the increasing shift toward mixed workload deployments.
Posted May 19, 2015
The shortage of skilled talent and data scientists in Western Europe and the U.S. has triggered the question of whether to outsource analytical activities. This need is further amplified by competitive pressure to reduce time to market and lower costs.
Posted May 19, 2015
As the excitement and opportunity provided by big data tools develop, many organizations find their big data initiatives originating outside existing data management policies. As a result, many concepts of formal data governance are either intentionally or unintentionally omitted as these enterprises race to ingest huge new data streams at a feverish pace in the hope of increased insight and new analytic value.
Posted May 19, 2015
Data-driven companies continue to explore data management technologies that better unify operational, analytical, and other disparate or siloed data in a way that offers tangible business value and data management relief.
Posted May 19, 2015
The demand for effective data management is intensifying. At the same time, the database market has expanded into a wide array of solutions—from traditional relational database management systems to alternative databases such as NoSQL, NewSQL, cloud, and in-memory offerings.
Posted May 19, 2015
Data preparation is gaining considerable visibility as a distinct aspect of data management and analytics work.
Posted May 19, 2015
Just when you thought NoSQL meant the end of SQL, think again, and realize why you need to hold on to your relational database administrator like it was 1999. NoSQL has proven to be a resilient next-generation database technology for increasingly common internet-era specialized workloads. Now approaching a decade after its arrival on the scene, NoSQL is moving beyond architectural marvels to practical tools in the software development toolkit and, in that process, unveiling tried-and-true capabilities formerly known to be the scalpels of the enterprise relational database. Let's go back to the future and take a look at how the DBA is becoming as relevant as ever while NoSQL evolves for the enterprise.
Posted May 19, 2015
With the influx of big data solutions and technologies comes a bevy of new problems, according to Data Summit 2015 panelists Miles Kehoe, search evangelist at Avalon Consulting, and Anne Buff, business solutions manager for SAS best practices at the SAS Institute. Kehoe and Buff opened the second day of Data Summit with a keynote discussion focusing on resolving data conundrums.
Posted May 14, 2015
The objects and relationships identified within any database design need to match with the very subjective realities considered true within a given organization. An optimal data model must incorporate the semantics of the business and provide for a structural arrangement supporting the necessary corporate instrumentality. And that model should do so, even if in the details things within the model are contrary to what other organizations may consider to be the nature of their reality.
Posted May 14, 2015
Every now and then, somebody will raise the age-old question "How can I measure the effectiveness and quality of my DBA staff?" This can be a difficult question to answer. And it almost always hides the actual question that is begging to be asked, which is "How many DBAs do we need?"
Posted May 14, 2015
With all the cheerleading and the steady drumbeat of new features being released to Azure, it's easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality estimator (CE), underwent a large redesign for SQL Server 2014 to improve performance. Cardinality estimates are an extremely important part of query processing. In a nutshell, cardinality estimates are what the relation engine predicts for the number of rows affected by a given operation, including intermediate row sets like those created by filters, aggregations, joins and spool.
Posted May 14, 2015
RevCon is Revelation Software's conference that covers a wide array of topics on Revelation Software. Revelation Software users' conference this year focused on Revelation Software's flagship product, OpenInsight, and the new capabilities of version 10.0.
Posted May 14, 2015
Capgemini is extending its long-standing strategic partnership with SAP, allowing Capgemini to act as a single point of contact for customers globally, and delivering SAP products and support services through one consolidated framework. By signing a global value-added reseller (VAR) agreement with SAP, Capgemini is among a select group of global SAP partners that are part of the global program, which has specific entry requirements that include global reach, reseller capabilities and revenue targets.
Posted May 12, 2015
Splice Machine is partnering with Talend to enable customers to simplify data integration and streamline data workflows on Hadoop. Through this partnership, organizations building operational data lakes with Splice Machine can augment Talend's data integration technology with its data quality capabilities.
Posted May 12, 2015
IBM today announced a combined package of new servers and storage software and solutions in a move to accelerate the development of hybrid cloud computing. The company also revealed flexible software licensing of its middleware to help clients speed up their adoption of hybrid cloud environments.
Posted May 11, 2015
HP has made multiple contributions to the OpenStack Kilo release, including new converged storage management automation and new flash storage technologies to support flexible, enterprise-class clouds. HP's storage contributions to the OpenStack Kilo release focus on two strategic goals.
Posted May 11, 2015
Teradata has made enhancements to the Teradata Database's hybrid row and column capabilities to provide quicker access to data stored on columnar tables and drive faster query performance. Other relational database management systems store data tables in rows or columns, and each method offers benefits, depending on the application and type of data. However, they have been mutually exclusive. Teradata's new hybrid row and column capabilities allow the best of both worlds.
Posted May 08, 2015
Tableau's cloud analytic solution, Tableau Online, is being upgraded to version 9.0. The new release enables faster performance, and provides additional live database connection support, single sign-on, and other new features designed to help users do more with their data in the cloud. The new update brings a complete redesign of Tableau Online to deliver a faster, more scalable, resilient, and extensible platform with capabilities such as parallel queries, query fusion, vectorization and smarter query caches that will make Tableau Online as much as 10 times faster.
Posted May 07, 2015
Accenture and Oracle have launched a new business group to jointly deliver industry-specific solutions built on the Oracle Cloud, helping clients realize the benefits of the cloud faster and with reduced risk. The new group will bring solutions to market across a range of industries, with an initial focus on the public, financial and hospitality services sectors.
Posted May 06, 2015
Oracle has announced that Oracle SQL Developer version 4.1, Oracle SQL Developer Data Modeler 4.1, and Oracle REST Data Services version 3.0 are now generally available. A common theme across all three new releases is an emphasis on making developers lives easier, said Kris Rice, senior director of database tools, Oracle. "Everything revolves around the data."
Posted May 06, 2015
Oracle has introduced Oracle Secure Global Desktop (SGD) Release 5.2, the latest version of the company's secure remote access solution for cloud-hosted enterprise applications and hosted desktops running on not only Microsoft Windows, but also Linux, Solaris and mainframe servers. SGD allows users to work securely from any device and from any location, while providing administrators controlled access to applications and desktop environments resident in the data center, providing a key benefit to large companies in a BYOD world.
Posted May 06, 2015
When databases are built from a well-designed data model, the resulting structures provide increased value to the organization. The value derived from the data model exhibits itself in the form of minimized redundancy, maximized data integrity, increased stability, better data sharing, increased consistency, more timely access to data, and better usability.
Posted May 06, 2015