String Character Count
A while ago I once attended an interview where I was asked to write a short script that counts each letter of a given string.
2013-04-25 (first published: 2013-04-12)
1,697 reads
Scripts
fnArabToEnglish(from Arabian number to english)
This function can convert a Arabian number to english,for example,if you input 1234.56, then you'll get 'One thousand two hundred thirty four and cents fifty six'.
2013-04-22 (first published: 2002-08-08)
540 reads
2013-04-18 (first published: 2013-04-05)
1,471 reads
2013-04-17 (first published: 2013-04-03)
1,479 reads
Restore Latest Backup with Powershell
Restores the latest backup of a database to a destination server of your choice, and creates a new backup if needed.
2013-04-16 (first published: 2013-03-30)
1,773 reads
Search for an object across multiple databases on a server.
There are other options available like Sql search from Red Gate. Here's a simple script to search for objects(s) containing a particular keyword.
2013-04-15 (first published: 2012-08-23)
2,868 reads
Retrieve SQL Instance Connect Info
This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port
2013-04-11 (first published: 2013-03-24)
1,477 reads
2013-04-05 (first published: 2009-03-27)
4,605 reads
2013-04-03 (first published: 2013-03-08)
1,712 reads
2013-04-02 (first published: 2008-09-11)
15,401 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers