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...
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...
In the past, I have written several tutorials on reporting services (you can find them in the reporting services – SSRS category). I have gone into great detail on...
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...
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...
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...
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....
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...
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....
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...
The previous article focused on installing dbt in the Mage.ai environment or independently, followed by the initialization of a project named mage_dbt – Dbt Installation (pip/conda) and project initialization....
I have been using the KingswaySoft tool for automating ETL data flows for many years and decided to write an article about this tool. KingswaySoft brings a low-code revolution...
In this short article I will introduce the possibility to run a sql script outside of SQL management studio using SQL server command line utility (sqlcmd for short). This...
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...
Table Indexes are a fundamental pillar of optimizing SQL queries in a database. They significantly speed up read operations. Unfortunately, over time, indexes get fragmented, and the order of...
A temporary table with a hash (#) or double hash (##) is a temporary table stored in the system database tempdb. This table exists only for the duration of...
A data warehouse is a centralized repository where information from the entire company is stored, and this information is stored in a format that allows for easy and understandable...
Resource Governor is one of the SQL Server enterprise features that are not available in any other edition. If you are interested in various limitations across editions, I have...
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...
As SQL Server administrators, we might want to know what is happening on the server during the day and if any unwanted incidents are occurring. This is where Alerts...