Organizations often need to debug production errors, which many times in the past has been done directly pointing development applications to the production database. This, which is in itself a malpractice, is one of the measures that comes to regulate the GPDR with force and is precisely one of the things we should never do.
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.
Grow your business:
Do we need to hear more news of the fines, sentenced to those who do not apply GDPR regulations, in the media to take the necessary measures?
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.