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

SQL Server In Place Upgrades

By

Good morning dear blog reader. Today’s episode is fresh from a great weekend with...

Daily Coping 27 Sep 2022

By

Today’s coping tip is take your time. Make space to just breathe and be...

Running SQL Server in Windows Subsystem for Linux (WSL)

By

I previously wrote a post on how to convert a SQL Server Docker image...

Read the latest Blogs

Forums

Create a DACPAC to only update not replace a SQL Server Database

By Weegee71

Hi there We have been creating a DACPAC from a SQL server database project...

How to get record based on nearest date in SQL

By pelusch

Guys! For the three customers  in Table A I want to get the amount...

delete my own login

By snomadj

So I have my own individual windows login to SQL & access via a...

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