database news around the world

ASD

2011-12-15T10:33:00.001-08:00

Asd

How to drop a Database by closing existing connections using T-SQL?

2011-12-15T10:06:00.003-08:00

aaaaaaaaaa

How to drop a Database by closing existing connections using T-SQL?

2011-12-15T10:06:00.001-08:00

MongoDB - Why Does NoSQL Matter?

2011-11-10T05:04:00.001-08:00

In recent years, the drumbeat of vendors proclaiming the ascendancy of NoSQL has become increasingly loud. One of the NoSQL vendors that is seeing business results from its NoSQL solution is 10gen, which is the lead commercial sponsor behind the open source MongoDB NoSQL database.

http://www.databasejournal.com/news/mongodb-nosql.html

Has NoSQL been overhyped?

2011-11-08T22:01:00.001-08:00

One of the biggest technology buzzwords to emerge in the past several years is 'NoSQL.' Put simply, NoSQL has come to refer to any database management system that isn't a traditional RDBMB.

From Cassandra to CouchDB, there are a number of NoSQL systems that have attracted significant attention, and that are used in commercial applications, including some of the most popular consumer internet services.

But the honeymoon with NoSQL may be coming to an end.

http://econsultancy.com/us/blog/8231-has-nosql-been-overhyped

Microsoft Adds Hadoop Support to SQL Server, Data Warehouse

2011-08-13T10:50:00.001-07:00

Microsoft is responding to the "Big Data" movement by adding support for the open-source Hadoop framework for large-scale data processing to its SQL Server database and Parallel Data Warehouse platform.

The connectors will be available in CTP (community technology preview) form soon, according to a post this week on the official SQL Server Team blog.

Big Data refers to the ever-growing volumes of data being generated by enterprises, particularly from sensors and Web traffic.

http://www.pcworld.com/article/237608/microsoft_adds_hadoop_support_to_sql_server_data_warehouse.html

10gen Selected by AlwaysOn as an AlwaysOn Global 250 Winner

2011-07-30T10:35:00.001-07:00

10gen, which sponsors leading open source non-relational database MongoDB, today announced that it has been chosen by AlwaysOn as one of the AlwaysOn Global 250 winners. Inclusion in the AlwaysOn Global 250 signifies leadership amongst its peers and likelihood of a technology to disrupt existing markets and entrenched players in the Global Silicon Valley. 10gen was selected by the AlwaysOn editorial team and industry experts on the basis of innovation, market potential, commercialization, stakeholder value, and media buzz. The vetting process involved a three-month rigorous review of thousands of domestic and international technology companies nominated by investors, bankers, journalists, and industry insiders.

More at http://www.marketwire.com/press-release/10gen-selected-by-alwayson-as-an-alwayson-global-250-winner-1541186.htm

NoSQL standouts: New databases for new applications

2011-07-30T10:32:00.001-07:00

Cassandra, CouchDB, MongoDB, Redis, Riak, Neo4J, and FlockDB reinvent the data store was it just two or three years ago when choosing a database was easy? Those with a Cadillac budget bought Oracle, those in a Microsoft shop installed SQL Server, those with no budget chose MySQL. Everyone in between tried to figure out where they belonged.

Oracle Plans 78 Bug Fixes in Critical Patch Update

2011-07-16T04:21:00.001-07:00

Oracle will patch 78 software vulnerabilities across its product portfolio, including the Oracle database and PeopleSoft as part of its quarterly CPU (Critical Patch Update).
racle is delivering patches for almost every product in its portfolio in its quarterly Patch Tuesday update next week. July's update package is slightly larger than the April update where 73 issues were fixed and a number of critical flaws were patched.
http://www.eweek.com/c/a/Security/Oracle-Plans-78-Bug-Fixes-in-Critical-Patch-Update-811398/

NoSQL: CouchDB with CloudBees and Cloudant

2011-07-16T04:14:00.001-07:00

CouchDB is a popular NoSQL database - specifically you could called it a "document database" - i.e. it is all about storing documents which consist of sets of fields in a JSON document against a key. There is no schema - a document can consist of any JSON structure - there is no requirement that the same fields be present in each document unlike rows in a RDBMS. Of course CouchDB has a lot of the other benefits of NoSQL databases - high scalability and ease of use.

Read more at http://blog.cloudbees.com/2011/07/nosql-couchdb-with-cloudbees-and.html

Database high priest mud-wrestles Facebook

2011-07-14T12:21:00.001-07:00

Mike Stonebraker is famous for slagging Google's backend. And now he's slagging Facebook's too.

Last week, in a piece from our friends at GigaOM, Database Grandpoobah Mike Stonebraker announced that Facebook's continued dependance on MySQL was “a fate worse than death,” insisting that the social network's only route to salvation is to “bite the bullet and rewrite everything.”

We're confident he was quoted warmly and accurately. After all, he said much the same thing to The Register. "Facebook has shared their social network over something north of 4,000 MySQL instances, and that's nowhere near fast enough, so they're put 9,000 instances of memcached in memory in front of them. They are just dying trying to manage this," Stonebraker recently told us. "They have to do data consistency and crash recovery in user space."

Microsoft Releases SQL Server 'Denali' CTP3 and SQL Server 2008 R2 SP1

2011-07-14T12:18:00.001-07:00

Microsoft on Monday announced the third community technology preview (CTP3) release of its next-generation SQL Server database management system, code-named "Denali," as well as Service Pack 1 for its current SQL Server 2008 R2 product.

Denali was frequently mentioned during the keynotes and session talks at the 2011 Microsoft Partner Conference, which is ongoing this week in Los Angeles. The CTP3 test version of Denali can be downloaded at this page.

The release of SP1 for Microsoft's current SQL Server 2008 R2 product took a back seat to all of the WPC news this week, but it's available for downloaded here. Highlights in the new service pack include greater supportability in "dynamic management views," improved query performance through a "ForceSeek" feature, improved upgrades via Data-tier Application Component Framework and better disk space control for PowerPivot, which is Microsoft's data analysis tool for Excel. Microsoft provides the release notes for SQL Server 2008 R2 SP1 at this wiki page.

Epicor supports Microsoft SQL Server Denali

2011-07-14T12:13:00.001-07:00

