(graz) This article covers the basics of full backup backups and restores in SQL Server. The examples are from SQL Server 2005 however it applies to SQL Server 2000 and SQL Server 2005. This is a very basic article covering full database backups, database restores and the simple and full recovery mo
Other News
Mastering Enterprise BI: Time Intelligence Pt. I
(William Pearson) As I stated in my article Introduction to SQL Server 2000 Analysis Services: Handling Time Dimensions, it is a rare thing to encounter an instance of an OLAP cube that does not require a Time dimension. Throughout years of business intelligence consulting, I have only witnessed thi
Getting the difference between two sets of like data
(Louis Davidson) A question came up on the forums the other day that a person wanted to compare two tables of data. Doing this is pretty easy using several techniques: –Using EXCEPT –Using NOT EXISTS –Using a FULL OUTER JOIN
Get more data comparison options in MySQL with operators you may not know
(Melonfire) It’s likely that if you’ve performed a SELECT or UPDATE query in the recent past, you’ve made use of one or more of MySQL’s comparison operators in constraining your query’s output. Comparison is an integral part of most SELECT queries, and MySQL comes with numerous functions for this; a
Radiating Intelligence
(David Baum) In a new vision for business intelligence (BI), all employees in an organization become potential decision-makers, whether they work in customer service, shipping, manufacturing, finance, human resources, or just about any other department. Companies with this vision are delivering anal
Introducing RDFa
(Bob DuCharme) For a long time now, RDF has shown great promise as a flexible format for storing, aggregating, and using metadata. Maybe for too long—its most well-known syntax, RDF/XML, is messy enough to have scared many people away from RDF. The W3C is developing a new, simpler syntax called RDFa
Managing OC4J and Configuring J2EE Applications
(Sam Alapati) Oracle Application Server 10g provides support for Java 2 Platform, Enterprise Edition (J2EE) applications, and support for J2EE is a crucial and integral part of Oracle Application Server 10g. This chapter is devoted to explaining how J2EE applications work and how the OracleAS compon
XML Inclusions reversal or transclusions strike back
(Oleg Tkachenko) Kzu, being also one of the Mvp.Xml project users has this wild feature request. He wants to reverse XInclude resolving back. The scenario is simple: you load XML document A.xml containing XML Inclusions for B.xml and C.xml, XInclude processor resolves XML Inclusions, you get a combi
Database Independent Development using ASP.NET 2.0
(Jagadish Chaterjee) This article shows you how to develop database independent applications using ASP.NET 2.0. I shall also show you how to develop a simple database independent data access layer using ADO.NET 2.0.
Documenting the High Availability Environment
(Bob Gast) By deploying high availability (HA) technology, you can shrink disaster-induced system downtime to 20 minutes or less. You can also deliver uninterrupted system access while maintenance activities are being performed.