SQL CLR (SQL Common Language Runtime) is a technology for hosting of the Microsoft .NET common language runtime engine within SQL Server. The SQLCLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment.
Category Archives: Sql Server 2012
How to implement a Credit Risk Data Warehouse – Part 2
In How to implement a Credit Risk Data Warehouse – Part 1 I did an overview and an executive summary of the activities required for the delivery of Credit Risk Data Warehouse project. If you haven’t read this already I recommend you read How to implement a Credit Risk Data Warehouse – Part 1 first.
In addition to the above, the DW Architect, Project Manager & their teams will have to work and define the implementation approach, which will allow the Implementation team to complete the work on an accelerated timeline.
Usually a multistage “work breakdown structure” approach for the implementation phases of the project is preferred. Continue reading How to implement a Credit Risk Data Warehouse – Part 2
Sql Interview question: What are the limitations of indexed views?
Some of the limitations with Indexed views are:
- The UNION operation is not allowed in an indexed view.
- We cannot create an Index on a nested view scenario which means we cannot create index on a view built from another view.
Continue reading Sql Interview question: What are the limitations of indexed views?
How to implement a Credit Risk Data Warehouse – Part 1
In the past years I’ve worked as a hands-on architect on the design and implementation of various data migration, data warehouse and business intelligence systems in various industries like Insurance, Retail, Food & Bev’s, Pharma & Investment Banking. Out of all nothing quite stands out like the complexity of building a Credit Risk Data Warehouse & Reporting system for the compliance with the Basel Regulatory requirements. Continue reading How to implement a Credit Risk Data Warehouse – Part 1
Data integrity & Business re-engineering
Usually when a company enrolls into a data clean-up exercise the focus is mainly on the in-depth analysis and profiling of the data.
Sometimes it’s worthwhile to step back from the in-depth look at data cleaning to get some perspective.
You should start asking questions like “Why is data dirty in the first place?”, “Are any of the clean-up exercise that we are currently doing reversible ?” or “Does this really need to become an ongoing process ?” Continue reading Data integrity & Business re-engineering