(David Hayden) I had the absolute joy of hanging out at the Tampa .NET Developer Group Meeting last night. Here is a tip I mentioned briefly at the meeting around resolving and optmizing namespaces.
Other News
Dynamic GridView and DataList in ASP.NET 2.0
(Satheesh Babu) Displaying tabular data to the users is one of the common tasks we will perform in any site we build. In ASP.NET 1.x we make use of the DataGrid, DataList and Repeater controls most of the time depending on the need. With the introduction ASP.NET 2.0, we have GridView in the place of
DB2 Backup Basics – Part 3
(Chris Eaton) So far we have discussed backup syntax including targets and backup types and some options for backup. In this posting let’s look at a few other options on the backup command.
I WILL NOT BLOB
(Frank) My thoughts have changed on this topic over time. Primarily, because I now work on a large scale infrastructure where I can see how things would have been if BLOBs were stored in database. Most of the following discussion keeps the size and scale of my work load in mind and is targeted towar
Implement new security capabilities in DB2 9.5, Part 2: Understanding trusted contexts
(Paul Read) IBM DB2 9.5 provides new options for tighter security, and allows for more granularity and flexibility in administration of the database. This tutorial is the second of two tutorials that cover roles and trusted contexts. Follow the exercises in this tutorial, and learn how to take advan
Strongly Typed Datasets (.NET 2.0)
(Mark Dryden) Welcome to my course on Strongly Typed Datasets. The intention of this course is to introduce the student to the concept of the Strongly Typed Dataset, its capabilities and advantages in the real world environment. This course is not intended for ADO.NET newbies and *does* require some
Managing Oracle’s Undo Tablespaces
(Steve Callan) In the days of yore, we had rollback segments. In order to use a rollback segment in a transaction, either by letting Oracle choose one or by explicitly setting/naming one, the rollback segment first had to be specified in the initialization parameter file. With the advent of Automati
Performance Comparison of Different Datatypes
(Asif Momen) Oracle database has a rich collection of datatypes and it offers different datatypes for different needs. Basically, datatype can be either scalar or non-scalar. A scalar type contains an atomic value, whereas a non-scalar contains a set of values. Examples of scalar datatypes include n
SQL Server 2008 TSQL – Table Valued Parameters
(Simon Sabin) Table Valued Parameters have to be one of the coolest features in SQL Server 2008. With them you are able to pass a set of data around as a single variable. What this means is that if you are saving multiple records you can do very easily in one procedure call.
Handling HTML multi-selects in PL/SQL
(Rex Baldazo) Dealing with HTML multi-selects in Oracle’s PL/SQL is a bit trickier than I’d like. Depending on how many items the user picks out of the multi-select, you either get back a simple VARCHAR2 object or a special array object. This means you have to write two separate methods to deal with