2018-04-18 (first published: 2018-04-12)
523 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,309 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,089 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,039 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,757 reads
Blogs
Weekly reading #19
By damianwidera
Good afternoon folks! It is Monday Tuesday already after a long weekend in Poland....
The Constant and Constantly Changing Role of the DBA
I’ve been working in and around data for over 30 years now. My title...
Power BI Monthly Digest – June 2019
By Devin-Knight
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...
Forums
unable to install SQL Server 2014
Hi, I am trying the install SQL Server 2014 enterprise edition on Windows 2016...
What's the CMK?
Comments posted to this topic are about the item What's the CMK?
Spread the Word about Basic Security
Comments posted to this topic are about the item Spread the Word about Basic...
Ask SSC