Case Cleanup Function
Capitalize the first letter of each new word in the string (clean, efficient, and easy to modify).
2008-08-14
340 reads
Scripts
ChangeDateTpFirstOfNextMonth
Nothing fancy; just allows you to change a date the the first of the following month. Friend needed this so I thought I would post it here for other newbies.
2008-08-14 (first published: 2008-06-20)
555 reads
2008-08-13 (first published: 2008-06-17)
1,098 reads
How to get list of Stored Procedure
You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.
2008-08-11
1,080 reads
2008-08-11 (first published: 2008-06-17)
891 reads
Find the port no Get Port SQL Server 2000
This Query is used to Find the port number or Get Port mumber SQL Server 2000 using T-SQL
2008-08-09
1,069 reads
2008-08-08 (first published: 2008-06-16)
938 reads
Remove SQL Logins from All Databases and SQL Server
Locate and remove/delete user logins from all databases and even SQL server.
2008-08-08
11,207 reads
Delete records in all related tables
Used to generate Select/Delete scripts. It does NOT run them.
You need to copy the output of this script to a new window and run it manually.
2008-08-06
591 reads
2008-08-06 (first published: 2008-06-16)
2,691 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers