Overblog Suivre ce blog
Administration Créer mon blog

Top articles

  • The dynamic filtered indexes

    20 février 2017 ( #Architecture )

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

  • Blog creation

    05 avril 2010 ( #General )

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

  • Transactional Replication

    06 avril 2010 ( #Architecture )

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

  • SQL server table Page density: the ennemy of the DBA!

    07 avril 2010 ( #Architecture )

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

  • Database High Availability vs High Performance

    10 avril 2010 ( #Architecture )

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

  • SQL server 2008 R2 - what is new?

    10 avril 2010 ( #Architecture )

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

  • The importance of security and securing your data tier

    14 avril 2010 ( #Administration )

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

  • Setting database mirroring and minimizing downtime

    14 avril 2010 ( #Architecture )

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

  • What HA strategy for your SQL server?

    25 août 2010 ( #Architecture )

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

  • Best practice Data management in a transactional environment, data versus database management

    02 octobre 2012 ( #Architecture )

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

  • Data density: method of scoring your database

    07 octobre 2012 ( #Architecture )

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

  • Data partitioning on Sql Server Express, Standard and Enterprise edition - Part 1

    09 octobre 2012 ( #Administration )

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

  • Data partitioning on Sql Server Express, Standard and Enterprise edition - Part 2

    09 octobre 2012 ( #Administration )

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

  • SQL server: musings about distributed environments, distributed transactions, and project development cycle

    21 novembre 2012 ( #Architecture )

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

  • Musings on optimizing your OLAP processing in SSAS: measures and partitions

    30 décembre 2012 ( #Administration )

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

  • SQL server tuning: DML for multiple rows in one shot

    15 janvier 2013 ( #Architecture )

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

  • Telecommuting! the key for social progress!

    15 janvier 2013 ( #General )

    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 I believe hiring telecommuters is eventually...