(Michaela Trautwein-Ostner and Marcio Bulek) IBM Informix Dynamic Server, Version 11 (IDS 11) has new SQL features. Learn how to use SQL to perform administrative tasks, improve query performance, manage data security, and manipulate data. The eighth in a series of eight tutorials, use this tutorial
Other News
Let’s talk DSNZPARM and DB2 for z/OS Version 8
(Willie Favero) Or at least, let’s talk about one new DSNZPARM keyword introduced since DB2 V8 went GA. This ZPARM snuck into DB2 Version 8 sometime around April 2006 via an APAR so it has already been around for quite a while. To me, it’s one of those good news, bad news APARs. Fortunately, the goo
New elements in HTML 5
(Elliotte Rusty Harold) Development of Hypertext Markup Language (HTML) stopped in 1999 with HTML 4. The World Wide Web Consortium (W3C) focused its efforts on changing the underlying syntax of HTML from Standard Generalized Markup Language (SGML) to Extensible Markup Language (XML), as well as comp
Image Resources in WPF (1)
(Ged Mead) As I had some feedback on how the images are accessed in my blog item on UniformGrids, I thought I would just very quickly explain what I did.
How to allow to sort by multiple columns in Custom Data Binding
(meglio) When you bind DataGridView to a custom business object you probably want to allow to sort by column or by multiple columns. You are able to use BindingSource to bind your data, but this component do not realize sorting functions.
TEXT in ROW option in SQL Server
MS SQL Server allows us to store large variable length data in text, ntext or image columns. One can store up to 2GB worth of non-Unicode character or binary data in text columns. Sometimes querying text data from a table with lots of rows may result in performance degradation. Query retrieving tex
Shadowing using Shadows in Visual Basic.NET 2005
(Jagadish Chaterjee) This article gives you an in-depth understanding of how to use “Shadows” in Visual Basic 2005. You will also see how “overloads” can replace “shadows” in certain situations.
Using SQL Server 2005 system SP to change extended property values of database objects
(Michael Livshitz) In this article, that is the logical continuation of the earlier published articles, I will show how you can update the value of an existing extended property or add a new extended property to a database object with the help of the system stored procedures of SQL 2005. The example
Six Secrets to SQL Server Availability
There are many expensive, complex technologies that promise availability for SQL. Fortunately there are also simple, automated ways to get the highest levels of protection. The following six secrets to affordable SQL availability will help you to implement a SQL environment with little downtime, zer
Say hello, static constructor?
(Robert Chipperfield) When does the static constructor of your .NET class actually get called?