(Jim Mason) Squirrel is a great tool for accessing any type of data anywhere using SQL! It’s great for developers, administrators, testers, even end-users needing to view, validate or update data anywhere. It works with every database I’ve tested ( MySQL, DB2/400, DB2, Oracle, SQL Server and more).
Author: SSWUG Research
Indexing Guide: The art and science of SQL Server indexing
(Jeremy Kadlec) You can improve your SQL performance by using indexes. But you have to choose the proper indexes and make sure the ones you do choose fit into your business situation. In this indexing guide, you will find answers to common indexing questions, indexing dos and don’ts, and tricks
IBM DB2 Universal Database and the Java Developer? Absolutely! Part 2
(Paul C. Zikopoulos) In Part 1 of this series, I discussed how to use the Database Explorer view in the IBM Rational Application Developer for WebSphere Software (“Rational AD”) product to create and work with IBM DB2 Universal Database (“DB2 UDB”) for Linux, UNIX, and Windows database connections.
Upload users’ files to a Web server using ASP.NET
(Tony Patton) Most Web sites collect data via Web pages—this includes everything from collecting user feedback to posting blog content. It’s good to be able to gather text; however, it’s often necessary to collect more robust elements. For instance, many career sites gather resumes that job seekers
Oracle SQL Developer (formerly Project Raptor)
Oracle SQL Developer (known as “Project Raptor” through EA Release 3) is a new, free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You
Enforcing Object Types in PHP: Filtering Input Objects in PHP 4
(Alejandro Gervasio) When you are writing an object-based web application in PHP, you want to prevent your classes from being convoluted with input objects of the incorrect type. These input objects can cause the application to throw a fatal error. In this article, you will learn how to enforce obje
FIX: No rows may be returned, and you may receive an error message when you try to import SQL Profiler trace files into tables by using the fn_trace_gettable function in SQL Server 2000
When you capture a SQL Profiler trace in a file and then you try to import the trace files into tables by using the fn_trace_gettable function in Microsoft SQL Server 2000, no rows may be returned. Additionally, you may receive the following error message: Server: Msg 568, Level 16, State 10, Li
DB2 8.2 on 16way p5 570 delivers record breaking performance
(Chris Eaton) On February 14, 2006 IBM delivered another first in TPC-C. The first to break the 1 million tpmC mark with only 16 processor cores. DB2 8.2 running on a 16way eServer p5 570 delivered 1,025,169 tpmC. This is the first time any vendor has delivered this level of performance on only 16 p
Visual Studio .Net 2005: the IDE just got better
(george.p.alexander) The Visual Studio IDE series has been pretty much my side kick ever since I’ve been working on Microsoft technologies. It’s a great tool for development and I think Microsoft technologies ups Java platforms on this one respect. I have’nt heard much on powerful Java IDE platforms
SQL Server 2000 I/O Basics
(Bob Dorr) Because new devices and storage solutions continue to appear in the marketplace, the environments in which Microsoft SQL Server runs have become extremely diverse. To ensure data integrity for our customers who are running SQL Server, it is important that I/O environments provide appropri