Manufacturing and distribution ERP software firm Epicor will support Microsoft SQL Server Denali, the cloud-ready platform claiming to offer enterprise visibility and lowest total cost of ownership.
The company made its announcement at the 2011 Microsoft Worldwide Partner Conference, and says that it now plans to enhance its EPM (enterprise performance management) software by taking advantage of the new release's improved performance, availability and security, through in-memory computing.

CouchDB Merges With Membase

2011-02-11T22:38:00.000-08:00

Two of the leaders in the NoSQL world (and big supporters of open source) announced a merger today. Membase, which powers massively scalable applications like those from Zynga, is merging with CouchOne, the makers of CouchDB. The new company will be called Couchbase.

OmBelt Solutions releases Copy Database tool for Microsoft SQL Server

2011-02-11T22:28:00.000-08:00

Make copy of your data with Copy database for Microsoft SQL Server tool by OmBelt Solutions.

New copy tool allows the user to create copy of selected tables (table definition and data) to another database or even another Microsoft SQL Server.

This handy utility helps the users, database developers and database administrators create a second copy of a database within seconds.

look for more here

Why and How Netflix Adopted NoSQL Databases

2011-02-05T00:52:00.000-08:00

Netflix uses three NoSQL tools: SimpleDB, HBase and Cassandra. "The reason why we use multiple NoSQL solutions is because each one is best suited for a specific set of use cases," Izrailevsky writes. He writes that the learning curve has been steep and re-architecting the company's systems has been difficult but "the scalability, availability and performance advantages of the NoSQL persistence model are evident and are paying for themselves already, and will be central to our long-term cloud strategy."

Read it

How Twitter Uses NoSQL

2011-02-05T00:47:00.000-08:00

InfoQ has released a video of Twitter's Kevin Weil speaking at Strange Loop earlier this year on how the company uses NoSQL. Weil is quick to point out that Twitter is heavily dependent on MySQL. However, Twitter does employ NoSQL solutions for many purposes for which MySQL isn't ideal. According to Weil, Twitter users generate 12 terrabytes of data a day - about four petabytes per year. And that amount is multiplying every year. Read on for our notes on Weil's talk.

Read it here

Cassandra vs MongoDB vs CouchDB vs Redis vs Riak vs HBase comparison

2011-02-05T00:42:00.000-08:00

While SQL databases are insanely useful tools, their tyranny of ~15 years is coming to an end. And it was just time: I can't even count the things that were forced into relational databases, but never really fitted them.

But the differences between "NoSQL" databases are much bigger than it ever was between one SQL database and another. This means that it is a bigger responsibility on software architects to choose the appropriate one for a project right at the beginning.

Read all here

Stockopedia becomes the first social investing platform to launch real-time analytics for Contributors

2011-02-01T22:22:00.000-08:00

The Publisher Analytics platform leverages MongoDB, a document-oriented database adept at handling high volumes of information, well suited for large scale data processing and most famously used at CERN for handling data generated by the Large Hadron Collider.

Ramin Keene, Stockopedia CTO, said: “We’ve been using MongoDB for an experimental internal analytics system, monitoring activity by our 100,000+ users and around 20,000 investment topics, stocks and sectors. We felt confident that we could expand the application using the same architecture at scale for all our users to have access to personalised, real time analytics about how the investment community is interacting with their content. Our aim is to ensure that our tools keep the Stockopedia userbase - whether they be investors, financial publishers or listed companies - as informed as possible, as instantaneously as we possibly can.”

Read more here

Hadoop, NoSQL, and MMP Databases Get big Data Reporting Capabilities

2011-01-28T22:41:00.000-08:00

Jaspersoft announces native reporting offering for big data systems; consolidating PaaS reporting foundation with support for Hadoop, NoSQL, and MPP databases. The release of over a dozen big data connectors has been a part of jaspersoft’s “Big Data Reporting” project as well as connectors for proprietary databases; becoming the first BI vendor to deliver native reporting for hadoop, NoSQL, and MPP analytic databases.

View article

Research Papers and Videos on Google Bigtable, GFS, Chubby and MapReduce

2011-01-27T22:39:00.000-08:00

Here are the links to the Google’s research papers and a couple of videos that relate to Bigtable (and Google App Engine internals):

Oracle Database 11g R2 RAC - The top 5 changes

2011-01-27T20:36:00.000-08:00

The introduction of the Oracle Grid Infrastructure product essentially combines Automatic Storage Management (ASM) and Oracle Clusterware into the same oracle home and product. With this new configuration, five main changes have been incorporated into Oracle Database 11g RAC. Read on to learn more.

More here

IBM Investigates Options for Keeping MySQL on IBM i

2011-01-26T22:27:00.001-08:00

Oracle says it won't build anymore MySQL binaries for the AIX and IBM i platforms.

It's too bad that Oracle has decided to not play fair, but the company is in the database business, and in business, I suppose it doesn't make sense to continue something that doesn't benefit you.

Still, IBM users don't need to get in a huff at the prospect of losing one of the keys to running open-source apps on i, nor should i users launch into a tantrum (yet).

Read more at here

New Cassandra Can Pack Two Billion Columns Into a Row

2011-01-14T15:14:00.000-08:00

The cadre of volunteer developers behind the Cassandra distributed database have released the latest version of their open source software, able to hold up to 2 billion columns per row.

An open source database capable of holding such lengthy rows could be most useful to big data cloud computing projects and large-scale Web applications, the developers behind the Apache Software Foundation project assert.

Read more from here

Cassandra vs MongoDB vs CouchDB vs Redis vs Riak vs HBase comparison

2011-01-10T03:14:00.000-08:00

While SQL databases are insanely useful tools, their tyranny of ~15 years is coming to an end. And it was just time: I can’t even count the things that were forced into relational databases, but never really fitted them.

But the differences between "NoSQL" databases are much bigger than it ever was between one SQL database and another. This means that it is a bigger responsibility on software architects to choose the appropriate one for a project right at the beginning.

In this light, here is a comparison of Cassandra, Mongodb, CouchDB, Redis, Riak and HBase:

Microsoft Blames Server Problem for Hotmail Outage

2011-01-04T05:04:00.001-08:00

Microsoft says it has fixed a problem with its Windows Live Hotmail service that temporarily deleted the e-mail of more than 17,000 users.

