(Sanjay Mishra, Michael Thomassy and Peter Byrne) Database Snapshots (http://msdn2.microsoft.com/en-us/library/ms175158.aspx) in SQL Server 2005 Enterprise Edition allow a read-only point-in-time view of data. Recently we encountered an interesting scenario with a customer implementation. The custom
Other News
FIX: Error message when you use a Volume Shadow Copy Service (VSS) writer to back up a snapshot in SQL Server 2005 or in SQL Server 2000: ‘Attempt to release mutex not owned by caller’
When you use a Volume Shadow Copy Service (VSS) writer to back up a snapshot in Microsoft SQL Server 2005 or in SQL Server 2000, an event that resembles the following may be logged in the Application log: Event Source: SQLVDI Event Category: None Event ID: 1 Date: Time: User
Special Characters in XML Element and Attribute Names
(Srinath MS) When creating XML files, sometimes there are fields (elements/attributes) where you need to use special characters like space, &,
Table Space Reporting with dba_spaceused
(Andrew Novick) Managing space is a constant responsibility for the DBA. When space becomes a problem I often want to know the size of each table. It isn’t difficult to find the amount of space used by a table, SQL Server provides the sp_spaceused stored procedure, which can report on the space use
Preserving XML queries during schema evolution
(Mirella Moura Moro, Susan Malaika and Lipyeow Lim) The always evolving context of the Web imposes the challenge of how to accommodate new functionalities and new data types in the database that underlies a Web application or service. For XML databases, new schema versions can be released as frequen
Working with Custom Provider Controls
(Brian Mains) The ASP.NET framework is made of up custom HTML and Server controls that are the building blocks for developing ASP.NET web applications. Other technologies are highly utilized in the web development process, such as HTML, CSS, and JavaScript; however, for data-driven or server-based
Programming Crystal Reports with ASP.NET 2.0
(Jagadish Chaterjee) This is the first article in a series focusing on programming with Crystal Reports with ASP.NET 2.0. In this article, we will focus on adding a Crystal Report to an ASP.NET 2.0 web site and displaying the same using the CrystalReportViewer control in a number of different ways.
sql*plus pagesize explained
(Laurent Schneider) SQL*Plus is a not only the command-line interface to the database server, it is also a featured reporting tool with paging capabilities. The pagesize is the number of rows of one page. The default is 14 and the maximum is 50000. One of the common property of the page is the heade
Handling Result Sets and More with PDO Objects in PHP 5
(Alejandro Gervasio) Building PHP applications that interact with different database systems can be a daunting task, especially from a developer’s point of view. To tackle this issue with minor hassles, PHP 5.1 comes bundled with a powerful extension called PDO (short for PHP Data Objects), a librar
Sorting
(Jonathan Lewis) This queston came up on the Oracle newsgroup a few days ago: I have a table (call it policy) with three columns a, b and c. The table has two rows, with column c having value zero for both rows. I run the following query select * from policy order by c;