Microsoft SQL Server 2008: Installation Made Easy

The article discusses the precaution thta one can take in installing the Microsoft SQL 2008 Sever (Developer Edition). Links to downloading a sample database with how-to note is also provided. Some of the initial problem solving in cleaning up the .NET miscellanea is discussed in this blog at : http://hodentek.blogspot.com/2008/01/you-were-cleaning-up-net-framework.html

Krishnaswamy, Jayaram. Packt (2008). Articles>Software>Databases>SQL

Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2

Business needs often necessitate data migration from a smaller, less secure database to a higher end, faster database server with a more reliable availability. A typical scenario is the migration of data from a desktop sized database such as MS Access or Fox Pro to any other higher end database servers such as MS SQL Server, Oracle, DB2 or SQL Anywhere Server. Oracle SQL Developer 1.2 with this latest version is sometimes called the Migration version as it supports migrating data from three vendors (MySQL, SQL Server and MS Access) to an Oracle database. In fact, it has been designed to migrate from more than one version of MS Access. This feature was not available in the version 1.1 of this tool.

Krishnaswamy, Jayaram. Packt (2007). Articles>Information Design>Databases>SQL

Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps

This tutorial shows how SQL Server 2005 can be migrated to SQL Server 2008 quite easily by manually detaching the database from SQL Server 2005 and attaching it to SQL Server 2008. This is a much easier process than the 'Copy Database Wizard' which has two procedures one of which is the same as the manual process but carried out under the guidance of a wizard and the other which does not require the stopping of the Source server.

Krishnaswamy, Jayaram. Packt (2008). Articles>Information Design>Databases>SQL

Review: SQL Server Integration Services Using Visual Studio

Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 provides you with the basic knowledge that you should have before you move on to more advanced ETL [Extraction, Transformation, and Loading]. The book will also provide you with a comprehensive description of the many designer windows that you may encounter while working with the designer. This guide provides the building blocks describing each block by way of an example as well as describing the nuts and bolts that bind the blocks. A majority of SSIS tasks are covered in this book and they are described fully in the summary of table contents section. You start building packages right from Chapter 2 and continue on to Chapter 20 gathering and building upon your knowledge in each step.

Krishnaswamy, Jayaram. Packt (2007). Articles>Reviews>Databases>SQL

VB.NET Application with SQL Anywhere 10 Database

This article by Jayaram Krishnswamy 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.O IDE. The article describes a window application with two examples developed with this easy to use integration interface.

Krishnaswamy, Jayaram. Packt (2007). Articles>Information Design>Databases>SQL

Windows Presentation Foundation Project - Basics of Working

The tutorial introduces the reader accustomed to working with the traditional graphic user interface in earlier versions of VB to Windows Presentation Foundation. Importantly, it introduces the reader to the XAML's declarative format and what it means in the design interface of VS 2008. WPF can do a great deal more than what is described in this article. The power of markup extensions such as declarative binding, dynamic resource, template binding and many others are not discussed. It is hoped that the reader will be up and running WPF projects based on his previous experience after reading this article.

Krishnaswamy, Jayaram. Packt (2008). Design>Presentations>Information Design>Microsoft Windows

Data Pager Control [.NET Framework 3.5] in Visual Studio 2008

When query results exceed the display area then you resort to scrolling and wish you had some way to limit the number of results displayed and comfortable to view without scrolling. Paging functionality which provides an answer to this is therefore a much desired feature. The Data Pager Control in Visual Studio 2008 provides this functionality when you create an ASP.NET web form under .NET Framework 3.5. It can be configured automatically using the GUI, or it can be installed manually after installing the ListView. In this article both of them are described. While the number of items displayed in a list can be declaratively coded, it is possible to set it at page load time as well.

Krishnaswamy, Jayaram. Packt (2008). Articles>Web Design>Databases

Migrating from MS SQL Server 2008 to EnterpriseDB

With many database vendor products in the market and data intensive applications using them, it is often required to port the application to use the data or, migrate the data so that the application can use it. Migration of data is therefore one of the realities of the IT Industry. Some of the author's previous articles on migration can be found at the link.

Krishnaswamy, Jayaram. Packt (2009). Articles>Information Design>Databases>SQL

Programmatically Creating SSRS Report in Microsoft SQL Server 2008

The process of programmatically creating the SQL Server Reporting Services (SSRS) tabular report is described. You will be creating a very simple report using the provided code. The approach is to introduce the programming by creating the three parts of a report: connection, dataset, and layout. Excerpt from the book, "Learning SQL Server 2008 Reporting Services.'

Krishnaswamy, Jayaram. Packt (2009). Articles>Information Design>Databases>Reports

jQuery Embedded in Dojo Accordion Panes

We will experiment embedding jQuery in DOJO 123's Accordion widget and try to identify if there exists any cross-code interactions. The code is also tested for cross-browser suitability.

Krishnaswamy, Jayaram. Packt (2009). Design>Web Design>DHTML>JavaScript

Obtaining Alfresco Web Content Management

In this article you looked at a simple application of Alfresco to create a web project and define web forms using XML Schema to allow non-technical users to create content.

Potts, Jeff. Packt (2007). Articles>Content Management>Project Management>Alfresco