all about database architecture and how to handle large volume sets
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...
Lire la suiteHello 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...
Lire la suiteHello 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...
Lire la suiteHello 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...
Lire la suite/pics%2Fsmiles%2Ficon_biggrin.gif)
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...
Lire la suite/pics%2Fsmiles%2Ficon_smile.gif)
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...
Lire la suite/idata%2F3844670%2FClement-Lyon.JPG)
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...
Lire la suite