SQL Server ER Diagrams – Do Not Expect Miracles

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 a house, the construction master needs the project documents, database specialists also need their ERD to build the database on strong foundation. ERD is part of… Read More »

How to Execute SQL Query in Excel (Office 365)? Tutorial with Examples

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 insert the data into Excel simply by copying it from some factory system. But data can also be inserted into excel in more suitable ways which… Read More »

How to Execute SQL Procedure in Excel incl. Parameters with Example

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 queries in Excel is not optimal in general, but sometimes there is no other option. This guide is aimed on advanced Excel users with SQL… Read More »

SQL Error: Login Failed for User – What to do?

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 »

MS BI Developer Skill Set – List of Knowledge and Abilities

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 »

SQL Error: Saving Changes is Not Permitted – Solution with Example

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 »

SSIS Google analytics Data Import into SQL Server Database (using KingswaySoft)

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 »

Intro to SQL Server Management Studio (SSMS) for Beginners

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 in Excel – SUMPRODUCT

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 »

SSRS Tutorial Part 6 – How To Deploy Report in SSRS – Reporting Services

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 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 »

SSRS Tutorial Part 5 – Configuring Parameter for Filter in SSRS – Reporting Services

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 also prepared in previous parts. We made a promise not to make the report too complicated but we still should do one thing. Report showing only… Read More »

SSRS Tutorial Part 4 – Creating Report in SSRS – Reporting Services

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 to create a simple report in SSRS. Reporting services offers plenty of useful tools you can use to create nice and practical tables/graphs. We will not… Read More »

SSRS Tutorial Part 3 – How to Configure Dataset in SSRS – Reporting Services

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 a connection to database via Data source connection manager. We used shared Data source with scope over whole BI project. Then we added reference to our… Read More »

Are You GDPR Ready? Try Out Our GDPR Questionnaire

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 cancels Law no. 101/2002 Coll on personal data protection and brings many new obligations. I recommend to start elsewhere in case you do not know GDPR… Read More »

SQL Collation – How to Change Collation of Table Column

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 stores non-Unicode data. We may choose SQL Collation CZECH_CI_AS in Czech environments. While starting a database, we can also select collation that can be different to… Read More »

SSRS Tutorial Part 2 – Data Source Configuration in SSRS – Reporting services

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 project and report creation). This set up the ground for this part in which we will configure the report for data tools (SQL Server database in… Read More »

SSRS Tutorial Part 1 – Creating SSRS Project and Report in Reporting Services

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 of place where we will create the report itself. To even start working with Reporting Services tool, we need: SQL Server Data tools 2015 (or older)… Read More »

SQL TRY CATCH and Error Handling with Examples

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 transaction (more in article on Transactions). If an error occurs in the first block – TRY..END like that is activated code in CATCH..END block. TRY CATCH… Read More »