Testimonials

What our customers are saying

"You're the best I have."


- D. Barton, Global Oracle Consulting Firm

about us

Service Delivery

Multiple ways to access M&S

M&S offers technology and process solutions through multiple offerings and vehicles. End-to-end solutions, training and mentoring, staffing, ongoing support.

read more

Effective and Efficient

Exceptional Results

M&S today reflects a rare combination of out-of-the-box thinkers, deep business acumen, enterprise architectural design/engineering, and software prowess.

contact us

From the M&S Blog...

Visual Studio 2008 (VS2008) – Common Keyboard Shortcuts

When I did a quick search online, I found some keyboard shortcuts for Visual Studio 2008 that didn’t work for me, so thought I would get a post going.

Comment and Uncomment Code Blocks Quickly

I comment blocks of code in VS2008 with:

CTRL-E, C

…and I uncomment blocks of code with:

CRTL-E, U

Microsoft CRM 3.0 – Hide Links in Left Navigation – Example Code

Here is an example of code to get stripped down contact and account forms. This code is placed in the onLoad event of the respective forms. Note: this is not supported, but a common way to hide left navigation links on specific entities (since normal site map customization does not affect these).

read more

Oracle BAM and SOA Suite – Potential Conflict On Same Machine

We had an issue where BAM stopped working after installing SOA Suite on a Windows 2003 Server (BAM only runs on Windows at the time of this writing).

After trying to uninstall/reinstall many times ourselves, Oracle Support suggested that this was not a compatible configuration. We have done it before (in play environments), but this clearly can cause some issues that are not easy to resolve. So, in this case, we ended up splitting the installation to different machines and have been sleeping much better at night.

SQL Server 2005 Service Pack, Version, Edition

Here is how I find out what SQL Server 2005 DB I am playing with:

  1. Log into any DB in your SS 2005 instance
  2. Run the following query
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

IIS Error – W3SVC Not Starting – Event ID 115

Did your personal IIS stop working recently — the one you run on XP perhaps? Did you get the following error in your event logs?


Event Type: Error
Event Source: W3SVC
Event Category: None
Event ID: 115
Date: 4/23/2006
Time: 12:28:08 PM
User: N/A
Computer: F4005
Description:
The service could not bind instance 1. The data is the error code.

For additional information specific to this message please visit the Microsoft Online Support site located at:

http://www.microsoft.com/contentredirect.asp.

This error is normally the result of another application/service on your machine listening on network Port 80.

But you’re sure you don’t have any other web servers, etc. running, right? This can be frustrating to troubleshoot. So, before you uninstall everything one by one, be sure to check Skype. As Skype gains popularity, my guess is more and more people will be getting this error and scratching their heads.

To stop the error from occurring in IIS, go to “Tools”, then “Options…” in your Skype applications. In the “Connection” section, be sure to UNCHECK “Use port 80 and 443 as alternatives for incoming connections”.

mands_skype_ports

Click “Save” and restart Skype. Restart IIS. You should be good to go.

I hope this helps someone!

RDL and RDLC Conversion – SSRS (Reporting Services) and ReportViewer

RDL and RDLC conversion is something that people who use both Reporting Services and ReportViewer have already done. For those of you who have not looked at these technologies, you really need to. Taking reports written for a full-featured reporting engine like SSRS and instead integrating that into a custom application (which does NOT require SSRS, let alone SQL Server) has huge market value along with technical value.

Following is a good lesson on RDL to RDLC conversion as well as RDLC to RDL conversion:

RDL and RDLC Conversion

Note: of course, if you have any issues with this or other ReportViewer and/or SSRS issues, feel free to engage us as we have been through many of the challenges.

Move Outlook 2003 Configuration Settings to New Computer

This assumes Outlook 2003, Windows XP Professional, and a default configuration.

Email Messages
If everything is stored in Exchange Server, then just configuring your Exchange profile should bring down all mail from the server.

If you are using local email storage, you will want to move your .pst file(s) to the new machine.

Signatures
C:Documents and Settings[username]Application DataMicrosoftSignatures

Rules
Export rules from within Outlook (click “Options” button in the rules configuration area). You will save them onto your harddrive as [something].rwz. Import these rules to the new machine.

Navigation Pane Settings
C:Documents and Settings[user]Application DataMicrosoftOutlook[profile].xml

Nicknames
C:Documents and Settings[user]Application DataMicrosoftOutlook[profile].nk2

SQL Server 2005 Licensing Costs and Pricing Example

  • Processor Licensing Model. Under this model, a license is required for each physical or virtual processor accessed by an operating system environment running SQL Server. This license does not require any device or user client access licenses (CALs).
  • Server plus Device CALs. Under this model, a server license is required for each operating system environment running an instance of SQL Server, as well as a CAL for each client device that accesses a system running SQL Server.
  • Server plus User CALs. Under this model, a server license is required for each operating system environment running an instance of SQL Server, as well as a CAL for each user that accesses a system running SQL Server.

High-Level Pricing For SQL Server 2005 Standard Edition

Processor Licensing
~6K/Processor

Server Plus User/Device CAL Licensing
~2K/Server
~$160/(user or device)