Strange behaviour loxone miniserver and intercom

  • December 27, 2017
  • 0 Comments

Since a couple of weeks I started noticing strange behaviour with my loxone miniserver and related devices. My intercom keeps looping old images when checking the images in “last activity” The web interface stopped working, but the iPad/iPhone app works fine No program updates are accepted. The interface shows no errors, but when executing “load […]

Poor man’s weather station

  • December 21, 2017
  • 0 Comments

I found the blog below Some years ago while looping for a alternative for the weather services of Loxone http://www.sinnema.ch/?p=392.

Finding User Sessions from SPID in Dynamics AX 2012

  • October 20, 2017
  • 0 Comments

While check issues it could be usefull to make the link between the Ax user and the related SQL session. In the post below it is explained properly how you should do this. https://community.dynamics.com/ax/b/axfaqblog/archive/2016/08/27/disable-and-enable-users-in-ax-using-t-sql-scripts

Creating a SQL user with consistent SID in all environment

  • October 13, 2017
  • 0 Comments

When you add a SQL user with the same user ID’s manually on several environments you will see that after a restore this user has no permissions when he tries to acces that database although he seems to be present when you check the SQL properties. The explication is simple, the SID for that user […]

Check SQL running processes

  • October 6, 2017
  • 0 Comments

If you want to check the processes running on your SQL server you can find all the info you need in sys.dm_exec_requests. SELECT command, s.text, start_time, percent_complete, CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + ‘ hour(s), ‘ + CAST((DATEDIFF(s,start_time,GetDate())%3600)/60 as varchar) + ‘min, ‘ + CAST((DATEDIFF(s,start_time,GetDate())%60) as varchar) + ‘ sec’ as running_time, CAST((estimated_completion_time/3600000) as varchar) + ‘ […]

Check SQL last back-date

  • September 29, 2017
  • 0 Comments

If you want to check in SQL when your databases was last back-upped (+ the type of back-up), you can execute the script below. this will list you everything of the last 7 days. SELECT CONVERT(CHAR(100), SERVERPROPERTY(’Servername’)) AS Server, msdb.dbo.backupset.database_name, msdb.dbo.backupset.backup_start_date, msdb.dbo.backupset.backup_finish_date, msdb.dbo.backupset.expiration_date, CASE msdb..backupset.type WHEN ‘D’ THEN ‘Database’ WHEN ‘I’ THEN ‘Differential database’ WHEN […]

Check SQL last restore-date

  • September 29, 2017
  • 0 Comments

If you want to check in SQL when your databases was last restored, you can execute the script below. SELECT [rs].[destination_database_name] , [rs].[restore_date] , [bs].[backup_start_date] , [bs].[backup_finish_date] , [bs].[database_name] AS [source_database_name] , [bmf].[physical_device_name] AS [backup_file_used_for_restore] FROM msdb..restorehistory rs INNER JOIN msdb..backupset bs ON [rs].[backup_set_id] = [bs].[backup_set_id] INNER JOIN msdb..backupmediafamily bmf ON [bs].[media_set_id] = [bmf].[media_set_id] ORDER […]

Working with numbersequences – new NumberSequence

  • September 22, 2017
  • 0 Comments

A few years a go I made a few posts about numbersequences, in these posts I forgot to mention that you need to execute the following job before you can find your new created Numbersequence. static void NumberSeqLoadAll(Args _args) { NumberSeqApplicationModule::loadAll(); }static void NumberSeqLoadAll(Args _args) { NumberSeqApplicationModule::loadAll(); }

Maximize a form in Ax

  • September 15, 2017
  • 0 Comments

Change the properties width = ‘column width’ and height = ‘column height’ on the form. Add the following code in the run-method of the form: #WinApi ; super(); WinApi::showWindow(this.hWnd(), #SW_SHOWMAXIMIZED);#WinApi ; super(); WinApi::showWindow(this.hWnd(), #SW_SHOWMAXIMIZED);