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 identify user name. This is how the error message looks like. What are the Most Common Reasons? Incorrect login or authentication type (Windows vs. SQL) Login… Read More »
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 to do. I put up together a list of knowledge and abilities which I consider important for this job. I gave each skill rating (1-10) according… Read More »
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 excel file containing data on companies: Steplist – Import Excel to SQL Database Example 1) Data import… Read More »
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 of a table via table design in SQL Server management studio. If there is data in the table, SQL server should display an error message if… Read More »
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 though, we might need to compare 2 lists where one of them contains typos. Here, Fuzzy lookup comes into play (can be downloaded here). Typical example… Read More »
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 because we need to create our own reports or combine Google analytics data with data from other source systems – for example internal factory systems. This… Read More »
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 from which you want to extract information. This is so called SQL Client application. It uses user interface to simply help mediate database commands. In factories,… Read More »
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 guide How Works Function SUMPRODUCT and Weighted Arithmetic Mean in Excel Example: Lets have few loans where every loan has different principal and interest rate. The… Read More »
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 covers how to get report on server so that other users can take a look at it. We will do a little configuration of the project and then… Read More »
In the last article we prepared a simple report returning all rows from SQL Server dataset (Part 4 – Creating report SSRS). It displays sales data in form of a simple table. We made a promise not to make the report too complicated but we still want to do one important thing. Report returning the… Read More »