Oracle SQL Developer Tool 1.5 with SQL Server 2005
by
Jayaram Krishnaswamy | October 2008 | .NET
Oracle SQL Developer Tool is a stand alone program that connects to Oracle as well as third-party databases which can be used to perform a variety of tasks from running simple queries to migration of databases from third party vendor products to Oracle. Please review the following articles on the earlier versions 1.1 and 1.2: MS Access Queries with Oracle SQL Developer 1.2 Tool and Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2.
In the present article by Dr. Jayaram Krishnaswamy the latest version of this tool [Oracle SQL Developer 1.5.0.53, IDE Version: 11.1.1.0.22.49. 33] will be described and some details of how to use this tool with SQL Server 2005 will be discussed. While the default installation is ready to connect to Oracle and Access databases the other third-party products such as SQL Server 2005, MySQL and Sybase require additional JDBC drivers. This article describes how you may connect to SQL Server 2005 and SQLExpress servers using the JDBC drivers. The Scratch Editor interface which accepts an SQL Statement from a 3rd party and translates into PL/SQL code is described. This feature was also available in the earlier version.
Read Oracle SQL Developer Tool 1.5 with SQL Server 2005 in fullCreating a Web Page for Displaying Data from SQL Server 2008
by Dr.Jay Krishnaswamy |
April 2008 | .NET Microsoft
This article by Jayaram Krishnaswamy describes how you may connect to SQL Server 2008 and display the retrieved data in a GridView Control on a web page. Trying to establish a connection to the SQL Server 2008 is not possible in Visual Studio 2008 as you will see soon in the tutorial. One way to get around this, as shown in this tutorial, is to create an ODBC connection to the SQL Server and then using the ODBC connection to retrieve the data.
Visual Studio 2008 Version: 9.0.21022.8 RTM, Microsoft Windows XP Professional Media Center Edition, and SQL Server 'Katmai' were used for this tutorial.
Read Creating a Web Page for Displaying Data from SQL Server 2008 in fullWorking with SBS Services as a User: Part 1
by
David Overton | April 2009 | .NET Microsoft
Your SBS 2008 server, network, computers, and users will now be configured for use. However, to get the business benefit, you will need to embed the use of the services and facilities into the user's psyche to enable them to benefit from it and use it.
In this two part article by David Overton, we will cover the following areas:
- E-mail, Calendar, and Contacts
- File Management
- Remote access to the server, network, and services
In this part, we will discuss E-mail, Calendar, and Contact functionality of SBS 2008.
Read Working with SBS Services as a User: Part 1 in fullA Simple Pocket PC Application using Visual Studio 2005
by
Jayaram Krishnaswamy | November 2008 | .NET Microsoft
This article by Dr. Jayaram Krishnaswamy teaches how you may create a .NET Compact Framework (CF) 2.0 forms application. This can be used with Pocket PC 2003, or later devices. In the absence of a device being available for testing, the emulator is the next best thing. The application will be tested on one of the many emulators available in Visual Studio 2005. You may try other devices as well just by choosing the item in the Device Emulation Manager described in the article.
Read A Simple Pocket PC Application using Visual Studio 2005 in fullADO.NET Entity Framework
by
Joydip Kanjilal | November 2009 | .NET Microsoft
In this article, by Joydip Kanjilal, we will discuss entity framework for ADO.NET.
we will cover the following points:
- Creating an Entity Data Model
- Introducing the Entity Data Source Control
- Implementing our first application using the ADO.NET Entity Framework
Technical Best Practices for Dynamics AX - Shared and AOT Object Standards
by
Anil Kumar Gupta | March 2008 | .NET Microsoft
Most of the qualities of an ideal ERP system such as, Total Cost of Ownership, Flexibility, Usability, Integration and many more are implemented by conformance to the technical best practices discussed in this two part article by Anil Kumar Gupta. The Dynamics AX best practice can be grouped into three categories i.e. application design standards, shared standards, and AOT object standards.
The previous article discussed the Application Design Standards. This article will focus on Shared and AOT Objects Standards in Dynamics AX.
Read Technical Best Practices for Dynamics AX - Shared and AOT Object Standards in fullTechnical Best Practices for Dynamics AX - Application Design Standards
by
Anil Kumar Gupta | March 2008 | .NET Microsoft
Most of the qualities of an ideal ERP system such as, Total Cost of Ownership, Flexibility, Usability, Integration and many more are implemented by conformance to the technical best practices discussed in this two part article by Anil Kumar Gupta. The Dynamics AX best practice can be grouped into three categories i.e. application design standards, shared standards, and AOT object standards.
The first part of this article will discuss Application Design Standards.
Read Technical Best Practices for Dynamics AX - Application Design Standards in fullTerm Extraction Tasks in SQL Server Integration Services
by Dr.Jay Krishnaswamy |
March 2008 | .NET Microsoft
Microsoft SQL Server's SQL Server Integration Services is a comprehensive, full featured tool for processing data in the back-end storage locations. Extraction of attributes in a body of text is an important task while mining data and the SSIS provides just the required transformation - Term Extraction, to accomplish this task. SSIS looks through the presented text document and sorts out terms. By terms are meant specifically nouns, noun phrases, and both nouns and noun phrases. You also have the flexibility of limiting extracted terms based on their frequency of occurrence. For example you could configure the task in such a way that you can capture terms that are repeated in the body of text a certain number of times.
This tutorial by Jayaram Krishnaswamy shows a simple example of extracting terms from a body of text.
Read Term Extraction Tasks in SQL Server Integration Services in fullUsing the Data Pager Control in Visual Studio 2008
by
Jayaram Krishnaswamy | September 2008 | .NET Microsoft
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.
This article by Dr. Jayaram Krishnaswamy describes how you may connect to SQL Server 2008 and display the retrieved data in a ListView Control on a web page. The ListView Control is the only control in ASP.NET that supports the new ASP.NET control, the Data Pager Control. This article shows how the data from a table in SQL Server 2008 is displayed in the ListView and how the Data Pager is configured to cycle the List View items.
Read Using the Data Pager Control in Visual Studio 2008 in fullWindows Presentation Foundation Project - Basics of Working
by Dr.Jay Krishnaswamy |
February 2008 | .NET Microsoft
This article by Jayaram Krishnaswamy 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.
Read Windows Presentation Foundation Project - Basics of Working in full
