Tag

SQL Server

May 14, 2019 SQL Server

SQL Alerts with HTML email body

This #TipTuesday post is about some SQL code I'm using in SQL Agent job alerts to get more information in a more readable format in my email notifications.

Mar 04, 2019 SQL Server Development

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.

Mar 03, 2019 SQL Server Development

Fun with XML, part 4

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.

Mar 02, 2019 SQL Server Development

Fun with XML, part 3

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.

Mar 01, 2019 SQL Server Development

Fun with XML, part 2

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.

Feb 27, 2019 SQL Server Development

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. 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.

Dec 20, 2018 Dynamics GP SQL Server

Clear Companies script & custom tables

This post is about the Clear Companies script provided by Microsoft to remove companies that no longer exist in a given environment, and an issue I ran into with a conflict in a custom table.

Aug 28, 2018 Dynamics GP SQL Server

GP Utilities user permissions

This post is about the user permissions in GP Utilities, and what the minimum setup required is for a user who is just doing Dynamics GP workstation installs.

Aug 21, 2018 SQL Server

Start/Stop SQL by Batch File

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.

Jul 24, 2018 SQL Server

SSRS 2016 Report Builder Permissions

This #TipTuesday post is about Report Builder permissions in SQL Server Reporting Services 2016.

Success! Your account is fully activated, you now have access to all content.

Error! Stripe checkout failed.

Success! Your billing info is updated.

Error! Billing info update failed.