Function for String Occurences Count
This function is used to get the particular string occurences count from the given input string.
2015-01-16 (first published: 2014-12-16)
1,133 reads
Scripts
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,035 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,023 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)
656 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)
694 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)
553 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,304 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)
725 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,539 reads
2014-12-25 (first published: 2014-12-04)
1,122 reads
Blogs
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers