AWS Developer Tools

https://app.pluralsight.com/library/courses/aws-developer-tools-getting-started/table-of-contents

AWS Athena

https://app.pluralsight.com/library/courses/aws-athena-get-started/table-of-contents

SQL Server

SQL Server:


Number of tables and sizes (Credit : stack overflow)

SELECT
    t.NAME AS TableName,
    s.Name AS SchemaName,
    p.rows AS RowCounts,
    SUM(a.total_pages) * 8 AS TotalSpaceKB,
    CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,
    SUM(a.used_pages) * 8 AS UsedSpaceKB,
    CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB,
    (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB,
    CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB
FROM
    sys.tables t
INNER JOIN  
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN
    sys.allocation_units a ON p.partition_id = a.container_id
LEFT OUTER JOIN
    sys.schemas s ON t.schema_id = s.schema_id
WHERE
    t.NAME NOT LIKE 'dt%'
    AND t.is_ms_shipped = 0
    AND i.OBJECT_ID > 255
GROUP BY
    t.Name, s.Name, p.Rows
ORDER BY
    t.Name

Size of Index

SELECT
    i.[name] AS IndexName,
    t.[name] AS TableName,
    SUM(s.[used_page_count]) * 8 AS IndexSizeKB
FROM sys.dm_db_partition_stats AS s
INNER JOIN sys.indexes AS i ON s.[object_id] = i.[object_id]
    AND s.[index_id] = i.[index_id]
INNER JOIN sys.tables t ON t.OBJECT_ID = i.object_id
GROUP BY i.[name], t.[name]
ORDER BY i.[name], t.[name]

Headless Magento

https://alankent.me/2016/12/14/headless-magento-and-extensions/
https://github.com/sitewards/headless-magento2-resources
http://devdocs.magento.com/guides/v2.0/get-started/bk-get-started-api.html
http://slides.com/rocwang/storefront#/

Redshift Spectrum

http://docs.aws.amazon.com/redshift/latest/dg/c-getting-started-using-spectrum-query-s3-data.html



Dabbling with Redshift Spectrum

Keep your larger fact tables in Amazon S3 and your smaller dimension tables in Amazon Redshift, as a best practice. If you loaded the sample data in Getting Started with Amazon Redshift, you have a table named EVENT in your database. If not, create the EVENT table by using the following command.


Amazon Redshift uses massively parallel processing (MPP) to achieve fast execution of complex queries operating on large amounts of data. Redshift Spectrum extends the same principle to query external data, using multiple Redshift Spectrum instances as needed to scan files. Place the files in a separate folder for each table.

Completed Multi-Tier Serverless Architecture

https://cloudacademy.com/amazon-web-services/advanced-use-of-amazon-api-gateway%20-course/scenario-overview.html

Functional Java Script Course

https://app.pluralsight.com/library/courses/javascript-functional-programming-fundamentals/table-of-contents

Big Data - Part 6

1. Asp .net to parse Query
2. Parquet as Storage format
3. https://github.com/google/protobuf
4. 
   

https://blog.openbridge.com/how-to-be-a-hero-with-powerful-parquet-google-and-amazon-f2ae0f35ee04

http://blog.panoply.io/the-spectrum-of-redshift-athena-and-s3

https://www.sumologic.com/blog/devops/kinesis-streams-vs-firehose/
https://www.sumologic.com/wp-content/uploads/DemystifyingAmazonKinesis_infographic.pdf


Kafka Vs Kineis

https://blog.insightdatascience.com/ingestion-comparison-kafka-vs-kinesis-4c7f5193a7cd


https://hackernoon.com/processing-real-time-big-data-streams-using-kinesis-lambda-561a029ef305

Installing Kali Linux and Nessus

Penetration Testing

https://app.pluralsight.com/library/courses/penetration-testing-lifecycle-explained/table-of-contents

Security Training

Installing Kali

https://aws.amazon.com/marketplace/pp/B01M26MMTT


https://www.exploit-db.com/google-hacking-database/


https://www.alienvault.com/blogs/security-essentials/configuring-kali-linux-on-amazon-aws-cloud-for-free

http://toolbar.netcraft.com/site_report?url=http://shop.cricut.com

Installing VNC on Ubuntu finally

sudo apt-get updatesudo apt-get install xfce4 xfce4-goodies tightvncserverapt-get install gnome-core kali-defaults kali-root-login desktop-base

Docker Mangento

https://github.com/andreaskoch/dockerized-magento

https://hub.docker.com/r/alexcheng/magento/

MVC , MVP , MVVM on Android

http://stackoverflow.com/questions/2056/what-are-mvp-and-mvc-and-what-is-the-difference

http://www.bigdev.de/2014/02/gui-design-patterns-mvc-mvp-vs-mvvm.html


https://news.realm.io/news/eric-maxwell-mvc-mvp-and-mvvm-on-android/



https://code.tutsplus.com/tutorials/an-introduction-to-model-view-presenter-on-android--cms-26162

https://stackoverflow.com/questions/2056/what-are-mvp-and-mvc-and-what-is-the-difference

Model-View-Presenter

 For example, when someone clicks the "Save" button, the event handler delegates to the Presenter's "OnSave" method. Once the save is completed, the Presenter will then call back the View through its interface so that the View can display that the save has completed.

AWS Scripting

brew tap wallix/awless; brew install awless

awless config set aws.profile devawless config set aws.profile prod

awless list instances --filter name=api2-ASG production1

Aws Links

News

https://github.com/open-guides/og-aws#ecs-tips
https://aws.amazon.com/blogs/aws/
https://www.youtube.com/channel/UCT-nPlVzJI-ccQXlxjSvJmw







https://redash.io/

Utils

http://blog.powerupcloud.com/2016/10/09/application-load-balancer/


http://rclone.org/


https://github.com/thinhpham/aws-tools

https://github.com/Fullscreen/aws-rotate-key

HTTP2

https://aws.amazon.com/blogs/aws/page/9/

Scaling Amazon RDS

https://aws.amazon.com/blogs/database/scaling-your-amazon-rds-instance-vertically-and-horizontally/

https://s3-eu-west-1.amazonaws.com/public-s3-bc3538/sqlsplitter/SmartAMI+SQLSplitter.pdf

Architecture

https://www.youtube.com/watch?v=sjpP2ynkCbo
https://www.youtube.com/watch?v=flMAML4-VX4
https://scaleyourcode.com/interviews/interview/25




Container

https://blox.github.io/

xamarin mobile development

https://app.pluralsight.com/library/courses/play-by-play-xamarin-mobile-development/table-of-contents

AWS AppStream and workspaces

https://aws.amazon.com/appstream2/

https://aws.amazon.com/workspaces/

Test Driven Development

https://github.com/Netflix/SimianArmy

https://github.com/Netflix/SimianArmy/wiki/The-Chaos-Monkey-Army



https://app.pluralsight.com/player?course=test-driven-development-big-picture&author=jason-olson&name=test-driven-development-big-picture-m3&clip=2&mode=live

R Programming

IAM Course

Android Graphics

https://developer.android.com/reference/android/view/SurfaceView.html


https://developer.android.com/reference/android/graphics/Canvas.html

https://developer.android.com/reference/android/graphics/Canvas.html#drawPath(android.graphics.Path, android.graphics.Paint)

http://android-er.blogspot.nl/2011/08/drawpath-on-canvas.html

path.lineTo(x1, y1);

path.cubicTo(x1, y1, x2, y2, x3, y3);
path.quadTo(x1, y1, x2, y2);

Host file, local host and Virus Scanner

https://security.stackexchange.com/questions/96418/localhost-loopback-risk

https://support.microsoft.com/en-us/help/2764944/hosts-file-is-detected-as-malware-in-windows-defender

https://www.devside.net/wamp-server/unlock-and-unblock-the-windows-hosts-file

https://stackoverflow.com/questions/32563611/cant-open-local-iis-site-in-ie-edge

https://blogs.msdn.microsoft.com/msgulfcommunity/2015/07/01/how-to-debug-localhost-on-microsoft-edge/

Catching up on Android 2017

https://www.youtube.com/watch?v=v6QH89i4YCI&index=43&list=PLWz5rJ2EKKc-odHd6XEaf7ykfsosYyCKp


https://www.youtube.com/watch?v=fPzxfeDJDzY&list=PLWz5rJ2EKKc-odHd6XEaf7ykfsosYyCKp&index=50


https://www.youtube.com/watch?v=vOJCrbr144o


https://www.youtube.com/watch?v=rHiA66zUv8c

Completed: Elastic Search course

https://app.pluralsight.com/library/courses/elasticsearch-analyzing-data/table-of-contents

Elastic Search Course

https://www.udemy.com/learning-elasticsearch-50/learn/v4/t/lecture/6510294?start=0

Fluentd vs logstash

https://logz.io/blog/fluentd-logstash/

https://www.quora.com/What-are-the-pros-and-cons-of-logstash-vs-fluentd

Managing Elastic Search Domains

http://docs.aws.amazon.com/elasticsearch-service/latest/developerguide/es-managedomains.html

https://www.elastic.co/guide/en/elasticsearch/plugins/master/cloud-aws-best-practices.html

To prevent overloading a dedicated master node, you can monitor usage with the Amazon CloudWatch metrics that are shown in the following table. Use a larger instance type for dedicated master nodes when these metrics reach their respective maximum values.

FreeStorageSpace (Minimum)

Specifies the free space, in megabytes, for the single data node with the least available free space in a cluster. Amazon ES throws a ClusterBlockExceptionwhen this metric reaches 0. To recover, you must either delete indices, add larger instances, or add EBS-based storage to existing instances. For more information, see Recovering from a Lack of Free Storage Space. Relevant statistics: Minimum

CloudWatch Metric	Guideline
MasterCPUUtilization	Measures the percentage utilization of the CPU for the dedicated master nodes. We recommend increasing the size of the instance type when this metric exceeds 40% with a domain status of Active and exceeds 60% with a domain status of Processing.
MasterJVMMemoryPressure	Measures the percentage utilization of the JVM memory for the dedicated master nodes. We recommend increasing the size of the instance type when this metric exceeds 60% with a domain status of Active and exceeds 85% with a domain status of Processing.

.NET Standard

https://blogs.msdn.microsoft.com/dotnet/2016/09/26/introducing-net-standard/

.NET Core for Windows developers

https://app.pluralsight.com/player?course=dotnet-core-windows-developers-getting-started&author=wes-mcclure&name=dotnet-core-windows-developers-getting-started-m0&clip=0&mode=live

ECS - Docker

https://docs.bitnami.com/containers/how-to/ecs-rds-tutorial/

https://aws.amazon.com/blogs/compute/microservice-delivery-with-amazon-ecs-and-application-load-balancers/

https://aws.amazon.com/blogs/aws/powerful-aws-platform-features-now-for-containers/

Dynamic Port Mapping

http://www.awsomeblog.com/aws-application-load-balancer-amazon-ecs-using-dynamic-port-mapping/#

http://www.tothenew.com/blog/dynamic-port-mapping-in-ecs-with-application-load-balancer/


Asp.NET Core

https://blogs.msdn.microsoft.com/stevelasker/2016/09/29/building-optimized-docker-images-with-asp-net-core/

https://medium.com/trafi-tech-beat/running-net-core-on-docker-c438889eb5a

https://github.com/ExpediaDotCom/c3vis