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...

Infrastructure stack alliances bring benefits and drawbacks to enterprise data ... - Search Storage

Thu, 11 Mar 2010 15:00:53 +0000

Infrastructure stack alliances bring benefits and drawbacks to enterprise data ... Search Storage HP's infrastructure stacks will extend from the Microsoft application down through server, networking and storage hardware, more like Oracle's database ...

Data Warehousing Platform promotes architecture flexibility. - ThomasNet Industrial News Room

Thu, 11 Mar 2010 13:42:26 +0000

Data Warehousing Platform promotes architecture flexibility. ThomasNet Industrial News Room (press release) The combination of processor enhancements, expanded main memory, and a faster data storage subsystem enables 65 percent higher performance for the node, ... and more »

Akvelon's New Web Analytics Solution Boosts Large Electronics Retailer's ROI - PR Newswire

Thu, 11 Mar 2010 13:31:40 +0000

Akvelon's New Web Analytics Solution Boosts Large Electronics Retailer's ROI PR Newswire (press release) The Akvelon Web Analytics Solution processes large volumes of data in real time without relying on a prohibitively expensive classical pure database system, ... and more »

Service Optimization: A Winning Approach for Delivering Business Value - TMCnet

Thu, 11 Mar 2010 12:48:10 +0000

Service Optimization: A Winning Approach for Delivering Business Value TMCnet The approach identifies underperforming management processes within the data center — including processes in database, operations, systems, storage, ... and more »

NoSQL Supporters Challenge Relational Databases - InternetNews.com

Thu, 11 Mar 2010 00:10:07 +0000

NoSQL Supporters Challenge Relational Databases InternetNews.com "There are a new class of problems that can be solved with different types of database solutions that in some cases require more flexible data storage ...

Tech Start-ups Cope With Data Flood - Wall Street Journal

Wed, 10 Mar 2010 19:57:14 +0000

Tech Start-ups Cope With Data Flood Wall Street Journal A key issue has been the bottleneck created by data-storage systems. Fusion-io Inc., No. 2 on this list, tackles this with newfangled systems that, ...

interCLICK Chooses Netezza TwinFin Appliance to Power Its Data-Enrichment Platform

Wed, 10 Mar 2010 17:45:25 +0000

NEW YORK -- interCLICK, Inc. today announced that it has chosen the Netezza TwinFin data warehouse appliance to support its newest platform, known internally as Open Segment Manager (OSM), the first data-enrichment platform for online display advertising.

Truly Open Data

Wed, 10 Mar 2010 16:30:37 +0000

I'm kicking myself. I have spent a non-trivial number of hours talking to government departments and scientists about open data, talking up an "open source approach" to data, pushing hard to get them to release datasets in machine readable formats with reuse-friendly licenses. I've had more successes than failures, met and helped some wonderful people, and now have more mail about open data in ...

Symantec Unveils Object File System to Manage Data Growth

Wed, 10 Mar 2010 11:35:41 +0000

MOUNTAIN VIEW, Calif. — Symantec demonstrated a new Object File Server technology it said its researchers have developed to help deal with the management and storage issues IT is facing in dealing with the massive growth of unstructured data.

Raima's Embedded Database on the iPhone - Earthtimes

Wed, 10 Mar 2010 08:05:21 +0000

Raima's Embedded Database on the iPhone Earthtimes (press release) This application, on the other hand, uses the RDM Embedded database engine for its data storage and access. In fact, there are no SQL statements used at all ... and more »

Raima’s Embedded Database on the iPhone

Wed, 10 Mar 2010 07:00:00 +0000

Raima published a cool iPhone application on iTunes which is based on their popular embedded database product RDM Embedded. The free application allows users to enter a departing airport and an arriving airport and then displays all the direct flights between the two airports.

Hitachi Data Systems' Yoshida on HDS future, post Sun/Oracle - Search Storage

Tue, 09 Mar 2010 23:41:51 +0000

Hitachi Data Systems' Yoshida on HDS future, post Sun/Oracle Search Storage Yoshida: Exadata is more specifically focused around being a database engine. That's not a general-purpose storage product, so it's something we could also ... and more »

BioDiscovery Turns to the Cloud to Support Collaborative Copy Number Variation Database

Tue, 09 Mar 2010 21:00:33 +0000

BioDiscovery has turned to the Amazon Elastic Cloud to support a collaborative repository for genomic variation data that is linked with its Nexus Copy Number analysis software.

GenomeQuest Opens API for Sequence Data Management

Tue, 09 Mar 2010 18:44:44 +0000

Cambridge, MA — At a gathering of life science researchers, bioinformatics developers, and computational biologists, GenomeQuest today announced a comprehensive Application Programming Interface (API) to its fast-growing sequence data management (SDM) platform.

Network Monitors offer data mining and performance analysis.

Tue, 09 Mar 2010 13:50:58 +0000

Savant(TM) data mining and network analysis devices simultaneously provide protocol decodes, data analysis, and near 100% packet captures and also include security surveillance and forensic analysis. Accumulator(TM) allows devices to warehouse and index data at rates of 400 million items/sec. Systems also offer tracking and instrumentation of email, chat, DNS, VoIP, socket API calls, SQL, or any ...

Oracle Exadata database engine to integrate Flash storage

Tue, 09 Mar 2010 10:23:17 +0000

Servers to feature embedded drives for performance The second iteration of Oracle's Exadata database engine will feature flash storage embedded within the server machine, eliminating the need to source data from storage disks and cutting query processing time significantly, a company executive revealed.

Storage Guardian Announces ‘Virtual Backup Roadmap’ for SQL 2008 Users

Tue, 09 Mar 2010 10:00:00 +0000

MSPs and small businesses planning to migrate a physical installation of Microsoft SQL Server 2008 to a virtual model can now take advantage of zero upfront software/hardware cost program that features Asigra technology. Storage Guardian’s capacity-based pricing means no additional license fees when making the switch, plus a completely smooth transition to a dependable, cloud-based solution.

IT centralization is back in fashion

Tue, 09 Mar 2010 09:57:47 +0000

When the economy plummeted at the end of 2008, the Western U.S. branch of The Salvation Army was ahead of the cost-cutting game. CIO Clarence White had centralized the IT organization a year or two earlier, and he had consolidated the database and storage servers from the business units into a single data center in Long Beach, Calif.

New, Faster Teradata Active Enterprise Data Warehouse Platform Delivers ... - PR Newswire

Fri, 05 Mar 2010 16:01:29 +0000

New, Faster Teradata Active Enterprise Data Warehouse Platform Delivers ... PR Newswire (press release) The combination of processor enhancements, expanded main memory, and a faster data storage subsystem enables 65 percent higher performance for the node, ... and more »

Data Storage Corporation to Present at the Fourth Annual "Spring Break for ... - CNNMoney.com

Mon, 01 Mar 2010 19:26:11 +0000

Data Storage Corporation to Present at the Fourth Annual "Spring Break for ... CNNMoney.com (press release) Data Storage Corporation's SEC filings can be accessed through the SEC's EDGAR Database at www.sec.gov (Data Storage Corporation has EDGAR CIK No. ... and more »