Feeds

Dell bundles up SQL Server 2012 data warehouse appliance

Swaddled in PowerEdge metal, sipping Boomi ba-ba

Internet Security Threat Report 2014

Dell might be chasing large enterprises like mad these days, but it has not forgotten the small and medium business customers that made the company a player in IT. SMBs need data warehouses as much as the big boys, but they have less money and less skills with which to slap one together. That's where, Dell hopes, its QuickStart Data Warehouse Appliance 1000 comes in.

The system maker hinted back in February, when it pre-announced the PowerEdge 12G server lineup, that it was working on such an appliance – a mashup of Dell's Boomi integration service and a PowerEdgie running Windows Server and the SQL Server database, all preconfigured and ready to suck data out of your systems.

Specifically, the appliance is based on a PowerEdge 720R rack-based server with only one 3.3GHz, four-core Xeon E5-2643 processor installed in one of its two sockets. The machine is equipped with four 16GB DDR3 memory sticks running at 1.33GHz, and has a total of 24 2.5-inch disk drives in the front and two in the rear.

There are eighteen 300GB disks spinning at 10K RPM that are used for data stored in SQL Server 2012, plus four of the same drives to store the data logs.

There are two drives in the rear of the chassis – 600GB 10K RPM units – that are used to hold Windows in a RAID 1 mirror, and the two remaining drives in the front of the chassis are 600GB hot spares to back up the OS disks or the data disks, whichever one fails first.

The data warehouse appliance is configured with Windows Server 2008 Enterprise Edition at the R2 SP1 level, which is the latest-greatest release until Windows Server 2012 ships in September. The server is configured with SQL Server 2012 Data Warehouse Appliance Edition. This is not one of the normal editions of the database, which currently includes Enterprise, Business Intelligence, Standard, and Express Editions – this variant is based on the Enterprise Edition of SQL Server 2012. But it looks like it is based on a scaled-down version of Enterprise Edition in that it has the xVelocity ColumnStore indexing capability and Remote BLOB (Binary Large Object) support added in.

The software stack has been tuned and put through Fast Track reference architecture integration testing so partners can peddle it and know that all the parts work together. The first edition of the data warehouse appliance scales to 5TB of usable data, which is plenty big enough for lots of SMBs.

That gives you the baby data warehouse, but you need the Boomi integration service from Dell to extract data from various production applications so that there is something to do ad hoc queries on. The QuickStart Data Warehouse Appliance 1000 includes a one-year license to the Boomi service with five standard connectors to data sources and five test connections.

Dell also provides tech support for the whole shebang and tosses in a set of services called Foundation Pack, which includes 32 hours of setup, hands-on training in data-warehouse concepts, and a post-installation check by a data-warehouse architect. Dell also tosses in quarterly health checks on the appliance and on the data designs and schemes customers create for their data warehouses to suggest improvements. (Yeah, "Buy more iron.")

The QuickStart Data Warehouse Appliance 1000 is available now and has a list price of $69,990. It is not clear what the Boomi and other Dell services cost, but a typical Boomi customer gets addicted to data integration and spends on the order of $20,000 a year for the service.

Which Michael Dell just loves. ®

Internet Security Threat Report 2014

More from The Register

next story
Cray-cray Met Office spaffs £97m on VERY AVERAGE HPC box
Only 250th most powerful in the world? Bring back Michael Fish
UK.gov pushes for SWIFT ACTION against nuisance calls, threatens £500k fines
DCMS seeks lowering of legal threshold to fight rogue firms
Just don't blame Bono! Apple iTunes music sales PLUMMET
Cupertino revenue hit by cheapo downloads, says report
The DRUGSTORES DON'T WORK, CVS makes IT WORSE ... for Apple Pay
Goog Wallet apparently also spurned in NFC lockdown
Microsoft brings the CLOUD that GOES ON FOREVER
Sky's the limit with unrestricted space in the cloud
'ANYTHING BUT STABLE' Netflix suffers BIG Europe-wide outage
Friday night LIVE? Nope. The only thing streaming are tears down my face
Google roolz! Nest buys Revolv, KILLS new sales of home hub
Take my temperature, I'm feeling a little bit dizzy
prev story

Whitepapers

Cloud and hybrid-cloud data protection for VMware
Learn how quick and easy it is to configure backups and perform restores for VMware environments.
Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Saudi Petroleum chooses Tegile storage solution
A storage solution that addresses company growth and performance for business-critical applications of caseware archive and search along with other key operational systems.
How to simplify SSL certificate management
Simple steps to take control of SSL certificates across the enterprise, and recommendations centralizing certificate management throughout their lifecycle.