Enforcing Ordered Delivery using Azure Logic Apps and Service Bus
September 16, 2017
When consuming messages from an Azure service bus the order may not be guaranteed due to the brokered based messaging scheme where multiple consumers can consume messages from the bus. Sure you can force the Logic App to execute as a single instance but then you sacrifice performance and scalability. You can also use ReceiveAndDelete but then you loose the transactional nature of the bus. Ultimately to ensure a message is consumed in the correct order using the transactional nature of the bus you would add a sequence number to each message and use this to enforce the ordering.
To achieve ordered delivery using Logic Apps, you would need to ensure all related messages are consumed by the same Logic App instance and for this we use the session Id property on the service bus. Below is the full workflow process to force ordered delivery using Logic Apps and session…
View original post 592 more words
Get Azure API Management Git Credentials using PowerShell
September 16, 2017
One of the many great features of Azure API Management is the fact that it has a built in Git repository for storing the current configuration as well as publishing new configurations.
This allows you to push updated Azure API Management configurations to this internal Git repository as a new branch and then Deploy the configuration to API Management.
The internal Git repository in Azure API Management is not intended to be used for a normal development workflow. You’ll still want to develop and store your Azure API management configuration in an external Git repository such as GitHub or TFS/VSTS and then copy configuration updates to the internal Git repository in Azure API Management using some sort of automated process (e.g. Continuous Integration/Continuous Delivery could be adopted for this).
The Internal Git Repository
To access the Internal Git Repository requires short lived (30 days maximum) Git credentials to…
View original post 588 more words
Microsoft Tech Summit
September 13, 2017
Microsoft is hosting their Tech Summit conference in Toronto from December 13-14, 2017. You can build your skills with the latest in cloud technologies at a free, technical learning event for IT professional and developers.
This is a great event to build your cloud skills, connect with experts and get inspired. What’s great is that you can customize your learning – there is something for everyone.
Click here to register.
Reference
New updates for Office 2016 apps
August 25, 2017
This past week updates for Office 2016 started to roll out. Let’s take a look at some of the new features.
What’s New
New ink effects – Easily express your ideas with flair using metallic pens and ink effects like rainbow, galaxy, lava, ocean, gold, silver and more.
New Dubai font.
Insert 3D models.
While you were away – shows you who edited your shared document since your last visit.
Saves for you – Changes are automatically saved when your document is stored in the cloud (much like the mobile versions of Office apps). You can also see others’ updates in seconds.
Once you start saving your document to OneDrive, you will see your AutoSave feature enabled.
While AutoSave is enabled your work will automatically be saved, similar to the Office mobile apps.
If you’re not already saving your work to the Cloud (OneDrive or another) then you should seriously consider doing this. It provides a better experience and also peace of mind that your content is backed up to the cloud and accessible from just about any device.
Enjoy!
References
Video: An introduction to Azure Logic Apps & Salesforce demo
August 15, 2017
Recently, I’ve created an audition video to become a Pluralsight author. I wanted to share this video, as it might be interesting for you. The video gives an introduction to Azure Logic Apps and finishes with a great demo about Saleforce integration (at 5:43).
Enjoy!
FAQ: Azure App Service Domain and Custom Domains
August 10, 2017
I came across an excellent blog post from the Azure App Service Team Blog – FAQ: App Service Domain (preview) and Custom Domains. Lots of great of questions and answers relating to Azure DNS and your custom domains.
If you have any questions or have run into issues with your custom domain and Azure this is a great resource, so check it out!
Reference
An Update to SQL Server Management Studio is Available
August 9, 2017
This week we see an update for SQL Server Management Studio, version 17.2. This release is the latest generation of SQL Server Management Studio and provides support for SQL Server 2017.
What’s New in this Release
- Multi-Factor Authentication (MFA)
- The connection dialog box now supports the following 5 authentication methods:
- Windows Authentication
- SQL Server Authentication
- Active Directory – Universal with MFA support
- Active Directory – Password
- Active Directory – Integrated
- Database import/export for DacFx wizard can now use Universal Authentication with MFA
- ADAL managed library used by Azure AD Universal Authentication with MFA was upgraded to version 3.13.9
- A new CLI interface supporting Azure AD admin setting for SQL Database and SQL Data Warehouse
- Output window has entries for queries run during expansion of Object Explorer nodes
- Enabled View designer for Azure SQL Databases
- Changes to the default scripting options for scripting objects from Object Explorer in SSMS
- Added support for National Clouds in "Restore from URL"
- QueryStoreUI reports now supports additional metrics (RowCount, DOP, CLR Time etc.) from sys.query_store_runtime_stats
- IntelliSense is now supported for Azure SQL Database
- Security: connection dialog will default to not trusting server certificates and to requesting encryption for Azure SQL Database connections
- General improvements around support for SQL Server on Linux
- Performance Dashboard server report now available as a default report
- Showplan node search allows searching in plan properties. Easily look for any operator property such as table name
For the full list of changes, see SQL Server Management Studio – Changelog (SSMS).
Getting the Update
Head over to https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms and you will find two links for installation. The first links downloads and installs SSMS 17.2 where as the second link will update an existing 17.x installation.
This update will not upgrade or replace SSMS versions 16.x or earlier. SSMS 17.x will install side by side with previous versions. If you have multiple SSMS versions installed than the latest is labeled as Microsoft SQL Server Management Studio 17 and has the following icon:
Starting the Installation
Installation is quick and easy…
After the installation is complete, when you open up SSMS 17.2 and look at the About dialog you will see the following components updated:
Sadly we still don’t have an official Dark theme for SQL Server Management Studio. I recall reading comments from the SQL team last year that they needed to do work on all the dialogs before releasing this theme. If the base SSMS IDE supports the Dark theme than just release it You can work on the dialogs as needed and provide them in future updates.
Enjoy!
