Will the database move into the cloud?

2010-01-13T06:21:00-07:00

In 1999 when senior vice president Marc Benioff left Oracle to create Salesforce.com, many thought he was headed for a cliff at full steam but 10 years down the line, software as a service (SaaS) is a matured business model. Online productivity applications have joined the fray and are maturing at a brisk pace (Say Google Docs, Zoho).

In our modern enterprise, the database is a corner of most of the software architecture and I ask myself, will the database move into the cloud too? Will I be able to implement applications and point it to a database somewhere unknown?

The benefits are obvious – zero hardware configurations, zero backups (hey, I could spend a million dollars for that!), titanium grade security protection, etc. But should things fail, I have loss of data staring me in the face. With that I could get a jail time or be bankrupt depending on what data is missing.

These are interesting times.

Create a Replica Table based on another Table Schema

2008-06-13T05:46:00-07:00

A quick and dirty way to create a table in MS SQL as a replica of another table without having to move data from first table to the second one. Say you want to create Table B based on Table A schema:SELECT TOP 0 * INTO TABLE B FROM TABLE A

The King and Abrastisio

Will the database move into the cloud?

Create a Replica Table based on another Table Schema