I recently purchased a new Macbook Air with Apple Silicon M1 CPU architecture (ARM). From the first time everything was fine – super experience when unboxing, everything tuned to...
It is possible to connect to many data sources using Power Query (more in this article) and SQL Server database is one of them. This article will tell you...
Correct table indexing in SQL Server is a base for good database performance during querying. You need to understand how SQL Server stores data into tables/indexes if you want...
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...
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...
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...
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...
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...
What you will find below is a map of all components and tasks which are part of SSIS Project framed in SQL Server Data Tools 2015. Particular components and...
Surrogate key is term mostly used in data warehouse environments. We might not come by this term in application production databases simply because there is no need to generate...
I described plus and cons of SQL Server Express edition in the article SQL Server Express for Beginners. If you decided to try Express and you wonder how to...