webprofit.consulting
Pavel Danilov – WebProfIT Consulting
http://webprofit.consulting/author/paveldanilov
Posts by Pavel Danilov. How to shrink size of Linux EBS volume in AWS. 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 […]. Written by Pavel Danilov. Renaming Primary Keys to Standard. Written by Pavel Danilov. Summary:...
webprofit.consulting
Enterprise Data Governance – WebProfIT Consulting
http://webprofit.consulting/enterprise-data-governance
Definition of Data Governance. Data Governance is the formal orchestration of people, processes and technology to enable an organization to leverage data as enterprise asset. Data governance is not:. Data cleansing or extract, transform and load data (ETL). Master Data Management (MDM). Database management and administration. When and why it’s required. The organization gets so large that traditional management isn’t able to address the high scale of data-related activities. While data policies guide wha...
webprofit.consulting
Microsoft SQL Server – WebProfIT Consulting
http://webprofit.consulting/topic/sql/microsoft-sql-server
Renaming Primary Keys to Standard. 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 […]. Using a DDL trigger to control and automate history of data changes. Written by Pavel Danilov. Written by Pavel Danilov.
webprofit.consulting
RSS – WebProfIT Consulting
http://webprofit.consulting/rss-2
RSS content can be read using software called an “RSS reader,” “feed reader” or an “aggregator.” The user subscribes to a feed by entering the feed’s link into the reader or by clicking an RSS icon in a browser that begins the subscription process. The reader checks the user’s subscribed feeds often for new content, downloading any updates that it finds. The letters “RSS” are used to refer to the following formats:. Really Simple Syndication (RSS 2.0). RDF Site Summary (RSS 1.0 and RSS 0.90).
webprofit.consulting
Migration To Cloud – WebProfIT Consulting
http://webprofit.consulting/migration-to-cloud
Reasons to migrate to Cloud. Private, public or hybrid? Basically, the main and almost the only reason to migrate to Cloud is saving costs in one form or another. Once the server is in the Cloud, you don’t pay any more for:. Hardware maintenance, upgrades and repairs. In some pricing models you also partially or completely forget about:. This brings us to another important reason of moving to the Cloud:. In the Cloud there is almost no waiting. You need a new environment? Not a problem, upgrade your LAMP...
webprofit.consulting
How to shrink size of Linux EBS volume in AWS – WebProfIT Consulting
http://webprofit.consulting/how-to-shrink-size-of-ebs-volume-in-aws
How to shrink size of Linux EBS volume in AWS. How to shrink size of Linux EBS volume in AWS. 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. It’s not a big deal, you can downsize your disk and save a few bucks. This is step-by step instruction. Create a new empty 8Gb volume in the same availability zone as the original 30Gb volume and attach...
webprofit.consulting
Tutorials – WebProfIT Consulting
http://webprofit.consulting/topic/tutorials
INCLUDE Clause in Non-clustered Indexes. 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 […]. How to shrink size of Linux EBS volume in AWS. Renaming Primary Keys to Standard. WebProfIT Consulting, Inc. 2016.
webprofit.consulting
gparted – WebProfIT Consulting
http://webprofit.consulting/tag/gparted
How to shrink size of Linux EBS volume in AWS. 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 […]. How to shrink size of Linux EBS volume in AWS. Renaming Primary Keys to Standard. WebProfIT Consulting, Inc. 2016.
webprofit.consulting
Cloud – WebProfIT Consulting
http://webprofit.consulting/topic/cloud
How to shrink size of Linux EBS volume in AWS. 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 […]. How to shrink size of Linux EBS volume in AWS. Renaming Primary Keys to Standard. WebProfIT Consulting, Inc. 2016.
SOCIAL ENGAGEMENT