(Scott Lysle) This article describes an easy approach to saving an image file into an SQL Server 2000 database table as an SQL Server image data type. The sample windows forms application provides a simple interface used to allow the user to select an image file (bitmap, gif, or jpeg) from the file
Author: SSWUG Research
Automating Common SQL Server Tasks using DMO
(Phil Factor) This article includes the source of stored procedures that will: –List all available servers –Enumerate all database on a Server –Create a new database on any available server –Copy an entire database within a server or between servers –Copy selected tables or stored pr
Understand the effects of NULLs on inner and outer JOINs
(Arthur Fuller) SQL Server developers must understand two things: the difference between inner and outer JOINs, and the effect of NULLs upon these choices. This tip addresses both subjects.
Creating an XML table and XML-based indexes with the IBM Database add-ins for Visual Studio 2005
(Paul Zikopoulos) In a previous series of articles, I showed you the integration features between the IBM DB2 Universal Database for Linux, UNIX, and Windows Version 8.x (DB2 UDB) product and the Microsoft Visual Studio.NET 2003 integrated development environment (IDE).
DB2 Recovery Expert for z/OS User Scenarios
(Nagraj Alur, Hennie Mynhardt, Gregg Palmer and Alicia Wangelien) This IBM Redbook describes the procedures for using IBM DB2 Recovery Expert for z/OS to manage the recovery of DB2 for z/OS objects in a data sharing and non-data sharing environment. IBM DB2 Recovery Expert for z/OS is an easy-to-use
Examine user creation scripts before migrating to Oracle 10gR2
(Bob Watkins) In computer security work, the principle of Least Privilege states that users should have the minimum privileges needed to do their jobs. Oracle has made a small change in Database 10g Release 2 (10gR2) to be more consistent with this principle: It has changed the meaning of the CONNEC
XForms tip: Using the help and hints events
(Nicholas Chase) XForms enables you to easily send help messages and hint messages to a form using elements, but did you know that you can get even more control over this process by reacting to the help and hints events instead? This tip shows you how to detect when the user needs some assistance an
PostgreSQL Application Performance Tips, Part 2
(Josh Berkus) Tip 4: DELETE is expensive It’s common for application developers to think that a DELETE statement is virtually without cost. You’re just unlinking some nodes, right? Wrong. DBMSes are not filesystems; when you delete a row, indexes need to be updated and free space needs to be clea
Exporting Crystal Reports in ASP.NET
(Farhan Ali) It is relatively easy to retrieve data from a database and display it using any of the bound controls. This is especially so in ASP. NET 2.0 where the amount of code you need to write has been drastically reduced. However, to present the data in a formal, board-room friendly format and
Oracle data mining, not only good but affordable too!
(David Norris) Having been very impressed by what Microsoft has to offer I wanted to learn more about what Oracle has to offer, and I am equally impressed. I, like many others I suspect, tend to rather overlook that Oracle does data mining; because Oracle has so much on offer, some elements do tend