SQL Server Compact Edition 3.5 can be used to create applications that are useful for a number of business uses such as: Portable applications; Occasionally connected clients and embedded applications and devices. SQL Server Compact differs from other SQL Servers in that there is just one file which can be password protected and features 128-bit file level encryption. It is referential integrity compliant; supports multiple connections; has transactions support with rich data types.
In this tutorial by Jayaram Krishnaswamy, various scenarios where you may need to connect to SQL Server Compact using Visual Studio IDE (both 2008 and 2010) are described in detail. Connecting to SQL Server Compact 4.5 using Visual Studio 2010 Express (free version of Visual Studio) is also described. The connection is the starting point for any database related program and therefore mastering the connection task is crucial to work with the SQL Server Compact.Read Connecting to Microsoft SQL Server Compact 3.5 with Visual Studio in full
In this article by David J. Parker, author of Microsoft Visio 2010 Business Process Diagramming and Validation, we will discuss Microsoft Visio ShapeSheet™ and the key sections, rows, and cells, along with the functions available for writing ShapeSheet™ formulae, where relevant for structured diagrams.Read Understanding ShapeSheet™ in Microsoft Visio 2010 in full
In this article by Mark Polino, author of the book Microsoft Dynamics GP 2010 Cookbook, we will look at:
- Speeding up account entry with Account Aliases
- Gaining visibility with Horizontal Scroll Arrows
- Streamlining payables processing by prioritizing vendors
- Getting clarity with User Defined fields
- Developing connections with Internet User Defined fields
These recipes are designed to help administrators get more out of Dynamics GP for their users by organizing Dynamics GP.Read Organizing Microsoft Dynamics GP 2010 in full
There may be situations where you need to support standard users and have no choice but to temporarily grant administrative privileges. This article by Russell Smith, author of Least Privilege Security for Windows 7, Vista and XP, includes information about tools and techniques that can be used to solve Least Privilege Security problems.
In this article we'll learn to:
- Set up a system for temporarily granting administrative privileges to standard users for support purposes
- Use Task Scheduler to run common processes without the need to elevate privileges
Maintaining Dynamics GP is an important part of keeping the system healthy. In this article by Mark Polino, author of the book Microsoft Dynamics GP 2010 Cookbook, we will look at some common maintenance items including:
- Preventing entry of wrong dates by Closing Periods
- Improving performance by adjusting AutoComplete settings
- Cleaning up Accounts Receivable with Paid Transaction Removal
- Providing correct tax information by Updating 1099 information
- Maintaining updated code by rolling out Service Packs with Client Updates
Office Live Small Business is Microsoft's web-presence service for small businesses. It's part software and part service. In fact, Microsoft calls this strategy Software + Services.
In the previous article we have learned How to create and Customize your Home Page
In this article byRahul Pitre, author of Microsoft Office Live Small Business: Beginner’s Guide we will learn :
- A Contact Us page that enables visitors to contact you
In this article series, the objective is to create a skeleton for your website by building four skeletal web pages that will serve as your website's foundation.
In this article by Rahul Pitre, author of Microsoft Office Live Small Business Beginner's Guide we will learn :
- A Home page that acts as the gateway to your site
- An About Us page that tells a visitor about you and your business
In this article by Mike Liu, author of WCF 4.0 Multi-tier Services Development with LINQ to EntitiesWe will cover the following topics in this article:
- Configuring the firewall for the distributed WCF service
- Propagating a transaction from the client to the WCF service
- Testing the multiple database support of the distributed WCF service
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.
In this article series, we will first verify that the LINQNorthwind WCF service does not support distributed transaction processing. We will then explain how to enhance this WCF service to support distributed transaction processing and how to configure all related computers to enable distributed transaction support. To demonstrate this, we will propagate a transaction from the client to the WCF service and verify that all sequential calls to the WCF service are within one single distributed transaction. We will also explain the multiple database support of the WCF service and discuss how to configure MSDTC and the firewall for the distributed WCF service.
In this article by Mike Liu, author of WCF 4.0 Multi-tier Services Development with LINQ to Entities We will cover the following topics in this article:
- Creating the solution files
- Testing the transaction behavior of the DistNorthwind WCF service
- Enabling transaction flow in the service bindings
- Modifying the service operation contract to allow transaction flow
- Modifying the service operation implementation to require a transaction scope
- Configuring the Distributed Transaction Coordinator for the distributed WCF service
Microsoft Dynamics NAV 2009 is a very complete ERP package, but unlike other ERP packages it has a design capable of providing an open structure and a development platform. The idea is to provide 80% of the solution out of the box and allow the other 20% to be designed by qualified business application developers.
In this article by Mark Brummel, author of Microsoft Dynamics NAV 2009 Application Design, we will learn how Microsoft Dynamics NAV fits a consultancy company. Most consultancy companies have project related processes. They take on larger projects that take a certain time to complete. Some consultancy companies also purchase and sell items.
We will discuss four different project scenarios and see how Microsoft Dynamics NAV can be used to support those. To do this we will create some modifications along the way.Read How Microsoft Dynamics NAV fits a consultancy company in full