Tuesday, 12 April 2016

Using Checksums to test for Unexpected Database Schema Changes

USE [DATABASE-NAME]
GO

SELECT CHECKSUM_AGG (CHECKSUM (
                TABLE_NAME,
                COLUMN_NAME,
                CHARACTER_MAXIMUM_LENGTH ))
FROM INFORMATION_SCHEMA.COLUMNS


No comments:

Analysis Service in Power BI Report Server

 We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly... link