New Extensions for Project Madeira

When I run Project ‘Madeira’ for the first time, I found only three extensions there:

  • QuickBooks Data Migration
  • PayPal Payments Standard
  • Envestnet Yodlee Bank Feeds

All of them were created by Microsoft. But now, we can find eight of them (one new from Microsoft and few of them by ChargeLogic and Sana Commerce).

MadeiraExtensions.jpg

It looks nice to see new extensions here from other vendors. I hope we will have a hundreds of them in few months as well.

But I’m afraid about their visibility when we have a hundreds or thousands of them. I use brick view for the best visibility, and yes – search works fine, but I think we have to have some additional tags. Minimum I need is Category tag, because we will have a lot of completely different types of extensions (data migration, notifications, integrations, payment, some specific vertical or horizontal solutions, localisations,…). Also, it will be fine to have Market tab because some of extensions are for global market, but some of them will be only for some specific countries.

I expect to have some kind of rating as well. We will have a lot of similar extensions, and we need something for differentiation. I think these ideas can improve ‘Madeira’ experience. But it look it will be a great product.

Advertisement

NAV Gallery Image – PS Scripts Order

This week I have training about NAV and Azure and I used some examples in NAV 2016 Gallery Image on Azure.

NAV90GalleryImage.jpg

This image is awesome, but sometime people doesn’t know what PowerShell script can be started before some others. For example, you cannot run “Use Azure SQL Database” and after that “Install Multitenancy”…

Because of that I wanted to make some small help to all people who want to use this NAV 2016 image. In the following, you can find a chart with order of using all PowerShell scripts. Now, you know how to configure all of them on the same VM.

NAV90GalleryImageOrder.jpg

MS SQL is a Global ODBMS Leader

A few days ago, I’ve wrote about place of Power BI in Gartner survey about BI & Analytics solutions. Power BI was a global leader on Gartner Magic Quadrant. Now, we have new Gartner story about Operational Database Management Systems. For the first time, MS SQL is an absolutely leader and on better position in comparison with Oracle database.

ODBMS Gartner.jpg

The operational database management system (DBMS) market is concerned with relational and nonrelational database management products suitable for a broad range of enterprise-level transactional applications. These include purchased business applications, such as those for ERP, CRM, catalog management and security event management, and custom transactional systems built by organizations’ own development teams. Also included in Gartner’s definition of this market are DBMS products that support interactions and observations as new types of transaction. (from Gartner)

Microsoft deserves this position because they market its SQL Server DBMS for the operational DBMS market, as well as the Microsoft Azure SQL Database (a DBMS platform as a service), and the NoSQL DBMSs Microsoft Azure DocumentDB and Azure Tables.

It is very important that Microsoft continue with working on enterprise SQL Servers and on Azure SQL as well. And finally about NAV. Microsoft Dynamics NAV (from NAV 2016) works on both of these SQL versions and I think this cooperation between strong database and ERP solution will continue to deliver amazing business solutions.

What is Microsoft Azure Stack?

Microsoft Azure Stack is a totally new thing, currently in “technical preview” phase. It changes currently model of using Azure. Before it, you could use a lot of Azure features (Management Portal, VMs, Storage, Azure SDK…), but hosted in the Azure cloud within Microsoft data centers. Now, with Azure Stack, you can use all these Azure features in your own datacenter in your private cloud.

Maybe you think, it is replacement for Windows Server, but it is not a true. Azure Stack is a cloud platform and enables you to make your private cloud platform where you can run Windows Servers or some other servers. Azure Stack makes Azure on not exclusive Microsoft datacenters. I think, this will be great way of using different cloud system who enables a really good hybrid cloud. With this, we can use the same deployment and development tools to build and deploy system that resides either in the Microsoft Azure Cloud or within the some other datacenter, because we can mix IaaS and PaaS services independently of datacenter owners. Almost all features on Azure Management Portal and usage of Microsoft Azure will be the same on Azure Stack and it can make life easier for IT Pros and Developers.

Azure Stack.png

If you want to learn something new, you can find Microsoft Azure Stack Technical Preview documentation here. You can also download Microsoft Azure Stack Technical Preview. Try it, but I think it’ll make a revolution in future cloud systems.

VMs in New Azure Portal

I’ve already wrote about new Microsoft Azure Portal code named Ibiza. When you look this new portal, one of the first news in that now we have two menus for virtual machines:

  • Virtual Machines
  • Virtual Machines (classic)

AzureVMandVMclassic.png

You will see that all virtual machines you already created using old Azure Portal are placed in Virtual Machines (classic). I want to give you a small descriptions about difference between these two options.

The new Azure Resource Manager with a new API doesn’t uses resources as the old API. Because of that, the classic API stack is still operational, but you’ll see those resources showed up as (classic). You have not a reason to convert classic VM to the new VM. You just need to know that you cannot include classic VM in a virtual network deployed with Resource Manager and they don’t have to be included in a virtual network (unless new VMs must be included).

But if you want to migrate classic VM to the newer model, first you have to be sure you can afford a downtime for your VM. If you can afford it, than you can do it using ASM2ARM PowerShell script. You can find all details here.

I hope, I helped you. I have some more information about it and I’ll prepare a real interesting example soon.

Administering Azure SQL

Now we have Microsoft Dynamics NAV 2016 on Azure SQL Server, I’m getting a lot of different questions about this topic. One of them is related with database administration.

If you want to administer Azure SQL Server, you can do it through SQL Server Management Studio. You just need to use your full Azure database name (YourDatabaseName.database.windows.net) and login to database using SQL Server authentication. Of course, previously you have to add your IP address to Azure SQL firewall.

But unfortunately, you cannot use SQL Server Profiler for Azure SQL (maybe in future, but currently not). You can use some other useful tools, for example Index Advisor.

Also, you cannot use SQL Agent on Azure SQL. The most of tools we used to are not available. But, instead SQL Agent we have feature on Azure as Scheduler. To use this, you need to create your new mobile service on Azure for your database. More about this tool, you can find here and here.

New Azure Portal

Few days ago we got a new Azure Portal general availability. You will open new portal (codename Ibiza) if you use the following URL: https://portal.azure.com/

This portal looks like the following picture and this is now default Azure portal:

AzureNew.png

Microsoft promises really better performance and usability, but I need to test completely portal longer period before I can give my opinion. On the first sight, we can see some new features, but I’ll write more soon.

If you still want to use old Azure portal, you just need to use the following URL: https://manage.windowsazure.com/