LE BLOG DE CLEMENT
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...
Hello Guys, It is usually pretty straightforward to read an execution plan, to understand why one query would use an index instead of another one, to understand the needs of a nested loop or a hash join, etc... It is usually.... But then comes .... the...
Hello All folks interested in the data-tier! Given the importance of networking and internet, I decided to create this blog to interact with my fellow DBA friends and friends-to-be. I am an independant Senior Sql server consultant who advises all-sized...
Hey, This is my first article. My friends over facebook commented on my blog and asked for a first article. The challenge is there: try to wrtie an article frequently (I wish daily but this is too presemptuous: plus, I am going to have a baby and I am...
Hello Guys, You might wonder what is new and whether this is that fantastic? Well as usual, I cannot say that Microsoft changed the world on this one either but as good followers, they release some of the new good obvious features they should address...
Hello Guys, How are you doing? The topic of today is how to setup mirroring by minimizing downtime. Well it is not that difficult but it requires some tips to achieve this. First, we need to make sure we have all the prerequisites set up. 0. secondary...
1. 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...
There 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...
Hello 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...
On 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...
Before 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...
Hello 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...
Hello Guys, 10 years ago, people did not care too much about getting the database fast or available. Databases were small and ECommerce or online payment or any kind of social community did not exists. Performance and availability were somewhat important...
Data 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...
During 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...
Hello Guys, I cannot tell you how many clients have extremely bad security layer at the data-tier, thinking they will be off the hook because their security at the application tier is well defined. This is nice to have ssl/https protocol layers and some...
hello 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...