Reverse-Engineer Database Permissions (2005 up)
This script reverse engineers SQL statements to recreate database permissions.
2011-10-24 (first published: 2011-10-07)
16,298 reads
Scripts
Search for a String in all Stored Procedures and beyond?
Search for String Occurence with this script in your stored procedures.
2011-10-20 (first published: 2008-06-08)
5,412 reads
UP_COMPACTA_COPIA
I have several problems with my corporate network and therefore need to do all my backups locally, and to make matters worse, still use SQL Server 2005.
2011-10-17 (first published: 2011-09-30)
441 reads
2011-10-14 (first published: 2011-08-24)
530 reads
Detailed Table Data
Gets Detail table information such as partition information, compression, and partition range.
2011-10-13 (first published: 2011-09-30)
1,242 reads
2011-10-12 (first published: 2011-08-31)
954 reads
Next grow for all databases per disk
This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database.
2011-10-11 (first published: 2011-09-13)
1,029 reads
2011-10-10 (first published: 2011-08-24)
837 reads
Get Modified Objects As on Date
This table Valued Function return the Modified Objects (SP /Views) For the Date specified.
2011-10-07 (first published: 2007-11-23)
1,398 reads
2011-10-06 (first published: 2007-11-14)
1,944 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers