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 […]

Stairway to SQL Server Security

Stairway to SQL Server Security Level 5: Schemas and Security

In this stairway level you’ll learn how you can give principals access to groups of objects by assigning permissions on schemas instead of individual tables, code modules, and other objects. You’ll also learn about the benefits of user-schema separation and how it can increase object security, and how using default schemas for users and groups can simplify object access management and security.

Blogs

Understanding Microsoft Purview Pricing

By

Ever since its official launch around October 2021, Microsoft Purview has been one of...

Why I tweet about work and personal topics from the same account

By

Over the last few years, I’ve had a few people ask me why I...

Daily Coping 26 Sep 2022

By

Today’s coping tip is to enjoy photos from a time with happy memories. On...

Read the latest Blogs

Forums

cursor to do update for multiple tables of a specific field

By sqlfriend

I am trying to scramble ID field in multiple tables in database. I created...

3616 Trigger Error when Calling Stored Procedure on Linked Server

By mrslade

I am updating a proprietary database using an SSIS package. From a web UI...

Seggregating access within a database to users

By noobdba

For some folks that have gotten used to working in Oracle where a user...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Using R apply

See possible answers