Home
»
Microsoft Dynamics GP
»
Microsoft Dynamics GP DBA
»
All Tags
»
DBA
»
Dynamics GP
»
SQL Code
Browse by Tags
Application Management
BI & Reporting
CBI
Code
Consolidated Business Intelligence
Data Warehouse
Dynamics
Dynamics GP SQL Performance
Dynamics GP Users Group
EDW
Enterprise Data Warehouse
Errors
FYI
GP
GPUG SIG - DBA
Maintenance
Microsoft
Microsoft Dynamics GP
Payroll
Performance
Reporting
SQL
SQL Administration
SQL Maintenance
SQL Server
Related Posts
Blog Post:
Cleaning up after a Payroll Error
John Lowther
If during the Payroll Process the Payroll Clerk gets an error to the effect of "an Open Operation error, a Get/Change error, or a Save Operation error " Then give these scripts a try: --Find let us find out where the error actually is: -- I like to know what I am about to delete! Select * From...
on
20 Aug 2012
Blog Post:
Alerts: 401k Setup
John Lowther
For years I have been writing alerts to let either myself of someone else know that there is a problem somewhere so that it can be fixed before it becomes a major issue. Now, over the years I have boiled my alerts down into a few generic types. And while I will keep you guessing as to the types of alerts...
on
18 Jul 2012
Blog Post:
SQL Script for Account Level Security - Developing for Dynamics GP - Site Home - MSDN Blogs
John Lowther
Check out Sivakumar's post on SQL Script for Account Level Security till later,
on
13 Jul 2012
Blog Post:
Deadlocks caused by Implicit Conversion
John Lowther
Sans SQL has a good post on how implicit Conversion can call deadlocks in SQL Server. Check out their post at Sans SQL: Deadlock - Implicit Conversion I would also like to thank Vaidy for letting us know about this in his post Implicit Conversions Causing Deadlocks in SQL Server . Till later,
on
29 Jun 2012
Blog Post:
Using Lookups in GP Reports Viewer to make parameter selection more user friendly | Victoria Yudin
John Lowther
Victoria Yudin takes a look at using data lookup as parameters for reporting. See her post for details Using Lookups in GP Reports Viewer to make parameter selection more user friendly till later,
on
31 May 2012
Blog Post:
Problem with SQL Server 2008 and Exchange 2010
John Lowther
First please keep in mind that I know almost nothing about Exchange or how it works. The parts about Exchange that I will be discussing I am just paraphrasing from my Exchange Server Admin. Here is what happened: For years we have been using Exchange 2003 with no problems. And for years I have had SQL...
on
23 Apr 2012
Blog Post:
Some great scripts that I recently found
John Lowther
A few days ago I was searching for something and ran across this post from Jivtesh Singh . One of the scripts that he points out is a post from Mariano Gomez and lets you search for all tables for columns with the same name. Another one is a stored procedure to search the entire database for a specific...
on
10 Apr 2012
Blog Post:
Script History Table and Procedures
John Lowther
As I do a lot of Data Warehousing I am always concerned that the data warehousing process itself could possibly impact performance. In order to track the various data warehousing procedures and insure that they do not harm performance I came up with the idea of having a table that each procedure would...
on
21 Feb 2012
Blog Post:
Resetting the users passwords after updating your test system
John Lowther
Ok, when you have multiple test servers and you have to refresh them more than just once in a while, or if you only have one test server but lots of users, resetting everyone’s password can become a pain point fairly fast. Now, mind you, I actually do like the way Dynamics GP handles security....
on
17 Feb 2012
Blog Post:
Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) - Step 6
John Lowther
Ok, now that I gotten a few unrelated things out of the way, where was I? Oh yeah, getting data from my application databases into a single Stage 1 database. Now if you can remember back on Step 3 , I had created a single stored procedure named sjp_ImportData. That stored procedure was the one that...
on
3 Dec 2011
Blog Post:
Synchronizing Dynamics GP Test Databases from your Production System
John Lowther
I was replying to an email when it hit me that this information would probably help a lot of other people as well as the person I was replying to, so how about posting it instead. The question was how to keep multiple test servers synchronized with Production information. Now, reasons for having...
on
29 Sep 2011
Blog Post:
Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) - Step 5
John Lowther
Before I start going into code, please allow me to explain a few details about my system. I have four company databases that I want to merge into one. I also want to take some tables and merge them into a single table. In addition, I want to do all of this without affecting the performance of Dynamics...
on
22 Aug 2011