Author
User cant change password: Configuration information could not be read from the domain controller
Error: User cant change password: Configuration information could not be read from the domain controller, either because the machine is unavailable, or because access is denied. Resolution: Make you are you are connected to VPN before changing your password.
Create Linked Server
Creating a linked server called “RPT” that connect into SERVER01… Note: When generating the linked server from a script from an existing database server, the rmtpassword parameter will not be set. After the linked server has been created, go to properties of the linked server and set the security context.
Azure Function From Queue to Blob or CosmosDB
From Azure Queue to Azure Storage Blob Container From Azure Queue to Azure NoSQL CosmosDB Container Sources: https://docs.microsoft.com/en-us/azure/azure-functions/functions-add-output-binding-cosmos-db-vs-code?pivots=programming-language-csharp
The filegroup xxxx has no files assigned to it.
Error: The filegroup "xxxx" has no files assigned to it. Tables, indexes, text columns, ntext columns, and image columns cannot be populated on this filegroup until a file is added. Fix: Sources: https://forums.asp.net/t/1397838.aspx?The+filegroup+comn_data+has+no+files+assigned+to+it+sql
Database Backup Compression
This topic describes the compression of SQL Server backups, including restrictions, performance trade-off of compressing backups, the configuration of backup compression, and the compression ratio. Backup compression is supported on SQL Server editions: Enterprise, Standard, and Developer. Every edition of SQL Server 2008 and later can restore a compressed backup. Benefits Because a compressed backup... » read more
CosmosDB Trigger Azure Function
Get specified field value… Note: Make sure you installed the Microsoft.Azure.WebJobs.Extensions.CosmosDB package. Created a CosmosDB connection string (Get string value from Azure Portal). Created a container called “leases” or set CreateLeaseCollectionIfNotExists =true.
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
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
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