(Anghel Leonard) Use the following code to insert an XML Schema into an XQuery query. The following code assumes that the XML Schema is: file:///C://Data_Local//xml//docs//AirWings_xslt_xmlschema.xsd
Other News
ORA-04030 doesn’t always mean you’re running out of RAM
(Rex Baldazo) I maintain an ancient Oracle Reports system, which does a peculiar FTP gyration that recently started giving us errors. Here’s the scenario. We have a 10g database that powers a farm of six Oracle Reports servers. Some, not all, of the reports we generate are tilde-delimited text files
MySQL Proxy: Adaptive Slow Query Log
(Jan Kneschke) Kris brought up a simple question: Why do I have to set the slow-query-time by hand ? Why can’t the server figure out the normal query time and tell me when something is unusual slow ?
Data Transformation Services (DTS) Overview
(Buck Woody) Most often data is entered into Microsoft SQL using applications and other programs. But at times you need to enter large amounts of data, most often from a file or other data source. Microsoft SQL Server provides several means such as the Bulk Copy Program (BCP) and the BULK INSERT sta
SQL Server Show Posted, SQL Server Ongoing Maintenance
Latest SQL Server Weekly Show Posted Check out SelectViews – the weekly SQL Server program from SSWUG.org. In this week’s show, you’ll find: IT vs. Management and Big Ideas, a SQL Server Challenge. Using Variables with SPs, Upcoming Events, Tips and Tricks and Much More. The show is a bit longer this week because we’re testing two segments. A SQL […]
Create Strongly Typed Data-Access Code
(John Cronan) ADO.NET is extraordinarily useful, but it’s not without its flaws. One of its biggest annoyances is that it includes far too much repetitive code. Fortunately, you can eliminate a lot of the repetitive code that goes along with ADO.NET by applying the declarative model to the data-acce
Integrate XForms with the Google Web Toolkit, Part 1: Introducing GWT’s JavaScript Native Interface
(Michael Galpin) This four-part series demonstrates how to use the Google Web Toolkit (GWT) and XForms together to create a dynamic Web application. Part 1 starts with a bottom-up approach to the problem of using GWT and XForms together. It takes a look at some of the underpinnings of each technolog
All aboard the Microsoft Visual Studio Express
(Ed Tittel) Microsoft has been releasing free-for-all versions of its developer tools under Express Edition branding since Visual Studio made its first appearance. Now that Visual Studio 2008 is in the offing, with commercial release scheduled for early 2008, Microsoft is unleashing another batch of
ASP.NET 2.0, Custom Role assignment without a ‘Role Provider’
(Mark Dryden) I love starting new projects with a new technology and recently the requirement for an ASP.NET 2.0 custom reporting module landed on my desk. I have some ASP.NET 1.1 experience having created a couple of sites about two years ago but that was it.
VS 2008 Support to Treat HTML, CSS and JScript Validation issues as warnings instead of errors
(Scott Guthrie) One of the features that VS 2005 added was support for HTML source validation. This enabled you to validate your page markup against different HTML schemas and standards (XHTML Transitional/Strict, HTML 4.01, various browser types, etc). You could also use the HTML validation featu