Friday, December 25, 2015

Season's Greetings and Best Wishes for the New Year.

Peace on Earth. 
Best wishes for a wonderful holiday season and a new year filled with peace and happiness


Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara

Get all the current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine

Have seen many of the forum users are posting question on how to find active user sessions in an instance of Microsoft SQL Database Engine. 


In order to get the current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine, we can use the "sp_who2" SQL stored procedure. 


Following is the definition provided for "sp_who2" in the TechNet
Provides information about current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine. The information can be filtered to return only those processes that are not idle, that belong to a specific user, or that belong to a specific session.
"sp_who2" return a data set as a output and in order to capture the data set we can use a temporary table. Following is the sample code that would return all the current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine.


 DECLARE @Table TABLE(  
     SPID INT,  
     Status VARCHAR(MAX),  
     LOGIN VARCHAR(MAX),  
     HostName VARCHAR(MAX),  
     BlkBy VARCHAR(MAX),  
     DBName VARCHAR(MAX),  
     Command VARCHAR(MAX),  
     CPUTime INT,  
     DiskIO INT,  
     LastBatch VARCHAR(MAX),  
     ProgramName VARCHAR(MAX),  
     SPID_1 INT,  
     REQUESTID INT  
 )  
 INSERT INTO @Table EXEC sp_who2  
 SELECT *  
 FROM  @Table  
 WHERE DBName = 'DatabaseName'  

Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara

Saturday, December 19, 2015

Microsoft Dynamics MBL/BRL January 2016 Price Changes

​Microsoft Dynamics AX, Microsoft Dynamics GP, and Microsoft Dynamics NAV Module Based Licensing and Business Ready Licensing price changes – effective January 2016.​

Microsoft Dynamics currently supports three licensing models for Microsoft Dynamics AX, Microsoft Dynamics GP, and Microsoft Dynamics NAV: 
  • Module Based Licensing ("MBL") model and Business Ready Licensing ("BRL"), available to existing customers having first licensed in 2014 (or prior)​
  • Business Value Licensing for new and existing Dynamics AX customers
  • Perpetual Licensing for new and existing Dynamics NAV and Dynamics GP customers
While we encourage existing MBL and BRL customers with an active enhancement plan to upgrade to the latest version of their products using the attractive license model transition upgrade policies, if applicable, we understand that some customers will want to remain on their current versions.  Therefore, existing MBL and BRL customers will be able to continue licensing additional users and functionality through their existing licensing models.  That said, we do not want our pricing policies to discourage customers from upgrading due to user price differences. 
So, to complete the user price point rationalization change first implemented in July 2014, Microsoft is increasing user prices on the following license models and editions effective 1 January 2016:
- Microsoft Dynamics AX MBL Professional, MBL Enterprise, and BRL Business Essentials
- Microsoft Dynamics GP and Microsoft Dynamics NAV MBL Professional, MBL User Based Pricing, and BRL Business Essentials
We believe that this pricing realignment, designed to bridge the gap between old and new licensing models, will help you increase your existing customer revenue while making it slightly more compelling for your existing customers to upgrade to the latest version of their products. 
The resulting prices are illustrated in the table below.
This price increase does not impact the Protected List Price of users licensed by existing customers prior to 1 January 2016, subject to the then applicable Customer Services and Support Policy. 
Please note that MBL prices for the Standard edition and that BRL prices for the Advanced Management edition are not changing.  ​
What does it mean for existing customers?  Between now and 31 December  2015, there is no better time for your existing customers on the MBL and BRL license models to buy the usersthey might need in the next 6 to 12 months by buying them before prices go up on 1 January 2016.
Next steps for your organization:
  1. Refer to the email templates below to help you communicate these changes to your existing customers.  While we have localized these templates in many languages, we apologize if your specific language is not available.
  2. Query your customer files to create a list of customers impacted by these change.  You can also use Voice to pull a customer list - please select this file for instructions. 
  3. Please communicate these changes by October 15 to give your existing customers a chance to react to the message and buy additional users by the end of December. 
  4. Please place your orders by December 29th 2015 to ensure posting by December 31st 2015.​

