.NET

MySQL Linked Server on SQL Server 2008

by Jayaram Krishnaswamy | August 2009 | .NET Microsoft

Linking servers provides an elegant solution when you are faced with running queries against databases on distributed servers or looking at your distributed assets on disparate databases.

This article by Dr. Jay Krishnaswamy explains how to set up a MySQL linked server on SQL Server 2008 Enterprise. Configuring a linked MySQL server as well as querying a table on the MySQL linked server is described. The reader would benefit reviewing the first article on this series on MySQL Servers.

Read MySQL Linked Server on SQL Server 2008 in full

New SOA Capabilities in BizTalk Server 2009: WCF SQL Server Adapter

by Richard Seroter | April 2009 | .NET BPEL Microsoft SOA Web Services

In this article by Richard Seroter, you will learn what's WCF SQL Adapter, how to go about executing composite transactions, polling for data, and using SQL Server Query notifications.

Read New SOA Capabilities in BizTalk Server 2009: WCF SQL Server Adapter in full

VB.NET Application with SQL Anywhere 10 database: Part 2

by Jayaram Krishnaswamy | July 2007 | .NET Microsoft

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. SQL Anywhere also provides a DataWindow specifically for .NET but this is not included in this article.

Read VB.NET Application with SQL Anywhere 10 database: Part 2 in full

Securing the Small Business Server 2008

by David Overton | April 2009 | .NET Microsoft

This article by David Overton covers the process of finishing the network protection and routing setup and configuring the protection of the data on the server. We will cover:

  • Configuring the firewall ports
  • Configuring and testing backups
  • Configuring anti-malware
Read Securing the Small Business Server 2008 in full

VB.NET Application with SQL Anywhere 10 database: Part 1

by Jayaram Krishnaswamy | July 2007 | .NET Microsoft

This article by Jayaram Krishnaswamy 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. SQL Anywhere also provides a DataWindow specifically for .NET but this is not included in this article.

Read VB.NET Application with SQL Anywhere 10 database: Part 1 in full

Installing SBS 2008 and Connecting to the Internet

by David Overton | April 2009 | .NET Microsoft

This article by David Overton covers the installation of SBS 2008 on a new system, either as a first server in an organization or as a new server into an organization with SBS 2003. We will cover:

  • Installing the operating system
  • Installing the SBS components
  • Migrating network settings
  • Getting updates
  • Confirming company information
  • Creating an administration account
  • Naming servers
  • Installing anti-malware tools
  • Resolving installation issues

The steps involved will get you to the point where you are connected to the Internet. There are some steps that are different, depending on whether this is a new installation or a migration.

Read Installing SBS 2008 and Connecting to the Internet in full

Copying a Database from SQL Server 2005 to SQL Server 2008 using the Copy Database Wizard

by Jayaram Krishnaswamy | April 2008 | .NET Microsoft

This article by Jayaram Krishnaswamy shows how to migrate a database from SQL Server 2005 (should work for 2000 as well) to SQL Server 2008 using the Copy Database tool in SQL Server 2008. In an earlier article we saw how this can be done manually by detaching the database from the SQL 2005 and then attaching it to the SQL 2008 server using the SQL Server Management Studio.

Read Copying a Database from SQL Server 2005 to SQL Server 2008 using the Copy Database Wizard in full

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 full

Creating 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 full
Syndicate content
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software