Database Management Articles
It's almost hard to believe I've been your columnist for Microsoft SQL Server topics for more than 5 years! As an analyst of Microsoft SQL Server, as well as one who's interested in the whole spectrum of database systems, I've tried to provide insight for the questions of "how" and "why" Microsoft has made the choices it has in crafting SQL Server. After all, understanding the context and motivation for a particular set of features-or a particular marketing strategy-can help you fully understand the best choices for your own internal IT strategies and projects.
Posted September 07, 2010
Database systems require data files to store the data under management. These files, or data sets, reside on storage media. So storage management should be a key part of the database operations required of a database administrator (DBA). Unfortunately, storage is sometimes relegated to an afterthought; after all, don't we have storage administrators who deal with our disk arrays? But this way of thinking is misguided. To succeed, database administration and storage administration need to cooperate and work together.
Posted September 07, 2010
Interest in and adoption of open source databases continues to dramatically increase. This truth was recently underscored for me when I sat down with one of the top industry analysts who covers the database market. Among the many interesting data points we discussed were the fact that his company has seen a 50% increase in open source database inquiries in the past 18 months and that more than 80% of corporations are looking to use open source databases in their infrastructures, including companies in the Fortune 100.
Posted September 07, 2010
Many organizations now have, in their possession, the sophisticated analysis tools and dashboards that connect to back-end systems and enable them to peer deeply into their businesses to assess progress on all fronts-from revenues to stock outs to employee performance. However, a recent survey of 279 Oracle applications managers reveals that when it comes to decision making, simple spreadsheets still remain the tool of choice. And business users still wait days, weeks, and months for their IT departments to deliver reports, despite significant investments in performance management systems.
Posted September 07, 2010
Oracle yesterday announced that Mark V. Hurd has joined Oracle as president and has been named to Oracle's board of directors. Hurd will report to Oracle CEO Larry Ellison. "Mark did a brilliant job at HP and I expect he'll do even better at Oracle," said Oracle CEO Larry Ellison, in a statement commenting on Hurd's hire. "There is no executive in the IT world with more relevant experience than Mark. Oracle's future is engineering complete and integrated hardware and software systems for the enterprise. Mark pioneered the integration of hardware with software when Teradata was a part of NCR."
Posted September 07, 2010
Quest Software, Inc. announced today that it has added Apache Cassandra, an open source NoSQL database, to its list of supported NoSQL platforms with the second beta release of Toad for Cloud Databases. Toad now supports data access and management for Apache Cassandra, Amazon SimpleDB, Microsoft Azure Table Services, Apache HBase, and any open database connectivity-enabled relational database.
Posted September 07, 2010
InterSystems Corporation, a leader in software for connected healthcare, has announced that its customer, LifePoint Informatics, has moved its flagship LifePoint InfoHub to the InterSystems Ensemble rapid integration and development platform. InterSystems' application partner LifePoint, based in Glen Rock, N.J., provides outreach business applications and electronic medical record and health information exchange integration. The migration to Ensemble has enabled LifePoint to grow its business an estimated 40% since 2008, according to the company.
Posted September 07, 2010
EnterpriseDB, which provides products, services, support and training based on the PostgreSQL open source database project, has received a strategic investment from KT (formerly Korea Telecom) and has accepted venture capital funding from new investment partner TransLink Capital. EnterpriseDB says the new funding will enable it to expand its product and marketing operations to capitalize on the upheaval in the database market caused by consolidation and an enterprise platform shift to virtualized and cloud infrastructure.
Posted September 07, 2010
MarkLogic Corporation has announced that MarkLogic Server has earned Common Criteria Certification from an unbiased independent evaluator. MarkLogic Server has been validated in accordance with the provisions of the National Information Assurance Partnership (NIAP) Common Criteria Evaluation and Validation Scheme (CCEVS) for IT Security, an IT security certification program.
Posted September 07, 2010
Mythics, Inc. has announced that it has been awarded a letter of supply to resell the Oracle Exadata platform from Oracle. Mythics is an Oracle PartnerNetwork Platinum Partner, Oracle GSA Schedule Holder (GS-35F-0153M), and Oracle Value Added Reseller (VAR). The letter of supply will allow Mythics to sell the Oracle Exadata platform via their own GSA Schedule contract.
Posted September 02, 2010
Oracle has announced a full line-up of partner events and activities at Oracle OpenWorld 2010 in San Francisco. The week kicks off with the Oracle PartnerNetwork (OPN) Forum, and will be followed by a series of Partner Pavilions and partner-only sessions, throughout the conference that will allow partners to share successes, showcase solutions and capabilities, increase customer and prospect visibility, and learn about new opportunities for business growth with Oracle.
Posted September 02, 2010
Oracle recently hosted a 6-hour online forum to showcase its strategy for virtualization. Oracle's Edward Screven, chief corporate architect, and John Fowler, executive vice president, Systems, kicked off the agenda of analyst, customer and product webcasts, by explaining how Oracle delivers a complete virtualization offering, all the way from desktop through the data center and why that approach provides more customer benefits than point solutions.
Posted September 02, 2010
The Rocket U2 Denver team is moving its offices. According to the company, customers should see minimal-to-no disruption in service during the relocation, as the U2BC system and U2 websites are hosted at another Rocket site. Starting Monday, August 30, the new address will be 4600 S. Ulster Street, Suite 1100, Denver, Colo., 80237. All phone numbers and email addresses remain the same.
Posted August 25, 2010
Entrinsik has announced that, at the recommendation of its solution provider, Progenixx, the Everett Housing Authority (EHA) has selected Entrinsik's Informer Web Reporting software. For over 60 years, EHA has served the housing needs of the people of Everett, Wash. Critical to supporting this commitment is the ability to provide its staff across four departments with information that is up-to-the-minute and easily accessible in order to optimize decision making without burdening IT with numerous custom report requests.
Posted August 25, 2010
The latest version of Sybase Unwired Platform, 1.5.2, that will enable enterprise developers to simply and quickly build applications that connect business data from more sources, including SAP applications, to mobile workers on any device, is now available.
Posted August 25, 2010
Sybase, Inc., an SAP company, recently announced the continued growth of the Sybase(R) IQ partner ecosystem. Through key relationships with companies such as Bradmark Technologies, Fuzzy Logix, ISYS Search Software, Kapow Technologies, SAS, Tableau Software, and Zend Technologies, Sybase IQ analytics server continues to support the demanding analytics environments of its more than 1,800 customers and 3,200 installs worldwide.
Posted August 25, 2010
At an event last week co-located in Boston and Frankfurt, company leaders from SAP AG and Sybase came together for the first time to share the strategy and joint product direction for the newly combined companies. SAP confirmed that Sybase will be run as a separate, independent unit - and that customer investments in Sybase products will be preserved and supported.
Posted August 24, 2010
Idera, a provider of Microsoft SQL Server management and administration solutions, has announced Idera SQL admin toolset 1.5, a set of 25 desktop tools for monitoring, troubleshooting, administering and reporting on SQL Server.
Posted August 24, 2010
Canonical Ltd., the company behind Ubuntu, has launched a virtual appliance of IBM's DB2 Express-C software running on the Ubuntu cloud computing platform in private and public cloud configurations. Canonical also announced that IBM has completed validation of the full version of DB2 software on Ubuntu 10.04 Long Term Support Server Edition.
Posted August 18, 2010
Furthering its commitment to desktop virtualization, Oracle announced the newly released Oracle Virtual Desktop Infrastructure 3.2. Oracle Virtual Desktop Infrastructure (VDI) is a complete management, hosting and access solution for virtualized desktops hosted in the data center. By enabling standardized virtual desktop images, Oracle Virtual Desktop Infrastructure helps reduce administration overhead, lover total cost of ownership and increase security.
Posted August 18, 2010
Oracle Database 11g Standard Edition One has delivered a world record price/performance result with the TPC-C benchmark, Oracle announced. Oracle Database 11g Standard Edition One running on an HP ProLiant ML350 G6 server with a single six-core Intel Xeon X5650 2.67 GHz processor with Oracle Enterprise Linux set a world record TPC-C price/performance result of $0.39/tpmC with a performance result of 290,040 tpmC.
Posted August 18, 2010
As part of its Power announcements yesterday, IBM introduced IBM Rational Power Appliance, a family of software appliances comprised of Power Express servers that are pre-loaded and pre-configured with IBM Rational software for AIX development. Available in a range of sizes and programming languages to suit specific user requirements, these ready-to-use systems provide customers a fully-enabled software development environment that can be put to use in a matter of hours.
Posted August 18, 2010
Continuity Software, a provider of disaster recovery (DR) and high availability (HA) management solutions, has announced the general availability of RecoverGuard version 5.2 (v5.2), featuring a Private Cloud Advisor designed to enable customers to ensure availability, recoverability and adherence to industry best practices in the private cloud. "Until about a year ago, no one really used private clouds in the mid and large enterprise for mission-critical systems, but in the last 12 months, we have started to see a shift toward people either deploying such systems or at least planning the deployment of private clouds in the medium and large data centers," Gil Hecht, founder and CEO of Continuity Software, tells 5 Minute Briefing.
Posted August 18, 2010
EnterpriseDB has announced the immediate availability of the latest version of its flagship Postgres Plus Advanced Server database. EnterpriseDB's Postgres Plus Advanced Server 8.4, which is built on the open source object relational Postgres database, is now fully compatible with all the features and functionality found in the most recent community distribution. The new release provides increased core functionality for the database as a whole, increased Oracle compatibility, increased manageability, and increased security, according to Robin Schumacher, EnterpriseDB's director of product strategy.
Posted August 11, 2010
Today, Sybase, Inc., an SAP company, also announced a new HP-Sybase BI (business intelligence) reference architecture that leverages the HP Converged Infrastructure. The joint solution optimizes query response and data loads with reduced overhead, storage costs and maintenance requirements. Featuring Sybase IQ 15 running on HP ProLiant DL785 servers, Sybase says the solution will help organizations looking for high performance, scalability and energy efficiency at a lower TCO than other analytics server offerings.
Posted August 10, 2010
CA Technologies announced new identity and access management (IAM) solutions intended to enhance security, ease compliance efforts, and automate IT processes within cloud computing environments. The company released a new version of CA Identity Manager, which extends identity management to cloud applications, as well as leverage CA SiteMinder portfolio to control access to its SaaS applications.
Posted August 10, 2010
Idera, a provider of Microsoft SQL Server management and administration tools, has announced the latest version of its SQL Server backup and recovery solutions: SQL safe 6.4, SQL safe lite 6.4 and SQL virtual database 1.4.
Posted August 10, 2010
First elected to Oracle Applications Users Group board of directors in 2009, David Ferguson became president of the OAUG this year. He talks with DBTA this month about how the users group is getting "back to basics" with educational sessions and networking opportunities as well as the new approaches it is taking to meet its members' evolving needs.
Posted August 10, 2010
Earlier this year, Andy Flower took over as president of the Independent Oracle Users Group from Ian Abramson. With Oracle OpenWorld right around the corner, Flower talks with DBTA about how the IOUG is changing to best meet the challenges and opportunities presented by the expanding Oracle ecosystem, despite what continues to be a difficult economy. For the IOUG, it is "the year of the member" and it all starts with the database, he says.
Posted August 10, 2010
Revelation Software has announced the availability of a significant new release of OpenInsight (OI) Development Suite, which continues Revelation's commitment to extend OpenInsight by embracing new technologies as well as providing seamless integration with external databases. OI 9.2, which the company has been working on for more than 2 years, includes the new OpenInsight for Web (O4W) and SQL Connector.
Posted August 10, 2010
Design should be an intention, preferably a planned intention. In that intention, design requires more groundwork than a simple thought-train such as the following, "I planned to write a module that functions; since the module functions, my designs are working." Some situations do exist where true design really is less important than successful functionality. Determining the appropriate level of design and preparation offers an interesting question to every architect. At the lowest level, standards and practices present suitable patterns that can serve as a design skeleton for those low-level or isolated items not requiring a heavy-handed blueprint.
Posted August 10, 2010
What is the most difficult thing about acquiring enterprise software? If you are like most IT technicians, your first inclination was probably something related to cost justification. Let's face it, enterprise software typically is very expensive ... and eventually, something will need to bring costs more in line with value.
Posted August 10, 2010
Extending its leadership in the enterprise tape market, Oracle announced high availability and capacity enhancements to its StorageTek tape libraries and drives. New features of the StorageTek SL8500 Modular Library System include an increase in scalable capacity from 70,000 to 100,000 tape slots and redundant electronics to help customers manage growth, increase availability and reduce risk. "Being able to scale to 150 petabytes with up to 100,000 tape slots under the management of a single library is a significant advantage for customers who are dealing with explosive data growth, as many companies are today," Tom Wultich, director of product management for tape at Oracle, tells 5 Minute Briefing.
Posted August 04, 2010
Revelation Software has announced the availability of a new release of OpenInsight (OI) Development Suite. The 9.2 release includes the SQL Connector, which allows SQL tables in relational database management systems including Oracle, SQL Server, and MySQL, to be seen as native tables to all components of OpenInsight, including forms, reports, popups, stored procedures and O4W. "What we have done is built intelligence into the connector so that programmers that have been doing work, not just in OpenInsight, but any flavor of MultiValue, can now use that same knowledge base that they have, and go against data that used to be fairly difficult for them to get at," Mike Ruane, president and CEO of Revelation Software, tells 5 Minute Briefing.
Posted August 04, 2010
Revelation Software has announced the availability of a new release of OpenInsight (OI) Development Suite, which continues Revelation's commitment to extend OpenInsight by embracing new technologies as well as providing seamless integration with external databases.
Posted August 03, 2010
The International Sybase User Group (ISUG) has announced the immediate availability of its latest course offering in conjunction with online training specialist eLearnIT LLC. The new course is entitled "ASE Performance & Tuning with MDA Tables" and has been planned to offer a pragmatic combination of both practical and theory-based skills for Sybase DBAs. With today's data center management demands becoming increasing time critical as well as mission critical, this course compehensively provides DBAs with the skills they will need to perform effectively when troubleshooting problem queries and bottlenecks within Sybase ASE.
Posted July 28, 2010
SAP AG has announced the completion of the cash tender offer for all outstanding shares of common stock of Sybase, Inc., by Sheffield Acquisition Corp., a wholly-owned subsidiary of SAP, which expired at 9:00 p.m., New York City time on Monday, July 26, 2010. American Stock Transfer & Trust Company, LLC, the depositary for the tender offer, has indicated that, as of the expiration of the tender offer 80,929,717 shares of common stock of Sybase had been tendered into and not properly withdrawn from the tender offer (including 9,293,901 shares of common stock tendered pursuant to the guaranteed delivery procedures). These shares represent approximately 92.1% of Sybase's outstanding shares of common stock, or 91.8% on a fully diluted basis. All Sybase shares that were validly tendered into the offer and not properly withdrawn have been accepted for payment.
Posted July 28, 2010
Sybase has reported financial results for the second quarter ended June 30, 2010. Total revenue for the second quarter of 2010 grew 9% to $302.0 million, compared to $278.0 million in the second quarter of 2009. License revenue grew 6% to $100.1 million, compared to $94.1 million in the second quarter of 2009, services revenue grew 5% to $147.2 million, and messaging revenue grew 24% to $54.8 million in the second quarter of 2010.
Posted July 28, 2010
Sybase has announced the availability of its SQL Anywhere 12 database and synchronization solution. A core component of the Sybase Mobility Platform, SQL Anywhere is optimized for mission-critical database applications running outside traditional data center environments requiring little or no onsite IT support. According to Chris Kleisath, senior director of engineering, SQL Anywhere 12 represents a major platform release, providing many key new enhancements for performance and scalability such as support for storage and synchronization of spatial data, support for iPhone devices, and new self-management features.
Posted July 28, 2010
Confio Software, which offers Ignite 8 performance analysis software, has unveiled IgniteFree, which the company describes as the only free response-time database performance analysis tool. IgniteFree is carved from Ignite 8's primary feature set and gives DBAs a point-in-time view of bottlenecks in their database. IgniteFree for Oracle, SQL Server, Sybase and DB2/LUW can be downloaded from Confio at no cost. "We have taken the core feature of Ignite - which is the response time monitoring - and we have packaged it in a free version so that you get all the response time information for real time monitoring for the past hour at no cost," Don Bergal, chief operating officer of Confio, tells 5 Minute Briefing.
Posted July 28, 2010
Quest Software, Inc. has introduced a beta program for Toad for Cloud Databases, a new data access and management tool for non-relational data stored in cloud databases, also known as NoSQL databases. Toad for Cloud Databases is intended to help users unlock data stored in the cloud by using the familiar SQL language or Toad's popular visual query and data access capabilities. Users can query and report on non-relational data, migrate data in both cloud and relational databases from one to the other, and create queries that combine the two.
Posted July 28, 2010
SunGard, a leading software and technology services companies, has certified the latest version of its Front Arena position control solution with Adaptive Server Enterprise (ASE) 15, Sybase's enterprise database management system. Customers using SunGard's newest version of Front Arena to support cross-asset capital markets trading and trading strategies combined with ASE 15 have experienced up to a 400 percent increase in transaction processing of stock exchange data.
Posted July 28, 2010
Revelation Software has announced the availability of a significant new release of OpenInsight (OI) Development Suite, which continues Revelation's commitment to extend OpenInsight by embracing new technologies as well as providing seamless integration with external databases. OI 9.2, which the company has been working on for more than 2 years, includes the new OpenInsight for Web (O4W) and SQL Connector.
Posted July 27, 2010
EnterpriseDB has announced the immediate availability of the latest version of its flagship Postgres Plus Advanced Server database. EnterpriseDB's Postgres Plus Advanced Server 8.4, which is built on the open source object relational Postgres database, is now fully compatible with all the features and functionality found in the most recent community distribution. In this latest release, EnterpriseDB continues to enrich Postgres Plus by building enterprise-class capabilities on top of the open source relational database management system.
Posted July 27, 2010
SAP AG announced today the completion of the cash tender offer for all outstanding shares of common stock of Sybase, a partner and a market leader in managing, analyzing, and mobilizing business information. Through this transaction, SAP said it intends to accelerate the reach of SAP solutions across mobile platforms and drive forward the realization of SAP's in-memory computing vision.
Posted July 27, 2010
The Pythian Group Inc., a remote database infrastructure services company and a Platinum member of the Oracle PartnerNetwork has announced the implementation of the Sun Oracle Database Machine at LinkShare Corporation, a division of Rakuten, Inc., and the launch of Pythian's Oracle Exadata services practice.
Posted July 21, 2010
Creating standards for cloud computing is key to its future evolution and broader adoption. What is the role of Linux in the cloud? What economic or technological advantages (if any) do open standards-based clouds have? Where else is open source software gaining traction in the cloud, and will customers choose to run a mix of open and 'private-source' software? How does the history of the evolution of Linux relate to the future of the cloud?
Posted July 21, 2010
SAP AG and CA Technologies announced they are collaborating as part of an effort to meet the latest demands to instill governance, risk and compliance (GRC) market within business and IT processes. Leveraging products from CA Technologies with leading GRC applications from SAP will allow IT executives to gain tighter control over their IT risk and compliance initiatives and focus on long-term value creation for the business.
Posted July 20, 2010
HiT Software, a provider of data integration products and division of a BackOffice Associates, LLC, says it is shipping a new version of its change data capture and replication product that supports multiple databases as well as support for Netezza data warehouse appliance. The new product, DBMoto 7, also delivers data verification, enhanced administrative security options, and log-based replication for IBM DB2 LUW.
Posted July 13, 2010
Mid-sized businesses are using and saving more data than ever before. Indeed, the phenomenon that IT engineers have come to refer to as "big data" is being felt in businesses of all sizes. At the same time, however, organizations are facing reduced budgets. Regardless of how much data their likely overburdened IT staff must manage today and tomorrow, mid-sized businesses must find ways to save money by keeping a tight rein on both capital and operational expenditures.
Posted July 12, 2010