Category Archives: SQL Server

Power Pivot in Excel. First look. Part 2

This post is continue of the PowerPivot in Excel. First look Part 1.  Today I will get the currency rate for each transaction that is done not in rubles currency. The rates are entered usually monthly (but there can exceptions), … Continue reading

Posted in Business Intelligence, Database development, SQL Server, Technology | Tagged , , , , | Leave a comment

How to create currency conversion in Microsoft SQL Server Analysis Services (SSAS)

In this post I would like to speak about currency rates calculations in standard dimension model, and in the next post I would return to Tabular model, DAX language and perform the same calculations there. It’s quite a common business … Continue reading

Posted in Business Intelligence, Database development, SQL Server, Technology | Tagged , , , , | Leave a comment

Date Range in SQL

While creating SQL queries for reports, it’s usually required to get a continuous list of dates for a given period. E.g.: get all dates from 1980 Jan 01 till 2013 Dec 31 (12419 records). In this post I would like … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , | 6 Comments

ERP system performance. How it works in practice.

As I promised, this post will be dedicated to some real life practice. We’ll try to find the bottle neck in one document save process. The principles and structures for ERP performance were described in the previous posts you can … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , , | Leave a comment

ERP system performance metrics

In this post I’d like to show what performance reports we use in our everyday work to track whether system is ok or not. First section – reports we are receiving on daily basis. Timeout Report. The report consists of … Continue reading

Posted in SQL Server, Technology | Tagged , | Leave a comment

Database structure to store performance metrics

In this I will continue previous one What performance metrics are important and how to collect them and will describe the database structure to store performance statistics. I will take as basis the structure designed by me and generalize it for … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , , | 1 Comment

What performance metrics are important and how to collect them

In the previous post How to measure your system performance, I’ve given common description of your own ERP system performance. Now I would like to concentrate on what performance metrics we can collect. First of all let’s try to list … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , , | 2 Comments