MS SQL Server is the software created by Microsoft. It includes a database engine and a number of features that help with database development, maintenance, and various activities such as reporting or master data management.
These features include SQL Server Integration Services, Reporting Services, Analysis Services, and other components such as Master Data Management or Data Quality Services.
Don’t miss out from category:
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 »
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 »
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 to create report. To even start working with Reporting Services tool, we need to meet these requirements: Visual studio 2019 (or SSDT) – in case we… Read More »
What you will find below is a map of all components and tasks which are part of SSIS Project in SQL Server Data Tools 2015. Particular components and tasks can be found in SSIS Toolbox (see screenshot). I am going to add tutorials for SSIS and other ETL tools in the future. SSIS ToolBox –… Read More »
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 these keys. We can do just fine with primary keys. It is much needed to create surrogate keys in data warehouses for many reasons, read further.… Read More »
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 install it, go ahead and take a look at this article. If you would like to inspect particular SQL server editions more thoroughly, take a look… Read More »
I finally got to MS SQL Server 2016 – Release candidate 3 installation during weekend. First thing I did was focusing on news regarding Reporting services 2016. Microsoft presents its new reporting services as a big thing full of innovations. It looks attractive, sorted and when you look closely you can see resemblance to Power… Read More »