(Noel Herrick) I want to teach you the difference between an inner and an outer join. We first need to think about what a join is. Simply, it’s when you combine two tables to make a new one. You’re not physically creating a new table when you join them together, but for the purposes of the query, yo
Author: SSWUG Research
Free trainings on using DB2 with BLU Acceleration
(Henrik Loeser) Many of you know that IBM is offering free trainings on Information Management products, so-called bootcamps, to business partners. Two new classes have been added that cover solely DB2 with BLU Acceleration:
Get Started With XML Using C#
(Abhishek Kumar Ravi) This article is part of the XML Tutorial series. In my first tutorial I am creating a XML file using C#. It’s like we take some input from the user and generate a XML file according to that.
Automatic Workload Management with BLU Acceleration
(Chris Eaton) There are often competing goals in any system today. One such example is the desire to leverage resources available on a machine in order to complete a given complex query as fast as possible, alongside the desire to provide predictable response time by ensuring a given set of resource
What is the difference between logical and physical corruption in Oracle?
(Jeremiah Wilton) When we talk about logical corruption, there are two different failure states that fall under this label:
SQL for date ranges, gaps and overlaps
(stewashton) There are lots of questions and posts on the Web about data with date ranges. It’s harder than it seems to design tables with start and end dates, to avoid overlaps or even to write SQL to find gaps or overlaps. I’m writing this post to get some basic ideas straight and to make myself s
ODM: Changing the bar chart format in Explore Node
(Brendan Tierney) In Oracle Data Miner you can use the Explore Node to gather an initial set of statistics for your dataset. As part of this you will also get a bar chart that shows the distributions of the values contained within each attribute. The following example shows the default layout of the
Raising Errors in Transact-SQL
(Richard Carr) When developing reusable scripts, such as stored procedures and triggers, it is often necessary to raise errors. With the RAISERROR command, it is possible to create errors with varying severity and customised messages.
Username Availability Check with AngularJS in ASP.NET MVC
(Brij Mohan Dammani) In my previous article, We have implemented to check username availability in ASP.NET Web Forms using jQuery Validation Plugin. In this article, we will do same thing in ASP.NET MVC, but using AngularJS(An open-source MV* JavaScript framework for building dynamic web apps).
Embedding Foreign Characters In Your Content-Disposition Filename Header
(Ben Nadel) Since English is my primary language, I sometimes don’t realize that aspects of my web applications don’t play nicely with non-US ASCII characters. Such is the case with the “Content-Disposition” header. I’ve been using it for years; but, only found out last week that the “filename” port