If you have worked with or implemented Microsoft CRM 3.0 (or even previous versions like 1.2), you will know that there are some features that could really help improve the implementation, development, and end-user experiences. CRM Titan (4.0) has the promise of bringing together some of these features in this third major release of Microsoft CRM (yes, they skipped 2.0). Along with multilingual capabilities, one of the main hot-points is the SaaS offerings. Microsoft CRM will be available in 3 architectural flavors: On-Site (Self Hosted) — as done in the past Hosted by Partners Hosted by Microsoft The SaaS offerings … Read More
SQL Server 2005 Service Pack, Version, Edition
Here is how I find out what SQL Server 2005 DB I am playing with: Log into any DB in your SS 2005 instance Run the following query SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
Mr. Ashok Aggarwal Blog – MrAggarwal.com
M&S Consulting Partner, Ashok Aggarwal, has released a personal blog. The blog site can be found here: Ashok Aggarwal’s Blog. Note: M&S Consulting does not endorse or sponsor anything written on www.mraggarwal.com.
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 … Read More
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 … Read More
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
Oracle SQL Subselect Statements
It is becoming more common that I find myself surprised by self-proclaimed, seasoned SQL developers who do not even understand some of the basic power that is possible with an Oracle SQL SELECT statement. I am not talking about some of the more complex analytical functions; I have seen SQL developers lost when it comes to simple subselect statements (a “SELECT” inside a “SELECT”). Most people understand that they can nest a SELECT statement inside the WHERE clause of another SELECT statement, but many do not realize that it is possible inside the FROM clause (perhaps, my most common use) … Read More
Oracle Portal CMEF
A new and exciting piece of functionality that comes with the new versions of OracleAS Portal (starting with 10g – 10.1.4) is the Content Management Event Framework (CMEF). CMEF enables you to extend OracleAS Portal’s content management functionality by adding programmatic hooks to certain pre-defined portal events. The framework publishes these events to an Oracle database queue. This allows third party programs to subscribe to these events and to use the APIs to extend your portal. In this way, you can use page and item related events within a portal to trigger actions within one or more external applications. The … Read More