all about database architecture and how to handle large volume sets
/image%2F1479277%2F20170220%2Fob_596d48_capture1.JPG)
I have struggled with one client on queries that were dealing with date ranges or type ranges or many filters, on very large tables with low density in many cases, and you knew one index would really improves it but it was based on some filter that was...
Lire la suiteHello Guys again, Although my blog main concern is about SQL server, I like to share my experience in the telecommuting field, misconceptions and reality. 1. Telecommuters works more efficiently than Onsite people: TRUE I believe hiring telecommuters...
Lire la suitehello guys, Today's topic relate to a series of trainings I spent doing at one of the top 10 ECommerce in Europe as a database/etl architect for 2 years time. The idea of those series were to train junior to senior level developpers on how to optimize...
Lire la suiteThere are many ways to set up your cube but there are definite best practices to implement if you want to scale your cube. The first point will just remind us that a cube is an analytical tool and should not be used as a source of detailed report. Drillthrough...
Lire la suite1. Understanding the concept One of the main challenges to a distributed system is how to handle transactions across several servers and technologies. What if your application connect for the same transactions to several web services or database servers...
Lire la suiteOn Sql Server Standard On Sql server Standard edition, this is actually easier in a way. You do not manage partition scheme or function or at least not in the way the enterprise version does. You actually set up tables to be your partitions. If you want...
Lire la suiteBefore going into details in how to setup data partitioning on SQL server, it is important to understand data partitioning concept. So first, I will give a simple definition of what it is. Understanding the concept Data partitioning is a way to spread...
Lire la suiteData density: method of scoring your database A database is a container for data. The aim for a database is mainly storing in a way that we can read and write data in an efficient way. An efficient way in terms of securing your data, read your data in...
Lire la suiteDuring the past ten years, websites have witnessed different stages on their needs of database tools. In the beginning, websites stored nothing at all on database because they were primarily giving simple services based on application algorithms or they...
Lire la suiteHello guys, Today we will discuss the different high availability (HA) strategy you have on SQL server. Basically, it all depends on your needs, your SLA towards your clients and the level of satisfactory you would like to have to your client. Also, it...
Lire la suite