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)
7,106 reads
Scripts
Verify Login SID and Machine SID
This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.
2015-01-12 (first published: 2014-12-24)
1,666 reads
Calculate Temperature - Most Advanced UOC
This function is used to calculate the actual unit of conversion for temperature.
2015-01-09 (first published: 2014-12-11)
1,035 reads
Find no of records in each table in database (against Clustered Index)
If you want to find TotalPages, Usedpages,datapages,totalspaceMB,UsedSpaceMB,DataSpaceMB then can use this query.
2015-01-08 (first published: 2014-12-26)
1,531 reads
Calculate Angle - Most Advanced UOC
This function is used to calculate the actual unit of conversion for angle.
2015-01-06 (first published: 2014-12-10)
662 reads
Calculate Area - Most Advanced UOC
This function is used to calculate the actual unit of conversion for area.
2015-01-02 (first published: 2014-12-10)
700 reads
Calculate Mass/Weight - Most Advanced UOC
This function is used to calculate the actual unit of conversion for mass.
2015-01-01 (first published: 2014-12-10)
562 reads
Dynamic Script to Generate Backup Script
Use this script to generate BACKUP DATABASE scripts for selective or all databases during Instance or Database migration.
2014-12-31 (first published: 2014-12-10)
1,315 reads
Calculate Energy - Most Advanced UOC
This function is used to calculate the actual unit of conversion for energy.
2014-12-30 (first published: 2014-12-11)
733 reads
All OS version info in one function
Always wanted to know the OS details? This function tells you everything (MSSQL 2008R2 and newer version only)
2014-12-29 (first published: 2014-12-06)
1,580 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers