There are many options available to recover tablespaces and indexes to a previous point in time. However, when tablespaces and indexes are undamaged, alternative solutions are available.
Other News
Red Gate’s SQL Toolkit Helps SyZLaB Automate Changes for 200 SQL Server Databases
by Kathleen Wheatley – Companies talk all the time about their data and information being “mission-critical,” “strategic” and “available 24/7,” but reality often doesn’t match the claims. SyZLaB, a Norwegian company that develops and sells web publishing and content management systems, doesn’t have
Microsoft to Simplify Patching
(Madeline Bennett) Microsoft will next month begin beta testing its new patch installer, which promises automatic updates for a number of products. Microsoft Installer 3.0 is a unified update tool for several products, including Office, Excel and SQL Server. It will be followed by an installer fo
Tracking Data Access Patterns in Oracle
By James F. Koopmann – Performance in Oracle is directly related to the SQL workload that is submitted. Often it is not the change in the SQL that degrades performance but instead is the access path to that data. This article will help you understand when new access paths have been introduced in you
Selecting Nth MAX or MIN
by Ramcharan Karthic – This Select query will help you select the Nth Max or Min value from any table. For example, consider a table TAB1 in which you want to find the Nth Max or Min from the column, COL1.
Creating an XML Schema using VS.Net – Part – II
by J.V.Ravichandran – Before proceeding to the Complex types, let us look into creating the “Unnamed Simple Types” that appears in the right-side combo box of an element. Follow the same procedure as in creating Simple types (Creating an XML Schema using VS.Net – Part – I) i.e., from the toolbox, dr
Overheard at Extreme Markup Languages 2003
By Simon St.Laurent – Extreme Markup Languages had its usual thought-provoking intensity this past week in Montreal. The following bits may provoke yet a few more thoughts.
Experiences in writing XML documents
By Benoît Marchal – In this article, I survey the three most popular paths to build XML user interfaces. I will compare their characteristics and include many links so you can download products and test for yourself.
Blaster worm attack a bust
By Paul Roberts – A scheduled denial of service attack against Microsoft Corp.’s main software update Web site did not materialize Saturday, as computers infected with the W32.Blaster worm failed to find their target.
Data Modeling for Everyone : Free sample chapter for you to read, from the new book
Book by Sharon Allen – Data Modeling is about gathering, documenting and communicating the elements and structure of business information. What begins as a conceptual interplay of logical data units, through the application of rational theory, becomes the basis for creating a physical database desig