Author : All posts by ilikesql

20

Aug

Driving industry transformation with Azure – Getting started – Edition 1

Microsoft is highly focused on solving industry challenges, creating new opportunities and driving digital transformation for all organizations. Through dedicated industry resources from Microsoft and premier partners, new solutions, content, and guidance are released almost daily. This monthly blog aggregates a series of the newest resources focused on how Azure can address common challenges and drive new opportunities in a variety of industries.

Banking and Capital Markets Protecting against fraud and financial crime
New types of attack vectors and fraud are emerging every day, and detection systems need to respond faster  than ever. Find banking case studies and information from financial leaders showing how Azure machine learning and AI solutions can rapidly detect and protect against risks. How to upgrade your financial analysis capabilities with Azure
In corporate finance and investment banking, risk analysis is a crucial job. Read how Azure can be used to implement a risk assessment solution. Lessons from big-box retail
Banking customers want more from their services, including new choices, speed, and tailored recommendations. Find out how modern retail experiences can help. Microsoft Azure launches tamper-proof Azure Immutable Blob Storage for financial services
Immutable Blob Storage is now in public preview – enabling financial institutions

Share

20

Aug

Azure Block Blob Storage Backup
Azure Block Blob Storage Backup

Azure Blob Storage is Microsoft’s massively scalable cloud object store. Blob Storage is ideal for storing any unstructured data such as images, documents and other file types. Read this Introduction to object storage in Azure to learn more about how it can be used in a wide variety of scenarios.

The data in Azure Blob Storage is always replicated to ensure durability and high availability. Azure Storage replication copies your data so that it is protected from planned and unplanned events ranging from transient hardware failures, network or power outages, massive natural disasters, and so on. You can choose to replicate your data within the same data center, across zonal data centers within the same region, and even across regions. Find more details on storage replication.

Although Blob storage supports replication out-of-box, it’s important to understand that the replication of data does not protect against application errors. Any problems at the application layer are also committed to the replicas that Azure Storage maintains. For this reason, it can be important to maintain backups of blob data in Azure Storage. 

Currently Azure Blob Storage doesn’t offer an out-of-the-box solution for backing up block blobs. In this blog post, I will design

Share

20

Aug

Migrate Windows Server 2008 to Azure with Azure Site Recovery

For close to 10 years now, Windows Server 2008/2008 R2 has been a trusted and preferred server platform for our customers. With millions of instances deployed worldwide, our customers run many of their business applications including their most critical ones on the Windows Server 2008 platform.

With the end of support for Windows Server 2008 in January 2020 fast approaching, now is a great opportunity for customers running Windows Server 2008 to modernize your applications and infrastructure and take advantage of the power of Azure. But we know that the process of digital transformation doesn’t happen overnight. There are some great new offers that customers running their business applications on Windows Server 2008 can benefit from as they get started on their digital transformation journey in Azure. One of the options available to customers is the option to migrate servers running Windows Server 2008 to Azure and get extended security updates for three years past the end of support date, and this offer is available at no additional cost. In other words, if you choose to run your applications on Windows Server 2008 on Azure virtual machines, you get extended security updates for free. Further, with Azure Hybrid Benefit you

Share

17

Aug

Power BI Report URL filter improvements
Power BI Report URL filter improvements

https://powerbi.microsoft.com/en-us/blog/power-bi-report-url-filter-improvements/Source: https://powerbi.microsoft.com/en-us/blog/power-bi-report-url-filter-improvements/           Power BI now offers enhanced filtering capabilities that let you define more complex report-level filters as query string parameters directly in the report URL, as the following screenshot…

Share

16

Aug

Azure #HDInsight Interactive Query: simplifying big data analytics architecture

Fast Interactive BI, data security and end user adoption are three critical challenges for successful big data analytics implementations. Without right architecture and tools, many big data and analytics projects fail to catch on with common BI users and enterprise security architects. In this blog we will discuss architectural approaches that will help you architect big data solution for fast interactive queries, simplified security model and improved user adoption with BI users.

Traditional approach to fast interactive BI

Deep analytical queries processed on Hadoop systems have traditionally been slow. MapReduce jobs or hive queries are used for heavy processing of large datasets, however, not suitable for the fast response time required by interactive BI usage.

Faced with user dissatisfaction due to lack of query interactivity, data architects used techniques such as building OLAP cubes on top of Hadoop. An OLAP cube is a mechanism to store all the different dimensions, measures and hierarchies up front. Processing the cube usually takes place at the pre-specified interval. Post processing, results are available in advance, so once the BI tool queries the cube it just needs to locate the result, thereby limiting the query response time and making it a fast and interactive

Share

16

Aug

Advanced Analytics is coming into Azure Portal
Advanced Analytics is coming into Azure Portal

We see Azure Monitor users are using both the Log Search page and the Analytics portal to accomplish their tasks. The Analytics portal offers advanced features, and we’re happy to announce it’s coming into Azure!

This is another step on our journey to consolidate and unify all Log Analytics experiences under Azure Portal.

What’s coming?

If you’re not familiar with the Analytics portal, you’re in for a treat!

