(Jonathan Yarden) In all my years in the computing industry, I have seen a number of technologies come, go, and resurface. Without a doubt, one of most interesting is data encryption; yet, the general public still doesn’t seem to have a firm grasp on it.
Author: SSWUG Research
MDX Set Functions: The Distinct() Function
(William Pearson) In this article, we will extend our examination of MDX functions to concentrate upon the basic, but useful, Distinct() function. We will discuss the straightforward purpose of the function, to return a set without duplicates from a set we specify within the function, as well as the
FIX: An access violation may occur when you run a query on a table that has a multicolumn index in SQL Server 2000
When you run a query in Microsoft SQL Server 2000, an access violation may occur. You experience this problem when the following conditions are true: • A table has a multicolumn index such as Table1(col1, col2). • The columns of the table do not accept the value NULL. • The query uses a predi
New Windows Event Log: Gateway to Native Windows Functionality in Vista
(Nick Wienholt) While the .NET Framework’s feature coverage continues to increase—particularly with the WinFX release in Windows Vista, native code will continue to be the most powerful and flexible mechanism for producing applications that work closely with the host operating system (OS). To demons
Using the Queue Class in the .NET Framework
(Brett Burridge) We English people love to queue! So I was especially pleased when Microsoft included the Queue class within the .NET Framework. It’s just the thing for creating applications where items must be processed in an orderly fashion.
Introduction to Basic SQL, Part 2 – Joins
(Lewis R Cunningham) This is an article I wrote last year for Suite101.com. I’m no longer posting there so I decided to post this and the next entry (part 3) here. That way all of the starter stuff I’ve done is all in one place. You can read Learn Oracle – What is Oracle? and an Introduction to SQL,
Grand Unification – Table Partitioning, Database Partitioning and Multi Dimensional Clustering
(Chris Eaton) In a previous posting someone asked if you could use Table Partitioning with Database Partitioning (DPF). The short answer is Yes, but I thought it was worth doing a full posting on the subject. Actually I’m going to be given a presentation at IDUG Europe in October on this exact subje
Learning to Query in Oracle XE
(Jayaram Krishnaswamy) Querying the database is one of the most common tasks that you may have to carry out routinely. This tutorial shows you the options for running SQL queries and how to run the queries against the database in the Oracle Express Edition, Oracle XE for short.
Wire Up Data-Driven Web Apps with an ASP.NET 2.0 DataSource Control
(Mark Strawmyer) DataSource controls provide declarative data binding, or put more simply, data binding without requiring you to write code. They represent back end data stores and replace the code that queries data sources and binds the results to controls with tags. As such, they have no re
Oracle OpenWorld 2006 Overview
Oracle OpenWorld 2006 is the world’s largest event dedicated to helping enterprises understand and harness the power of information. Connect with the people, products, and trends at the forefront of business and information technology in San Francisco. (R)