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 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… Read More »
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 a connection to database via Data source connection manager. We used shared Data source with scope over whole Reporting services project. Then we added reference to… Read More »
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 issues in the future can be avoided. Additionally, script performance can be influenced by the structure of SQL queries and properly configured indexes. This article is… Read More »
The error message “Conversion failed when converting the varchar value to data type int” occurs in SQL Server client (for example Management Studio) when attempting to convert a value stored as the varchar (text) data type to an integer data type. This might not be an issue if the varchar contains numeric values, but problems… Read More »
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 on severity. The THROW command is an alternative command introduced with SQL Server 2012. THROW Syntax in SQL Server The syntax is simpler compared to RAISERROR.… Read More »
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 invoke an error within a BEGIN /END TRY BEGIN/END CATCH construct. In such cases, you can use the RAISERROR command or the newer THROW command. In… Read More »
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 you how to do the opposite – that is, how to get data from an SQL database into Excel – exporting a table. Generally, I don’t… Read More »
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 »
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 »
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 a kind of preparation for this part in which we will configure the report to be able to query a database (SQL Server database in our… Read More »