SQL Script

Business Central Onpremise – Create SQL Missing Indexes from AL

3 min read

• #DYN365BC
• AL
• Business Central
• Indexes
• SQL Script

Business Central Onpremise – Create SQL Missing Indexes from AL

rs 01/08/2023

Through the page 9521 Database Missing Indexes it is possible to see the missing indexes suggested by...

Read More

SQL – Search for special characters

1 min read

• #DYN365BC
• #DYNDEV365
• Query and Views
• Special Char
• SQL Script

SQL – Search for special characters

rs 27/09/2022

Sometimes it may happen that by importing data from external sources (even with Web Services), some special...

Read More

GDPR, NAV Data discovering from SQL Server, Part I

3 min read

• GDPR
• NAV Tips
• SQL Script
• SQL Scripts

GDPR, NAV Data discovering from SQL Server, Part I

rs 03/04/2018

GDPR, NAV Data discovering from SQL Server, Part I Hi people, The GDPR deadline is approaching! …for...

Read More

NAV 2013 SQL Query Codeunit Tool (SQL From NAV Part II)

2 min read

• .NET
• NAV 2013
• NAV 2015
• NAV 2016
• SQL 2016
• SQL Script
• T-SQL

NAV 2013 SQL Query Codeunit Tool (SQL From NAV Part II)

rs 27/07/2016

NAV 2013 SQL Query Codeunit tool i found this nice demo tool by Dynamic Manufacturing Solutions on...

Read More

Automate backup on SQL Express and Send Mail Powershell Script

1 min read

• SQL Script
• SQL Scripts
• SQL Server

Automate backup on SQL Express and Send Mail Powershell Script

rs 05/07/2016

235 download on Technet…

Read More

“HOW TO RESET” NAV “BAD” USER

2 min read

• General
• NAV 2013
• NAV 2015
• NAV 2016
• SQL Script
• SQL Scripts

“HOW TO RESET” NAV “BAD” USER

rs 10/03/2016

  “HOW TO RESET” NAV “BAD” USER If you have some issues with NAV single user (ex;...

Read More

sp_whopro™ – SQL Server Activity Monitoring and Logging Stored Procedure

1 min read

• SQL Script
• SQL Server ALL

sp_whopro™ – SQL Server Activity Monitoring and Logging Stored Procedure

rs 22/02/2016

sp_whopro™ – SQL Server Activity Monitoring and Logging Stored Procedure Great SQL Script ! Source: SQLDownload Download

Read More

SQL Sessions Killer 2.0

2 min read

• SQL Script

SQL Sessions Killer 2.0

rs 13/10/2015

SQL Sessions Killer 2.0 If you have some issues about “there are no more NAV license availables.....

Read More

Automate backup on SQL Express and Send Mail Powershell Script

1 min read

• SQL Backup
• SQL Script

Automate backup on SQL Express and Send Mail Powershell Script

rs 22/09/2015

Sql Server Backup Automation and send-email Solution to automate backup on SQL Express and send mail based...

Read More