Multiple tabs – use as many tabs as you want to run multiple queries Rich visualizations – a variety of charting options to choose from Improved IntelliSense and language auto-completion Syntax highlighting – making queries easier to read Query explorer – access your saved queries and functions, within the editor Schema view – review the full schema of your data Column selection – select the columns of the results table, and their order Share – create links to queries, or pin queries to any shared Azure dashboard

When and where?

In the coming days, a menu item named “Logs (preview)” will light up in Azure Log Analytics. It will gradually be integrated into a number of Azure features and services, such as Application Insights, Azure Monitor and Azure Kubernetes Service.

At

Share

16

Aug

Azure #HDInsight Apache Phoenix now supports Zeppelin
Azure #HDInsight Apache Phoenix now supports Zeppelin

The HDInsight team is excited to announce Apache Zeppelin Support for Apache Phoenix

Phoenix in Azure HDInsight

Apache Phoenix is an open source, massively parallel relational database layer built on HBase. Phoenix allows you to use SQL like queries over HBase. Phoenix uses JDBC drivers underneath to enable users to create, delete, alter SQL tables, indexes, views and sequences, upset rows individually and in bulk. Phoenix uses NOSQL native compilation rather than using MapReduce to compile queries, enabling the creation of low-latency applications on top of HBase.

Apache Phoenix enables OLTP and operational analytics in Hadoop for low latency applications by combining the best of both worlds. In Azure HDInsight Apache Phoenix is delivered as a 1st class Open Source framework.

Why use Apache Phoenix in Azure HDInsight?

HDInsight is the best place for you to run Apache Phoenix and other Open Source Big Data Applications. HDInsight makes Apache Phoenix even better in following ways:

Out of the box highly tuned Apache Phoenix cluster in minutes

In Azure, several large customers runs their mission critical HBase/Phoenix workloads, over the period of time services becomes more and more intelligent about right configurations for running the HBase workloads as efficiently as possible.

Share

16

Aug

Installing certificates into IoT devices
Installing certificates into IoT devices

Lots of folks are moving to X.509 certificate-based authentication as they start to use the Azure IoT Hub Device Provisioning Service, which is great! But I’ve gotten lots of questions about what the best practices are, and how to go about doing it at scale. There are a lot of variables that influence where certs come from and how they are installed, and who owns each stage depends on the specific processes and business relationships in place. This blog post is meant to provide some clarity around the cert generation and installation process for IoT devices at production-level scales.

One note before I begin, if you already have a system in place for installing certificates on your IoT devices and its working out for you, great! Feel free to stop reading and check out some of our other content. This blog post is for folks who are just making the switch to using certificates on IoT devices and are struggling with figuring out what works best.

Mandatory security rant

If you’re coming from the land of passwords and want a quick fix, you might be asking yourself why you can’t use the same certificate in all your devices like you

Share

16

Aug

Announcing VNet service endpoints general availability for MySQL and PostgreSQL

This blog post was co-authored by Anitha Adusumilli, Principal Program Manager, Azure Networking.

We recently made Azure database services for MySQL and PostgreSQL generally available. These services offer the community versions of MySQL and PostgreSQL with built-in high availability, a 99.99 percent availability SLA, elastic scaling for performance, and industry-leading security and compliance on Azure. Since general availability, we have continued to bring new features and capabilities like increased storage and availability across more regions worldwide.

We are excited to announce the general availability of Virtual Network (VNet) service endpoints for Azure Database for MySQL and PostgreSQL in all regions where the service is available for General Purpose and Memory Optimized servers. Visit region expansion for MySQL and PostgreSQL for service availability. VNet service endpoints enable you to isolate connectivity to your logical server from only a given subnet or set of subnets within your virtual network. The traffic to Azure Database for MySQL and/or PostgreSQL from your VNet always stays within the Azure backbone network. Preference for this direct route is over any specific ones that route Internet traffic through virtual appliances or on-premises.

There is no additional billing for virtual network access through service endpoints. The current pricing model for Azure Database for MySQL and PostgreSQL applies as is.

Using

Share

16

Aug

IoT in Action: Building secure, sophisticated solutions

With a compound annual growth rate of 28.5 percent forecasted by 2020, the global Internet of Things (IoT) market is exploding, and the technology behind IoT continues to evolve at a feverish pace.

Here at Microsoft, we’re working hard to secure, simplify, and democratize IoT so that every customer can transform business, and the world at large, with connected solutions. This is why Microsoft has committed $5 billion to IoT over the next four years.
 
While IoT offers companies across industries a wealth of powerful benefits, the reality of implementation poses serious considerations such as security, complexity and scalability–not to mention keeping up with all the innovations flooding the market.

In the run up to the IoT in Action kickoff event for FY18 (where you’ll definitely learn more), I’d like to briefly touch on some key areas to consider when preparing to build out your IoT solution.

Make security intentional with Azure Sphere

Did you know that more than 9 billion microcontroller units (MCU) are deployed each year? From a risk standpoint, that’s 9 billion more opportunities for compromised security. Which means, making end-to-end security a priority from the start is a top priority.

Recently, as part of

Share