Azure Functions time zone issue

Fix: Select Configuration option in your Function App Add new “application settings” Fill the fields with the following value… Name: WEBSITE_TIME_ZONEValue: Pacific Standard Time Sources: https://www.serverlessnotes.com/docs/azure-functions-time-zone-issue

VS Code (Visual Studio Code)

https://code.visualstudio.com/ Visual Studio Code is a lightweight but powerful source code editor which runs on your desktop and is available for Windows, macOS and Linux. It comes with built-in support for JavaScript, TypeScript and Node.js and has a rich ecosystem of extensions for other languages and runtimes (such as C++, C#, Java, Python, PHP, Go,... » read more

Azure Cosmos DB Tools

https://developer.azurecosmosdb.com/tools – List of tools Note: You can not access Cosmos DB from Azure Storage Explorer (ASE) any more. That feature has been depreciated. Microsoft Azure Portal CosmosDB Explorer https://cosmos.azure.com/ Azure Databases extension for VS Code Need to download extension for VS Code. Access container and item from Visual Studio Code. Azure Data Factory Copy... » read more

In-Place Upgrade from SQL Server 2016 to 2019

Upgrade from SQL Server 2016 (13) to SQL Server 2019 (15) How to Upgrade SQL 2016 to SQL 2019 Mount the SQL 2019 ISO or media on your current SQL 2016 server. Select “Upgrade from a previous version of SQL Server” Note Make sure the current Windows versions can support the new SQL Server 2019.

TortoiseGit

TortoiseGit for 64-bit Windows.  https://tortoisegit.org/download/ Pre-reqs Install FAQ and Pre-reqs are here: https://tortoisegit.org/support/faq/#prerequisites git for Windows https://gitforwindows.org/ TortoiseGit vs TortoiseSVN TortoiseGit vs TortoiseSVN: What are the differences? Developers describe TortoiseGit as “The Power of Git in a Windows Shell“. It is a Git revision control client, implemented as a Windows shell extension and based on TortoiseSVN. It is free... » read more

DevOps dev.azure.com vs visualstudio.com

Switch existing organizations to use the new domain name URL Although we’ve moved to the new dev.azure.com domain name as the URL for new organizations, you’ll be able to continue accessing your organization using the visualstudio.com domain, as usual. If you’d like to change your URL to be based on dev.azure.com, an organization administrator (Project Collection Administrator) can change this... » read more

git push

The git push command is used to upload local repository content to a remote repository. Pushing is how you transfer commits from your local repository to a remote repo.  git push updates the remote branch with local commits. It is one of the four commands in Git that prompts interaction with the remote repository. You can also... » read more

git fetch vs git pull

Git Fetch is the command that tells the local repository that there are changes available in the remote repository without bringing the changes into the local repository. Git Pull on the other hand brings the copy of the remote directory changes into the local repository. git fetch is the command that tells your local git to retrieve... » read more

MAXDOP Settings to Limit Query to Run on Specific CPU

Query Hint MAXDOP – Maximum Degree Of Parallelism can be set to restrict query to run on a certain CPU. Please note that this query cannot restrict or dictate which CPU to be used, but for sure, it restricts the usage of number of CPUs in a single batch. Sources: