© 2022 Hashnode
#sql-server
Intro In this part I will be talking about: Trigger limitations Trigger use cases Trigger limitation and use cases Let's begin by discussing some of the advantages of using Triggers: Used for Datab…
Introduction As a Backend Software Engineer, you will be working with databases a lot on a regular basis, so you should get comfortable reading SQL errors to properly fix them, so it's an essential s…
Trigger Management and Optimization In the previous part I've talked about how to properly use Triggers (AFTER, INSTEAD OF) along with their use cases and limitations. In this part, I'll talk about: …
Problem: I have configured the distributor and then trying to create a publication on the publication server using sp_addpublication stored procedures with respective parameters. I have got the below error message. Error message: Msg 14013…
If you are looking to start your data analytics and visualization journey. There you are in the right place, as this blog post would guide you step by step on how to start. In data analytics and visua…
If you've had to write SQL the chances are that you've had to write some queries that utilize some handy platform specific functions. You may use them for so long you even forget that they are platfor…
What is PL/SQL ? PL/SQL is Oracle's procedural language extension to SQL Oracle database allows us to create tables, objects, execute all the familiar SQL statements, like INSERT, UPDATE, and DELETE.…
We did the initial project setup on containers in the previous "Demystifying Docker" series article. In this one, we will cover the database with persistence (examples with MS SQL Server, PostgreSQL, …
In my previous blog, I briefly introduced apache airflow and mentioned how the tool can be used to orchestrate tasks however I did not set it up locally. This was a deliberate attempt to discuss the t…
Write a SQL query to concatenate multiple rows into a single string? USE TestDB; GO DROP TABLE IF EXISTS dbo.product_category; GO CREATE TABLE dbo.product_category ( product_category_id INT NOT…