The trouble began on Dec. 30 when the e-mail in 17,355 accounts disappeared. On Monday, a Microsoft executive wrote that the company had identified the technical glitch and restored e-mail to the affected accounts by Sunday night.

Microsoft uses its SQL Server to manage Hotmail in what it says is the largest deployment of its product in the world, using tens of thousands of SQL databases.
More at here

The Most Widely Distributed, NoSQL Open Source DB

2010-12-12T22:40:00.000-08:00

What open source DB is shipped along with Ubuntu and so is on millions of computers today? If you guessed MySQL you lose. If you guessed CouchDB you are today's lucky winner. Yes, thats right, CouchDB is shipped with every version of Ubuntu and in terms of computers with it loaded on may be the biggest of the open source databases. I recently had a chance to speak with Damien Katz the founder and original developer for the CouchDB project and CouchOne (formerly Couchio) the commercial entity he started.

more here

Microsoft’s Cloud Computing Strategy

2010-12-02T03:28:00.001-08:00

Windows Azure, a Platform as a Service offer, is Microsoft's cloud computing platform. It was announced at PDC 2008 where Microsoft announced some interesting improvements and additional features to its Windows Azure Platform. Microsoft is serious about its strategy on Windows Azure, as was demonstrated in the PDC keynote, which dedicated over one hour to Azure. But what exactly is Microsoft's cloud computing strategy? This article describes the new features that will be available soon on Windows Azure.

http://www.sys-con.com/node/1633303

10 Best Things Microsoft Did in 2010

2010-12-02T03:15:00.000-08:00

When it comes to the enterprise, Microsoft hit the ball out of the park in 2010. Here's our favorite offerings.

It's been a successful year for Microsoft. The company took a lot of heat, but overall accomplished quite a bit -- especially for its enterprise customers. Here's their top tips for what Redmond got right in the past
year.

full report here

Using Oracle In-Memory Database Cache to Accelerate the Oracle Database

2010-11-29T06:12:00.000-08:00

IT managers are always looking for ways to bring data closer to the application, and to improve overall application throughput without interfering with the centralized management and administration of the back-end database.
In this technical white paper you will learn about the Oracle In-Memory Database Cache, and how it accelerates business processes, enables real-time business intelligence, and facilitates the personalization of customer-facing applications.

http://viewer.media.bitpipe.com/934318651_120/1285769294_947/DBWPMemory.pdf

10 Cloud Predictions For 2011

2010-11-20T11:23:00.001-08:00

The foundations for cloud computing were firmly laid in 2010, paving the way for what will likely be a landmark year for the technology, a Forrester analyst has predicted.

More info

IBM Pushes The Migration Of Oracle To DB2

2010-11-17T12:30:00.000-08:00

IBM's recently concluded Information on Demand 2010 event in Las Vegas covered a tremendous amount of ground on numerous topics. One of the most intriguing was the dedicated push that IBM is making to have Oracle database customers migrate to its own DB2 solutions. Given that migration from one database to another has been described by many analysts as "heart surgery," how can IBM possibly expect customers to willingly embrace so difficult and potentially risky a procedure?

Read more here

Vulnerability assessment for Microsoft SQL Azure

2010-11-15T11:11:00.001-08:00

Sentrigo announced Repscan 4.0 which offers expanded support for cloud-based and open source database platforms, productivity enhancements for database administrators (DBAs) and added management capabilities.

More at here

Quest Launches Cloud-based SQL Server Testing Service

2010-11-13T15:06:00.000-08:00

Quest Software has launched a free cloud-based service that analyses SQL Server trace files and helps determine the source of performance issues.

The company announced the new service, currently in the pilot phase, at the PASS Summit 2010, which that took place this week in Seattle, Wa. The site, called Project Lucy, is hosted on Microsoft's Windows Azure cloud service, and is aimed at creating a virtual community of SQL Server users.

more at here

Microsoft Details SQL Server Assessment Technology 'Atlanta'

2010-11-13T11:45:00.001-08:00

Microsoft has unveiled more details of project "Atlanta", a cloud-based configuration assessment service aimed at Microsoft SQL Server deployments.

More at here

Progress Software Introduces New Database Drivers for Microsoft SQL Server 2008 R2 Parallel Data Warehouse

2010-11-12T12:57:00.000-08:00

Progress Software Corporation a leading software provider that enables enterprises to be operationally responsive, announced today the availability of database drivers for the Microsoft SQL Server 2008 R2 Parallel Data Warehouse, announced this week at PASS Summit 2010. Available for pre-sales registration immediately with shipment in Q2 2011, the Progress(R) DataDirect Connect(R) drivers enable companies using Unix-, Linux- and Java-based applications to connect to Microsoft SQL Server 2008 R2 Parallel Data Warehouse.

more at here

Microsoft Ramps up Fight to Be Cloud Leader

2010-11-11T12:43:00.000-08:00

Microsoft has enhanced its Azure cloud service by giving customers the ability to launch and control Hyper-V based virtual machines and SQL Server instances, neither of which were available in earlier editions.

Read more at here

Microsoft's big grab for the cloud

2010-11-08T19:23:00.000-08:00

Remember when Steve Ballmer made this statement? "About 70 percent of our folks are doing things that are entirely cloud-based, or cloud inspired," he told an audience at the University of Washington last March. "And by a year from now that will be 90 percent."

more at here

How Facebook Makes MySQL Scale

2010-11-05T19:52:00.000-07:00

A few people from Facebook's database teams (yes, plural) recently gave a MySQL Tech Talk at Facebook headquarters about how Facebook uses MySQL to process 13 million queries per second. Former Facebook CTO and Quora founded Adam D'Angelo has said that Facebook is "stuck" with PHP and MySQL for legacy reasons, but it sure sounds the Facebook team is making the best of it. Video and notes after the jump.

http://www.readwriteweb.com/hack/2010/11/facebook-mysql-scale.php

Camouflage Software Expands Trial Version of Test Data Security Suite to include MS SQL Server

2010-11-05T06:53:00.000-07:00

