Script to find Disk Space including Mount points
works two different ways using sql for 2000 and 2005 and powershell for 2008.
2012-05-23 (first published: 2012-05-01)
5,798 reads
Scripts
Find a text string in any column in a database
Find a string in any "string" (char, varchar, nchar etc) column in the database.
2012-05-22 (first published: 2007-12-19)
5,683 reads
2012-05-22 (first published: 2012-05-01)
821 reads
Payment due date function
Calculates the nth due date for any given date, while accounting for weekends.
2012-05-16 (first published: 2007-10-11)
3,759 reads
Effectively mapping primary key – foreign key relations
This script maps the primary key - foreign key relations regardless if the column names are the same or not.
2012-05-15 (first published: 2007-11-07)
2,968 reads
sa_help_rev.erse.sa.login
A script to generate a recovery script for setting your sa account back to the password it is using at the time of running this script.
2012-05-14 (first published: 2012-04-09)
989 reads
sp_Find2
Searches database for up to 4 keywords. It will search through SPs, UDFs, Triggers, SSIS packages, jobs, table names, and column names.
2012-05-10 (first published: 2012-04-18)
2,188 reads
2012-05-09 (first published: 2012-04-19)
1,353 reads
Identify Bad Characters in a Table Column
An interesting recursive CTE to list out the non-alphanumeric characters in a column of a table.
2012-05-08 (first published: 2012-04-12)
3,014 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.
2012-05-08 (first published: 2011-09-13)
1,016 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers