Sunday, March 26, 2017

Engineering Culture






































Branching Strategy

Tuesday, March 14, 2017

MSSQL Load Testing



https://www.mssqltips.com/sqlservertip/2730/sql-query-stress-tool/


Sunday, March 12, 2017

Debugging High Memory and CPU In IIS



Windows Performance Toolkit” 8.1 update from the ADK or SDK


https://blogs.technet.microsoft.com/yongrhee/2014/05/28/wpt-updated-version-of-windows-performance-toolkit-8-1-update-from-the-adk-or-sdk/


WDK, WinDbg, and associated tools


https://developer.microsoft.com/en-us/windows/hardware/windows-driver-kit



Great Tool

https://technet.microsoft.com/en-us/sysinternals/dd996900.aspx
https://support.microsoft.com/en-us/help/2580960/debug-diagnostics-tool-v1.2-is-now-available



DOTNET TRACE
https://www.jetbrains.com/profiler/



Windows performance analyzer

https://go.microsoft.com/fwlink/p/?LinkId=536682









https://blogs.technet.microsoft.com/yongrhee/2012/11/23/wpt-wprxperf-capture-high-cpu-disk-io-file-registry-networking-private-bytes-virtual-bytes-paged-poolnonpaged-pool-andor-application-slowness/

Capture high cpu, disk i/o, file, registry, networking, Private bytes, Virtual bytes, Paged Pool/Nonpaged pool and/or application slowness.


https://blogs.technet.microsoft.com/yongrhee/2012/11/23/wpt-wprxperf-capture-high-cpu-disk-io-file-registry-networking-private-bytes-virtual-bytes-paged-poolnonpaged-pool-andor-application-slowness/







Data Analytics Platform





Mode Analytics Overview

https://vimeo.com/167591387


https://chartio.com/


https://www.quora.com/Who-has-used-Periscope-How-would-you-rate-this-tool-compared-to-Chartio


http://docs.aws.amazon.com/quicksight/latest/user/welcome.html



https://amplitude.com/
https://app.getvero.com/segments
http://docs.mparticle.com/#product-events


Testing with Sample Data









ModeAnalytics is very promising, does not show views or SP.




Data Warehousing course

SSAS , SSIS , SSRS , SSDT



https://www.visualstudio.com/vs/ssdt/


https://app.pluralsight.com/library/courses/sql-server-bi/table-of-contents

https://app.pluralsight.com/library/courses/ssis-design-patterns-data-warehousing/table-of-contents



Installing Reporting Services with default configurations

https://www.safaribooksonline.com/library/view/sql-server-2016/9781786461810/ch01s03.html


SQL Server Analysis Services (SSAS) Tutorial


https://www.mssqltips.com/sqlservertutorial/2000/sql-server-analysis-services-ssas-tutorial/






MDX Query Basics (Analysis Services 2012)



How to Install and Configure SSIS 2012








PowerBI












Building the data warehouse

Monday, December 26, 2016

AWS Athena - ELB Log Analaysis



Thoughts


Able to get working Athena on our production logs.

No more ELK Stack, Hadoop , Map reduce, Big Query.


Create database apilogs2

CREATE EXTERNAL TABLE IF NOT EXISTS apilogs2.elb_logs_raw_native (
  request_timestamp string,
  elb_name string,
  request_ip string,
  request_port int,
  backend_ip string,
  backend_port int,
  request_processing_time double,
  backend_processing_time double,
  client_response_time double,
  elb_response_code string,
  backend_response_code string,
  received_bytes bigint,
  sent_bytes bigint,
  request_verb string,
  url string,
  protocol string,
  user_agent string,
  ssl_cipher string,
  ssl_protocol string )
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'

WITH SERDEPROPERTIES (
         'serialization.format' = '1','input.regex' = '([^ ]*) ([^ ]*) ([^ ]*):([0-9]*) ([^ ]*):([0-9]*) ([.0-9]*) ([.0-9]*) ([.0-9]*) (-|[0-9]*) (-|[0-9]*) ([-0-9]*) ([-0-9]*) \\\"([^ ]*) ([^ ]*) (- |[^ ]*)\\\" (\"[^\"]*\") ([A-Z0-9-]+) ([A-Za-z0-9.-]*)$' )

LOCATION 's3://....';


SELECT * FROM apilogs2.elb_logs_raw_native WHERE elb_response_code = '200' LIMIT 100;


