Shivayan Mukherjee

A professional software developer having more than 11yrs of industry experience in Java, SQL, microservices across multiple domains such as insurance, airlines, telecom, healthcare.
  • Interests: coding, travelling, outdoor games

SQLServerCentral Article

PostgreSQL Triggers Part 2

Article Overview In this article, we will learn how to drop, alter, enable, and disable a PostgreSQL trigger. In the 1st part of this series, we got an overall view of database triggers, PostgreSQL-specific triggers, types of PostgreSQL triggers, and how to create a trigger with basic syntax and examples. If you haven't read it […]

You rated this post out of 5. Change rating

2022-09-23

1,625 reads

SQLServerCentral Article

PostgreSQL Hibernate Integration

Overview PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language while Hibernate is probably the most popular ORM tool. If you are not familiar with PostgreSQL then I suggest you to go through this link below before going ahead in this article. This article is […]

(1)

You rated this post out of 5. Change rating

2021-07-16

26,477 reads

Blogs

Methodology for dealing with bad data in production

By

Pinal Dave wrote up his methodology for what to do when you discover bad...

How to Provision an Azure SQL Database

By

Aside from spinning up a SQL Server instance container, the free Azure SQL Database...

Claude finds two cryptographic weaknesses (but the sky isn’t falling)

By

If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...

Read the latest Blogs

Forums

Why SQL Server Database Attach fails and how to repair it

By Nisarg Upadhyay

Comments posted to this topic are about the item Why SQL Server Database Attach...

Fixing P1 Queries

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fixing P1 Queries

BIT_COUNT() IV

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BIT_COUNT() IV

Visit the forum

Question of the Day

BIT_COUNT() IV

In SQL Server 2025, I run this code:

select bit_count('A')
What is returned?

See possible answers