First assumption that could CRASH your Credit Risk Data Warehouse project

Over the past two weeks I’ve covered a summary for the implementation of a Credit Risk Reporting project which is available in two parts, How to Implement a Credit Risk Data Warehouse – Part 1 and How to Implement a Credit Risk Data Warehouse – Part 2 holding the overview of the implications and a structured best practices approach to be considered when enrolling on the delivery of such a project.

Today I will focus on a common preconception that could have a severe impact to the schedule, resources, cost, development and ultimately the delivery of your Credit Risk Data Warehouse & Reporting project. Continue reading First assumption that could CRASH your Credit Risk Data Warehouse project

Sql Server Interview question: Data deletion / Size reduction

Question: When you delete data from a table, is SQL Server reducing immediately the size of that table? Continue reading Sql Server Interview question: Data deletion / Size reduction

Sql Interview Question: What is SQL CLR?

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.

Continue reading Sql Interview Question: What is SQL CLR?

How do you check if automatic statistic update is enabled for a database?

The following query can be used to determine if Automatic Statistic update is enabled: Continue reading How do you check if automatic statistic update is enabled for a database?

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

%d bloggers like this: