Author Archives: Ing. Jan Zedníček - Data Engineer & Controlling

About Ing. Jan Zedníček - Data Engineer & Controlling

My name is Jan Zednicek, and I have been working as a freelance Data Engineer for roughly 10 years. During this time, I have been publishing case studies and technical guides on this website, targeting professionals, students, and enthusiasts interested in Data Engineering particularly on Microsoft technologies as well as corporate finance and reporting solutions. 🔥 If you found this article helpful, please share it or mention me on your website or Community forum

SQL Error – Microsoft.ace.oledb provider is not registered on the local machine

Microsoft.ace.oledb provider is not registered on the local machine is a quite common error message in data & analytics when we try to work with data in database without proper driver installed. When Does the ACE OLE DB Provider Error Occur and How to Resolve It? This error occurs when attempting to connect to an… Read More »

Data Analyst – Job description | Business Intelligence

A data analyst is a professional who investigates data using data analysis tools to extract valuable information for management and business development. These individuals are capable of identifying patterns, dependencies, and trends in a large amount of data through a logical approach and technology (programming languages) that can positively influence management decisions and, consequently, business… Read More »

SQL Simple Recovery Model – Functions and Backup

SQL Server offers 3 types of database recovery models: simple recovery model, full recovery model, and bulk-logged recovery model. The recovery model defines how SQL Server manages transactions and transaction logs and whether it stores or doesn’t store these data. Ultimately, this affects the options available for restoring data from backups. Each database can have… Read More »

SQL IDENTITY (Auto increment) – Automatic value increase, description

IDENTITY is a property in SQL Server that allows for the automatic numbering of records inserted into a table. It creates an automatic increment with unique values without the need for manual insertion of numbers into the table. This function can be utilized with numeric data types, and its typical use is for identifiers and… Read More »

SQL Server Email Configuration from Gmail – Example – Database Mail (Part 1)

The Database Mail feature is only available in the SQL Server Standard edition and higher. In the SQL Server Express edition, unfortunately, it is not available. This feature is useful primarily if you want to send various messages from SQL Server to your email. Typically, this involves various checks, notifications, and alerts. Finally, this feature… Read More »

SQL Server Change data capture (CDC) – Tracking Changes in a Table

In applications or complex enterprise information architectures, there is often a need to handle historical records and track changes in values for various reasons. Most of the time, it’s for security purposes; we need to monitor who is making changes and be able to correct errors, whether they are from users or database administrators. Another… Read More »

SQL Server Error Messages and Severity – sys.messages + Description

In SQL Server, there is a system table that stores all possible error states and their severity levels. Error severity ranges from 0 to 25 and defines the seriousness of an error. All sql server error messages that you may encounter are stored in the sys.messages table. USE MASTER SELECT * FROM SYS.MESSAGES WHERE language_id… Read More »

xp_cmdshell – How to Enable cmdshell in SQL Server?

xp_cmdshell is a very powerful procedure that allows you to execute commands via the command-line (cmd) in SQL Server. With cmdshell, you can perform various operations on a Windows server through the SQL platform, such as copying files, creating, deleting, running bcp for data import and export, and more. However, there are significant security risks… Read More »