Price Table - Effective 1 January 2016
Microsoft Dynamics AX, Microsoft Dynamics GP, and Microsoft Dynamics NAV 
Module Based Licensing and Business Ready Licensing
New Price per Additional User - Effective 1 January 2016
​Country​​
​Currency
​Microsoft Dynamics AX ​
BRL Business Essentials
MBL Professional
MBL Enterprise
​Microsoft Dynamics GP/NAV
BRL Business Essentials
MBL Professional
MBL User Based Pricin
g​
​United States, American Samoa , Bermuda, Cayman Islands, Guam, Marshall Islands, Northern Mariana Islands, Puerto Rico, U.S. Minor Outlying Islands, U.S. Virgin Islands
​USD
​ ​3,000.00 
​Canada, Saint Pierre and Miquelon
​CAD
​​​3,700.00 ​
​​​​​Andorra, Austria, Belgium, Bouvet Islands, Bulgaria, Croatia, Cyprus, Czech Republic, Denmark, Estonia, Faroe Islands, Finland, France, French Guiana, French Southern and Antarctic Lands, Germany, Gibraltar, Greece, Greenland, Guadeloupe, Hungary, Iceland, Ireland, Italy, Latvia, Liechenstein, Lithuania, Luxembourg, Malta, Martinique, Mayotte, Monaco, Netherlands, Norway, Poland, Portugal, Reunion, Romania, Saint Helena, San Marino, Slovakia, Slovenia, Spain, Svalbard and Jan Mayen, Sweden, Switzerland, ​United Kingdom, Vatican City ​ ​ ​ ​ ​
​EUR
​​ ​​2,250.00
​GBP
​​​1,775.00 ​
​CHF
​2,715.00 ​
​DKK
​16,750.00 ​
​NOK
​17,403.00 ​
​SEK
​​​ 20,582.00 ​
​Russia
​RUB
​​118,456.00 ​
Australia, Christmas Island, Cocos (Keeling) Islands, Heard Island and McDonald Islands, Kiribati, Nauru, Norfolk Island, Tuvalu​
AUD
3,000*
* No change to AX BRL Business Essentials 
New Zealand, Cook Islands, Niue, Tokelau​
NZD
​3,900.00
​China
​RMB
​19,500.00
​Japan
​JPY
​​300,000.00
​Bahrain, Iraq, Israel, Jordan, Kuwait, Lebanon, Oman, Palestinian Authority, Qatar, Saudi Arabia, United Arab Emirates, Yemen
USD
3,000.00
​2,700.00
​Afghanistan, Albania, Armenia, Azerbaijan, Bangladesh, Belarus, Bhutan, Bosnia and Herzegovina, British Indian Ocean Territory, Brunei, Cambodia, Fiji Islands, Georgia, Hong Kong SAR, Indonesia, Kazakhstan, Kyrgyzstan, Laos, Macao SAR, Macedonia, Malaysia, Maldives, Micronesia, Moldova, Mongolia, Montenegro, Myanmar, Nepal, Pakistan, Palau, Papua New Guinea, Philippines, Pitcairn Islands, Samoa, Serbia, Singapore, Solomon Islands, South Korea, Sri Lanka, Taiwan, Tajikistan, Thailand, Timor-Leste, Tonga, Turkey, Turkmenistan, Ukraine, Uzbekistan, Vanuatu, Vietnam, Wallis and Futuna
​USD
3,000.00
​2,100.00
​India
​INR
​134,970.00​
​108,600.00
​Algeria, Angola, Benin, Botswana, Burkina Faso, Burundi, Cameroon, Cape Verde, Central African Republic, Chad, Comoros, Congo, Congo (DRC), Côte d'Ivoire, Djibouti, Egypt, Equatorial Guinea, Eritrea, Ethiopia, French Polynesia, Gabon, Gambia, The, Ghana, Guinea, Guinea-Bissau, Kenya, Lesotho, Liberia, Libya, Madagascar, Malawi, Mali, Mauritania, Mauritius, Morocco, Mozambique, Namibia, New Caledonia, Niger, Nigeria, Rwanda, Sao Tomé and Príncipe, Senegal, Seychelles, Sierra Leone, Somalia, South Africa, Swaziland, Tanzania, Togo, Tunisia, Uganda, Western Sahara, Zambia, Zimbabwe
​USD
3,000.00
​1,800.00
​Anguilla, Antarctica, Antigua and Barbuda, Argentina, Aruba, Bahamas, Barbados, Belize, Bolivia, Brazil, British Virgin Islands, Chile, Colombia, Costa Rica, Dominica, Dominican Republic, Ecuador, El Salvador, Falkland Islands (Islas Malvinas), Grenada, Guatemala, Guyana, Haiti, Honduras, Jamaica, Mexico, Montserrat, Netherlands Antilles, Nicaragua, Panama, Paraguay, Peru, Saint Kitts and Nevis, Saint Lucia, Saint Vincent and the Grenadines, South Georgia and the South Sandwich Islands, Suriname, Trinidad and Tobago, Turks and Caicos Islands, Uruguay, Venezuela​​
​USD
​2,413.00​​​
​​1,800.00


Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Saturday, December 12, 2015

