2014-09-29 (first published: 2010-02-04)
9,474 reads
Vidyadhar Pandekar
- Interests: Databases
Changing Primary key names to standard naming convention across the DB
This script will rename the Primary keys to standard notation - PK_TableName
2011-07-29 (first published: 2010-02-09)
1,693 reads
Changing Foreign key names to standard naming convention across the DB
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
2011-07-06 (first published: 2010-02-09)
1,174 reads
Seach any DB object across database server.
This procedure will help you to find particular database object in all databases across database server. Like search gives you all objects from all databases whos name includes seach word critera.
2006-05-01 (first published: 2006-03-06)
365 reads
Proper Case the data in the Table
Persons Names,Addresses or any other master information if not entered with proper case . I mean if some records are with All caps ,some with all small or any other combination.You may be able to convert this data to proper case. Which will help you to show it in better looks on websites or in […]
2003-11-19
505 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
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...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
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...
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