Sunday, March 26, 2017
Sunday, March 19, 2017
Tuesday, March 14, 2017
Sunday, March 12, 2017
Debugging High Memory and CPU In IIS
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.
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.htmlSQL Server Analysis Services (SSAS) Tutorial
MDX Query Basics (Analysis Services 2012)
How to Install and Configure SSIS 2012
PowerBI
Saturday, March 11, 2017
Sunday, March 5, 2017
Monday, January 9, 2017
E2E Testing
http://www.slideshare.net/harvardwww/ui-testing-with-ghost-inspector
CSS selector for ghost inspector
https://github.com/jquery/sizzle/wiki
Tuesday, January 3, 2017
Mobile Apps Testing
Android
http://bitbar.com/top-5-android-testing-frameworks-with-examples/
https://developer.android.com/training/testing/index.html
https://google.github.io/android-testing-support-library/
https://google.github.io/android-testing-support-library/docs/espresso/setup/index.html
Expresso on Device Farm
https://github.com/awslabs/aws-device-farm-sample-app-for-android
iOS
http://bitbar.com/top-5-ios-testing-frameworks-with-examples/Monday, January 2, 2017
Tuesday, December 27, 2016
Big Data - Part 5 - AWS Athena
Athena
https://www.youtube.com/watch?v=ihVI-MZ6xR0
https://aws.amazon.com/blogs/big-data/analyzing-data-in-s3-using-amazon-athena/
https://shinesolutions.com/2016/12/09/will-athena-slay-bigquery/
Presto
https://en.wikipedia.org/wiki/Presto_(SQL_query_engine)
https://aws.amazon.com/emr/details/presto/
https://prestodb.io/docs/current/index.html
Athena Tutorial
https://medium.com/@robwitoff/athena-alb-log-analysis-b874d0958909#.jb7rj9smk
PARQUET
https://www.mapr.com/blog/how-convert-csv-file-apache-parquet-using-apache-drill
https://www.youtube.com/watch?v=ihVI-MZ6xR0
https://aws.amazon.com/blogs/big-data/analyzing-data-in-s3-using-amazon-athena/
https://shinesolutions.com/2016/12/09/will-athena-slay-bigquery/
Presto
https://en.wikipedia.org/wiki/Presto_(SQL_query_engine)
https://aws.amazon.com/emr/details/presto/
https://prestodb.io/docs/current/index.html
Athena Tutorial
https://medium.com/@robwitoff/athena-alb-log-analysis-b874d0958909#.jb7rj9smk
PARQUET
https://www.mapr.com/blog/how-convert-csv-file-apache-parquet-using-apache-drill
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
Sunday, November 27, 2016
Publish Subscribe
Conversely, PubNub supports an unlimited number of PubNub channels. This allows every end-user device to have its own channel for one-to-one connectivity.
SQL Server
SQL Server Data File, Log File
http://blog.sqlauthority.com/2013/08/14/sql-server-sql-basics-database-datafiles-and-logfiles-day-8-of-10/
Thursday, November 3, 2016
Monday, October 31, 2016
Redis
https://github.com/MSOpenTech/Redis
https://github.com/StackExchange/StackExchange.Redis
http://objectrocket.com/blog/how-to/10-quick-tips-about-redis/
https://gist.github.com/JonCole/925630df72be1351b21440625ff2671f
http://www.slideshare.net/noahd1/redis-in-practice
Redis on Windows
https://github.com/MicrosoftArchive/redis/releases
Wednesday, October 26, 2016
SQL Server Maintenance & Trouble Shooting
https://ola.hallengren.com/
http://sqlblog.com/blogs/adam_machanic/archive/2016/01/04/sqlquerystress-the-source-code.aspx
https://www.brentozar.com/archive/2010/09/sql-server-dba-scripts-how-to-find-slow-sql-server-queries/
EXEC sp_WhoIsActive
http://www.solarwinds.com/
http://www.solarwinds.com/aws-dpa
installed solarwinds for mysql
https://www.mssqltips.com/sqlservertip/2730/sql-query-stress-tool/
Saturday, October 22, 2016
Elastic Search
http://siddhumehta.blogspot.com/2014/05/elasticsearch-tutorial-elasticsearch-gui-tools.html
https://www.elastic.co/
https://aws.amazon.com/elasticsearch-service/
https://github.com/fullscale/elastic.js/
https://github.com/danpaz/bodybuilder
https://www.elastic.co/blog/found-sense-a-cool-json-aware-interface-to-elasticsearch
https://github.com/KunihikoKido/atom-elasticsearch-client
https://www.elastic.co/guide/en/elasticsearch/plugins/2.4/cloud-aws-best-practices.html
http://appbaseio.github.io/dejaVu/
http://appbaseio.github.io/mirage/
https://github.com/ozlerhakan/mongolastic
https://www.elastic.co/guide/en/elasticsearch/plugins/2.4/integrations.html
http://stackoverflow.com/questions/37413901/which-javascript-node-module-is-best-for-elastic-search-query-dsl
https://www.elastic.co/guide/en/elasticsearch/client/javascript-api/current/api-reference.html
search
edit
client.search([params, [callback]])
Return documents matching a query, aggregations/facets, highlighted snippets, suggestions, and more. Write your queries as either simple query strings in the
q
parameter, or by specifying a full request definition using the Elasticsearch Query DSL in the body
parameter.
The default method is
POST
and the usual params and return values apply. See the elasticsearch docs for more about this method.Tuesday, October 18, 2016
Saturday, October 8, 2016
Big Data - Part3
https://www.quora.com/What-can-you-do-with-Amazon-Kinesis
http://docs.fluentd.org/articles/kinesis-stream
http://www.slideshare.net/sonots/fluentd-hacking-guide-at-rubykaigi-20140920?next_slideshow=1
http://www.slideshare.net/treasure-data/fluentd-loves-mongodb-at-mongosv-july172012/39-Fluentd_Plugin_forTuesday_July_17
http://www.slideshare.net/tamuraaa/life-of-an-fluentd-event?qid=31ec332f-bc6b-4940-bdf2-fa9b5b04ae22&v=&b=&from_search=11
http://www.slideshare.net/sonots/fluentd-hacking-guide-at-rubykaigi-20140920?next_slideshow=1
http://www.slideshare.net/treasure-data/fluentd-loves-mongodb-at-mongosv-july172012/39-Fluentd_Plugin_forTuesday_July_17
http://www.slideshare.net/tamuraaa/life-of-an-fluentd-event?qid=31ec332f-bc6b-4940-bdf2-fa9b5b04ae22&v=&b=&from_search=11
https://www.quora.com/Which-is-better-Cloud-Data-Science-Platform-or-dominodatalab-com-Are-there-any-other-platforms-that-I-should-consider
https://www.dominodatalab.com/resource/data-science-experiments#
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
Tuesday, September 13, 2016
Sunday, September 4, 2016
Friday, September 2, 2016
Wednesday, August 31, 2016
Monday, August 22, 2016
Sunday, August 21, 2016
Saturday, August 13, 2016
Load Testing
Using this
https://chrome.google.com/webstore/detail/restful-stress/lljgneahfmgjmpglpbhmkangancgdgeb?hl=en]
https://loadimpact.com/
https://www.blitz.io/login
https://loader.io/
http://alternativeto.net/software/blitz-io/
https://www.slant.co/topics/138/~load-testing-services
http://stackshare.io/load-and-performance-testing
Tuesday, August 9, 2016
Lauch App from Browser
https://msdn.microsoft.com/subscriptions/json/GetDownloadRequest?brand=MSDN&locale=en-us&fileId=69105&activexDisabled=true&akamaiDL=false
http://stackoverflow.com/questions/916925/how-to-launch-an-exe-from-web-page-asp-net
Subscribe to:
Posts (Atom)