These may just be the types of articles you are looking for

There are some 50 articles covering most areas of contemporary database/web related technologies.

SQL Server 2008, MySQL, Oracle, Analysis Services, Twitter, Microsoft Lightswitch, SSIS, SSRS, Linked Servers, Enterprise DB, SQL Anywhere 10, Data Transfer Access to SQL Server, LinqDataSource, XAML. XBAP, Data Migration, jquery in Dojo, PocketPC, and many more...

Review the following link: Articles on Packt
 

Bridging the computing clouds with SSMA2008

Well, for various reasons you may be willing (wanting) to place a part of your stuff on Microsoft Azure and part on the Amazon Cloud. In fact it is a repetition of the same story of the bygone era, some data on Microsoft platform, some on Oracle etc. Sooner or later you want to move data from one to the other. Of course there are the integration tools that can handle this. But there are others who specialize in migration of data.

Microsoft went relational with its flagship SQL Server 2008 ported out to the clouds with SQL Azure. Soon Amazon followed with its relational offering based on MySQL.

Now Microsoft has released SQL Server Migration Assistant 2008 for MySQL v1.0 in CTP1. This is a toolkit that you may use to migrate your MySQL data to SQL Server 2008 and SQL Azure. This is a nice one way bridge to SQL Azure from Amazon's MySQL.

Every database vendor has his own migration tool to take away data from a rival. There is the Oracle SQL Developer, there are migration wizards in Sybase's SQL Anywhere not counting the similar tools for the Big Blue. Of course there are other third party vendors using their skills to migrate from anywhere to anywhere.

All told it has never been easier to move data along the internet highway, nor the cloud jet way.

You may download SSMA 2008 and give it a spin. Well there is another toolkit if you want to migrate to SQL Server 2005 at the same site.

Note: SSMA 2008 for MySQL v1.0 CTP1 is designed to work with MySQL 4.1, 5.0 and 5.1 and all editions of SQL Server 2008 or SQL Azure.

If you are interested in migrating data, read all of my migration related articles for free on my blog here.

All so, if you are interested in Business Intelligence, read my no brainer SQL Server Business intelligence books here and here.

Read my Cold Fusion articles

Not the low-temperature nuclear fusion articles but the down to earth Adobe's Cold Fusion. Presently it is version 9.0 but the articles I wrote a couple of years ago are still useful. In fact I am planning to revisit Cold Fusion 9 to savor the enhancements.

I hear there is even a <cfspreadsheet> tag to interact with all kinds of data. This and the <cfchart> tag should be a very interesting combination. To get the latest on Cold Fusion and find out what's new read this article by Ben Forta.

In the mean time brush up your skill set reveiwing the following articles.

Installing the ColdFusion MX Server

My First Applcaition on ColdFusion MX_Server

Everything You Must Know About ColdFusion Variables

What You Must Know About Operators in ColdFusion!

What You Must Know About ColdFusion Flow-Controls

Querying SQL 2000 Server with ColdFusion

CFAjax What it is and how to use it?

Creating a web service with ColdFusion: the basics

CFXML: Probing XMLDOM in ColdFusion

How to Access a SQL Anywhere Database with ColdFusion

2008 was a very good year

During 2008 I managed to write more than 18 articles and a book. Got a lot of positive response from readers which has encouraged me to do better in 2009.

The following articles are available on the Packt site

VB.NET Application with SQL Anywhere 10 database
Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2
Microsoft SQL Server 2008 - Installation Made Easy

Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps
Windows Presentation Foundation Project - Basics of Working
Understand and Use Microsoft Silverlight with JavaScript

Term Extraction Tasks in SQL Server Integration Services
Creating a Web Page for Displaying Data from SQL Server 2008
Copying a Database from SQL Server 2005 to SQL Server 2008 using the Copy Database Wizard

Creating a Simple Report with Visual Studio 2008
Data Processing using Derived Column and Aggregate Data Transformations
Creating an Analysis Services Cube with Visual Studio 2008 - Part 1

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2
Using the Data Pager Control in Visual Studio 2008
Oracle SQL Developer Tool 1.5 with SQL Server 2005

A Simple Pocket PC Application using Visual Studio 2005

These two appeared on other sites.

Web enabling data on a SQL Anywhere Server using a native web service

Retrieving Data on a SQL Anywhere Server Using AJAX

Consuming a SQL Anywhere native web service using a .NET client
International Sybase Users Group Technical Journal, May / June 2008, Pages 14 - 19

The first book had favorable reception and reviews (9) from readers. There were some adverse (2) reviews as well.

