Database management system DBMS architecture design and strategy
- January 19, 2006
Top Oracle executives took to the stage yesterday to detail the progress of Fusion thus far and to lay out a Fusion roadmap for the future.
- January 12, 2006
Oracle and Sun yesterday renewed their vows of collaboration and detailed their plan to give Microsoft .NET a Java-based run for its money.
- January 05, 2006
There are different approaches that need to be taken in evaluating a vendor-led or a consumer marketplace for data warehousing.
- December 29, 2005
You may want to consolidate SQL Servers to reap the reduced licensing, hardware and administrative costs, but there are various "gotchas" to consider before making such a move. Contributor Hilary Cotter outlines the pros and cons.
- December 26, 2005
A typical SQL Server shop has some combination of newer and older database versions running, posing a challenge to application functionality. This tip discusses the expiration of older version support and how to integrate multiple versions ...
- December 20, 2005
You must regularly test SQL Server security if you hope to identify security weaknesses before an intruder does. Contributor Kevin Beaver offers SQL Server security testing methods, tools and a checklist to help you find and fix vulnerabilities.
- December 15, 2005
Enterprise Manager's standard tools aren't much help in examining SQL Agent jobs. To get details about jobs currently running, try this sp_ListJobInformation routine instead.
- December 15, 2005
In a large SQL Server 2000 installation, you have to contend with many backup and recovery challenges, from monitoring to testing with minimal impact on network bandwidth. Edgewood Solutions' Greg Robidoux offers points to consider when establishing...
- December 13, 2005
As databases become more alike and all of them have the capability to pull data from multiple sources, dare to be different! Moving everything to a single platform can make things less complicated.
- December 08, 2005
No matter what type of company you work for, chances are you have to prepare for spikes in SQL Server activity throughout the year. (Online retailers are in the midst of one right now.) Learn how to maintain highly available, fast-performing SQL ...
- December 07, 2005
This excerpt from the new book by Kevin Keenan introduces the three types of data cryptography.
- December 05, 2005
You may not classify hardware and application failures as disasters, but fail to prepare for such problems and you could have a system meltdown on your hands. This checklist will help you develop the documentation and best practices you must have ...
- November 29, 2005
Seven quick rules for designing correct primary keys in Oracle databases.
- November 28, 2005
Early adopters tend to pay the price for kinks not yet worked out of new technology products. But SQL Server 2005 is not entirely new and may not need to be treated as such, says Edgewood Solutions' Greg Robidoux. He explains the benefits and risks ...
- November 23, 2005
SAP plans to acquire Khimetrics Inc., a retail software vendor with expertise in profitability forecasts and pricing strategies.