Prerequisites to enable before you can deploy a CLR function

1. Enable the CLR execution on the target database that is disabled by default. The T-SQL command to enable CLR execution is as follows:
   sp_configure ‘clr enabled’, 1
   reconfigure
   GO
2. Make the database TRUSTWORTHY. This is required because our CLR project is going to be deployed with permission set = EXTERNAL_ACCESS as its calling an external web service, and for an assembly having EXTERNAL_ACCESS permissions we need to make database TRUSTWORTHY. The command for making database TRUSTWORTHY is
   ALTER DATABASE <databasename> SET TRUSTWORTHY ON
   GO

Megode Definition

Megode

English
Etymology
First attested 1961, Sandton Clinic, South Africa.
Pronounciation

• (UK) enPR: mēgōdē, IPA: /miːgəʊdiː/, SAMPA: /mi:g@Udi:/
• (US) enPR: mēgōdē, IPA: /migəʊdi/, SAMPA: /migoUdi/

Noun
Megode

1. A thing (used in a vague way to refer to something whose name one cannot recall)

Please pass me that Megode over there.

1. Used to label specialized emergency room equipment by nurses in South Africa.
2. A BI data-warehousing company based in Seattle Washington with South African roots.
3. Used to label or describe any data schema or object whose name one cannot recall.

Synonyms

• dohickey
• doodad, doodah
• gismo, gizmo
• thingamabob, thingmabob, thingumabob, thingummabob
• thingamajig, thingmajig, thingumajig, thingummajig
• thingy
• whatsit
• whaddayacallit, whatchamacallit
• da kine (local Hawaiian slang)

Translations
A thing

Maturity over time

Each distinct phase of a business’ lifecycle represents a milestone of what amounts to continuous improvement concerning these business truths (operating model). The compliment of IT enhancements to meet these maturity moves forward, match the value and thereby justifying the costs of all IT enhancements. This starts on day one of a successful business.

Business Data

The repository of all possible truths about a business. The key to “great” data repositories begins by creating systems that house and manage objective truths that are as atomic as usefully possible, and when those atomic parts are reassembled, they will continually represent verifiable facts that can be distinctly described.

Megode’s Capabilities

Megode’s capabilities; ranging from app dev/web dev/world-class BI solutions to their Virtual CTO and DBA position offerings – are not just a collection of IT service options, but are specific byproducts of the relationship Megode develops with each client.

Each relationship is governed by the knowledge that all businesses, like persons, grow into and through distinct levels of maturity. That each level of maturity requires the right level of IT investment; always focusing on value not cost. Megode understands that there is no one “right/forever solution” for a business problem. Megode approaches all engagements by taking into consideration the specific businesses needs of each client. This in-depth understanding requires a commitment-based relationship which Megode proudly has with each and every client.

Megode works individually with each of its distinguished clientele searching for the most efficient and effective roadmap to help guide their business forward starting from where it’s at today. Megode uses their experience and expertise to help guide businesses along this roadmap – governed by their business strategy. Via an ever more effective IT solution to the business’ operating model, Megode helps their clients create a value-based IT infrastructure serving their growing business goals and objectives.

It’s a journey, not a Destination

Revenue Recognition – DW Solution

Revenue Recognition Image

Introduction
Megode delivered a complete Data Warehousing “eco-system” to understand and report revenue for a large financial services client.  This client had been operating in “startup mode”, but as they were acquired, the urgency to be auditable and demonstrate viability in their accounting practices became critical to their success as a company.

Not only did Megode deliver the systems and reports to complete end of 2009 revenue reporting, but the architecture of the system is such that the client may now continue on to grow the system for more  partners and increased capabilities.

Implementation
The RevRec system is built upon Microsoft SQL Server 2008, SSIS and SSAS using Visual Studio.   Architecting and building the solution required knowledge of these technology components combined with depth of expertise in dimensional modeling and accounting principles.

Rev Rec Case Study

Changing BI

Business Intelligence (BI) solutions help organizations adapt faster to changing market conditions, listen to customers more effectively, and most importantly, improve an organization’s overall profitability.

BI Service Card