WebProfIT Consulting
  • Home
  • Cloud
  • SQL
  • Big Data
  • Contact Us
  • RSS
Relational Databases

Relational Databases

Design, development, deployment, integration, configuration, performance tuning, troubleshooting, security, administration. SQL scripting.

Cloud Solutions

Cloud Solutions

Virtualization, public, private & hybrid cloud deployments. High availability, disaster recovery, workflow automation.

READ MORE
Big Data or not yet?

Big Data or not yet?

Detailed analysis of possible Hadoop / NoSQL implementation, pros & cons. Migration from classic Data Warehousing to Big Data concept.

Data Warehousing

Data Warehousing

Design, optimization and performance improvement of data warehouses; OLTP / OLAP balancing.

Prescriptive Analytics

Prescriptive Analytics

ETL, BI, data mining. Data modelling, integration, analysis, visualization.

Categories

  • AWS (1)
  • Big Data (1)
  • Cloud (1)
  • SQL (4)
    • Microsoft SQL Server (3)
  • Tips and Tricks (2)
  • Tutorials (1)

Recent Comments

    How to shrink size of Linux EBS volume in AWS

    2016-09-25 Leave a Comment Written by Pavel Danilov

    If you over-allocated the size of EBS volume for EC2 instance, it may seem to be a problem to downsize it because Amazon Web Services don’t offer this operation, which is understandable. Suppose you allocated 30 Gb just in case, and it turned out that  your data actually take about only 4Gb. Taking into account […]

    Read More
    AWS, Cloud
    Amazon Web Services, AWS, EBS volume, EC2, EC2 instance, gparted, linux, partitioning, scaling, Ubuntu

    Data Normalization

    2016-09-09 Leave a Comment Written by Pavel Danilov
    Data Normalization

    Best practice of the database design for OLTP (transactional) databases is to have all data at least in the 3rd normal form. After some hands-on experience developers design tables right in the 3RD NF. But in case of any difficulties, it can be done iteration by iteration via following the rules: 1st Normal Form First […]

    Read More
    SQL, Tips and Tricks
    analytics, data integrity, data normalization, INDEX, OLTP, performance, primary key

    Renaming Primary Keys to Standard

    2016-09-03 Leave a Comment Written by Pavel Danilov

    We prefer to name all primary key constraints explicitly and not let SQL server come up with its own names. In this case: We always know what name to look for. Standard name, which in our case looks like PK_tableName, simplifies automatic maintenance of primary keys: if all names are standard, they can be used […]

    Read More
    Microsoft SQL Server, SQL
    primary key, SQL, SQL Server

    INCLUDE Clause in Non-clustered Indexes

    2016-09-03 Leave a Comment Written by Pavel Danilov

    Summary: improve performance of you queries by including hot data into index If you have a big table, let’s say with 100 columns and million rows, and some of those 100 columns, say 5 of them are being used in queries very often, you may significantly improve performance by building a special non-clustered index with […]

    Read More
    Microsoft SQL Server, SQL, Tips and Tricks, Tutorials
    BigTable, HOT, INDEX, non-clustered index, performance, primary key, SQL

    Using a DDL trigger to control and automate history of data changes

    2016-09-03 Leave a Comment Written by Pavel Danilov
    Time Capsule - Sony tape recorders

    Summary: DDL trigger does all the magic of automatic support of historical data, all you need is to run the script against your database (once). After that you can turn history on tables on, off, or pause it. It will keep audit of all schema changes in your database and automatically generate DML triggers on […]

    Read More
    Big Data, Microsoft SQL Server, SQL
    backup, COMMIT, DDL, DDL trigger, DML trigger, Excel, IDENTITY column, INDEX, INSERT, management, Microsoft, Microsoft SQL server, primary key, React, replication, SQL, SQL Server, trigger, XML

    Recent Posts

    • How to shrink size of Linux EBS volume in AWS
    • Data Normalization
    • Renaming Primary Keys to Standard
    • INCLUDE Clause in Non-clustered Indexes
    • Using a DDL trigger to control and automate history of data changes

    Archives

    WebProfIT Consulting, Inc. 2016