2018-04-18 (first published: 2018-04-12)
583 reads
Rename Foreign Key Constraints
Rename Foreign Key Constraints in a consistent manner. Ideal for preventing constraint errors during code promotion.
2015-02-09 (first published: 2013-03-19)
1,311 reads
Generate Create View statements for database tables.
Create views based on table definitions for backwards compatibility when relocating tables to a new database.
2013-08-16 (first published: 2013-07-30)
1,090 reads
Quick view of User database and server roles
Outputs an easily readable result of the database and server roles for database principals.
2013-07-18 (first published: 2013-06-14)
1,042 reads
Search for String in all columns
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
1,794 reads
Blogs
Reviewing 2019 Career Goals
By Steve Jones
According to this post, I rate 2019 as a Failure. Of the books I...
ASF 029: Tomaz Kastrun interview
By Kamil
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...
Schema Filtering in SQL Prompt
By Steve Jones
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...
Forums
Can we use DC SQL Cluster Role name in DR Site (Same name Both Site)
Hi I have SQL Server FCI running in my DC site following are cluster...
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE
Hello experts, A client is reporting the following error when his application tries to...
Connectivity to Oracle 12.2 instance via OLE DB ?
I installed Oracle 12 on Windows 10 in all possible ways/configurations, including the defaults....
Ask SSC