2018-04-19 (first published: 2018-04-12)
1,753 reads
Rename Foreign Key Constraints
Rename Foreign Key Constraints in a consistent manner. Ideal for preventing constraint errors during code promotion.
2018-04-13 (first published: 2013-03-19)
1,323 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,098 reads
Quick view of User database and server roles
Outputs an easily readable result of the database and server roles for database principals.
2013-08-05 (first published: 2013-06-14)
1,049 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,856 reads
Blogs
Working with Neo4j Imports–I HATE CASE SENSITIVITY
By Steve Jones
I’ve been working to better understand graph databases and where they can be useful....
Daily Coping 8 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure DevOps: Deploying Power BI reports with a parameterized gateway-based Data Source
By Rayis Imayev
(2022-Aug-08) You have developed your Power BI report, by connecting one or more sourcing datasets,...
Forums
SCOM alert : Other processes use too much memory
Hi , We have several SQL instances (200 servers). Some of them have SSRS...
Identifying Driver it is using
Hi, We have SQL server installed on one server & SSAS stand-alone installation on...
Any BIxPress users out there?
We use a third party logging framework from what is now SolarWinds (originally PragmaticWorks)....
Ask SSC