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…
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,…
Best practice Data management in a transactional environment, data versus database management
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 were institutional websites. Then came e-Commerce…
What HA strategy for your SQL server?
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,…
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…
The importance of security and securing your data tier
Published on: April 14th 2010 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…
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…
SQL server 2008 R2 – what is new?
Published on: April 6th 2010 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…
Setting database mirroring and minimizing downtime
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….
Categories
- Inspiration (1)
- Security (2)
- SQL Architecture (21)
- SQL Monitoring (1)
- SQL Performance (16)
- Tips & tricks (1)
- Uncategorized (5)
- Utilities (1)