Category: Backup Software Tags: Backup software, Restore softw Compatibility: SQL Server 2000 only Description:
Author: SSWUG Research
HOW TO: Rotate a Table in SQL Server
This article describes how to rotate a SQL Server table. Suppose you have a table that is named QTRSALES. The table has the columns YEAR, QUARTER, and AMOUNT with the data in the following format (note that there is no row for the fourth quarter of 1996):
Microsoft Reiterates SQL Slammer Warning
by Scott Bekker – In response to the publication of the SQL Slammer source code in a major industry magazine, Microsoft officials are warning users to make sure they’ve taken advantage of the rash of SQL Slammer defenses on the Microsoft Web site.
J.D. Edwards Says Oracle May Be Violating Antitrust Laws In PeopleSoft Bid
By Beth Bacheldor – Kicking off his company’s annual user conference Monday, J.D. Edwards & Co. chairman, president, and CEO Bob Dutkowsky said Oracle’s $5.1 billion bid late last week to buy PeopleSoft Inc. could ultimately violate antitrust laws because it will reduce customer choice.
Oracle Simplifies Java Development
By Darryl K. Taft – Tying into a major theme of the JavaOne conference here this week, Oracle Corp. Tuesday previewed its new Application Development Framework, a feature of the company’s next version of its Oracle9i JDeveloper tool that will enable developers to more easily develop enterprise Java
Denormalization of DB2 tables
by Craig Mullins – Speeding the retrieval of data from DB2 tables is a frequent requirement for DBAs and performance analysts. One way to accomplish this is to denormalize DB2 tables. The opposite of normalization, denormalization is the process of putting one fact in many places. This speeds data r
Just the Stats, Ma’am
By Robert Catterall – Statistics reports can reveal surprising facts about the subsystem you thought you knew well.
Ascential Software and IBM DB2 Cube Views Maximize the Performance of Business Intelligence Solutions
Ascential Software Corporation (Nasdaq: ASCL), the enterprise data integration leader, announced full support for IBM’s new DB2 Cube Views software. The Ascential(TM) Enterprise Integration Suite combines with Cube Views to accelerate the development and lower the total cost of ownership for online
Making Use of the XML Data Source Object
by Premshree Pillai – The XML Data Source Object is an ActiveX control that allows you to manipulate data between XML files and HTML pages. This article will show you the basics of how to extract content from various XML data sources and how to present that data using a little JavaScript.
Install Those Service Packs!
By Michael Otey – You might not need the new functionality a service pack provides, but prompt installation of service packs could be the very thing that beats virus writers to the punch.