Skip to content
Roberto Stefanetti Blog – Microsoft MVP and MCT

Roberto Stefanetti Blog – Microsoft MVP and MCT

Dynamics 365 Business Central Blog

  • About
  • Channels
  • Interviews
  • MCT Courses – Academy
  • My Books
  • Privacy

SQL Scripts

SQL Scripts SQL Server 

Detect Deadlocks in old NAVs

11 April 2018 rs 1 Comment Deadlocks, Locks, OLD NAV

Detect Deadlocks in old NAVs (<2017) In old NAV releases (between NAV 2013 and NAV 2016) is very difficult to

Read more
GDPR NAV Tips SQL Script SQL Scripts 

GDPR, NAV Data discovering from SQL Server, Part I

3 April 2018 rs 0 Comments NAV Data Discoverer

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

Read more
General SQL Scripts 

SQL Monitor

18 September 2017 rs 1 Comment Monitor, Performance, SQL Script, SQL Server, Tuning

SQL Monitor I’ve done a lot of NAV optimizations and sometimes it’s enough to isolate the bigger issues to get

Read more
License NAV 2015 NAV 2016 NAV 2017 NAV Server Sessions SQL Scripts 

“ALL ABOUT” Kill (In)active Sessions when “no more licenses”

15 January 20177 February 2019 rs 4 Comments .NET, Dynamics NAV, KILL, NAV Sessions, No more licenses, Session Killer, SQL Server, VB.NET

Sometimes it happens that there are “no more licenses available” for Dynamics NAV, from NAV 2013 R2 and next releases,

Read more
.NET C# General SQL Scripts SQL Server 

A Visual SQL Query Designer – Code project (SQL From NAV Part III)

1 August 2016 rs 0 Comments .NET Integration, Query, SQL

A Visual SQL Query Designer – Code Project (SQL From NAV Part III) If some of your customers asks you to

Read more
SQL Script SQL Scripts SQL Server 

Automate backup on SQL Express and Send Mail Powershell Script

5 July 2016 rs 0 Comments SQL

235 download on Technet… Post Views: 1,275

Read more
General NAV 2013 NAV 2015 NAV 2016 SQL Script SQL Scripts 

“HOW TO RESET” NAV “BAD” USER

10 March 2016 rs 0 Comments NAV User

  “HOW TO RESET” NAV “BAD” USER If you have some issues with NAV single user (ex; can’t login, permissions

Read more
Linked Tables SQL Scripts 

Some SQL date calculation scripts for NAV Linked Tables

9 January 2016 rs 0 Comments NAV

Some SQL date calculation scripts for NAV Linked Tables Dato che alcuni utilizzano le viste SQL come tabelle collegate in

Read more
Data Migration SQL Scripts 

NAV to NAV SQL Fast Data Migration (with dynamic “INSERT INTO” STATEMENT)

10 September 2015 rs 0 Comments

SCENARIO If you have some old NAV releases and you want to copy data fast from db\company to another db\company

Read more
SQL Scripts 

Script Search for a string in “all tables” of SQL Server Database

4 August 2015 rs 1 Comment NAV 2015, SQL Server

Good & Fast Script to search for a string in “all tables” of SQL Server Database, very useful with NAV Databases

Read more
  • ← Previous

DISCLAIMER

The views and opinions expressed in this blog are those solely of the author.

Follow me on socials

Trending

https://robertostefanettinavblog.com/wp-content/uploads/2022/01/RSB-VIDEO-2.mp4

Archives

Links

Blogroll
  • Alterna
  • Balazs’s Business Central Blog (HU)
  • Best NAV Blogs By Microsoft
  • Business Central Best World Resources
  • Demiliani Blog (MVP)
  • DUG (Dynamics User Group)
  • Ideas Portal
  • MIBUSO.COM
  • MSDYN365BC OnPrem. Cumulative Updates
  • My First NAV Blog (2007-2015)
  • My Github Page
  • My MVP Page (on Microsoft)
  • My Technet WIKI Page
  • NAVUG
  • Saurav Blog (MVP)
  • Tech Academy MSDYN365BC, 2002
  • Waldo Blog (MVP)
  • XAMARIN

Recent Posts

  • Business Central and Shopify Connector 24 May 2022
  • Export SQL data to CSV or XML File via Powershell 30 April 2022
  • Business Central from Directions NA, “Pictures are worth a thousand words..” 15 April 2022
  • Used and not used Objects in Business Central license 29 March 2022
  • Business Central: Performance & Data management tools recap 25 March 2022
  • Excel Layouts for reporting 6 March 2022
  • Dynamics 365 Business Central 2022 Wave1 (r.20) public preview is available 4 March 2022

Recent Comments

  • Constantin on Business Central: Send an appointment from Job Planning Line
  • Juan Miguel Cerezo on Typologies of Items in Business Central
  • Eneko on Business Central – The Cloud Data Migration Tool
  • Hein Kruger on Business Central Send Email with Multi Attachments
  • Darren Bezzant on Business Central SaaS Exporting Database Backup and Restore it on your Sql Server

RSS Dynamics Community Blogs

  • Solution for The Error: The system is not accessible | Dynamics NAV | Business Central 27 May 2022 Vidura Dananjaya
  • Overcoming Challenges to Integration 26 May 2022 ERP Software Blog
  • Top benefits of Business Central for Pharmaceutical Industry 26 May 2022 ERP Software Blog
  • Top 8 Reasons You Should Attend Solve My ERP Problems 26 May 2022 ERP Software Blog
  • New features for QlikView and Qlik NPrinting with May 2022 releases 26 May 2022 prismainformatik

Tag

#DYNDEV365 #MVPBUZZ 365 Business Central AL AL Code APIs APP BC BC OnPremise Blog & News Business Central Business Central Cloud Business Central SaaS Cloud Cumulative Update Development Directions EMEA Docker DYN365BC Dynamics 365 Business Central Dynamics NAV Events Integration Microsoft Microsoft AL MSDYN365 Release Wave 2 MSDYN365BC MVP NAV NAV 2015 NAV 2016 NAV 2017 NAV 2018 News News & Events Performance Powershell Preview Reports SaaS SQL Server VS Code Wave2 Web Services What's New

MSDYN365BC FORUM HOME

My Book – Implementing Business Central

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright © 2022 Roberto Stefanetti Blog – Microsoft MVP and MCT. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.
Welcome to Roberto Stefanetti Blog - Cookie Banner
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website.

Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent.

You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
SAVE & ACCEPT