Camouflage Software Inc., a leading provider of data masking technologies, is pleased to announce the expansion of a trial version of the Camouflage® Test Data Security Suite to include MS SQL Server™ databases. St. John’s, NL November 4th, 2010 – Camouflage Software Inc., a leading provider of data masking technologies, is pleased to announce the expansion of a trial version of the Camouflage® Test Data Security Suite to include MS SQL Server™ databases. This trial version of Camouflage will allow customers to easily discover and mask sensitive information within their organizations.

read more at here

InnoDB Remains Free as Part of MySQL Community Edition

2010-11-04T16:30:00.000-07:00

Here's what is really happening. InnoDB is free as part of the MySQL community edition, under a GPL license. For enterprise support, InnoDB is included with the exception of the Classic Edition, which uses the MyISAM storage engine.

The classic edition is an embedded database for ISVs, OEMs and VARs. It does not include InnoDB. Supported versions with InnoDB include the standard edition that costs $5,000 and a high-end version that comes with a price tag of $10,000.

read more at here

Cloud Computing and Oracle’s Standards

2010-11-04T16:26:00.000-07:00

More often than not, lack of standardization can add to the complexity of measuring and deploying emerging technologies. Consider cloud computing, for example. The fact that cloud services can give the user on-demand computing resources makes it a very attractive prospect for many businesses. A company can choose to host their services internally (on a private cloud) or remotely (on a public cloud). Regardless of this choice, monitoring of performance, usage, and security is crucial. Generally speaking, cloud computing services result in a simplification of IT tasks, but sometimes, they can make the application environment very complex. Such complexity leads to the need for stringent, globally applicable and accepted standards for managing infrastructure and other aspects of cloud computing.

more at here

Oracle Puts the Squeeze on SMBs with MySQL Price Hike

2010-11-03T17:01:00.001-07:00

Oracle is once again showing that it is determined to squeeze profits out of its open source projects. The owners of the MySQL database recently announced a round of price hikes for customers of the widely used open source database product. With this round of price hikes, Oracle is really putting the hit on SMBs who were traditionally the bread and butter of the MySQL business. But there is an alternative. As I wrote about a few weeks ago, a new company called SkySQL made up of ex-MySQL folks has started offering support and services to MySQL customers. In general, SkySQL prices are anywhere from 30 to 60% cheaper than the advertised Oracle price.

more at http://www.networkworld.com/community/node/68219

Bet on Microsoft's Cloudy Forecast

2010-11-02T15:45:00.000-07:00

Redmond's massive investment in forward-thinking cloud infrastructure is spreading across the globe, indicating that Microsoft will be worth partnering with for years to come.

More at http://rcpmag.com/articles/2010/11/01/bet-on-microsofts-cloudy-forecast.aspx

The price hike should kick in sometime in the next couple of months

2010-10-15T00:14:00.000-07:00

Oracle is going to increase the prices paying customers shell out for the MySQL open source database that came close to preventing its acquisition of Sun.

http://www.sys-con.com/node/1570774

Making the move to Data Protection Manager 2010

2010-09-29T03:01:00.000-07:00

Microsoft provides academic institutions with deep discounts that entice us to consider their solutions pretty carefully before moving on to other options.

http://blogs.techrepublic.com.com/datacenter/?p=3194

A SQL Database Built for the Cloud

2010-09-14T23:00:00.000-07:00

The challenges that MySQL faces in the cloud - questions of elasticity, synchronization, scalability - are often referenced as part of the arguments in support of NoSQL database alternatives. But today, Xeround announces a solution to the problems of MySQL in the cloud that is actually a SQL solution - a SQL database for the cloud.

more at http://www.readwriteweb.com/cloud/2010/09/a-sql-database-xeround.php

Google hits back at Oracle's lawsuitGoogle hits back at Oracle's lawsuit

2010-08-25T01:28:00.000-07:00

Google will put up a fight in response to the patent- and copyright-infringement lawsuit that Oracle filed over the use of Java in the Android mobile phone platform.

Oracle's lawsuit is a disappointing and "baseless" attack not only against Google but also against the open-source Java community, Google spokesman Aaron Zamost said on Friday.

more at http://www.infoworld.com/d/the-industry-standard/google-hits-back-oracles-lawsuit-933

Amazon introduces reservation system for databases in its cloud

2010-08-25T01:26:00.000-07:00

Amazon Web Services has introduced Reserved Database Instances, a new way to pay for its cloud-based Relational Database Service (RDS), the company said on Monday.

With Reserved Database Instances, users can make a one-time, up-front payment to reserve a database instance in a specific region for either one or three years, according to Amazon. In return, they get a discount off the ongoing hourly usage rate. A Reserved Database Instance costs from $227.50 for one year and $350 for three years plus $0.046 per hour. That compares to the standard hourly rate that starts at $0.11, according to Amazon's price list. If the database instance is used for the entire term, the discount can amount to up to 46 percent, Amazon said.

http://www.infoworld.com/d/cloud-computing/amazon-introduces-reservation-system-databases-in-its-cloud-170

Cloud Computing: Microsoft Windows Azure Cloud Platform: Top Attractions for Developers

2010-08-11T05:52:00.000-07:00

With Microsoft now touting its Windows Azure cloud computing platform as the best option for developers, this slide show provides multiple reasons why Microsoft officials say Windows Azure could be a game-changer as a development platform. Though Salesforce.com, Amazon Web Services, Google and IBM may disagree, Microsoft maintains that its developer story flexibility puts the company in the forefront among cloud solution providers. As Amitabh Srivastava, senior vice president of Microsoft's Server and Cloud Division, said from its inception, Windows Azure targets developers. Said Srivastava: "We support any language and multiple frameworks. We provide a rich ecosystem of technology or you can use open-source software like MySQL or Apache. Our approach is we don't put any shackles on the developer." Learn what other ways Microsoft claims Windows Azure is a contender for title of the best cloud platform for developers.
http://www.eweek.com/c/a/Cloud-Computing/Microsoft-Windows-Azure-Cloud-Platform-Top-Attractions-for-Developers-344774/

Programming Beyond Relational Features in SQL Server 2008 - A Free Live Webcast

2010-08-06T00:14:00.000-07:00

Programming Beyond Relational Features in SQL Server 2008 - A Free Live Webcast - Aug 19 @ 10am PT

Leonard Lobel, lead author of the Microsoft Press book Programming Microsoft SQL Server 2008, will guide you through detailed demos that showcase the new "beyond relational" features introduced in Microsoft SQL Server 2008. Register for the webcast now. More upcoming webcasts: Best Practices for Upgrading and Migrating to SharePoint 2010Presented by Joel Oleson, Dux Raymond Sy August 20 @ 10am ...

http://oreillynet.com/pub/e/1699

US Justice Department Sues Oracle Over Contract Fraud

2010-08-04T05:23:00.000-07:00

The US Justice Department sued Oracle, the world's second- biggest software maker, of fraud, and has filed a suit claiming that the company the company, more at http://www.adi-news.com/us-justice-department-sues-oracle-over-contract-fraud/22994/

The Open Source Software That Runs Facebook

2010-08-04T04:57:00.000-07:00

Facebook connects its 500 million users using an array of open source software to enable social networking as well as data intelligence. Facebook's open source Web serving infrastructure has a lot more than just the traditional LAMP (Linux/Apache/MySQL/PHP) stack behind it.

During a keynote session at the OSCON open source conference, David Recordon, the senior open programs manager at Facebook, detailed the infrastructure in use today at Facebook.
Read the full story at http://www.developer.com/features/article.php/3894566/Inside-Facebooks-Open-Source-Infrastructure.htm

Oracle Backup Failure Major Factor In American Eagle 8-Day Crash Read more: http://www.storefrontbacktalk.com/securityfraud/oracle-backup-failure-maj

2010-08-04T04:51:00.001-07:00

It seems a failure in an Oracle backup utility coupled with the failure of IBM hosting managers to detect it and to verify that a disaster recovery site was operational were the key factors in turning a standard site outage at American Eagle Outfitters into an 8-day-long disaster, according to an IT source involved in the probe

Read more: http://www.storefrontbacktalk.com/securityfraud/oracle-backup-failure-major-factor-in-american-eagle-8-day-crash/#ixzz0vdZNYlaU

Top 6 Misconceptions About Cloud Computing

2010-07-23T22:38:00.001-07:00

This time of year, when people think about buzz and clouds, it's typically related to the squadron of mosquitoes patrolling their backyard in search of that elusive patch of bare skin. But it’s also appropriate in the case of cloud computing, which, while frequently discussed in insurance IT circles, still doesn't have too many carriers currently on board.

Recognizing the buzz — and lack of bite — surrounding cloud, Slalom Consulting recently polled its clients to learn what they believed to be the most commonly held misconceptions about cloud computing.

According to Slalom, the top six misconceptions are:

Read at http://www.information-management.com/newsletters/cloud_computing-10018317-1.html?ET=informationmgmt:e1636:1010415a:&st=email&utm_source=editorial&utm_medium=email&utm_campaign=IM_Daily_072210

Data Deduplication Background: A Technical White Paper

2010-06-25T08:41:00.001-07:00

This technical white paper takes an in-depth look at data deduplication. Read on to develop a better understanding of what this technology does, how it does it, and why it is becomes such a popular tool among organizations looking to manage storage more efficiently.

Data Deduplication Background- A Technical White Paper

Seven reasons to care about SQL Server 2008 R2

2010-06-14T09:59:00.001-07:00

With Microsoft SQL Server 2008 R2, Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

http://www.networkworld.com/reviews/2010/060910-seven-reasons-to-care-about.html?inform

How Microsoft's Azure and cloud services are shaping up

2010-06-14T09:58:00.001-07:00

Monday's unveilings included an update to the Windows Azure software development kit (SDK), a new public preview of the SQL Azure Data Sync Service for syncing and distributing data among several datacentres, and SQL Server Web Manager, to develop and deliver cloud applications.

ZDNet UK spoke to Mark Taylor, the company's director of developer and platform evangelism, about Microsoft's whole approach to cloud computing, from infrastructure to data sovereignty, private clouds and licensing.

http://www.zdnet.co.uk/news/cloud/2010/06/11/how-microsofts-azure-and-cloud-services-are-shaping-up-40089188/

High Availability Database Solutions for PostgreSQL & Postgres Plus

2010-06-13T06:54:00.001-07:00

This paper discusses the failover and redundancy capabilities of specific high availability products that can be used in conjunction with PostgreSQL, Postgres Plus, and the Oracle-compatible database Postgres Plus Advanced Server.

High Availability Database Solutions for PostgreSQL & Postgres Plus

SQL Server Insider E-zine - Volume 2: Selling a SQL Server 2008 R2 Upgrade

2010-06-06T11:24:00.001-07:00

When proposing an upgrade to SQL Server 2008 R2 to management, you need to focus more on ROI than its cool, new features. In the second volume of the SQL Server Insider e-zine, you’ll learn how to draft a presentation that will wow the higher ups and convince them that migrating to SQL Server 2008 R2 is worth it

SQL Server Insider E-zine - Volume 2- Selling a SQL Server 2008 R2 Upgrade

What's New in MySQL Enterprise Spring 2010 Release

2010-06-06T10:57:00.001-07:00

MySQL is proud to announce the Spring 2010 Release of the MySQL Enterprise Monitor. This release improves the flexibility, usability and scalability of the MySQL Enterprise Monitor to alleviate common pain points for DBAs and developers, so that you can deploy advanced MySQL features more efficiently to build, maintain and scale your on-line applications.

Read the Paper

CUs Released

2010-05-22T08:39:00.001-07:00

Microsoft has released SQL Server 2008 SP1 CU8 (Build 2775). There are 18 fixes in this cumulative update, and most of them are for Reporting Services and Analysis Services.

Microsoft released SQL Server 2008 R2 RTM CU1. It is Build 1702, and it contains 76 fixes.

Lowering IT Costs with Oracle Database 11g Release 2

2010-05-19T10:05:00.001-07:00

Learn how you can transform your business, budgets, and service levels with Oracle Database 11g Release 2. You’ll discover how its new options and features can help you reduce server and storage costs, improve query performance, and ensure availability during database application upgrades.

Lowering IT Costs with Oracle Database 11g Release 2

SQL Server 2008 R2 Virtual Licensing Headaches

2010-05-13T11:53:00.001-07:00

