Browse by Tags

Related Posts
  • Blog Post: GPUG DBA SIG (2012 - 09 - 20) Voting for Topics

    All the request for our next webinar are in and the top three are ready for your votes and comments . You can register for the webinar here . till later,
  • Blog Post: Getting entire databases from one point to another.

    This is an addendum to the Getting Data from Point A to Point B series. When I first started this line of thought I was thinking more about SQL Queries, Triggers, etc.; however, as time when by I realized that there was an incredible need to get massive amounts of data from one place to another. ...
  • Blog Post: GPUG DBA SIG (2012 - 09- 20) Topic Request

    To enter your request for the list of topics to be voted on please take this quick three question survey located here . After the results are in I will post the list of general topics for everyone to vote for their favorite. You can register for the webinar here . till later,
  • Blog Post: Cleaning up after a Payroll Error

    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...
  • Blog Post: GP - Multiple Company Support in Single Database | Microsoft Connect

    Ever wanted needed multiple companies but wanted the advantages of a single database? Go here to vote on this item in Microsoft Connect ==> GP - Multiple Company Support in Single Database | Microsoft Connect till later,
  • Blog Post: How to use Word Mail Merge and Macros to Import Data - Developing for Dynamics GP - Site Home - MSDN Blogs

    I was nicely surprised on my GPUG DBA SIG webinar today when someone told me about a post from my friend David Musgrave on How to use Word Mail Merge and Macros to Import Data . Check it out! till later,
  • Blog Post: Alerts: 401k Setup

    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...
  • Blog Post: SQL Script for Account Level Security - Developing for Dynamics GP - Site Home - MSDN Blogs

    Check out Sivakumar's post on SQL Script for Account Level Security till later,
  • Blog Post: Notes on Performance for Microsoft Dynamics GP

    When it comes to the performance of Microsoft Dynamics GP one of my favorite links is to the  Optimizing and Maintaining Performance for Microsoft Dynamics GP 2010 white paper on Customer Source.  But rather than just downloading the file I keep a link to it because it is updated as new things...
  • Blog Post: Deadlocks caused by Implicit Conversion

    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,
  • Blog Post: Using Lookups in GP Reports Viewer to make parameter selection more user friendly | Victoria Yudin

    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,
  • Blog Post: Single Insert with Union versus Multiple Inserts

    This is an addendum to the Getting Data from Point A to Point B series. Wow, has it been that long since I first thought about writing this post? I wonder if work as many hours a week as I do has anything to do with that. J Anyway, as I promised longer ago that I care to admit, in this post we...
  • Blog Post: Rebooting because of an Automatic Update does interrupt SQL job execution.

    I am not sure where I got it from, if it was incorrect information, if it is just outdated information, or if it is one of those "It Depends" things. But I have always been under the impression that a reboot caused by automatic updates would not occur if the SQL Server was busy. However as...
  • Blog Post: Problem with SQL Server 2008 and Exchange 2010

    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...
  • Blog Post: Backing up the Tail of the Log

    One of the secrets to recovering that last piece of data that has changed since your last backup when disaster strikes is to backup the tail of the log. To find out multiple ways to backup the tail of the log when disaster strikes, check out this post from Pau Randall. In Recovery... | Disaster recovery...
  • Blog Post: Database Snapshots - Something's do not always work the way you think they should.

    While there are a lot of good things about database snapshots, and a lot of good reasons for using them. Under certain circumstances they can cause problems. In his Blog ( In Recovery ) Paul Randall goes over a bug when you are reverting back from a database snapshot. You can get all the details from...
  • Blog Post: Check Links and Reconcile

    So that you get this information as well please check out my post on the The Dynamics GP Administrator site. Till later,
  • Blog Post: Some great scripts that I recently found

    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...
  • Blog Post: Best Jobs in America 2011 - Money Magazine on CNNMoney

    Hey Folks, Considering that I wear multiple hats were I work, like most people these days, this years list of the Best Jobs in America does a person good. You can check out the Best Jobs in America for 2011 here: Best Jobs in America 2011 - Money Magazine on CNNMoney Till later & hope to see you...
  • Blog Post: Script History Table and Procedures

    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...
  • Blog Post: Resetting the users passwords after updating your test system

    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....
  • Blog Post: Where to put “my” stuff?

    It has been a while since my last post as I have been really busy, but as I sit here during an install staring at a blue bar slowly going across the screen, I might as well multitask. So, as a DBA we are constantly getting this stored procedure from here or that one from somewhere else, all of which...
  • Blog Post: Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) - Step 7 – Putting it all together.

    RECAP As the last post in this series, I wanted to recap and try to give a high level of what we wish to accomplish. If you remember on the first post we wanted to achieve two things, and that was not to hurt the performance of the Applications or of the BI Solution. In the second post , we...
  • Blog Post: Dynamics GP Appears Locked-Up or Not Responding

    Over the years I have had quite a few fellow users both where I work; and other companies as well, report to me that Dynamics GP locks up on them from time to time. And I myself have noticed that on occasion it initially appears  even to me that Dynamics GP is locked up. However, I have also discovered...
  • Blog Post: Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) - Step 6

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