Category: SQL Server

  • SQL Alerts with HTML email body

    Today’s #TipTuesday is a bit different from my normal type of post. In the course of monitoring some integrations, I wanted to change the emails I get when there are issues. What I inherited was email alerts with attachments, without any data that I could use as an Outlook filter to tell me if something… (continue >)

  • 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. (continue >)

  • 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. (continue >)

  • 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. (continue >)

  • 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. (continue >)

  • 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. (continue >)

  • Clear Companies script & custom tables

    ,

    This is a funny story… or funny now that I’ve figured out the problem I had earlier today. This story begins with a DEV/TEST environment for Dynamics GP where I was setting up some scripts to automate the process of restoring from PROD to DEV. I posted a blog article about this earlier this year… (continue >)

  • GP Utilities user permissions

    ,

    Today’s #TipTuesday post is about GP Utilities and what permissions are required. For those going through any service pack install or upgrade, there might be a lot of workstations that need to be updated! In our case, we just upgraded the Dynamics GP environment and wanted all hands on deck to help with installs, including… (continue >)

  • 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. (continue >)

  • SSRS 2016 Report Builder Permissions

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

  • Sample SQL Views for Smartlists

    ,

    Today’s #TipTuesday has been on my list for a while and it’s a great resource that many people don’t know exists. Microsoft has created a “living” document that has embedded links to SQL views that an admin can run and tweak in their Dynamics GP environment to create custom SmartLists. The document says it is… (continue >)

  • 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. (continue >)

  • Looking for special characters in SQL

    This post shows an example of a SQL script to look for special characters in a column. (continue >)