SQL Alerts with HTML email body
Learn how to configure SQL Server alerts to send email notifications with HTML formatting for better readability and presentation.
SQL Server
Development SQL Server
Fun with XML, the end
This is the 5th post in a 5-part series where I was building an XML file in SQL with Dynamics GP data and Extender data for T5 filing.
Development SQL Server
Fun with XML, part 4
This is the 4th post in a 5-part series about building an XML file in SQL with Dynamics GP data and Extender data for T5 filing.
Development SQL Server
Fun with XML, part 3
This is the 3rd post in a 5-part series about building an XML file in SQL with Dynamics GP data and Extender data for T5 filing.
Development SQL Server
Fun with XML, part 2
This is the 2nd post in a 5-part series about building an XML file in SQL with Dynamics GP data and Extender data for T5 filing.
Development SQL Server
Fun with XML, part 1
This is the 1st post in a 5-part series where I was building an XML file in SQL with Dynamics GP data and Extender data for T5 filing.
Dynamics GP SQL Server
Clear Companies script & custom tables
A post about the Clear Companies script, and how to deal with custom tables that may contain a company ID column.
Dynamics GP SQL Server
GP Utilities user permissions
Learn which SQL and Active Directory permissions are needed to run GP Utilities successfully and understand why each one matters.
SQL Server
Start/Stop SQL by Batch File
A post is about stopping and starting SQL Server services by batch file, for development or testing purposes.
SQL Server
SSRS 2016 Report Builder Permissions
This #TipTuesday post is about Report Builder permissions in SQL Server Reporting Services 2016.
SmartList & SmartList Builder SQL Server
Sample SQL Views for Smartlists
Learn how to create custom SQL views to enhance your Dynamics GP SmartLists with practical examples and step-by-step guidance.
SQL Server
Do you know when a SQL trigger is dropped?
This post is about SQL triggers and some tips to monitor them in case they get dropped during service pack installs or upgrades.
SQL Server
Looking for special characters in SQL
This post shows an example of a SQL script to look for special characters in a column.