Confluence: Use labels to organize pages and attachments
Documentation: https://support.atlassian.com/confluence-cloud/docs/use-labels-to-organize-your-content/ List all Labels:
Author
Application Environment
Environment Note Development Used for development. QA Used by QA for testing and verification.Should be on its own network other than development. Staging Used for acceptance testing.Should be in the same network as Production. Production Used for production.
SQL WITH Common Table Expression Statement
Sources: https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver15
Bulk Insert from File
Insert the content of files into a database table.
Azure Cosmos DB
Azure Cosmos DB is Microsoft’s proprietary globally-distributed, multi-model database service “for managing data at planet-scale” launched in May 2017. It is schema-agnostic, horizontally scalable, and generally classified as a NoSQL database. Azure Cosmos DB is a fully managed NoSQL database service for modern app development. Get guaranteed single-digit millisecond response times and 99.999-percent availability, backed... » read more
SQL vs NoSQL
What is NoSQL? NoSQL is a non-relational DMS, that does not require a fixed schema, avoids joins, and is easy to scale. NoSQL database is used for distributed data stores with humongous data storage needs. NoSQL is used for Big data and real-time web apps. For example companies like Twitter, Facebook, Google that collect terabytes of... » read more
Enable Anonymous Access for Confluence Site
https://support.atlassian.com/confluence-cloud/docs/set-up-public-access/ To enable anonymous access: Select (Settings) in the Confluence navigation Choose Global Permissions in the left-hand panel Click Edit Permissions In the Anonymous Access section, check the box under Use Confluence Click Save all To allow anonymous users to see user profiles, check the checkbox in the View User Profiles section. You need to grant the Use Confluence permission to grant the View User... » read more
Set Azure Function Time Zone for Timer Trigger
Azure Function based on Web app sandbox. Web app need you to set the timezone in env settings first. The timetrigger attribute is the declaration part of the function. The environment variables will be checked here. If you do not set the environment variables about the time zone in advance, it will be processed according... » read more
Copy Database Login User Account After Database Restore
Note: Run the following on the source server and run the output on the destination server. Run after database has been restored. Apply to restored databases from PROD backup. Apply to AlwaysOn databases.
C# Get Time By Time Zone
Note: Different OS will have different Time Zone Id. On Windows systems, FindSystemTimeZoneById tries to match id to the subkey names of the HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Time Zones branch of the registry. On Linux and macOS, it uses time zone information available in the ICU Library Windows OS Pacific Standard Time Non Windows OS America/Los_Angeles Time Zone List https://en.wikipedia.org/wiki/List_of_tz_database_time_zones Code UTC... » read more