Friday, December 02, 2016

New – AWS Personal Health Dashboard – Status You Can Relate To | AWS Blog

New – AWS Personal Health Dashboard – Status You Can Relate To | AWS Blog



We launched
the AWS Service Health Dashboard way back in 2008! Back then, the AWS
Cloud was relatively new, and the Service Health Dashboard was a good
way for our customers to check on the status of each service



You can also use CloudWatch Events to automate your response to alerts and notification of scheduled activities. 



you also have access to the new AWS Health API.

Thursday, December 01, 2016

SQL Server Perfmon Counters Tutorial

SQL Server Perfmon Counters Tutorial

.NET Productivity Improvements | Connect(); // 2016 | Channel 9

.NET Productivity Improvements | Connect(); // 2016 | Channel 9



Interview with Damian Brady | DevOps Interviews | Channel 9



Logic Apps Management and Tooling | Azure Friday | Channel 9



Web Development in Visual Studio 2017 | Connect(); // 2016 | Channel 9



Application Performance Management with Azure Application Insights | Connect(); // 2016 | Channel 9







Amazon Athena – Interactive SQL Queries for Data in Amazon S3 | AWS Blog

Amazon Athena – Interactive SQL Queries for Data in Amazon S3 | AWS Blog



Athena includes an interactive query editor to
help get you going as quickly as possible. Your queries are expressed in
standard ANSI SQL and can use JOINs, window functions, and other
advanced features. Athena is based on the Presto
distributed SQL engine and can query data in many different formats
including JSON, CSV, log files, text with custom delimiters, Apache Parquet, and Apache ORC.  You can run your queries from the AWS Management Console or from a SQL clients such as SQL Workbench, and you can use Amazon QuickSight to visualize your data. You can also download and use the Athena JDBC driver and run queries from your favorite Business Intelligence tool.

Amazon Aurora Update – PostgreSQL Compatibility | AWS Blog

Amazon Aurora Update – PostgreSQL Compatibility | AWS Blog



Customers love the MySQL compatibility, the focus on high availability,
and the built-in encryption. They count on the fact that Aurora is built
around fault-tolerant, self-healing storage that allows them to scale
from 10 GB all the way up to 64 TB without pre-provisioning. They know
that Aurora makes six copies of their data across three Availability
Zones and backs it up to Amazon Simple Storage Service (S3)
without impacting performance or availability. As they scale, they know
that they can create up to 15 low-latency read replicas that draw from
common storage.

Tuesday, November 29, 2016

Learning on the Move | Backyard Data Science

Learning on the Move | Backyard Data Science



I spend a little time each morning before work learning something new – either on the Microsoft Virtual Academy, EdX, Coursera, blog posts, books, websites and videos. I go to conferences, and yes, I learn on cruises.

So I’ve been doing microservices | Piotr Gankiewicz

So I’ve been doing microservices | Piotr Gankiewicz



Whenever something goes wrong, you want to make sure that your whole
system doesn’t crash, or at least part of it. Make sure you have some
retry policies included (e.g. Polly), service discovery tools such as Consul and also keep your credentials in some centralized place e.g. using Vault, Azure Key Vault or my open source project Lockbox.



Decomposing Monolithic View Systems - via @codeship | via @codeship



When we break down a monolithic app into microservices, we go through a process known as decomposition. 



In a normal MVC-based monolith, the model, view, and controller logic
are tightly coupled. With decomposition, we want to extract the view
layer into a separate application, while leaving the rest of the
application’s existing logic in its place.

Monday, November 28, 2016

SQL Server on Linux - How I think they did it! - Centino Systems Blog

SQL Server on Linux - How I think they did it! - Centino Systems Blog



had a Twitter conversation this weekend with Slava Oks, who is a leader on the project team and several other very active people in the SQL Community Klaus AschenbrennerEwald Cress, and Lonny Niederstadt.

The code I’m still ashamed of

The code I’m still ashamed of

Re-encode the entire catalog, applying custom setting to each and every title

The Netflix Tech Blog: Chelsea: Encoding in the Fast Lane



We improved on our system a few years ago by rolling out a parallel encoding workflow, which breaks up a title in “chunks” and the chunks can be processed in parallel on different machines



We recently worked on a system to dynamically leverage unused Netflix-reserved AWS servers during off-peak hours. The additional cloud instances, not used by other Netflix services, allowed us to expedite and prioritize encoding of Chelsea’s show.



Netflix finishes its massive migration to the Amazon cloud | Ars Technica



Netflix has built a series of tools with names like “Chaos Monkey,”
which randomly takes virtual machines offline to make sure Netflix can
survive failures without harming customers. Netflix’s “Simian Army”
ramped up with Chaos Gorilla (which disables an entire Amazon
availability zone) and Chaos Kong (which simulates an outage affecting an entire Amazon region and shifts workloads to other regions).

 

Netflix Open Source Software Center

Netflix Open Source Software Center



The cloud platform is the foundation and technology
stack for the majority of the services within Netflix. The cloud
platform consists
of cloud services, application libraries and application
containers. Specifically, the platform provides service discovery
through
Eureka, distributed configuration through Archaius,
resilent and intelligent inter-process and service communication through Ribbon. To provide reliability
beyond single service calls, Hystrix is provided to isolate latency and fault tolerance at runtime. The previous
libraries and services can be used with any JVM based container.

The platform provides JVM container services through
Karyon and Governator and support for non-JVM runtimes
via the Prana sidecar. While Prana provides proxy capabilities within an instance,
Zuul (which integrates Hystrix, Eureka, and Ribbon as part of its IPC capabilities) provides dyamically
scriptable proxying at the edge of the cloud deployment.

If someone tries to touch a table, kill their connection

It greatly pleases me to announce, HAL0003! | SQL Studies



  • HAL0001 randomly stopped you from making DDL changes.
  • HAL0002 stopped you from using NOLOCK in code.
  • HAL0003 will not let you touch a given table (DiscoveryOne as it
    happens) and will disable your login and kill your connection if you
    try.

If your table has start and end dates, add constraints for better query plans

Do You Have Check Constraints On Your Start and End Dates? | Michael J. Swart



ALTER TABLE [your_table] ADD CONSTRAINT [start date must be less than end date] CHECK (start_date < end_date);

Build Enterprise Mobile Apps with AWS Mobile Hub – New User Management and SaaS Integration | AWS Blog

Build Enterprise Mobile Apps with AWS Mobile Hub – New User Management and SaaS Integration | AWS Blog



On the B2C side you can create your own fully managed directory in Amazon Cognito
and then add sign-up and sign-in features, including multi-factor
authentication (MFA).



On the B2E side, you can allow users to sign in
using their exist corporate credentials. This feature makes use of SAML (Security Assertion Markup Language) and works with multiple directories including Active Directory. To learn more, read Introducing Mobile Hub User Authentication Using SAML Federation or Email and Password Sign-in.




When you make use of either of these sign-in features, AWS Identity and Access Management (IAM) roles are automatically assigned to each user

Mobile Hub connectors allow you to build apps that access commonly used
objects (Accounts, Contacts, Leads, and so forth) across Salesforce, Microsoft Dynamics, Marketo, HubSpot, Zendesk, and QuickBooks. You can also run queries that access and retrieve custom objects from these applications.



The connectors take the form of REST microservices that are implemented as AWS Lambda functions and accessed through Amazon API Gateway

Are You Well-Architected? | AWS Blog

Are You Well-Architected? | AWS Blog



New AWS Well-Architected Framework.









launched free
online training
. The AWS Well-Architected training course  is designed
to provide a deep dive into the AWS Well-Architected Framework and its five
pillars.






whitepapers can all be found at the new home for Well-Architected 

Amazon Aurora: RDS for MySQL - Low Cost Options in AWS for Database hosting

Use Amazon Aurora for Dev & Test Workloads with new T2.Medium DB Instance Class | AWS Blog



a sixth choice, the new db.t2.medium DB instance
class with 2 vCPUs and 4 GiB of RAM. Steady-state, this instance class
has access to 40% of the performance of a single core, and can burst to
full-core performance when processing CPU-intensive queries and other
database tasks. Like the similarly-named EC2 instances, this new
instance class starts out with a full allocation of CPU Credits, which
are spent when the instance is active and accumulate when it is not (my
post, New Low Cost EC2 Instances with Burstable Performance, contains a full explanation).



The db.t2.medium should be a great fit for
many of your development and test scenarios, and you should also
consider them for some of your less-demanding production workloads. You
can monitor the CPUCreditUsage and CPUCreditBalance metrics to track the usage and accumulation of credits over tiem.