[Office] Transfer Capital Letters in Excel

This could be done through a few code steps. Please follow the instruction below:

Save your Excel File as “Excel Marco-Enabled Workbook (*.xlsm)

·         Add one column to help you to identify which filed has Capital character visibly

·         Type the formula in to the filed (Change your target field, in the case is A2), then apply to the whole column

IF it returns “FALSE”, it means you have UPPER case in the field

                =EXACT(A2,LOWER(A2))

[SCSM] Microsoft System Center SQL Server Permissions

After a two-week long time of studying the document and having a lots conversations with the vendor and System admin. I finally figured out the security scope for the SQL DBs on SCSM.

Document download link: http://www.microsoft.com/en-us/download/details.aspx?id=27850

Neither the vendor or the document would cover 100% correct settings on practical environment. At least not mine in my company.

I will list the summary below

[Permission] GRANTED "CREATE" still get "CREATE" WARNING through SSMS GUI

"You are not logged in as the database owner or as a user that is a member of the db_owner role"
Solution:
obviously, you need to grant the account as DB_OWNER. That's only for avoid the annoying GUI warning. Otherwise, "CREATE TABLE" is enough for Creating Tables. 

[BizTalk] BAM Tool - Cannot open database "BAMPrimaryImport"

Microsoft.BizTalk.Bam.Management.BamManagerException: The BAM deployment failed. ---> Microsoft.AnalysisServices.OperationException: OLE DB error: OLE DB or ODBC error: Cannot open database "BAMPrimaryImport" requested by the login. The login failed.; 42000.

Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'bam_rta_xxxJobXBamView', Name of 'bam_rta_xxxJobXBamView'.

Server: The current operation was cancelled because another operation in the transaction failed.