(Leon Katsnelson) We all like to get stuff for free. Not paying for something leaves money to spend on something else. So, when you come across something that is free it is hard to say “no”; the non-free alternative has to have a lot of value to win over “free”. But what if you have a choice of “fre
Other News
Easily manage directories with .NET’s Directory class
(Tony Patton) Last week I showed how you can use .NET’s Path class to work with string values representing file and directory paths. This week I’ll concentrate on the directory portion of the path with the Directory class, which you can find in the System.IO namespace. The Directory class provides
Storing PHP Sessions in a Database
(Rich Smith) There are many reasons to utilize sessions when creating a web-based application using PHP. Session information, by default, is stored in a file on your web server. But what if that becomes a problem? In this article, I’ll talk about why you might want to move your PHP sessions to a dat
PHP and RSS: Getting it together
(Tracy Peterson) RSS Syndication is virtually ubiquitous these days, so it’s imperative that a PHP developer at least understand RSS and how it works. This article explains the basics of RSS, some of its many uses, how to use PHP to create an RSS feed from a database, and how to use the XML_RSS modu
Enhance your Website with ASP.NET AJAX Extensions
(Dan Wahlin) AJAX (Asynchronous JavaScript and XML) is arguably one of the most hyped technology acronyms around. The primary advantage of using AJAX is that page refreshes can be minimized, allowing users to get the information they need quickly and easily through a more rich and functional interfa
XSD Tutorial – Part 5 of 5 – Other Useful Bits
(Simon Sprott) Elements and Attributes can be grouped together using and . These groups can then be referred to elsewhere within the schema. Groups must have a unique name and be defined as children of the element. When a group is referred to, it is as if it
Explanation SQL SERVER Merge Join
(Pinalkumar Dave) The Merge Join transformation provides an output that is generated by joining two sorted data sets using a FULL, LEFT, or INNER join. The Merge Join transformation requires that both inputs be sorted and that the joined columns have matching meta-data. User cannot join a column tha
Tracing Individual Users in Connection-pooled Environments with Oracle 10g
(Terry Sutton) Many of us have been using Oracle’s Extended SQL Trace, also known as a 10046 trace, for years. An Extended SQL Trace can provide the most detailed information about exactly what an Oracle session is doing, including which SQL statements the session is executing, how many logical and
What’s the difference between database version and database compatibility level?
(Paul Randal) I had a question this week from someone who’d heard me say at SQL Connections (paraphrasing) “database compatibility level is mostly about query parsing” and was having trouble trying to forcibly attach a 2005 or 7.0 database to a 2000 server.
Enhanced Oracle Explorer in C# and .NET using Windows Forms
(Sateesh Kumar) Oracle is commonly using database as a backend for .NET applications. But, the main problem with oracle is, there is no in-built easy-to-use GUI for accessing objects in it. So the only option is to use third party tools like TOAD or PL/SQL Developer for accessing objects without wri