Oct 22

Microsoft LightSwitch Application Development with SQL Server

Microsoft LightSwitchMicrosoft Visual Studio LightSwitch for Microsoft Access, SQL Server, and Visual Studio .NET Database Developers

The Visual Studio team has introduced a development platform called LightSwitch which simplifies the creation of database applications in Visual Studio. This rapid application development environment lets you create solutions that can be easily deployed on Windows or Mac platforms from a public web site or Intranet.

We’ve been using LightSwitch for the past year and find it to be ideal for a particular class of SQL Server based solutions. Here our first article providing an overview of the benefits and limitations of the LightSwitch platform for the Microsoft Access community. The paper includes:

  • Sample screens
  • The Visual Studio .NET Platform
  • Working with SQL Server and SQL Azure
  • Rapid Application Development
  • Silverlight Dependency and Limitations
  • Supporting Windows, Mac, and Web Browsers
  • Future Support of HTML5
  • How Microsoft Access Applications can Evolve into LightSwitch

If you’re interested in learning more about our help developing custom solutions based on LightSwitch, visit our LightSwitch Consulting page.

Jun 17

Watch the Microsoft TechEd Conference Videos for Free


TechEd is Microsoft's premier conference for IT professionals and developers. The sold-out conference took place in Orlando, Florida last week.

If you didn't attend, you can still watch many of the videos from the conference, including the keynotes and other highlights from each day. Visit the TechEd web site and click the "On Demand" tab to learn about the latest in Microsoft technology.

The announcements this year are stunning with huge advances in Azure, Visual Studio .NET, SkyDrive, LightSwitch, Virtual Machines, and more.

May 09

Microsoft Access Database Architecture: Taking Time into Account and Shadow Tables


When designing an application and its tables, it’s very important to capture the time dimension and determine how data should be stored with the expectation that it will change over time. While there’s a natural tendency to keep data normalized so that the same information is stored in only one place, the time dimension also needs to be considered.

  • What Needs to be Preserved Over Time?
  • Making Sure Data Normalization Doesn’t Lose Historical Data
  • Shadow Tables

For more details, read our paper: Microsoft Access Database Architecture: Taking Time into Account and Shadow Tables

Additional papers and resources in our Microsoft Access Developer and VBA Programming Help Center

Feb 27

The Hot Mommas Project Website Update

HotMommas Web SiteLongtime client Kathy Korman Frey, George Washington University School of Business professor and GWU Entrepreneur in Residence, has engaged the FMS Professional Solutions Group to enhance her HotMommas Project website.

The site is the world's largest collection of public case studies for entrepreneurial women. It is a community where women can learn from the experiences of other women addressing their businesses, family and personal challenges.

Visual Studio
The revamped website is built on Visual Studio .NET, SQL Server with a modern, dynamic interface incorporating our technical and graphic artist resources.

Contact us if we can help you with a similar solution.

Feb 16

Linked In Communities for the Microsoft Access, Azure, SQL Server and Visual Studio .NET Communities


LinkedIn
LinkedIn offers many opportunities for professionals to interact with each other. There are many groups available for the Microsoft Access, Azure, SQL Server, and Visual Studio .NET communities. Here are some of the vibrant groups we’ve discovered:

Microsoft Access, Excel and VBA

Microsoft AzureMicrosoft Azure and SQL Server


Visual Studio .NET