SELECT * FROM apilogs2.elb_logs_raw_native WHERE elb_response_code = '200' and url like '%serialNumber%' LIMIT 100;


SELECT * FROM apilogs2.elb_logs_raw_native WHERE elb_response_code = '200'
and url like '%serialNumber%'
and user_agent like '%ok%' LIMIT 100; --18

Big Data - Part 4



http://www.slideshare.net/AmazonWebServices/bdt310-big-data-architectural-patterns-and-best-practices-on-aws








Server less Architecture 


https://docs.aws.amazon.com/athena/latest/ug/json.html

https://medium.com/@pahud/kinesis-firehose-put-record-with-cli-e835a6e6ffe2#.j5t0okqux

http://aws.mannem.me/?p=1152



SnowPlow


http://snowplowanalytics.com/blog/2014/05/13/introducing-schemaver-for-semantic-versioning-of-schemas/

https://github.com/snowplow/snowplow

https://github.com/snowplow/snowplow/wiki/Setting-up-the-Cloudfront-collector

https://github.com/snowplow/snowplow/wiki/snowplow-tracker-protocol

http://www.slideshare.net/robkingston/a-taste-of-snowplow-analytics-data


Aws Lamda & Gateway


https://abhishek-tiwari.com/post/aws-lambda-and-endless-serverless-possibilities

https://gist.github.com/markusklems/1e7218d76d7583f1f7b3
https://claudiajs.com/tutorials/index.html


https://www.youtube.com/channel/UClLLJjpSWRRa1BosQrNVDjA



Sunday, December 25, 2016

Thursday, December 8, 2016

fonts



https://creativemarket.com/blog/whats-the-difference-between-leading-kerning-and-tracking

http://www.1001fonts.com/web-fonts.html

https://superdevresources.com/create-font-from-handwriting/

https://bond.co/

https://github.com/dok/awesome-text-editing


https://helpx.adobe.com/animate/using/text-layout-framework-tlf-text.html



Text Layout Framework Technology Center


https://helpx.adobe.com/animate/using/text-layout-framework-tlf-text.html
http://www.adobe.com/devnet-apps/tlf/demo/
http://www.adobe.com/devnet/tlf.html
https://www.cocoanetics.com/2012/02/dtrichtexteditor-dtcoretext-news/
https://www.objc.io/issues/5-ios7/getting-to-know-textkit/
https://www.raywenderlich.com/4147/core-text-tutorial-for-ios-making-a-magazine-app













Saturday, October 22, 2016

Saturday, October 8, 2016

Big Data - Part3



https://www.quora.com/What-can-you-do-with-Amazon-Kinesis















http://searchengineland.com/google-data-studio-258871

http://www.iacquire.com/blog/15-google-analytics-alternatives



Event Tracking:


https://mixpanel.com/help/reference/tracking-an-event
https://firebase.google.com/docs/analytics/ios/events
https://www.quora.com/Were-considering-using-Mixpanel-as-an-analytics-platform-for-our-new-app-Someone-has-recommended-we-use-Firebase-instead-Are-they-comparable

https://blog.treasuredata.com/blog/2016/03/09/evaluating-analytics-saas-raw-data-access-capabilities/


BigQuery

https://www.youtube.com/watch?v=D-YrpJkuGqE

https://www.thinkful.com/learn/google-bigquery-tutorial/#Exploring-GitHub-Data



https://www.safaribooksonline.com/library/view/the-deep-learning/9781491965115/video246708.html


9 Data Platform

http://www.confluent.io/
http://www.h2o.ai/
http://www.atscale.com/
https://algorithmia.com/
https://www.bedrockdata.com/product/overview
https://rjmetrics.com/product



http://my-netdata.io/


---


https://obviate.io/2015/08/05/tutorial-aws-api-gateway-to-lambda-to-dynamodb/
http://www.davekonopka.com/2016/serverless-aws-lambda-api-gateway.html


https://www.datawire.io/3-reasons-aws-lambda-not-ready-prime-time/



Tutorials:

https://www.quora.com/Can-we-become-data-scientist-by-going-through-online-tutorials



Friday, September 2, 2016

Image Resize CDN



https://news.ycombinator.com/item?id=10145502

https://docs.imgix.com/



Sunday, August 21, 2016

NewRelic








  1. Integrated Newrelic on tech stack 










Tuesday, August 9, 2016