Easy Upgrade SQL Server 2000/2005 to SQL Server 2008

Fri, 31 Oct 2008 12:26:00 +0000

Easy way to upgrade SQL Server 2005 to SQL Server 2008.

DateTime.MinValue underflow in SQL Server

Wed, 22 Oct 2008 09:29:00 +0000

You get an overflow exception when you save DateTime.MinValue into a SQL Server "datetime" column. (.NET, C#, VB.NET, SQL Server, PostgreSQL)

Get Approximate Row Count Fast on SQL Server

Fri, 26 Sep 2008 08:51:00 +0000

Here's how to find the approximate row count for any indexed table quickly in SQL Server.

Cycling SQL Server Logs

Tue, 23 Sep 2008 18:55:00 +0000

You can force SQL Server to flush the log to file and cycle the log numbers (SQL Server 2005, 2008)

How to Backup SQL Server to a Network Shared Folder

Tue, 17 Jul 2007 16:14:00 +0000

If you try to backup your SQL Server database to a Windows shared folder on a network PC, you're in for a little bit of a surprise. The following command is a valid statement but SQL Server will throw you an ugly exception. There are a couple of solutions you can workaround the problem.

New Snapshot Isolation Level in SQL Server 2005

Sat, 14 Jul 2007 13:05:00 +0000

Starting with SQL Server 2005, you can now use Snapshot Isolation to eliminate blocking READ operations and get rid of those pesky SQL locks. Snapshot Isolation is a better choice for OLTP operations where you expect a large number of reads and moderate writes. Your system will be able to scale much higher. Here's how to set your SQL Server database to use the new isolation level...

How to Find and Delete Duplicate Entries in a Table

Thu, 05 Jul 2007 10:24:00 +0000

Someone asked me today how to find a duplicate entry in a table using SQL. One of his tables became corrupted after SQL Server accidentally dropped his Unique Index on a field. As a result, the same data got inserted multiple times and he needed a way to find out which and how to delete them...

Dell’s enterprise challenge remains after losing 3Par

Sun, 05 Sep 2010 06:52:28 +0000

SEATTLE — Dell Inc. doesn’t have to start over in its quest to become a significant purveyor of technology for businesses after losing a multibillion dollar bidding contest for an obscure data-sto

The Leading Business Weekly

Sat, 04 Sep 2010 21:50:25 +0000

Because this web site wants to demonstrate its commitment to your privacy, it has agreed to disclose its information practices and have its privacy practices reviewed for compliance. If you have questions or concerns regarding this statement, you should contact The Standard.

YC-Funded Cloudant Launches Its NoSQL Cloud Database Platform

Fri, 03 Sep 2010 09:50:52 +0000

YCombinator -funded Cloudant , a database platform built around Apache’s open source CouchDB framework, officially launches after three years of hard work. Cloud-based like Cloudera and Amazon Web Services and part of the NoSQL movement, Cloudant scales your database on the CloudDB framework but also provides hosting, administrative tools, analytics and support so "You don't have to think a lot ...

Dell's enterprise challenge remains after 3Par

Fri, 03 Sep 2010 01:48:44 +0000

Dell Inc. doesn't have to start over in its quest to become a significant purveyor of technology for businesses after losing a multibillion dollar bidding contest for an obscure data-storage maker.

IBM Breaks Double Digit Performance Barrier

Thu, 02 Sep 2010 17:24:10 +0000

Bangalore, Sep 2: IBM today announced an IBM POWER7-based system with IBM DB2 database software while IBM System Storage broke all previous records and topped the 10 million transactions per minute mark using the industry standard TPC performance benchmark, besting all previous results by competitors such as HP and Oracle.

IBM breaks double digit performance barrier

Thu, 02 Sep 2010 16:17:29 +0000

United News of India Bangalore, Sept 2: IBM today announced an IBM POWER7-based system with IBM DB2 database software while IBM System Storage broke all previous records and topped the 10 million transactions per minute mark using the industry standard TPC performance benchmark, besting all previous results by competitors such as HP and Oracle.

EMC builds new data computing division around Greenplum

Thu, 02 Sep 2010 15:29:23 +0000

EMC has acquired Greenplum and is building a Data Computing Products Division around it. Is this move purely opportunistic or part of a grander strategy?

The emergence of applications-managed storage

Thu, 02 Sep 2010 15:28:43 +0000

Technologies are now emerging that will enable automated data and storage management that is linked directly to the needs of the application environment.

Relational Database Software supports data sharing.

Tue, 31 Aug 2010 12:52:09 +0000

Designed for application developers of embedded systems and devices, ITTIA DB SQL v3.2 supports shared memory, which is compatible with existing TCP/IP transport, allowing data to be shared between local and remote connections. With storage-level locking, threads and processes can be read from database, but exclusive access is obtained automatically before writing changes. Savepoints can be used ...