I thank all the reviewers and more importantly my readers.

The second book is in its final stages and will be published during the first quarter of 2009. You may order early copies with a discount from Packt. I have tried to make it as comprehensive as possible with more than 50 hands-on exercises. I hope it is as useful as I think it will be.

Retrieving Data on a SQL Anywhere Server Using AJAX

An AJAX call to an SQL Anywhere Server using stored procedures and web services

AJAX has dominated the web space so extensively that it needs no introduction. Connecting to a server via XMLHttpRequest and making a partial page refresh is what makes this technique so attractive. However, use of these AJAX requests, although very attractive, can pose dangers as well. JavaScript acts as a vector to infect websites with worms, such as SAMY, using cross-site scripting, also known as CSS or XSS.

In a previous article - "Enabling Server data with native web service" - I explain how a web service of type HTML is created on the SQL Anywhere server, which can serve HTML pages, and that to make an AJAX call for this page from your browser, you need to make a call to the hosting domain, the SQL Anywhere Web Server.

Read more at...
http://ajax.sys-con.com/node/646922

If you liked this article you may also want to read the one at.....
http://hodentek.blogspot.com/2008/07/soap-web-service-with-sql-anywhere.html

and the other related article at.....
http://hodentek.blogspot.com/2008/01/enabling-server-data-with-native-web.html

Soap Web Service with SQL Anywhere

Enabling interoperability is one of the greatest benefits of using web services. In the business world, applications work on different platforms with different operating systems running applications whose programming languages vary wildly. For applications to interact
with each other there should be a common method to transparently talk to all the different systems. In fact, the charter of the WS-I, an open industry organization source, is to promote this idea of interoperability across platforms, operating systems, and programming languages.

Read this article ...

Consuming a SQL Anywhere native web service using a .NET client
By Jayaram Krishnaswamy
International Sybase Users Group Technical Journal, May / June 2008, Pages 14 - 19

Join ISUG and get a load of benefits.

Panorama: SQL Anywhere 11's BETA is out

I down loaded 'Panorama' and installed it on the same machine side by side with others SQL Server 2005, Oracle 10G Xe, IBM DB2 and also SQL Anywhere 10.

Initial findings extremely encouraging...

* The installation was uneventful, easy and smooth. A very positive feature

* The document installation was easy

* Visual improvements many, especially the dialogue boxes for connections [ the only one I evaluated in detail]

* The installation updated the .NET related items that you would see on VS 2005, namely, the Sybase Central and ISQLAnywhere.

* Ás per my original wishes, SQL Anywhere queries can now return data in 'JSON'

* Here is a quick view of the 'Demo' database's overview in Sybase Central 11.

Enabling Server data with native web service

Read the following article to see how it is carried out on a SQL Anywhere Server.

Web enabling data on a SQL Anywhere Server using a native web service

Exposing server data to intranet / internet, an attractive and much needed method has become possible due to the native web services, services that can be created on the database itself to which HTTP or Soap requests can be made. Microsoft Access in some of its versions provided this dynamic capability via Data Access Pages and this became possible from Microsoft SQL Server directly, only in its 2005 version. However MS Access 2007 does not support Data Access Pages instead recommends the use of SharePoint server. SQL Anywhere server, even in version 9.0 possessed this built-in capability.

Links to my Migration articles

Here are the links:

Migrating from
Access 2000 to SQL Server 2000

Migrating from
Access to SQL Anywhere 9

Migrating from
Oracle 10G XE to SQL Anywhere 10

Must read article on VB.NET Integration

Microsoft Visual Studio has attracted a lot of attention from many vendors and you can find add-ins that give direct access to third party programs. This is a much needed synergy as businesses grow and embrace a multiplicity of products.

This article shows how you can develop a VB.NET 2.0 application using the integration features provided by the SQL Anywhere database. The SQL Anywhere tools are directly accessible without going out of the Visual Studio 2.0 IDE. The article describes a window application with two examples developed with this easy to use integration interface.

VB.NET Application with SQL Anywhere 10 database

Do you want to know how to mail merge documents in Word 2007?

Read this latest article..

You get three things out of this reading:

* You get your feet wet with SQL Anywhere 10 database. The article shows you how to download this database product and look at its objects, and work with them.

* Shows you how to mail merge a Word 2007 document with data you retrieve from the SQL Anywhere 10 database.

* You will also learn how to create a Universal Data Link file.

Microsoft Word 2007's Mail Merge with a SQL Anywhere 10 database

Of course remember to rate the article at Officeusers.org site