A Visual SQL Query Designer – Code Project (SQL From NAV Part III) If some of your customers asks you to gain access to SQL data directly from NAV (as other systems with integrated […]
NAV 2013 SQL Query Codeunit tool i found this nice demo tool by Dynamic Manufacturing Solutions on Mibuso. Source http://mibuso.com/downloads/nav-2013-sql-query-codeunit nice tool, based on .NET integration (AD), usefull if you don’t like […]
Originally posted on Roberto Stefanetti NAV Blog:
Sql Server Backup Automation and send-email Solution to automate backup on SQL Express and send mail based on first Microsoft SQL BackupScript “sp_SQLBackupDatabases” Scheduling NB:…
sp_whopro™ – SQL Server Activity Monitoring and Logging Stored Procedure Great SQL Script ! Source: SQLDownload Download
Greg Larsen lists his top 10 SQL Server counters for maintaining database performance. Sorgente: Top 10 SQL Server Counters for Monitoring SQL Server Performance — DatabaseJournal.com Great post by Greg Larsen.
BOOST NAV – How to show most 50 heavy queries on SQL SERVER … very nice SQL Script to discover slow Sessions !! SQL SCRIPT SELECT TOP 50 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset […]