Blocking a user on SQL Server based on a schedule

Sat 14 November 2020

Ok, some time ago, I've posted about how you can set limits to connections on SQL Server using the Resource Governor. But what if you can't use it? You always can block logins using a login trigger, but I don't like the idea of having selects running on every login …

Removing a user from SQL Server database who owns a schema

Fri 06 September 2019

Your customer urge you to drop a user from the MsSQL Server database, but you stuck with the following related error:

Error: 15138 The database principal owns a schema in the database, and cannot be dropped.

That means that the user owns one or more shcemas of your database. If …

Limiting Connection Resources on SQL Server

Mon 12 August 2019

Have you ever suffered from a slow SQLServer database? Someone love to run that heavy query in the database? Resource Governor to the rescue. You can set a few rules on how users (connections actually) will use the server/database resources based on a few things.

First things first, if …