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:

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:

read more

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.

read more

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.

read more

“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.

read more

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.