Symbol menu is back with Cumulative update 2 for Microsoft Dynamics NAV 2016

As I mention in one of my previous blog posts, Symbol menu was not functioning properly in the Dynamics NAV 2016 Development Environment (Initial release and CU1).

Even though I was over the moon with the new Development Environment and its new features, at the same time I was somewhat disappointed with lacking of Symbol menu. Most of us was used to use Symbol menu and lacking of it makes us disappointed. 

However Microsoft has identified this as a bug and they have fixed it in the CU2 (Build 43897).

Thank you Microsoft for fixing this issue. 

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Thursday, December 10, 2015

Cumulative update 2 for Microsoft Dynamics NAV 2016 has been released (Build 43897)

Cumulative Update 2 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016.
The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see 

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions: 
  • AU – Australia 
  • AT – Austria 
  • BE – Belgium 
  • CH – Switzerland 
  • CZ – Czech Republic 
  • DE – Germany 
  • DK – Denmark 
  • ES – Spain 
  • FI – Finland 
  • FR – France 
  • IS – Iceland 
  • IT – Italy 
  • NA – North America 
  • NL – Netherlands 
  • NO – Norway 
  • NZ – New Zealand 
  • RU – Russia 
  • SE – Sweden 
  • UK – United Kingdom 
Where to find Cumulative Update 2
You can download the cumulative update from KB 3121038 – Cumulative Update 2 for Microsoft Dynamics NAV 2016 (Build 43897). 

Warning
Before you install a cumulative update in a production environment, take the following precautions: 
  1. Test the cumulative update in a non-production environment. 
  2. Make a backup of the system or computer where the cumulative update is to be installed. 
Additional Information
For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2016 Cumulative Update

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2016

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Tuesday, December 8, 2015

Cumulative Update 14 for Microsoft Dynamics NAV 2015 has been released (Build 43887)

Cumulative Update 14 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015.
The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see 

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions: 
  • AU – Australia 
  • AT – Austria 
  • BE – Belgium 
  • CH – Switzerland 
  • CZ – Czech Republic 
  • DE – Germany 
  • DK – Denmark 
  • ES – Spain 
  • FI – Finland 
  • FR – France 
  • IS – Iceland 
  • IT – Italy 
  • NA – North America 
  • NL – Netherlands 
  • NO – Norway 
  • NZ – New Zealand 
  • RU – Russia 
  • SE – Sweden 
  • UK – United Kingdom 

Note: You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than Cumulative Update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

Note: To enable customized translation of profiles, a number of actions are now available on the Profile List page. You can export and import resource files to enable translation for one or more profiles. The steps to install and uninstall language modules have also been modified. For more information, see How to: Install Language Modules, How to: Uninstall Language Modules, and How to: Export, Edit, and Import Translated Profile Strings in Help for Microsoft Dynamics NAV. 

Where to find Cumulative Update 14
You can download the cumulative update from KB 3121037 – Cumulative Update 14 for Microsoft Dynamics NAV 2015 (Build 43887). 

Warning
Before you install a cumulative update in a production environment, take the following precautions: 
  1. Test the cumulative update in a non-production environment. 
  2. Make a backup of the system or computer where the cumulative update is to be installed. 
Additional Information
For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2015 Cumulative Update
For information about how to work around a recent process change, see How to Get Back the ‘Hotfix Directories’ from NAV 2015 Cumulative Update 1
For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2015

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Cumulative Update 26 for Microsoft Dynamics NAV 2013 R2 has been released (Build 43896)

Cumulative Update 26 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2.
The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see 

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions: 
  • AU – Australia 
  • AT – Austria 
  • BE – Belgium 
  • CH – Switzerland 
  • CZ – Czech Republic 
  • DE – Germany 
  • DK – Denmark 
  • ES – Spain 
  • FI – Finland 
  • FR – France 
  • IS – Iceland 
  • IT – Italy 
  • NA – North America 
  • NL – Netherlands 
  • NO – Norway 
  • NZ – New Zealand 
  • RU – Russia 
  • SE – Sweden 
  • UK – United Kingdom 
