ZASLAVETS CONNECTION - SQL Server Database Consulting

SQL SERVER tuning tip:

Create persisted computed columns for scalar expressions that your queries use to filter results.
This way you will be able to have expressions pre-calculated and create and index on them.
  SQL Server Database Architecture Need SQL Architect or Developer? Get an expert!!






Proper database solution implemented from the start will save you hundreds of thousands (if not millions) spent on re-architecture and re-development besides lost time. It is important to design your database system in a way that will scale naturally while your business grows without any needs for re-factoring every year or so. Changes on database side usually much more costly then changes on application side, because database is a core of your system. Many components are depending on it, and a small change in database may require huge number of changes in various components. Imagine now re-design of your database due to scalability issues - potentially it may result in complete rebuilding of your system, which you may not be able to afford.

We make sure that data model satisfies all your current business requirements and also your plans for the future. While designing a database we keep in mind multiple factors: growth of the database and increasing application load, introduction of new entities and relationsips, addition of new functionality and business rules, etc.

When we are working on architecture we analize and compare various options to find a best solution for your business, this long list of options includes:

    distributed databases
    partitioning - vertical and horisontal
    normalization and de-normalization
    caching strategy
    load balancing
    clustering
    backup and recovery options
    replication
    data archival strategy
    and many others.

ZASLAVETS CONNECTION - SQL Server Database Consulting