(Brien Posey) Upgrading a database server to SQL Server 2008 R2 involves more than just inserting an installation DVD and clicking your way through the wizard. A lot of planning goes into a SQL Server upgrade. In this article, I will share with you 10 tips that should help your upgrade process to go
Other News
Index Skip Scan skipping specified column
(Dom Brooks) Everything I can remember reading about the Index Skip Scan access path has always talked about it being used in queries where the leading column in the index is not specified in a query AND where that leading column has a relatively low number of distinct values in that leading column.
Working with SOAP Messages in PHP
(Octavia Anghel) This article discusses how to write a PHP web service using the NuSOAP library as well as a JavaScript client to consume it using the AJAX technology and the SOAP protocol.
Enable Transparent Encryption with DB2 Field Procedures
(Kent Milligan) With all the scrutiny and legislation associated with protecting personal sensitive data, a good number of IBM i developers have had to investigate the effort it would take to add column-level encryption logic into their application programs. Anyone who has done this analysis quickly
The mysterious case of the empty WHERE
(Serge Rielau) In quite regular intervals some well meaning soul somewhere in the DB2 user-verse sends me an email that roughly goes like this:
Multidimensional Clustering (MDC) in Oracle Database: Can Exadata Beat This?
(Iggy Fernandez) Contrary to popular belief, Oracle Database does provide Multidimensional Clustering (MDC) and has done so for decades. Consider the following “fact” table with three independent dimensions—year, region, and color—and some straightforward aggregations.
Using Flexviews – part two, change data capture
(Justin Swanhart) In my previous post I introduced materialized view concepts.
Sequence Driven Primary Keys – Which is Better: Call NextVal in the Insert Statement or in a Row Level Trigger?
(Charles Hooper) Occasionally, I see interesting questions being asked about Oracle Database, and it is nice when the person asking the question provides a test case – or at the very least the DDL and DML statements needed to recreate an environment that matches the question.
Arguments.length In Javascript Depends On Invocation Arguments, Not Function Signatures
(Ben Nadel) In Javascript, within a function, you can use “arguments.length” to determine how many arguments were passed-in during the given function invocation.
MVC3 Routing
(David Talbot) MVC3 gives you great control over how URLs are mapped to your controllers. It gives you the ability to define your URLs in a human readable SEO (Search Engine Optimization) friendly fashion, to remap old URLs to new functionality and side-by-side utilize classic ASP.NET sites inside o