Transaction log backup

In this post, i want to populate good to know information about log backup in SQL Server.

Query to know the history of transaction log backup.

SELECT      bs.backup_start_date, bs.backup_finish_date, *
FROM        msdb..backupfile bf
JOIN        msdb..backupset bs ON bf.backup_set_id = bs.backup_set_id
WHERE       bf.File_Type = 'L'

OR using

select database_name, max(backup_finish_date)
from msdb..backupset
where type = 'L'
group by database_name

Detailed reference for above query : Link

How often we should take transaction log backup: Link

 Recover data from transaction log backup: Link

Import Export model Dynamics 365 for operations

Following model management commands i have tried on Demo VM downloaded from LCS, which i found working as per the expectations.

Export model in Dynamics 365 operations.
C:\AOSService\PackagesLocalDirectory\Bin>ModelUtil.exe -export -metadatastorepath=C:\AOSService\PackagesLocalDirectory -modelname="FleetManagement" -outputpath=c:\temp

Import model in Dynamics 365 operations.
C:\AOSService\PackagesLocalDirectory\Bin>ModelUtil.exe -import -metadatastorepath=C:\AOSService\PackagesLocalDirectory -file=C:\Test\XYZDevelopments.axmodel

Delete model in dynamics 365 operations.
C:\AOSService\PackagesLocalDirectory\Bin>ModelUtil.exe -delete -metadatastorepath=C:\AOSService\PackagesLocalDirectory -modelname="FleetManagement"

Object Server XX: Fatal SQL condition during login.

Message in event viewer on AOS server:

Object Server XX:  Fatal SQL condition during login. Error message: "The internal time zone version number stored in the database is higher than the version supported by the kernel (11/10). Use a newer Microsoft Dynamics AX kernel."

select * from SQLSystemVariables
WHERE PARM = 'SYSTIMEZONESVERSION'

Execute query above and check value in field "VALUE", it should look like image below. Please note that message in event viewer is helpful to update this value.

Event viewer message shows kernel (11/10) means current value is 11 and supported is 10, so here we need to update value to 10 using query below. - in your environment it can be 8/7 instead of 11/10 or it can be anything. I don't come across any MS documentation for the same. Please share your experience for the same error, does it works for you or have you solved by any other way.

update SQLSystemVariables set VALUE = 10
WHERE PARM = 'SYSTIMEZONESVERSION'

How to give authorization in fiddler

Fiddler: Set username and password for basic authentication

1. Open fiddler, click Tools->TextWizard.

2. Select checkbox of "To Base64"

3. Input your user name and password in top textbox such as

myUsername:myPassword

4. Go back to fiddler composer screen, below Host: line add line for Authorization as shown in image below.

Authorization: Basic bXlVc2VybmFSDlaAOaptOIeVBhc3N3b3J

https://XXX.YYY.ZZZ.AAA:4444/user/auth

User-Agent: Fiddler
Host: XXX.YYY.ZZZ.AAA:4444
Authorization: Basic bXlVc2VybmFSDlaAOaptOIeVBhc3N3b3J

Composer window should look like image below.

5. Hit execute.

6.Observe Result column on left side as well as Inspectors tab.

SQL Administration

I want to maintain this post to make my day to day SQL administration activities easy.

1. SQL always on demonstration. - Link
2. Tracking page split in detail - Link

Dynamics 365 for operations administration.

I want to maintain this blog post for purpose of dynamics 365 for operations administration tips and tricks.
This will consist of useful links from around the world to make administrator's life easy.

1. Dynamics 365 for operations, downloaded demo or development VHD default passwords - Link

Server remote login:

Username: local\Administrator

Password: pass@word1

SQL login (SSMS)

Username: axdbadmin 

Password: AOSWebSite@123

2. Database synchronizations using powershell

C:\AOSService\webroot\bin\Microsoft.Dynamics.AX.Deployment.Setup.exe -bindir "C:\AosService\PackagesLocalDirectory" metadatadir "C:\AosService\PackagesLocalDirectory" -sqluser "AOSUSER" -sqlserver "." -sqldatabase "AxDB" -setupmode "sync" -syncmode "fullall" -isazuresql "false" -sqlpwd "AOSWebSite@123"

3. Batch service exception/ Maintenance mode in Dynamics 365 operations - Link
Command: (Standard way)

C:\AOSService\PackagesLocalDirectory\Bin\Microsoft.Dynamics.AX.Deployment.Setup.exe –metadatadir C:\AOSService\PackagesLocalDirectory –bindir C:\AOSService\PackagesLocalDirectory –sqlserver . –sqldatabase axdb –sqluser AOSUser –sqlpwd AOSWebSite@123 –setupmode maintenancemode –isinmaintenancemode false

Using SQL query (Not verified!)

Update SQLSystemvariables set Value=0 where parm='CONFIGURATIONMODE'

4. Import license file  - Link

5. Deploy Dynamics 365 for operations environment into Azure - Link
This is good series of blog posts, to take you through deployment of various LCS environments. i.e. Development, Build and Test and Production environments.

6. Configure port forwarding. - Link

6. Install latest CU on local developer VM. - Link

All about dynamics 365 for operations extension

On this post, i will keep adding some useful links that you can refer while you are looking for options to extend any object/code in dynamics 365 Finance and operations.

Your suggestions are welcomed.

Customize startup - https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/extensibility/startup-customizations

Extend invent dim - https://blogs.msdn.microsoft.com/mfp/2017/12/22/extensible-product-dimension-sample-app/

Options for extensions - https://blogs.msdn.microsoft.com/mfp/2018/03/29/x-the-most-extensible-language-on-the-planet-2/

WHS extension - http://kashperuk.blogspot.com/2017/04/development-tutorial-link-extending.html

All options for extension - https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/extensibility/extensibility-home-page