2014-09-29 (first published: 2010-02-04)
9,142 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,674 reads
Changing Foreign key names to standard naming convention across the DB
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
2010-02-24 (first published: 2010-02-09)
1,145 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)
338 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
455 reads
Blogs
Power BI – Hungry Median
Introduction Median is a useful statistical function, which first time appeared in SSAS 2016...
Top 10 Must-Ask Questions Before Going to the Cloud
By kleegeek
After architecting and migrating some of the world’s largest data platforms, Let’s walk through my top...
Markdown Links– Remembering the Basics
By Steve Jones
For some reason, I can never remember how to do markdown links. I know...
Forums
Sql Server Specs Question
Hi, I have two different servers that I do a bulk insert on the...
error while running Replication
Has anyone faced this error Agent message code 20037. The process could not bulk...
Run Azure Automation Runbook Against DB Hosted on an Azure VM
Hi - has anyone created a PowerShell runbook which connects to a database hosted...
Ask SSC