2024-02-05
382 reads
2024-02-05
382 reads
2022-08-15
352 reads
2021-11-08
441 reads
2021-05-26 (first published: 2021-04-30)
8,372 reads
2018-02-01
865 reads
Learn how to find who has changed permissions from the default trace
2015-10-13
10,454 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)
6,319 reads
Easily grant exec permission to all stored procedures to a database role in SQL 2005 or higher.
2014-03-20
23,495 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)
15,359 reads
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I'm using the below connection string using providing UserID and password on their respective...
Comments posted to this topic are about the item Knowing Your Total Reward