Posted: February 5th, 2011
Author: Anthony Kippen | Filed under: Code, SQL | Tags: CLR, Database, funtion, SQL, t-sql | Comments Off
- 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
- 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
Posted: June 3rd, 2010
Author: Anthony Kippen | Filed under: Information | Tags: BI, Business Intelligence, data, def, definition, defn, Megode | No Comments »
First attested 1961, Sandton Clinic, South Africa.
- A thing (used in a vague way to refer to something whose name one cannot recall)
Please pass me that Megode over there.
- Used to label specialized emergency room equipment by nurses in South Africa.
- A BI data-warehousing company based in Seattle Washington with South African roots.
- Used to label or describe any data schema or object whose name one cannot recall.
Posted: April 21st, 2010
Author: Anthony Kippen | Filed under: Glossary | Tags: BI, Business Intelligence, data, Glossary, Megode, Service | No Comments »
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.
Posted: April 21st, 2010
Author: Anthony Kippen | Filed under: Business Intelligence, Glossary, Information | Tags: BI, Business Intelligence, data, Glossary, Megode, Service, Terms | No Comments »
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.
Posted: April 21st, 2010
Author: Anthony Kippen | Filed under: Information, Marketing | Tags: BI, Business Intelligence, capability, data, Destination, economy, Journey, Megode, Service, SQL, SSAS, SSIS, XML | Comments Off
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
Posted: April 9th, 2010
Author: Anthony Kippen | Filed under: Case Study | Tags: BI, Business Intelligence, Case Study, data, economy, financial, OLAP, sample, Service, SQL, SSAS, SSIS, XML | No Comments »
Revenue Recognition Image
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.
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
Posted: November 17th, 2009
Author: Anthony Kippen | Filed under: Marketing | Tags: BI, Business Intelligence, Media, Service | No Comments »
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