kodummu

Category: Azure

  • Cost cutting strategies for Azure…

    in ,

    Cost cutting strategies for Azure Cosmos DB – Hasan Savran – NDC Porto 2022

  • Azure Static Web Apps

    in

    Long-waited service from Azure is now in preview phase. I never understood why Azure did not have this product. Publishing a static page to blob storage is a nightmare, it is stupid. Anyway, finally, the service is here and can be used. Here are the steps to publish a static app to azure. Create the…

  • Azure – Application Settings and Connection Strings

    in

    Resources for storing connection string and application string in azure apps. https://azure.microsoft.com/es-es/blog/windows-azure-web-sites-how-application-strings-and-connection-strings-work/ https://mderriey.com/2018/08/21/azure-app-service-connection-strings-and-asp-net-core/ https://docs.microsoft.com/en-ca/azure/app-service/configure-common#connection-strings https://docs.microsoft.com/en-ca/azure/app-service/app-service-key-vault-references #azure #azure-database

  • Azure SQL Database (MSSQL) -…

    in ,

    Azure SQL Database (MSSQL) – Working with JSON Data SELECT Modify Convert JSON collections to a rowset Resources & more: https://cloudblogs.microsoft.com/sqlserver/2016/01/05/json-in-sql-server-2016-part-1-of-4/ https://channel9.msdn.com/Shows/Data-Exposed/SQL-Server-2016-and-JSON-Support https://azure.microsoft.com/es-es/blog/json-support-is-generally-available-in-azure-sql-database/ https://docs.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/relational-databases/json/store-json-documents-in-sql-tables?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/relational-databases/json/index-json-data?view=sql-server-ver15 MySQL from version 5.7 has JSON support: https://www.sitepoint.com/use-json-data-fields-mysql-databases/ #azure #azure-database #json #mssql-json

  • Whenever you publish a webjob,…

    in

    Whenever you publish a webjob, it is located under the App_Data/jobs/ {triggered or scheduled} of your App Service … Hence, you can publish the webjobs via FTP or directly from vstudio. If you do so, settings.jobs file need to be created manually. #azure #webjobs

  • Azure WebJobs

    in

    What is an Azure WebJob?  With WebJobs, you can simply run a program or script just like a running a web app. Azure Functions is also a similar service. You can create a console app and run it continuously or triggered. Let’s try a simple one. Create the console app: dotnet new console Write your code.…

  • Why Brackets in SQL queries with SQL Server

    in , , ,

    It’s been long time since I worked with SQL Server last time. I have been working with Oracle and there are differences for sure. This one is simple. The brackets are required if you use keywords or special chars in the column names or identifiers. You could name a column [First Name] (with a space)–but…