Find Deny permissions on database objects
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)
1,279 reads
Captain DBA
Blogs
Restoring Backups from Azure Blob with dbatools
Recently I needed to write a PowerShell script that could build a backup set...
Good to see you at Houston Tech Fest 2019!
By Will Assaf
It was awesome to see a great crowd at the triumphant return of Houston...
Using kubectl logs to read the SQL Server Error Log in Kubernetes
When working with SQL Server running containers the Error Log is written to standard...
Forums
SQL Server Restore precheck gets free space wrong
I'm trying to move a large database (22 TB) from a stand alone server...
2nd Server min requirements for transaction log shipping & reducing license cost
I will have a 64-bit 2008 R2 SQL Server Standard edition acting as the...
how to hide the passsword in the log file when the package fails.
I have an encryption and decryption package and the keyId public and private from...
Ask SSC