2012-10-04 (first published: 2012-04-10)
2,020 reads
Scripts
Find Primary Column of all tables in database
This code helps in finding Primary Keys for all tables in a database.
2012-10-02 (first published: 2012-09-04)
1,433 reads
2012-10-01 (first published: 2012-09-05)
2,589 reads
SQL Server Uptime
This script is used to get uptime for the SQL Server. (Supports SQL2005 and onwards only)
2012-09-28 (first published: 2012-09-07)
1,441 reads
Find all actual words from Dictionary Table using jumbled word
How to get all actual word from a table,if I pass a jumbled word
2012-09-27 (first published: 2012-09-05)
830 reads
SQL Start up Script
This is a script that I run when SQL starts to notify me via email that a server has restarted as well as the location of the server.
2012-09-25 (first published: 2012-08-29)
1,878 reads
Run SQL Hosted VBS Script from SQL
This routine allows you to run VBScript directly from SQL (i.e. without having to create a file in advance) by pushing the script to a temp file.
2012-09-20 (first published: 2012-08-21)
991 reads
Show all Objects used by Linked Server
Stored Procedure will list all objects, object type, and linked server name. The stored procedure can either be passed in a linked server name as string or null.
2012-09-17 (first published: 2012-08-23)
1,047 reads
ASCII Character Groups in String
Powerful function to find strings containing or excluding classes of ASCII characters.
2012-09-10 (first published: 2012-08-28)
1,050 reads
2012-09-07 (first published: 2007-11-15)
3,486 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers