(Scott Shaw) I hear the rumblings of DBA’s facing the prospective of virtualizing their databases. Some have managed to stave off the inevitable while others have embraced it slowly one test or development database server at a time. I’m writing a series of tips as a guide from a DBA who has already
Other News
Virtual Machine Experiences
$$SWYNK$$ Virtual Machine Experiences I recently had a discussion with my older brother who manages the servers for a large city on the West Coast. I was sharing how virtual servers, providing the same capacity as a physical server, actually cost more to own and maintain. My brother replied that Virtual servers had actually saved the city a great deal […]
Right on Cue: Facebook and Hadoop (Data Hoarding)
Right on Cue: Facebook and Hadoop (Data Hoarding) Now, I’m not saying data on Facebook is "hoarding" but consider what’s there. They are setting a fine example of how to manage a massive store, make it readily available and dealing with exponential growth, all in one… they’ve just moved their Hadoop cluster to a new facility and, I have to […]
Are You Virtual?
$$SWYNK$$ Are You Virtual? This is an old topic. Surveys and questionnaires abound for longer than a decade regarding the adoption of virtual operating systems and services. I’d like to revisit the topic as the game has changed considerably over that last few years. Most servers, even the low end servers for departmental or small business use, ship with 64bit […]
Processing the Groupon API with MapForce – Part 2
(DaveMcG) In Part 1 of this series we described how to connect Altova MapForce to the Groupon API. We queried the API for a list of Groupon divisions, then used the list to create API queries for all the current deals from every division.
Saving Space Through SQL Server Data Compression
(Claire Hsu) Data Compression is one of the exciting features available in the SQL Server 2008 release. It’s only available on the Enterprise and Developer Edition. Unlike backup compression, you can control it by setting in the SQL instance level. Data Compression requires individual handling on ta
Use PHP with Identi.ca, Part 2
(Vikram Vaswani) Identi.ca is a popular free microblogging service that allows users to post status messages and news. Web application developers are able to create, access, and search these messages through the Identi.ca API.
Basic T-SQL Statements – create database and table
(MichaelSimon) So you have SQL Server and you want to add a database in your SQL Server Management Studio. Open SQL Server Management Studio (SSMS) from windows start menu – all programs – SQL Server folder.
IBM DB2 Improves Performance Lead for x86-64 Systems with a new Record-Breaking Result
(Conor O’Mahony) Last year, I blogged about how IBM DB2 has the Leading x86-based TPC-C Result. Well, IBM has further cemented DB2Œs position as the leading database for x86-64 systems with a new record-breaking TPC-C benchmark result.
To OCP or not to OCP, that is the question
(Matt Canning) Over the years, the topic of whether or not to take the Oracle Certified Professional (OCP) exams has been discussed many times. A large number of clients and agencies now regularly ask for candidates who are OCP qualified.