Last 3 SSRS tutorials were kinda boring of preparation phase, maybe a calm before a storm :). After creating SSRS project, defining data source and dataset, it is finally...
Lets recap what happened in the last part of our series focused on SSRS report creating (Part 2 – Configuring Data source in SSRS). We learned how to create...
Performance optimizing SQL queries is an ongoing battle that begins right from the design of the database architecture and server resource scaling. With the right architectural design, many performance...
The error message “Conversion failed when converting the varchar value to data type int” occurs in SQL Server when attempting to convert a value stored as the varchar (text)...
Some time ago, I published an article on the RAISERROR command, which raises an exception and allows us to influence whether the script will or will not continue based...
In certain situations, it’s necessary to call an error within an SQL script and interrupt its execution. Typical scenarios include failing a data quality check or the need to...
In one of our previous articles, we tried to see how to get data from Excel into an SQL table (Import Excel to SQL Database). Now, we will show...
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...
In previous article we created a project and empty report in the BI tool SSDT (SQL Server Data tools) – Part 1 -SSRS project and report creation. It was...
In this article I will show you how to create Reporting services (SSRS) project and report step by step. This is a first step before we will be able...
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...
Email from MS landed in my inbox few days ago. It states that Power BI introduces new product called Power BI Premium valid since 2Q 2017. Hand in hand...
Operator UNION ALL in SQL makes it possible to unify 2 query results and does not remove duplicities in queries. Operator returns records of both queries with no regard...
UNION operator makes it possible to connect 2 results of query and remove all existing duplicities in them. In other words, operator actually performs DISTINCT (like SELECT DISTINCT) in...
SUBSTRING function is used in sql to select part of text string in text. This function belongs to the group of text functions – string functions. I created a...
T-SQL command IF is used to control flow of code mainly in operations where we somehow influence db (DDL, DML operations) – for example procedures. You can mix it...
This article follows post in which I offered overview of Data types in SQL Server (more in SQL Data types – Overview ). You can find list of all...
I will follow the previous article on Data types. I will go through numeral data types and their properties. Thanks to correct data type selection you may be able...
All columns, variables or terms in SQL Server have their defined data types. These data types define of what type are the values which can be contained in given...