Where to find Cumulative Update 26
You can download the cumulative update from KB 3121033 – Cumulative Update 26 for Microsoft Dynamics NAV 2013 R2 (Build 43896). 

Warning
Before you install a cumulative update in a production environment, take the following precautions: 
  1. Test the cumulative update in a non-production environment. 
  2. Make a backup of the system or computer where the cumulative update is to be installed. 
Additional Information
For more information about cumulative updates for this version, see Announcement of update rollups for Microsoft Dynamics NAV 2013 R2
For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2013 R2

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages: 

CustomerSource: 

PartnerSource 

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Cumulative Update 33 for Microsoft Dynamics NAV 2013 has been released (Build 43894)

Cumulative Update 33 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013.
The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see 

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions: 
  • AU – Australia 
  • AT – Austria 
  • BE – Belgium 
  • CH – Switzerland 
  • DE – Germany 
  • DK – Denmark 
  • ES – Spain 
  • FI – Finland 
  • FR – France 
  • IS – Iceland 
  • IT – Italy 
  • NA – North America 
  • NL – Netherlands 
  • NO – Norway 
  • NZ – New Zealand 
  • SE – Sweden 
  • UK – United Kingdom 

Where to find Cumulative Update 33
You can download the cumulative update from KB 3121031 – Cumulative Update 33 for Microsoft Dynamics NAV 2013 (Build 43894). 

Warning
Before you install a cumulative update in a production environment, take the following precautions: 
  1. Test the cumulative update in a non-production environment. 
  2. Make a backup of the system or computer where the cumulative update is to be installed. 
Additional Information
For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2013.

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages: 

CustomerSource: 

PartnerSource: 

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Sunday, November 8, 2015

Cumulative Update 32 for Microsoft Dynamics NAV 2013 has been released (Build 42948)

Cumulative Update 32 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013.
The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see 

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:
  • AU – Australia 
  • AT – Austria 
  • BE – Belgium 
  • CH – Switzerland 
  • DE – Germany 
  • DK – Denmark 
  • ES – Spain 
  • FI – Finland 
  • FR – France 
  • IS – Iceland 
  • IT – Italy 
  • NA – North America 
  • NL – Netherlands 
  • NO – Norway 
  • NZ – New Zealand 
  • SE – Sweden 
  • UK – United Kingdom 
Where to find Cumulative Update 32 
You can download the cumulative update from KB 3106086 – Cumulative Update 32 for Microsoft Dynamics NAV 2013 (Build 42948). 

Windows 10
The NAV team is proud to announce that with this cumulative update, Microsoft Dynamics NAV 2013 is compatible with Windows 10.

Warning
Before you install a cumulative update in a production environment, take the following precautions:
  1. Test the cumulative update in a non-production environment. 
  2. Make a backup of the system or computer where the cumulative update is to be installed. 
Additional Information
For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2013.

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages: 

CustomerSource: 

PartnerSource: 

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Cumulative Update 25 for Microsoft Dynamics NAV 2013 R2 has been released (Build 43391)

Cumulative Update 25 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2
The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see 

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions: 
  • AU – Australia 
  • AT – Austria 
  • BE – Belgium 
  • CH – Switzerland 
  • CZ – Czech Republic 
  • DE – Germany 
  • DK – Denmark 
  • ES – Spain 
  • FI – Finland 
  • FR – France 
  • IS – Iceland 
  • IT – Italy 
  • NA – North America 
  • NL – Netherlands 
  • NO – Norway 
  • NZ – New Zealand 
  • RU – Russia 
  • SE – Sweden 
  • UK – United Kingdom 
Where to find Cumulative Update 25
You can download the cumulative update from KB 3106087 – Cumulative Update 25 for Microsoft Dynamics NAV 2013 R2 (Build 43391).

Warning
Before you install a cumulative update in a production environment, take the following precautions:
  1. Test the cumulative update in a non-production environment. 
  2. Make a backup of the system or computer where the cumulative update is to be installed. 
Additional Information
For more information about cumulative updates for this version, see Announcement of update rollups for Microsoft Dynamics NAV 2013 R2.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2013 R2

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages: 

CustomerSource: 

PartnerSource:

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara