(Greg Robidoux) In a previous tip we discussed the different recovery models SQL Server offers and decision points on which to base your recovery model selection. After you’ve selected the appropriate recovery model, you need to put in place the proper backup strategy to minimize data loss and downt
Other News
Tip: Use XML to Send SMS Messages
(Nicholas Chase) Many developers tend to think of Web services as a way to easily move information from one place to another, but it’s also important to understand how integral a Web service can be to the overall application. This tip gives some examples of using XML for Short Message Service (S
Applying Oracle 10g’s Hierarchical Query options
(Scott Stephens) Oracle 10g adds new pseudo columns to the SQL Hierarchical Queries that use START WITH . . . CONNECT BY . . . clauses. For instance, you could specify a starting condition and continue to child rows using one or more connection conditions. As an example, suppose I have a table that
Bulk data transactions using OpenXML
(Ravi Chander Gunishetti and Harikishan Jayaraj) OPENXML is a new function added to SQL Server 2000 that provides a rowset view over an XML document. Since a rowset is simply a set of rows that contain columns of data, OPENXML is the function that allows an XML document to be treated in the familiar
Protect Objects from Deletion
(Laurent Leturgez) This script is based on a SECURED_OBJECTS table and a CHECK_BEFOREDROP trigger that will prevent the deletion of objects. The trigger tests if the object you try to delete is in the table. If true, an error occurs and the object is not deleted. (script)
IBM, SAP Cooperating on Database Software Compatibility
(Alfred Kueppers) International Business Machines and SAP AG have intensified their cooperation in database software compatibility recently as competition with rival Oracle intensifies, the Financial Times Deutschland reported.
New XML Query Language Addresses Non-Geeks, Too
GlobusData has developed qxLanguage, which the company says is easier to use “than any existing tool on the market.” It is designed for use by programmers and lay people alilke, through the use of SQL-like constructs for self-describing codes. It is compatible with existing XML standards governed by
SQL Server 2005 and CLR Integration
(Mahesh) Microsoft SQL Server 2005 features the integration of CLR component of the .Net framework allowing the developers to seemingly use the power of .Net languages like C#, VB .Net, J# etc in writing stored procedures, triggers, user-defined types, and user-defined function.
Building Intelligent .NET Applications: Data-Mining Predictions (Sample Chapter)
(Sara Rea) This chapter uses a fictional retailer named Savings Mart to show how Microsoft’s Analysis Services, included with Microsoft SQL Server, can be used to improve operational efficiencies and reduce costs.
EnginSite Editor: A Fully Loaded PHP IDE on the Cheap
(Laurence Moroney) Until recently I did most of my PHP development using DreamWeaver or Notepad. I wasn’t happy with most IDEs for developing PHP applications. In my opinion, the best IDEs for software development were, and still are, Microsoft Visual Studio.NET and BEA Weblogic Workshop. In the PHP