SQL Server

SQL Alerts with HTML email body

2019-05-15

A #TipTuesday post about how to send a SQL Alert in email in HTML.

Fun with XML, the end

2019-03-05

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

2019-03-04

This is the 4th 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. In this post, I discuss file validation.

Development SQL Server

Fun with XML, part 3

2019-03-03

This is the 3rd 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. This post is about namespaces.

Development SQL Server

Fun with XML, part 2

2019-03-02

This is the 2nd 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. This post is about the “guts” of the SQL to create the XML.

Development SQL Server

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. This post is the intro and story on why I needed to do this and the trials and tribulations of my various efforts to get it working.

Dynamics GP SQL Server

Clear Companies script & custom tables

2018-12-21

A post about the Clear Companies script, used when refreshing a Dev or Test environment, and how to deal with custom tables that may contain a company ID column.

Dynamics GP SQL Server

GP Utilities user permissions

2018-08-29

A #TIpTuesday post about GP Utilities and what permissions are required and why.

SQL Server

Start/Stop SQL by Batch File

2018-08-21

This #TipTuesday post is about stopping and starting SQL Server services by batch file, something that is useful for those running a local SQL instance for development or testing purposes.

SQL Server