(Chris Eaton) There are many instances where you may want to create a temporary table of data just to perform some lookups and then throw it away. For example, what if we want to create a table of weekdays to join with our shipment table. Or maybe we want to classify rows in an orders table by some
Author: SSWUG Research
orking with temporary models
Sometimes it is very useful to be able to create and train a temporary mining model for use in the context of a single connection. For instance, you might have a data exploration application that creates a temporary Naïve-Bayes model for the current user based on the subset of server data they have
i-Technology Viewpoint: ‘Open Source Is Not a Trend, It’s a Paradigm Shift’
(Mark R. Hinkle) I recently read an article in the “mainstream” media that gave me pause. The author made an assertion that the current trend towards Open Source might just be a passing fad. I thought about this and looked critically at the software industry, thinking about whether there was merit i
SelectViews: Data Explosion Follow-Up, IT Planning for the Holidays, SQL Connections and More
Video Programming for IT Professionals
Delete and Constraint Handling Stored Procedure Using SQL Server 2000
(Jeremy Mullinax-Hill) I was providing consulting services, developing an application in C# and .NET 2.0 with a SQL Server 2000 database. The application framework was based on a custom code-generator, which created SQL scripts, business objects, and UI code. Because the previous consultant who desi
Application Settings in VB 2005
(Ged Mead) Application and User Settings have been given a facelift in VB2005. One of the questions that has appeared in VBCity Forums many times over the past few years is the one where someone wants to know how to save user choices, UI settings or other small items of data that have been input b
8 Golden Rules to Develop and Design Quickly
(Dave Martin) We can access any information within seconds – the Internet expectation is fast. For many clients, businesses and management the development expectation is also fast but the reality can be slow and disappointing with unexpected costs or delays. Some of the key reasons are frequently po
Using DB2 XML and Java
(Anson Kokkat) IBM DB2 9 enables you to use the power of pureXML and integrate it into your application development environment. Take a look at how to integrate this powerful technology into your Java applications and make development easier with the new DB2 Developer Workbench.
XML Schema considerations for WSDL design in conformation with WS-I Basic Profile
(Shawn X. K. Hu) A valid XML schema is not necessarily valid in a WSDL definition. Learn how design decisions in XML schema definition (XSD) can have significant impact on Web service design. We’ve included some sample XSDs and WSDLs and we’ll briefly discuss them.
Make only one instance of an application run with VB.NET
(Irina Medvinskaya) It’s usually a good practice to make sure that only one instance of your application can be run at a time. In order to determine if there are other instances of an application running, you need to get a list of all the processes running and see if an instance of the application i