Comparison: Sql Server in Azure VM and Azure Sql Database

Azure SQL Database is native to the Azure and offered as Platform as a service (PaaS). The objective of this offering is to reduce the overall costs to the minimum for provisioning and managing many databases. This offering comes with built-in high availability, disaster recovery, and upgrades for the database. Databases run on latest version of SQL Server Enterprise Edition. Many... Continue Reading →

Azure Website Deployment mechanisms

A website or code to Azure App Service is deployed normally via following methods: FTP: This is manual steps to deploy a website wherein all deliverable files are copied to destination path on the web server via FTP client tools like FileZila. This is a basic way of deployment where you have to know how to... Continue Reading →

Different Hosting Models in Azure

Orange boxes here showing what you have to manage. Yellow boxes here showing what cloud vendors manage. On-premises: customer has to provision servers, storage, monitoring, installation and maintenance of services and applications. Infrastructure as Service (IaaS): the customer can manage some of it, like the actual Hyper-V, the virtualization engine that your virtual machines are running on; the storage,... Continue Reading →

Suspend or resume windows controls to be redraw

Recently, I was facing issue with third party Image Viewer to apply multiple operations before redrawing of images. Third-party control was not allowing to suspend and resume painting of images inherently. After searching for various solutions, I found a solution that can be achieved using windows message "WM_SETREDRAW" from an application to Windows to allow... Continue Reading →

Change Tracking example -Sql Server

If there is a requirement to get incremental or changed data from database frequently without putting a heavy load on database objects, then Change Tracking mechanism of Sql Server can be out of the box solution for this requirement. Normally, developers have to do custom implementation to achieve change tracking behavior. It can be implementation... Continue Reading →

Importance of Use Case Document

“JSON, XML, .Net, C++, Java, Middleware”. These are some of the technical jargon which many IT professionals use while having a discussion with business users to implement business requirements. Business users might not be interested into how the system will be developed technically. Mostly, they are interested in if the proposed or existing systems are... Continue Reading →

Powered by WordPress.com.

Up ↑