2024-02-05
375 reads
2024-02-05
375 reads
2022-08-15
351 reads
2021-11-08
438 reads
2021-05-26 (first published: 2021-04-30)
7,921 reads
2018-02-01
863 reads
Learn how to find who has changed permissions from the default trace
2015-10-13
9,759 reads
This script allows the DBA to quickly determine if a deny statement is stopping a user from accessing db objects.
2015-01-14 (first published: 2014-12-17)
5,890 reads
Easily grant exec permission to all stored procedures to a database role in SQL 2005 or higher.
2014-03-20
22,781 reads
Someone, while locking down the SQL Server, removed the permissions by which the DBAs came in and administered the server. As a result, we cannot get back into SQL Server. How can we restore our access to SQL Server? Check out this tip to find out.
2012-03-29
4,423 reads
This script reverse engineers SQL statements to recreate database permissions.
2011-10-24 (first published: 2011-10-07)
14,607 reads
Have you ever wanted to filter a visual by selecting a range of values...
By Steve Jones
I wrote a post recently about pruning branches in git. That’s part of the...
By James Serra
I talked about Microsoft Fabric shortcuts in my blog post Microsoft Fabric – the...
Is there a specific platform or website where I can verify the compatibility between...
Comments posted to this topic are about the item Truncate tables where Referential Integrity...
Hi all, We have a SSIS package that does 2 things in parallel: moves...
I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?
See possible answers