(Rod Stephens) I was surfing the web the other day, looking for Visual Basic questions to answer, when I stumbled across an old FAQ that explained why Visual Basic no longer has arrays with non-zero lower bounds. I don’t really buy the explanation given by Paul Vick at (it seems like the needs of th
Other News
Creating an AJAX-Enabled Calendar Control
(Scott D. Smith) Go to any travel or event booking website and you’ll find the same user interface for collecting date information: the Calendar. Providing such an interface in an ASP.NET application is a breeze, thanks to the built-in Calendar Web control. There are two downsides to ASP.NET’s Calen
.NET Debugging Demos Lab 3: Memory – Review
(Tess Fernandez) Anyways, on to the lab review… the original lab was posted here and my comments are in-line in red.
Database Development: Table Structure Changes
(Kenneth Downs) There are two big things that your toolkit must contain if you are going to be a successful database programmer. The first, which we talked about last week, is a framework that respects relational concepts. The second, which we will talk about now, is a strong upgrade tool, something
10000+ tables in one MySQL database
(Bjørn Hansen) Once in a while I hear people talking about using thousands or tens of thousands of tables in one MySQL database and often how it “doesn’t work”.
Migrating MySQL to Oracle Part 2
(Sean Hull) As you might imagine, migrating a database and it’s attendant applications is no small affair. Throw into the mix a switch of database platform, and you certainly have your hands full. In this two part article, we’ll be discussing all of the steps involved in this process, questions to
Easily correct data casing with SQL Server
(Tim Chapman) Whether data is entered into your SQL Server system from a Web site, internal applications, or through files, the presentation of the data is always a concern. In this tutorial, I will create a function that will be useful in terms of updating data or just displaying data to end users
Oracle BI EE 10.1.3.3/2 – Pivoting Strings – Converting Rows into Columns
(Venkatakrishnan J) A pretty interesting question came up today in one of our internal forums. I just thought i would share with you all since BI EE does not have this capability out of the box. Look at the screenshot below.
Configuring SQL Server memory settings
(Denny Cherry) As with other applications, SQL Server applications need memory to run. However, unlike most applications, SQL Server allows you to decide just how much memory it can use. That’s good because SQL Server likes lots of memory. (R)
Partitioning enhancements in SQL Server 2008
(Erin Welker) Horizontal partitioning can be a great benefit to data warehouses, as it greatly facilitates the management of very large databases. Of course, querying on partitions can also have performance benefits, especially when only a small percentage of the database is queried and partition el