SQL server tuning: DML for multiple rows in one shot
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…
Musings on optimizing your OLAP processing in SSAS: measures and partitions
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…
SQL server: musings about distributed environments, distributed transactions, and project development cycle
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 and if any failure occurs, need…
Data density: method of scoring your database
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,…
SQL server table Page density: the ennemy of the DBA!
Published on: April 7th 2010 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…
Database High Availability vs High Performance
Published on: April 10th 2010 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…
Categories
- Inspiration (1)
- Security (2)
- SQL Architecture (21)
- SQL Monitoring (1)
- SQL Performance (16)
- Tips & tricks (1)
- Uncategorized (5)
- Utilities (1)