Data Platform for Developers and DBAs
In this category you will find technical articles with tips and best practices on:
- SQL Server Optimization, configuration and maintenance
- Development and good programming practices with T-SQL
- Cloud Migrations and Data Platform Modernization
Do you need to know more about database management, optimization or improve your knowledge in T-SQL? You might be interested in our courses:
Updates on Data Platform for Developers & DBAs:
Not all virtual machines are the same
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.
GPDR and HASH anonymisation
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.
Network latencies over 1ms. Are they enough for a good SQL server performance?
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:
Latency, the worst enemy for any Hybrid Cloud environment
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.
Azure Files Premium + SQL Server Failover Cluster instance = simplified OnPremise to Cloud
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.
“On the fly” backup and restores without requiring intermediate storage
I’m sure that the most “senior” readers will remember the possibilities available in old SQL Server versions to do backups using named pipes. And by older versions, I mean “really old”, since this functionality was marked as obsolete in SQL Server 7 and, although it remained in SQL 2000, it was completely removed from SQL Server 2005 and later versions.
About us
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.
Training
Check available courses. We deliver private and public training.
Free resources
Get free access and downlads to our contents: ebooks, events, publications….
Upcoming events
Find events near you and save your seat! Learn directly from the experts.
Meet us
Check our story and values. Would you like to be part of our team?
Let´s talk!
Write to us and we will get back to you as soon as possible.