Author

Database Cluster

Microsoft Windows Failover Clustering is a high-availability option designed to increase the uptime of SQL Server instances. A cluster includes two or more physical servers, called nodes; identical configuration is recommended. One is identified as the active node, on which a SQL Server instance is running the production workload, and the other is a passive... » read more

ISBN vs ISBN 13

“ISBN” stands for “International Standard Book Number”. An ISBN is a number, not a bar code. One agency per country is designated to assign ISBNs for the publishers and self-publishers located in that country. The U.S. ISBN Agency cannot assign ISBNs to publishers and self-publishers located outside the United States and its territories. The ISBN... » read more

Git Error: RPC failed; errno 10054

Error: PUSH to GitBucket from Sourcetree RPC failed; curl 56 OpenSSL SSL_read: SSL_ERROR_SYSCALL, errno 10054 Resolution: git config http.postBuffer 524288000 It might be because of the large size of repository and default buffer size of git so by doing above(on git bash), git buffer size will get increase. Sources: https://stackoverflow.com/questions/46232906/git-clone-error-rpc-failed-curl-56-openssl-ssl-read-ssl-error-syscall-errno

Azure Storage SDK

Visual Studio Nuget Manager PM>Install-Package WindowsAzure.Storage Samples: https://azure.microsoft.com/en-us/resources/samples/storage-blobs-dotnet-webapp/

Azure Storage Pricing

https://azure.microsoft.com/en-us/pricing/details/storage/ Blob storage is much less than file storage. Block Blobs Scalable object storage for documents, videos, pictures, and unstructured text or binary data. Choose from Hot, Cool, or Archive tiers. Prices for locally redundant storage (LRS) Archive Block Blob start from:$0.001/GB per month See Pricing Azure Data Lake Storage Combines the power of a... » read more

BitBucket

Source control from Atlassian. https://bitbucket.org/ Sources: https://bitbucket.org/product/pricing

TSQL String Split

Examples A. Split comma-separated value string Parse a comma-separated list of values and return all non-empty tokens. STRING_SPLIT will return empty string if there is nothing between separator. Condition RTRIM(value) <> ” will remove empty tokens. B. Split comma-separated value string in a column Product table has a column with comma-separate list of tags shown... » read more