Most calculations in the area of financial mathematics are relatively easy – for example, to calculate an annuity payment, interest rate or target amount value with regular deposits. However, financial calculations can be quite complex in certain circumstances. This is particularly true on the money and capital markets (bonds) or on some specifically agreed corporate… Read More »
A trigger is a database object (procedure) that works as a watchdog for certain event. Using database triggers we can catch this event and initiate some additional action – such as logging or rejecting the action. Trigger – event that initiates the action What are triggers used for? Triggers are used mainly for auditing objects… Read More »
In SQL Server administration, there are two terms that can easily be confused: SQL Login and SQL User. In a previous article, we took a closer look at SQL Login, and here we will focus on SQL User. SQL User While SQL Login is used to log in to SQL Server and defines permissions at… Read More »
In SQL Server administration, there are two terms that can easily be confused: SQL Login and SQL User. While SQL Login allows you to manage permissions for server access, SQL User defines permissions for database access. In this article, we’ll take a closer look at SQL Login. SQL Login It provides access to SQL Server.… Read More »
SQL Server is not just a platform for storing and working with data or databases. It is a suite of services that includes features such as: Reporting Services (SSRS) – report creation and storage, including a report server. Analysis Services (SSAS) – OLAP cubes. Master Data Services (MDS) – management of important data, such as… Read More »
Reporting services are a feature that you can use starting from the Express edition, and it is a set of services that allow you to create and publish reports. I have written a series of articles about Reporting services (the first part is here). Users can view these reports on the URL within the internal… Read More »
In the previous two articles, I covered setting up database mail (gmail) and configuring Change Data Capture (CDC), which is the automatic tracking of changes to a table. So, it occurred to me, why not combine these topics and describe how to use automatic email to report changes to a specific table? This could come… Read More »
A database is a system of files and objects that are organized and linked within the database through keys. In SQL Server databases, you can find objects such as tables, views, functions, procedures, triggers, and more. Essentially, there are two ways to create a database. The first option is to create the database using the… Read More »
DBCC stands for database console commands, which are commands executed on a specific database. The DBCC command set allows you to perform various administrative operations or queries on databases through scripting, instead of using the graphical interface of Management Studio. To execute these commands, you typically need a high-level role (such as sysadmin, serveradmin, db_owner,… Read More »
SQL Developer is responsible for the development and management of application database structures, both from a database architecture perspective (tables, views, procedures, triggers) and in terms of security (access management, protection). SQL Developers most commonly work with these database platforms: SQL Server, MySQL, and Oracle. They are often mistakenly referred to as Database Administrators, but… Read More »