Copy Latest Backups from Backup Path
This script is useful to copying latest backup files from job Backup path during Instance/Database Migration
2015-01-21 (first published: 2014-12-15)
986 reads
Scripts
Calculate Time - Most Advanced UOC
This function is used to calculate the actual unit of conversion for time.
2015-01-19 (first published: 2014-12-15)
1,031 reads
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,134 reads
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,065 reads
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,646 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,027 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,519 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)
659 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)
697 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)
557 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers