Getting introduced to working with Postgres was described in the recent article, "installation and some basic features of EnterpriseDB". Migration of data from SQL Server 2008 was described in "The migration of a table from SQL Server 2008 to EnterpriseDB". In this tutorial Dr. Jayaram Krishnaswamy shows how you may create a Visual Studio 2008's Windows application to access data on EnterpriseDB. Reading of two previous articles is recommended.Read Creating a VB.NET application with EnterpriseDB in full
In this article by Andrew Siemer, we will talk about the concept of Blogging and how it could be applied to our community site Fisharoo. With search engines, users, and security in mind, Andrew invests a part of this article to address an issue that plagues many dynamic websites—query string data being used to determine page output.
The article starts with the discussion of Problem, that is, what we need to do to achieve success for the article's topic-Blogs so to speak. Then it moves on to Design where we decide on and write down the physical requirements for our feature. And finally comes the Solution part where we discuss how to implement all the requirements for each feature.Read ASP.NET Social Networks—Blogs in Fisharoo in full
SOA is an architectural design pattern by which several guiding principles determine the nature of the design. Basically, SOA states that every component of a system should be a service, and the system should be composed of several loosely-coupled services.WCF is the acronym for Windows Communication Foundation. It is Microsoft's latest technology that enables applications in a distributed environment to communicate with each other.WCF is an umbrella technology that covers ASMX web services, .NET remoting, WSE, Enterprise Service, and System Messaging. It is designed to offer a manageable approach to distributed computing, broad interoperability, and direct support for service orientation. WCF supports many styles of distributed application development by providing a layered architecture. At its base, the WCF channel architecture provides asynchronous, untyped message-passing primitives. Built on top of this base are protocol facilities for secure, reliable, transacted data exchange and a broad choice of transport and encoding options. In this article by Mike Liu, we will implement a basic WCF service from scratch.Read Implementing a Basic HelloWorld WCF (Windows Communication Foundation) Service in full
In this article by Richard Seroter, you will learn about the new SOA capabilities in a BizTalk Server 2009, mainly the UDDI services. It seems that Microsoft is reinforcing BizTalk Server's role in a service-oriented architecture by moving their UDDI Services into the BizTalk Server 2009 product. In this article, we discuss what UDDI is, and how to use its capabilities in your environment. You will learn to add services to UDDI registry and also building subscription alerts for service changes.Read New SOA Capabilities in BizTalk Server 2009: UDDI Services in full
In the previous part of the article by David Overton, we discussed E-mail, Calendar, and Contact functionality of SBS 2008. In this part, we will discuss File Management and Remote access to the server, network, and services functionality provided by SBS 2008.Read Working with SBS Services as a User: Part 2 in full
A Windows Mobile is a Smart Phone with Windows Operating System. Windows OS in Windows Mobiles is the Compact Edition (CE) of the desktop Windows OS. This article will introduce you to writing Windows Mobile Applications using Visual C# and Microsoft Visual Studio 2008. This article by Prashant Thakkar will address:
- Essential features of Microsoft Visual Studio 2008 IDE that help in writing Windows Mobile Application.
- Writing your first Windows Mobile "Hello World" application and a "Quote of the Day" Application that uses Internet
- Packaging, Deploying and running your Windows Mobile Applications
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
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
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