What usually happens is that when we move SQL Server to a virtual machine, we become constrained by a maximum or limited amount of resources (CPU/ memory/ IO) that is significantly different to that of the physical machine.
Before uploading all our data to the cloud, we must be well aware of GDPR (General Data Protection Regulation), a European regulation aiming to protect individuals in regards to how their personal details are processed and the free movement of data.
Gradually, as storage gets faster and local SSD storage becomes more popular, etc. disk access times are significantly decreasing. In these regards, perhaps the best example are the SSDs Optane systems, notable for their much lower read/ write latencies than with traditional SSD’s, in addition to being directly connected through the PCIe bus:
In the last few years, we are increasingly finding more hybrid environments where some SQL Servers are being migrated to the Cloud. In these cases, other applications, services, ERPs or even SQL Server instances continue to be based OnPremise in the initial data center. This means that in the event of any connections between both environments, these will be restricted by bandwidth and higher latencies, as opposed to other connections that do not go across both environments.
One of the issues that many of our customers face when attempting to migrate OnPremise instances to the Cloud is the lack of a simple “shared storage”. Although there are some alternatives supported by third-party software or SDS solutions that allow us to configure a Failover Cluster instance in Azure, these are highly complex, therefore adding significant further costs to the solution’s TCO.
Grow your business:
SolidQ has developed a powerful tool through Power BI itself that gives abundant information on the use of the organization´s Dashboards and Reports. Power BI Usage Analytics allows us to know, for example, whether a Dashboard is being used or not, if it is used a lot or a little, who uses them and at what times, what Workspace is used more, as well as compare uses of Reports / Dashboards between several dates, etc
I know, I know, I might be a little too optimistic after watching Spain winning the Football World Championship last night. However, I'd like to point out the importance of team work over sparking individual performers. I don't know much about football, not even about...
We want to be part of your business project by building and implementing a Data Driven Strategy. We can share your digitalization path while providing innovative solutions based on our proven frameworks and expertise. We are global providers of technical consulting, mentoring and training services for Microsoft Data Management platforms. We focus on Data Management, Business Analytics, and AI.