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:
BCP is a utility that is installed by default with SQL Server editions and is used for bulk import or export of a large volume of data in user-defined formats. This utility is optimized for large data transfers either between SQL Server instances or between a SQL instance and a text file. The utility is… Read More »
Table and index compression is a functionality that has been available in various SQL Server editions for a while. It has been available in all editions, including SQL Server Express (for free), since version SQL Server 2016. Data compression allows you to save storage space significantly. This, of course, saves enterprise resources, such as hardware… Read More »
In previous articles, I have published several tutorials on Reporting Services (you can find them in the reporting services – SSRS category). These tutorials provide detailed guidance on creating a basic report using SSRS, applying parameters and filters to limit report output, and similar topics. Designing more advanced and visually appealing reports requires additional experience… Read More »
Data masking is a feature that allows you to completely or partially mask selected data in a database. Access to unmask the data can also be granted or revoked for individual users. Data masking and anonymization have become increasingly important topics, especially with the introduction of GDPR regulations by the European Commission, which require greater… Read More »
Lately, I’ve been dedicating a lot of time to financial mathematics in Excel. I’ll try to leverage that and shift the focus from Excel to SQL Server. Perhaps someone is considering creating an application for amortization calculator schedule where you can input parameters, and it will generate results for you in a table. The result… Read More »
For generating IDs (primary keys) in application databases or surrogate keys in data warehouses, there are several approaches. GUIDs or numeric IDs are mostly used. GUIDs are mainly used in application databases and are generated, for example, using the NEWID() function. This has its advantages and disadvantages. The biggest disadvantage is poor SQL query performance… Read More »
Aside from the standard method of installing SQL Server via the classic visual interface, there is also the option to install SQL Server from the command line or PowerShell. This is useful when you regularly perform multiple installations with similar configurations and want to dynamically define instance names, service accounts, or installation directories. Additionally, there… Read More »
Installation of MS SQL Server involves a lot of work before an IT specialist can actually start the installation process. Before we address the software and hardware requirements, we need to consider one thing: what edition of SQL Server we will actually need, depending on the features of SQL Server we intend to use. Hardware… Read More »
A data warehouse is a central information system designed to store data from one or more enterprise operational systems or other external sources such as Excel, SharePoint, and others. Data in the data warehouse is organized into schemas and undergoes a cleansing and structuring process before storage to make it understandable to users and easily… Read More »
AdventureWorks databases from Microsoft are the most popular sample databases for developers, database administrators, or simply for students looking to learn something about SQL Server and database management. In this article, we will take a look at the available variants of Adventure Works databases, but more importantly, I want to highlight the possibility of connecting… Read More »