Tag Archives: SQL Server

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

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

How to measure your system performance? First look

I would like to start a new set of posts about system performance. I would not write about Windows server performance or database performance, but speak how to measure your ERP system work. If you face situations when server is … Continue reading

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

Service Broker: add message to queue

In this post let’s dwell on adding messages to queues. In our system we prefer doing it inside triggers. Why triggers? There are several reasons: You cannot miss trigger event, whenever you perform update through web-service, or direct in the … Continue reading

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