EugeneChiang.com

Knowledge is Power. Never Stop Learning. Seek the Truth.

.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress

Azure Function fails with error message collection doesn’t exist

Azure Function fails with error message collection doesn’t exist Azure Function fails with error message “Either the source collection ‘collection-name’ (in database ‘database-name’) or the lease collection ‘collection2-name’ (in database ‘database2-name’) does not exist. Both collections must exist before the listener starts. To automatically create the lease collection, set ‘CreateLeaseCollectionIfNotExists’ to ‘true'” This means that... » read more

0
Read
echiang
Azure NoSQL CosmoDB Item Fields

Field Description Example /<OrderId> Primary KeyRequiredUser Provide 1001 id ID FieldAuto Generated or User Provide 6ad5da95-3a13-4eb0-a513-f8012b3b091j _rid Auto Generated HJ9mAKPzQnYHAAAAAAAAAA== _self Auto Generated dbs/HJ9mAA==/colls/HJ9mAKPzQnY=/docs/HJ9mAKPzQnYHAAAAAAAAAA==/ _etag Auto Generated \”b001a8e2-0000-0700-0000-610ac3870000\” _attachments Auto Generated attachments/ _ts Auto Generated 1628095367 Note: A partition key that distributes data evenly to each partition. Selecting the correct partition key is important in... » read more

0
Read
echiang
Azure Cosmos DB free tier

Azure Cosmos DB free tier makes it easy to get started, develop, test your applications, or even run small production workloads for free. When free tier is enabled on an account, you’ll get the first 1000 RU/s and 25 GB of storage in the account for free. The throughput and storage consumed beyond these limits... » read more

0
Read
echiang
No Global Profile Is Configured

Error: No global profile is configured. Specify a profile name in the @profile_name parameter Fix: 1.  Open database mail configuration by logging into SQL Server Management studio and expanding Management and right clicking on DatabaseMail, then choosing configure: 2.  Choose Manage Profile Security. 3.  Configure your profile to be the default profile: Sources:

0
Read
echiang
SSIS – File System Vs MSDB

I’ve tended to use filesystem which has the advantages of:- 1) Not bloating MSDB if you have thousands of packages. 2) Ease of deployment of packages – DTSX files can simply be copied into the filesystem using Windows Explorer. 3) Multi-user security – using NTFS permissions within the filesystem it’s possible to grant rights to... » read more

0
Read
echiang
Introduction to the SSIS Catalog database (SSISDB)

The SSIS Catalog database was introduced in SQL Server 2012 and prior to that users had the following three options to deploy their SSIS packages: Users could deploy the packages to a directory on the file system Users could deploy the packages to the package store which ultimately stores the packages on the file system... » read more

0
Read
echiang