If virtualization licensing wasn’t already difficult enough, should your company be contemplating virtualizing SQL Server 2008 R2, it might just have gotten harder. The problems center around the new Datacenter Edition which customers must buy if they want to have unlimited virtualization rights. However the Datacenter costs double what the Enterprise Edition for SQL Server R2 costs, which of course can now only support up to four operating system environments. Licensing costs themselves have risen for the Enterprise and Standard editions as well.

View article

5 Secrets to SQL Server Availability

2010-05-11T10:46:00.001-07:00

The following five secrets to affordable SQL availability will help you to implement a SQL environment with little or no downtime, zero data loss, and no added IT complexity.

5 Secrets to SQL Server Availability

Database Security for Security Professionals

2010-05-07T13:13:00.001-07:00

Information security professionals may be intrigued by emerging database security technologies like database access monitoring (DAM), but those protections are of little use without a solid understanding of the fundamentals of database design and management, context many infosec pros lack

Database Security for Security Professionals

Microsoft's Cloud Plan: What's In It For You?

2010-05-02T07:56:00.001-07:00

Microsoft's cloud computing strategy is a tale of two clouds. There are its popular software-as-a-service offerings: SharePoint, Exchange, Dynamics CRM, and the soon-to-be-released new Web version of Office 2010. And there's Microsoft's emerging platform as a service, Azure.

http://www.informationweek.com/news/windows/showArticle.jhtml?articleID=224700247

Databases and ERP Selection: Oracle vs SQL Server

2010-04-30T10:45:00.001-07:00

How do Oracle and Microsoft SQL Server database platforms compare on reliability, scalability and cost when run under enterprise software? Download this white paper for details.

Databases and ERP Selection- Oracle vs SQL Server

Why SQL Server 2008 R2 Matters to Small Business

2010-04-28T11:16:00.001-07:00

If you're like many small business owners, the news that Microsoft is weeks away from the release of a new version of SQL Server 2008 could seem utterly irrelevant to your interests. But it isn't. Microsoft has added important new features in this version that will help you delve more deeply into your business data, extract the most useful nuggets of information, and present them in a compelling way.

Best of all: If you're savvy enough to build a pivot table in Excel, you'll be able to use these features without the help of professional IT types.

http://www.pcworld.com/businesscenter/article/194808/why_sql_server_2008_r2_matters_to_small_business.html

Microsoft SQL Server 2008: What's New with R2?

2010-04-22T10:15:00.001-07:00

TITLE: Microsoft SQL Server 2008: What's New with R2?
PUBLISHER: Global Knowledge
DESCRIPTION: Are you ready for Microsoft SQL Server 2008 R2? This white paper highlights some of the major features included in SQL Server 2008 R2 due to be released in the first half of 2010.
URL: http://ra.techtarget.com/leads/magnifierResponded.do?email=dineshasanka@gmail.com&resourceId=1267476651_484&leadFollowupPathId=2953417&site=sss&asrc=EM_RMU_20100422

TITLE: Microsoft® SQL Server® 2008 R2 Data Sheet
PUBLISHER: Microsoft Corporation India Pvt Ltd
DESCRIPTION: Microsoft® SQL Server® 2008 R2 delivers several breakthrough capabilities that will enable your organization to scale database operations with confidence and improve IT and developer efficiency, as well as enable highly scalable and well-managed business intelligence on a self-service basis for your users. Read this data sheet to learn more.
URL: http://ra.techtarget.com/leads/magnifierResponded.do?email=dineshasanka@gmail.com&resourceId=1269909036_874&leadFollowupPathId=2953417&site=sss&asrc=EM_RMU_20100422

Oracle Database 11g for Data Warehousing and Business Intelligence

2010-04-21T11:40:00.001-07:00

This white-paper provides an overview of Oracle Database 11g's capabilities for data warehousing, and discuses its key features and technologies. Discover how to integrate information, perform fast queries, scale to very large data volumes, and more.

Oracle Database 11g for Data Warehousing and Business Intelligence

New SQL Azure Features Available

2010-04-20T10:48:00.001-07:00

New features introduced to Microsoft’ Cloud data platform make it easier for customers to migrate away from on-premise deployments, according to David Robinson, SQL Azure senior program manager. In this regard, SQL Azure now features Multiple Active Results Sets, ALTER rename and Application and Multi-server management. The evolution of SQL Azure was announced at the end of the past week, and the new additions are now live for customers to leverage and test-drive.

“These news features include: MARS (Multiple Active Results Sets), which simplifies the application design process; ALTER rename process for symmetry in renaming databases; Application and Multi-server management for Data-tier Applications which further streamlines application design and enables deployments of database applications directly from SQL Server 2008 R2 and Visual Studio 2010 to SQL Azure for database deployment flexibility,” Robinson stated.

http://news.softpedia.com/news/New-SQL-Azure-Features-Available-140177.shtml

Oracle Data Guard with Oracle Database 11g Release 2

2010-04-20T10:39:00.001-07:00

Read this white paper to learn about a unique data protection and recovery solution that provides the management, monitoring, and automation software to create synchronized standby databases that protect data from failures and other disasters.

Oracle Data Guard with Oracle Database 11g Release 2

Essential Steps to Implementing Database Security and Auditing

2010-04-19T09:23:00.001-07:00

Sponsored by Guardium, an IBM Company
Read this chapter from Implementing Database Security and Auditing by database security expert, Ron Ben Natan Ph.D., to learn best practices and specific tips for effectively securing most database environments, including tracking security vulnerabilities, the anatomy of buffer overflow vulnerabilities, and database auditing.

Essential Steps to Implementing Database Security and Auditing

MySQL under Oracle: No changes, except to what we say

2010-04-18T06:25:00.001-07:00

MySQL Con Kaj Arnö veered from the official keynote topic on The State of the MySQL Community and tackled the integration of MySQL into Oracle at the MySQL users’ conference on Thursday.

Or, in the words of the affable vice president of database community: "How the mapping of MySQL into Oracle is going. What's happening, what has changed already, what will change soon, and what won't change with Oracle as the steward of MySQL."

read at http://www.theregister.co.uk/2010/04/16/mysql_integration_oracle/

Oracle Reassures Developers about Future of MySQL

2010-04-16T10:11:00.001-07:00

Oracle Corporation will increase its investment in the open-source MySQL database it acquired with its purchase of Sun Microsystems, and it has already begun to make improvements to the software. So said Oracle's chief software architect, Edward Screven, during his "State the Dolphin" keynote address at the annual MySQL Conference and Expo in Santa Clara, Calif., this week.

http://adtmag.com/articles/2010/04/15/oracle-reassures-developers-about-future-of-mysql.aspx

Oracle invests in MySQL

2010-04-16T10:08:00.001-07:00

Oracle has decided to boost its investment in the MySQL open source database in order to compete against IBM and Microsoft's SQL server, states Zacks Investment Research.

Oracle acquired MySQL through the acquisition of Sun Microsystems, a provider of enterprise computing systems, software and services.

With its $7.5 billion acquisition, Oracle plans to enter the hardware market, where it will integrate Sun's hardware business into its own database and business applications software business.

http://www.itweb.co.za/index.php?option=com_content&view=article&id=32269:oracle-invests-in-mysql&catid=77:channel&Itemid=62

Advanced Compression with Oracle Database 11g Release 2

2010-04-16T09:59:00.001-07:00

Read this white paper to learn more about how Oracle Advanced Compression can help you reduce the disk space and costs of managing large data volumes.

Advanced Compression with Oracle Database 11g Release 2

Edison Group, Comparative Management Costs Study: Oracle Database 11g vs. Microsoft SQL Server 2008

2010-04-15T10:43:00.001-07:00

In this whitepaper presented by the Edison Group, reveals how Oracle Database widens the manageability lead over Microsoft SQL Server 2008. The study shows how Oracle Database can save 43% in time and 41% in database management costs over Microsoft SQL Server 2008.

Edison Group, Comparative Management Costs Study- Oracle Database 11g vs. Microsoft SQL Server 2

Oracle boosts MySQL investment, targets Microsoft

2010-04-15T10:21:00.001-07:00

In a bid to woo customers from rival Microsoft Corp, Oracle Corp will boost investment in the widely used MySQL open-source database that it acquired with its January purchase of Sun Microsystems.

http://www.reuters.com/article/idUSTRE63C3DV20100413

Microsoft links PHP and business intelligence

2010-04-11T00:43:00.001-07:00

Microsoft this week began offering a software development kit intended to boost interoperability between PHP applications and Microsoft's business intelligence and reporting software.

The company released the free SQL Server Reporting Services SDK for PHP. Developers can use the toolkit to build applications that run on top of Microsoft's SQL Server Reporting Services, leveraging business intelligence and reporting. Reports can be built and integrated with enterprise Web applications, thus providing greater access to information using graphically rendered data and rich content, a Microsoft representative said.

http://www.infoworld.com/d/developer-world/microsoft-links-php-and-business-intelligence-157

Bring Your Database Into The Cloud

2010-04-10T20:35:00.001-07:00

FathomDB announces itself to the world as “the easiest and best way to run a database on the cloud”. It makes such a claim based on the fact that it takes the concept of databases and propels it into the cloud, effectively turning the whole premise into something comparable to databases-as-a-service.
These databases have two immediate defining notes. First of all, they are relational. There is nothing to learn or rewrite if you are used to working with MySQL or any other standard format. And secondly, they are fully scalable. As the one implementing the service, you will be charged only for what you actually use - there are no up-front costs at all to be met.
Read more: http://www.killerstartups.com/Web-App-Tools/fathomdb-com-bring-your-database-into-the-cloud#ixzz0kl7tuo5e

High Availability on a (Government) Budget

2010-04-08T04:36:00.001-07:00

Whether managing emergency services, public records systems, government websites or water treatment systems, public services must maintain IT systems around the clock. Download this webcast to learn how imperative public services are efficiently protecting their data and application availability even with limited IT budgets and resources.

High Availability on a (Government) Budget

Microsoft SQL Server 2008: What's New with R2?

2010-04-08T04:01:00.001-07:00

Are you ready for Microsoft SQL Server 2008 R2? This white paper highlights some of the major features included in SQL Server 2008 R2 due to be released in the first half of 2010.

Microsoft SQL Server 2008- What's New with R2-

Your Enterprise Database Security Strategy 2010

2010-04-08T03:44:00.001-07:00

Database security is the last line of defense, so it deserves greater focus on the protection of private data from both internal and external attacks than IT pros have traditionally given it. Read this paper to learn what steps you can take to improve database security in your organization.

Your Enterprise Database Security Strategy 2010

Sun Oracle Database Machine

2010-04-03T10:52:00.001-07:00

This data sheet highlights the features and facts for the Sun Oracle Database Machine, the world's fastest for any type of database workload, and the only database machine that runs transaction processing applications.

Sun Oracle Database Machine

Microsoft turns 35: Best, worst, most notable moments

2010-04-03T10:28:00.001-07:00

The year is 1975. Gerald Ford is in the White House, South Vietnam falls, Muhammad Ali defeats Joe Frazier in the "Thrilla in Manila" world championship boxing match, the late-night comedy show NBC's Saturday Night (later called Saturday Night Live) debuts, One Flew Over the Cuckoo's Nest sweeps the Oscars, and Captain & Tennille's "Love Will Keep Us Together" and Glenn Campbell's "Rhinestone Cowboy" top the music charts.

And in Albuquerque, N.M., Harvard dropout Bill Gates and his high school friend Paul Allen set up a tiny business to write software for a new microcomputer called the Altair 8800. Their first product is the Altair BASIC language. At some point during that year, the company is called Micro-soft, and then MicroSoft, before it is ultimately named Microsoft.

http://www.itbusiness.ca/it/client/en/home/News.asp?id=57002

Clearing the Fog Around Microsoft's Cloud Computing Offerings

2010-04-03T10:25:00.001-07:00

Cloud computing. Everyone is talking about it. But cloud computing takes many forms. You may wonder what each cloud option is for and how cloud offerings differ from each other. Even if you limit the discussion of cloud computing and consider just two of Microsoft's cloud offerings, the Business Productivity Online Suite (BPOS) and the Windows Azure Platform, there's room for lots of confusion. You're not alone if you could use some clarification about how BPOS and Windows Azure fit together and how each offering relates to IT and business needs right now. Let's talk.

