Database Management Articles
In addition to StretchDB and AlwaysEncrypted, there are two more exciting features in the works for SQL Server 2016: dynamic data masking and row-level security. In the case of these two features, they'll be released first to the cloud platform (Azure SQL Database) and, later, to the on-premises version of SQL Server.
Posted December 08, 2015
It's commonly asserted—and generally accepted—that the era of the "one-size-fits-all" database is over. We expect that enterprises will use a combination of database technologies to meet the distinct needs created by various application architectures.
Posted December 02, 2015
As a DBA, establishing a reasonable backup schedule for your databases can be a challenging project. It requires you to balance two competing demands: the need to take image copy backups frequently enough to assure reasonable recovery time, and the need to not interrupt daily business. The DBA must be capable of balancing these two objectives based on usage criteria and the capabilities of the DBMS.
Posted December 02, 2015
Moving infrastructure, databases, or software into the cloud is no longer a bleeding edge decision. Many organizations have implemented this successfully with great benefits, and more continue to do so. It was not that long ago that we started learning about cloud technologies and capabilities. Technologists listened to webinars and read about the possibilities of such a paradigm shift with cynicism. It sounded great, but what about the practicalities, cost, and risk? The only organizations that seemed to embrace this new landscape were technology companies, while the rest of us stood on the sidelines watching and, on occasion, snickering. We thought nothing would ever replace our data centers. It appears we were wrong … it's time to embrace the paradigm shift.
Posted December 02, 2015
Database performance tuning is a complex but extremely important task. However, it can be difficult to effectively optimize databases when there are other "fires" to put out, limited resources, and an increasing number of databases to look after. But that doesn't mean it's impossible, especially with the right approach.
Posted December 02, 2015
It is often said that the only constant is change. For data executives and professionals, the coming year will only bring a lot more of it. Developments as diverse as cloud, big data, real time, NoSQL, analytics, and the Internet of Things (IoT) will continue to reshape enterprise data operations and opportunities as we know them. Here are 16 trends that will shape the enterprise data landscape in 2016.
Posted December 02, 2015
There's no question that the pace of data movement has quickened dramatically in recent years. This calls for new strategies for integrating data at the speed of business. That is the challenge as companies increasingly rely on data analytics in their decision making. In a new survey, a majority of managers and professionals (57%) state their business leaders now rely heavily on analytics in their day-to-day decision making. The survey, covering 303 data managers and professionals and conducted by Unisphere Research, a division of Information Today, Inc., finds that organizations are employing a range of new strategies and approaches to improve the speed of data delivery and integration. The survey, among members of the Independent Oracle Users Group (IOUG), and sponsored by Oracle, included respondents from organizations of all sizes and across various industries.
Posted December 02, 2015
Hewlett Packard Enterprise (HPE) has introduced HPE Synergy, a platform designed to run both traditional and cloud native applications in a hybrid infrastructure. HPE Synergy leverages fluid resource pools, software defined intelligence and a unified API to provide the foundation for organizations to continually optimize the right mix of traditional and private cloud resources.
Posted December 01, 2015
EnterpriseDB, a provider of enterprise Postgres products and database compatibility solutions is expanding its partnership with Hewlett Packard Enterprise (HPE) to enable HPE to resell and support EDB Postgres database and tools software and services worldwide. With the newly expanded agreement, HPE sales representatives will resell EDB's database subscriptions, training, consulting and bundled services such as EDB's RemoteDBA and Database Migration Assessment.
Posted December 01, 2015
With heightened SEC, FINRA, IIROC and FCA regulatory scrutiny within financial services firms, Actiance is releasing expanded supervisory capabilities for Alcatraz, its cloud-based archive platform. "Our company is really focused around regulatory compliance and helping organizations to get control of various channels that are being used for communications," said Robert Cruz, senior director of information governance at Actiance.
Posted November 23, 2015
Cirba Inc., a provider of software-defined infrastructure control solutions, released integration to EMC ViPR SRM, enabling organizations to optimize use of storage resources through smarter workload placements and visibility into storage health. The new integration adds to Cirba's existing support for placing workloads and optimizing infrastructure considering datastore requirements and physical storage resources managed by NetApp OnCommand Insight (OCI), announced in August 2015.
Posted November 23, 2015
SAP SE is now enabling customers to deploy and consume SAP Fiori apps across both on premise and cloud architectures to deliver superior mobile app performance. By introducing these new options, customers will have the ability to choose the deployment model which best suits their business environment and ensures a secure and rapid deployment option for SAP Fiori apps.
Posted November 18, 2015
CloudBerry Lab, a provider of backup and management solutions for cloud storage services, has introduced CloudBerry Backup for Oracle Database, which enables backups to be easily stored in the Oracle Database Backup Cloud with a data restore capability. "We've heard a lot from customers about the need for a purpose-built solution to back up Oracle databases directly to an Oracle Database Backup Cloud," said CloudBerry Lab CTO Alexey Serkov.
Posted November 18, 2015
The PASS Summit 2015, the largest conference in the Microsoft SQL Server world, was held in October in Seattle, WA. The event provided a look at key initiatives that Microsoft's SQL Server group has been working on and a glimpse of what's ahead for the future.
Posted November 18, 2015
Clearlake Capital Group, L.P. has completed the acquisition of Syncsort. "Our organic product investments and related software acquisitions over the last couple of years have been singularly focused on one of the most important secular growth opportunities in the technology industry today: demand for software that liberates data and existing budgets for use in advanced machine learning and business intelligence systems," said Lonne Jaffe, CEO of Syncsort.
Posted November 18, 2015
Splice Machine is releasing a new update to its relational database platform that will combine the power and flexibility of Hadoop and Spark. "Our version 2.0 takes our first version which scaled out on the Hadoop stack. Now, we are adding a new computation engine on HBase which is Spark," said Monte Zweben, co-founder and CEO of Splice Machine. "The benefit is that someone can use us as a regular SQL database management system and we will automatically take their queries and forward them to the proper computational engine for fast transactional types of updates."
Posted November 17, 2015
TIBCO is introducing two tools that extend beyond automation and into the realm of digitalizing businesses with the release of TIBCO Simplr and TIBCO ActiveMatrix BPM 4.0. "This is our first focus on the everyday user to help people build processes to automate some of the routine things they might do," said Brad Topliff, director of product marketing at TIBCO.
Posted November 17, 2015
Not too long ago, large volumes of information were available only to the select few organizations able to afford the expensive IT infrastructure to collect, store, manage, and analyze it—the big-budget companies with seemingly bottomless pockets, or the professional research services that built empires on collecting and interpreting data. But now, through the realized effects of Moore's law, along with the consumerization of BI tools, this data is increasingly available to everyone—and without having to dig deep into budgets or employ robust IT departments.
Posted November 13, 2015
As the business value of big data increases, vendors are offering cloud-hosted big data technology, known as big data as a service (BDaaS). Why choose BDaaS instead of on-premises deployments? Do you lack internal IT expertise in big data? Is the upfront cost for a cluster an issue? Or do you not have the luxury of time to build a cluster? These are all important questions when considering BDaaS.
Posted November 13, 2015
At Oracle OpenWorld each year, there are significant announcements about Oracle products and insight provided on key areas of focus for the future. Melissa English, president of the Oracle Applications Users Group (OAUG), recently reflected on some of the key developments at the 2015 OpenWorld conference and their relevance for OAUG members. In particular, said English, "Oracle's announcements about continuing to support on-premises apps for the next 10 years and beyond are significant."
Posted November 12, 2015
Dell expanded its PowerEdge 13th generation servers with the introduction of four new entry-level servers that provide greater performance, flexibility and efficiency for small and midsize businesses (SMBs). The latest Dell PowerEdge servers are designed to address the top IT pain points of SMBs which Dell says are performance, hardware capacity, and IT complexity. The new Dell PowerEdge servers include the PowerEdge R330 and R230 rack servers and the PowerEdge T330 and T130 tower servers.
Posted November 11, 2015
There are many different ways to look at database administration. It can be done by task, by discipline, by DBMS, by server, and so on. But one useful way to look at database administration is in terms of the type of support being delivered to applications. You can paint a broad brush stroke across the duties of the DBA and divide them into two categories: those that support development work and those that support the production systems.
Posted November 09, 2015
The DBA's role is becoming increasingly complex and now often involves managing data both on premise and in the cloud, and in a variety of database management systems including not only traditional relational systems such as Oracle, SQL Server, MySQL and others, but also new open source and NoSQL technologies, according to Gerardo Dada, vice president of product marketing, at SolarWinds.
Posted November 09, 2015
Oracle has announced that the new Oracle Exadata Database Machine X5-8, the latest in the X5 family of engineered systems which integrate hardware and software, is now available. The new Exadata X5-8 offers up to 576 CPU cores, more than 1.3 petabytes of disk storage or 180 terabytes of PCIe flash, and up to 24 terabytes of memory. The Oracle Exadata X5-8 is the new companion model to Oracle Exadata X5-2 and incorporates the same storage and networking capabilities of Oracle Exadata X5-2, which was announced in January 2015.
Posted November 04, 2015
To kick off Oracle Open World 2015, Oracle's annual user conference at the Moscone Center in San Francisco, CTO and executive chairman Larry Ellison detailed the steps that led Oracle be positioned in "every layer of the cloud." Ellison outlined the top design goals for the company in all three layers of the cloud - SaaS, PaaS and IaaS. These are cost, reliability, performance, standards, compatibility - as well as security, which he said is increasingly becoming a more critical concern.
Posted November 04, 2015
MongoDB is releasing an enhanced version of its platform, giving the company the opportunity to expand its capabilities to more users. "We're opening up MongoDB to a bigger audience in the enterprise, which is to say that traditionally the people that have used MongoDB were developers building modern applications and, with this release, we are building specific tools and capabilities targeted at data scientists, business analysts, and the C suite in terms of integration to business intelligence and visualization tools," said Kelly Stirman, vice president of strategy and product marketing at MongoDB. "We're also expanding MongoDB to DBAs and operations teams with specialized interfaces that make it easier to run MongoDB at any scale."
Posted November 03, 2015
Until the safe harbor agreement between U.S. and Europe was ruled invalid recently in a European court, it was understood that for any European company the U.S. was safe, and the data security in the U.S. was acceptable. But the recent ruling by the European Court of Justice says that is "actually not true," said Andreas Gauger, chief marketing officer and cofounder of Profitbricks, a cloud computing IaaS company. Now, a new agreement will have to be forged between the different entities. "Now that band-aid has been ripped off and the wound is open. Now they have to sit down and finally agree on something."
Posted October 28, 2015
There's unrelenting pressure on businesses to compete on analytics and to be able to anticipate customer needs and trends ahead of the curve. Enterprises are looking to expand BI and analytics capabilities as far and wide as technologies and budgets will allow them to go. As a result, the continuing advance of analytic capabilities across the enterprise has reached a "tipping point."
Posted October 28, 2015
Oracle has announced new services - Oracle Big Data Preparation Cloud Service, Oracle GoldenGate Cloud Service, Oracle Big Data Discovery Cloud Service and Oracle NoSQL Database Cloud Service - that complement Oracle's Big Data Cloud Service and Big Data SQL Cloud Service, to form a comprehensive portfolio of solutions for big data in the cloud.
Posted October 28, 2015
During the Sunday keynote presentation at Oracle OpenWorld, Oracle CEO Mark Hurd and Brian Krzanich CEO, Intel, introduced the new Exa Your Power Program to help customers migrate Oracle Database from IBM Power systems to Oracle Engineered Systems using Intel technology.
Posted October 26, 2015
Oracle kicked off the beta program for an updated release Oracle Database 12c which provides a multitenant architecture and dual format in-memory database technology. According to Oracle, Oracle Database 12c Release 2 further simplifies the journey to the cloud and enables efficient delivery of database services, with greater consolidation density and more administrative agility at cloud scale.
Posted October 26, 2015
Attunity Ltd., a provider of data management software solutions, has introduced the latest version of its data replication and loading solution. Designed to accelerate enterprise big data analytics initiatives, Attunity Replicate 5.0 automates big data movement to, from and between databases, data warehouses, Hadoop and the cloud, reducing the time and labor, and ultimately the cost of making big data analytics available in real time.
Posted October 26, 2015
With the current rate of data growth, it is not inconceivable that in 3 years, we'll have 10 times the volume of data we have today. The challenge will only continue to grow, but by following the five C's of data visualization, it is possible to prepare data and present eye-opening data visualization to improve users' reporting, analytics, and overall business intelligence.
Posted October 22, 2015
Enterprise data security provider Protegrity has announced that it has earned Oracle Exadata Optimized status through the Oracle PartnerNetwork (OPN), demonstrating that Protegrity Database Protector for Oracle Exadata is recognized as having been tested and tuned on Oracle Exadata Database Machine to deliver speed, scalability and reliability to customers.
Posted October 21, 2015
Oracle today announced the general availability of MySQL 5.7, the latest version of the open source database. According to Tomas Ulin, vice president, MySQL Engineering, Oracle, the new version delivers greater performance, scalability, manageability, plus enhanced NoSQL capabilities with JSON support and MySQL Router, which makes it easy to connect applications to multiple MySQL databases.
Posted October 21, 2015
Ever since Linux became a viable server operating system, organizations have been looking to all kinds of open source software (OSS) to save on license and maintenance costs and to enjoy the benefits of an open platform that invites innovation. If you're considering MySQL or another open source DBMS as either your primary database or to, perhaps, operate alongside your existing commercial systems, such as Oracle or Microsoft SQL Server, for one reason or another, here are seven things to keep in mind.
Posted October 21, 2015
The Agile methodology is great for getting turgid development teams to start working faster and more coherently. With Agile, which focuses on more rapid, incremental deliverables and cross-departmental collaboration, the bureaucratic plaque is flushed from the information technology groups' arteries. But there is a dark side to Agile approaches.
Posted October 21, 2015
Teradata is introducing a series of platforms that will capture streaming IoT data, land that data in Hadoop, and use advanced Aster machine learning natively in Hadoop to analyze data.
Posted October 20, 2015
The topics of resilience and change have been on my mind a lot lately for a variety of reasons. First, IT is always at the center of technology change, so that's nothing new. We must continually learn and keep abreast of new technology and trends before they even materialize. Second, I am an IT leader in the energy industry, and when one is at the mercy of natural resource supply and demand, there will be peaks and valleys in production and financial performance over the years. With this latest dip in energy prices, I sense a different perspective—one of working smarter and more efficiently, emphasizing innovation, and analyzing decisions with an enterprise perspective of what is right for the company at this time, not just IT.
Posted October 14, 2015
At Strata + Hadoop World 2015, Attunity announced the release of Attunity Replicate Express, a downloadable edition of its data replication and loading software. The solution, which answers a growing demand for more accessible real-time big data analytics, is freely available to download online. The new solution supports ingesting data to and from Oracle, SQL Server, and Hadoop Data Lakes for test and development environments.
Posted October 14, 2015
As more and more applications, websites, and basic smart home devices ask users permissions for their data, people are starting to wonder where their information is going. The question of privacy, the Internet of Things, and what companies do with an individual's personal information was the subject of two different sessions at Strata + Hadoop World in NYC.
Posted October 13, 2015