Rolling Snapshot dbs setup to correct quickly large errors on production
Hello Guys, You might have wondered if there was a solution that could keep a version of your database in case you/a process made a huge mistake (large update without the where for example) on a production database. You also want the solution to avoid…
SQL server: how to improve multi-threaded inserts on frequently-accessed tables
Hello again, So today we will talk about an issue that I have seen in two of my clients. One of them is a very suffessful Ecommerce that persists the shopping carts (not in cookie) and has millions of users storing in the cart products,…
Data vs Database management
I wrote this article a few years ago noting a change in paradigm where data was more important than database…. meaning the ACID paradigm enforced by the database engine was somewhat an old fashioned way of thinking of data storage…. Is this true? Any point…
The dynamic filtered indexes
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…
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…
Telecommuting! the key for social progress!
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. Telecommuters works more efficiently than Onsite people: TRUE I believe hiring telecommuters is eventually more efficient than OnSite people. A…
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 partitioning on Sql Server Express, Standard and Enterprise edition – Part 1
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 on…
Data partitioning on Sql Server Express, Standard and Enterprise edition – Part 2
On Sql Server Standard (before 2016 sp1) 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…
Categories
- Inspiration (1)
- Security (2)
- SQL Architecture (21)
- SQL Monitoring (1)
- SQL Performance (16)
- Tips & tricks (1)
- Uncategorized (5)
- Utilities (1)