This article will tell you about creating ER diagrams in SQL Server management studio. ER diagrams (entity relationship diagrams) describe static structure of database tables. Just like when building...
This article is made especially for those who regularly export large data volumes to Excel in order to analyze them or process some kind of regular report. Usually, we...
I must say right from the beginning that even though this process is possible, I do not recommend it (but I will show it to you anyway) :). Launching...
SQL Error “Login failed for user <user name>. The user is not associated with a trusted SQL Server connection” is quite common. The problem is that SQL Server cannot...
What I have for you here today is a different kind of stuff. We will take a look at what should BI developer working on Microsoft technologies be able...
Import of Excel sheet or csv file into SQL Server is a quite common task. You can find a guide on how to do it below. Let’s have an...
When working with database objects, we may sometimes get into a situation when we want to change property of an object. For example change of data type in column...
Did you ever need to compare 2 lists and test it for duplicities? The easiest way to do it in Excel is to use standard functions as VLOOKUP. Sometimes...
This article should give you guide on how to perform Google analytics data import to database/database storage without need of programming. Why should we want something like that? Maybe...
This article is mainly for beginners getting to know SQL Server management studio. It is tool used by you as a user to communicate with SQL Server database engine...
Weighted arithmetic mean is a statistical value of broad use not only in mathematics or statistics. If you need to calculate weighted arithmetic mean in Excel, here is a...
We now have well-prepared simple report after the 5th part of the series (Configuring parameter/filter in SSRS). This article is focused on report deployment in SSRS and describes how...
We prepared simple report in previous part (Part 4 – Creating report SSRS). It displays sales data in form of a simple table displaying results of dataset which we...
Last 3 SSRS tutorials were kind of preparation phase, maybe a calm before a storm :). After creating SSRS project, defining data source and dataset, it is finally time...
Lets rewind what happened in the last part of our series focused on SSRS report creating (Part 2 – Configuring Data source in SSRS). We saw how to create...
What I have for you today is not an article but a questionnaire focused on GDPR (General data protection regulation), that is directive in force since 25/5/2018. This directive...
While installing SQL Server, one of the parameters that is needed to be set during installation is Server collation. It is a parameter influencing the way in which SQL...
We took a look at creation of project and empty report in the BI tool SSDT (SQL Server Data tools) in previous part of the miniseries (Part 1 -SSRS...
This miniseries focused on making a report in Reporting services will show you how to create SSRS project and report step by step. Let’s take this as a preparation...
SQL TRY CATCH command is designed to control code flow in case that error situation occurs (error handling). This construction consists of blocks. It is also possible to use...