http://redmondmag.com/articles/2010/04/01/clearing-the-fog-around-cloud-computing.aspx

Microsoft Kicking Off SQL Server 2008 R2 Launch Tour at PASS European Conference 2010

2010-04-03T09:40:00.001-07:00

Microsoft Business Intelligence luminary Donald Farmer will head up the launch of the Microsoft SQL Server 2008 R2 Community Tour and dive into the new release at a special full-day Microsoft R2 Launch Event at PASS European Conference 2010 in Neuss, Germany, April 21-23.

R2, DBA, development, and BI sessions by top Microsoft and community experts will follow during two content-packed days of Europe's premier SQL Server

more at http://newsblaze.com/story/2010033102004900001.bw/topstory.html

Oracle(R) Database 11g Delivers World Record Result for a Two-Tier Configuration on SAP(R) Business Intelligence-Data Mart Standard Application Benchmark

2010-04-03T09:36:00.001-07:00

Oracle Database 11g Running on New Fujitsu PRIMERGY RX600 S5 Server Raises the Performance Bar for Business Intelligence Application Workloads

more at http://money.cnn.com/news/newsfeeds/articles/marketwire/0602401.htm

Database Security, Virtualization and Cloud Computing: The Three Key Technology Challenges in Protecting Sensitive Data in Modern IT Architectures

2010-04-03T09:24:00.001-07:00

There have been many changes recently in computing architecture, from dedicated servers in the data center to virtualization and cloud computing, and this has new implications for data protection. Read this paper to find out how to address these security challenges.

More at Database Security, Virtualization and Cloud Computing- The Three Key Technology Challenges in Pr

SQL Server 2008 R2 Now Supported by Attunity’s Change Data Capture and Operation Data Replication Product Lines

2010-03-29T06:13:00.001-07:00

With this, new and certified with CTP of SQL Server 2008 R2, release by Attunity, user can now capture and replicate changes that have been made to the new versions of SQL Server.

View article

Sun grows Oracle but stunts profits

2010-03-29T00:30:00.001-07:00

All eyes were on Wall Street this afternoon as software giant and new hardware vendor Oracle reported sales of $6.4bn for its third quarter of fiscal 2010 ended in February, up 17 per cent from the year ago period. However, thanks to its $7.4bn acquisition of Sun Microsystems, which happened a month before the end of the quarter, Oracle booked $34m in acquisition costs and had $306m in restructuring charges and that helped push net income down 10 per cent to $1.19bn.

http://www.theregister.co.uk/2010/03/26/oracle_q3_f2010_numbers/

Core Security Expert To Detail SQL Injection Testing

2010-03-28T06:24:00.001-07:00

Core Security Expert To Detail Advanced SQL Injection Testing At CanSecWest 2010 -- Leading Penetration Testing Specialist to Demonstrate Methods That Boost Accuracy of Automated SQL Injection Assessment

http://www.enterprise-security-today.com/story.xhtml?story_id=72349&full_skip=1

Oracle and SQL Server Too Difficult for Today's Cloud-based Data Management

2010-03-26T18:47:00.001-07:00

Two start-ups, FathomDB and Cloudscale are providing alternatives to traditional database management systems—making claim that traditional databases such as Oracle and SQL Server are just too expensive for today and too difficult to use for the average business user.

View article

Mapping SQL Server Features to Oracle Database

2010-03-25T11:45:00.001-07:00

Database administrators are often faced with the need to learn where features of his/her system live or reside on a less familiar system. Steve Callan approaches this need by mapping SQL Server features back into Oracle Database.

http://www.databasejournal.com/features/oracle/article.php/3871136/article.htm

SQL Server JDBC Driver 1.2 Downloads to Be Discontinued

2010-03-20T06:46:00.001-07:00

Microsoft is planning to kill off downloads of an older version of aType 4 JDBC driver designed to allow customers to leverage the standard JDBC application program interfaces (APIs) available in J2EE (Java2 Enterprise Edition) for database connectivity with SQL Server. Amina Saify, program manager – JDBC, revealed that the Redmond company was considering pulling SQL Server 2005 JDBC Driver 1.2 from the Microsoft Download Center.

SQL Server 2005 JDBC Driver 1.2 hasn’t been updated since the end of 2007, but it continues to be available for download even if Microsoft offered developers another major version of the driver in 2009. At the same time, the software giant is working on the upcoming iteration of the SQL Server 2005 JDBC Driver, namely version 3.0.

http://news.softpedia.com/news/SQL-Server-JDBC-Driver-1-2-Downloads-to-Be-Discontinued-137129.shtml

SQL Server 2005 SP4: What You Need to Know

2010-03-20T06:12:00.001-07:00

On a Microsoft Connect post, one user asked for a headcount concerning who would prefer Microsoft release an SP4 for SQL Server 2005. The vote? 1085 yea, 1 nay. Over 100 comments echo the same sentiments: "I really hope that Microsoft will release a SP4 for SQL Server 2005 soon."

http://www.sqlmag.com/article/sql-server/SQL-Server-2005-SP4-What-You-Need-to-Know.aspx

Apple's business database for Windows and Mac (you read right) moves forward

2010-03-20T06:05:00.001-07:00

FileMaker Pro 11 left beta testing for general release on Tuesday, adding a host of new capabilities for better productivity in database use, faster database creation, and easy production of eye-catching charts.

releases, the product has gained external links to Oracle, MySQL, and Microsoft SQL Server databases.

http://www.betanews.com/article/Apples-business-database-for-Windows-and-Mac-you-read-right-moves-forward/1268254481

Database expert Ronald Bradford on the pros and cons of migrating from Oracle to MySQL

2010-03-06T13:27:00.001-08:00

Oracle's acquisition of Sun has opened up all sorts of questions: Will MySQL get the support it needs? What will become of the MySQL community? Where should database administrators put their efforts and resources?

Ronald Bradford can answer that last question. Bradford, an RDBMS expert and a speaker at the upcoming MySQL Conference and Expo, has been guiding DBAs through key aspects of MySQL integration for years. In the following Q&A, he discusses the pros and cons of migrating from Oracle to MySQL (hint: it's not just about cost savings). He also weighs in on the future of MySQL and its community.

http://radar.oreilly.com/2010/03/oracle-to-mysql.html