Browse by Tags

Related Posts
  • Blog Post: Some things that I ran across today

    As I was searching the web this evening here’s a few things that I ran across. Of course this list is not inclusive nor is it in any peculiar order. From Victoria Yudin SQL view for Dynamics GP open year GL trial balance From GP2TheMAX Need to upgrade your Excel skills? Not sure where to start? Cal-Tex...
  • Blog Post: SQL view for SOP sales by customer by month

    Victoria is at it again! Check out SQL view for SOP sales by customer by month . Till Later,
  • Blog Post: Deprecated Database Engine Features in SQL Server 2012

    I do not know if everyone has seen this but you really should go take a look! You can find it here ==> Deprecated Database Engine Features in SQL Server 2012 Now, for me there is not too many things that list that make that much of a difference to me. Things change, that is life. The only constant...
  • 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: 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: 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: Dynamics GP SOP line items with serial numbers and comments

    Victoria shows us how to  get the Dynamics GP SOP line items with serial numbers and comments 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: In Recovery... | Using fn_dblog, fn_dump_dblog, and restoring with STOPBEFOREMARK to an LSN

    Paul Randal digs into how to recover from someone dropping a table in your database. Read all about here In Recovery... 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: 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: 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 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...
  • Blog Post: Searching for Data (updated)

    Now that I have finally gotten rid of my final SQL 2000 Server, I have updated my Data Search Script to take advantage of the VARCHAR(Max) data type. No more tables that is too wide for the @SQL variable. If you still have a SQL 2000 Server my old post is here . Here is the updated script: ...
  • Blog Post: Synchronizing Dynamics GP Test Databases from your Production System

    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...
  • Blog Post: Using "Select *" in code examples on my blog post

    A friend of mine pointed out that I really should not be using "*" in select statements and leaving out field names in Insert statements and that by doing so it might lead someone into bad habits, so I thought I would post this for everyone's understanding. As you may have noticed I...
  • Blog Post: Getting Data from Point A to Point B - Introduction

    As I write my series on Creating an EDW for CBI I realized that I really needed to go into much more detail on getting data from Point A to Point B than that series allowed. So in this series I will concertrate only on that one small aspect of the different ways of getting data from one table to another...
  • Blog Post: Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) - Step 5

    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...
  • Blog Post: Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) - Step 3

    Ok, now let us start moving some data around. I have looked at multiple ways of moving data everything from replication, log shipping, SSIS, and various others to writing T-SQL. However, as I am a T-SQL kind of guy and I really want the finite granular control that writing my own SQL scripts will give...
  • Blog Post: Searching for data

    (Notice: I have updated this script for SQL 2008 the new post with the new code is here .) I have no clue where I found this piece of code, how many years ago it was, if I wrote it or if I got it from someone else, but when I cannot find where in a database something is this SQL script has never...