CodePartners - Software Development - Dallas, Texas Software Development - Sage Accpac Customization - SageCRM Customization
Login
pay invoice online  |  remote assistance  |  
  • INTERNET APPLICATION DEVELOPMENT

    • Services
      • Web Application Development
      • Mobile Applications
      • Integration Solutions
      • Staff Augmentation
    • Technologies
    • How we work
    • About us
    • Success stories
    • Blog
  • MID MARKET ERP DEVELOPMENT

    • Intacct
    • Sage CRM
    • Sage
    • Sage Component Catalog
    • How We Work
    • About Us
    • Success Stories
    • Blog

Blog

CodePartners Blog

rss


Use Pivot Operator to Pivot Data

By Emma Tsai
Performing functional testing for software applications is part of the job as a business analyst. Occasionally, I need to work with SQL server to do database queries so that I can verify that the application pulls data results as expected. Recently, I learned how to use PIVOT operator to group and aggregate data in SQL database. Here is how it works:
In pivot queries, here are the thr...
Read More »

On August 27, 2014 in Development, Project Management, Web Development [Post:by] Comment 0
Tagged With: query, SQL, Pivot / 3289 Views

The Easiest Way to Test a SQL Server connection

by Derek Du

The other day I found an interesting way to test a SQL Server database connection. It is very easy, and quicker than what I usually do. For those of you who like moving pictures, here is a video tutorial.

To test a database connection, I usually make sure a port is open by using the Telnet command and then use a tool like SQL Command Line, or SQL Server Management Studio, ...
Read More »

On July 7, 2014 in Development, Project Management [Post:by] Comment 0
Tagged With: Test connection, SQL server, UDL file / 2720 Views

Customization Project for Sage CRM

by Emma Tsai

Recently, we provided staff augmentation services to a housing service company. We had a Sage CRM developer working on several CRM customization projects that support their special operational needs for their student housing account management. One of the most current projects is to pull the application information from their existing housing website and upload them to Sage CRM and t...
Read More »

On May 7, 2014 in Development, Project Management, Success Stories [Post:by] Comment 0
Tagged With: application development, customization, Sage CRM / 2261 Views

Sales and Project Management Using Intacct and Sage CRM, Part 2

by Hrayr Galoyan
In a previous blog post, I began explaining how to manage projects using Sage CRM and Intacct. Here are the next steps to take:

Step Three – Follow-up

In the most cases, clients let us know if they approve the project. The problem is, if the client decides to not proceed with the project, we usually don’t know about it, but the opportunity continues sitting in our ...
    Read More »

    On April 16, 2014 in Development, Integration, Project Management [Post:by] Comment 0
    Tagged With: Project Management, Sage CRM, Intacct / 2317 Views

    Sales and Project Management Using Intacct and Sage CRM, Part 1

    By Hrayr Galoyan
    At CodePartners, we literally handle hundreds of opportunities per year. In three years since I joined, I alone worked on over 750 opportunities, big and small. Some of them converted into projects, and some were lost, but all needed attention and had to be tracked. And I am only one of the team members, analyzing the requirements, designing solutions, sending out proposals, manag...
        Read More »

        On March 17, 2014 in Development, General, Project Management [Post:by] Comment 0
        Tagged With: Intacct, Project management, Sage CRM / 3315 Views

        Top Stories for the Week of March 7

        by Emma Tsai
        As a business analyst, my job includes gathering the requirements by collecting User Stories and writing the Use Case. People can easily get confused between User Story and Use Case, since they are pretty similar in the concept. Then how is a User Story different than a Use Case? “While a use case is highly structured and tells a story, the User Story sets the stage by stating t...
        Read More »

        On March 7, 2014 in Development, General, Project Management [Post:by] Comment 0
        Tagged With: use case, user story, product development, project mangaement / 2191 Views

        Overview of a Data Warehouse Logical Design - Schema

        by Sheila Zhang
        Databases designed for businesses typically focus on data manipulation. Normalized relational databases tend to increase the amount of tables, to reduce the space required for data storage, while being updated to reduce redundancy. For example: a customer table holds the customer ID and address information for each customer, and the sales order table only keeps the customer ID, not...
        Read More »

        On December 4, 2013 in Development, Project Management, Web application, Web Development [Post:by] Comment 0
        Tagged With: Data Warehouse, MSSQL, Schema / 8498 Views

        Business Partners Must Turn Their Lemons into Lemonade!

        by Brian Terrell
         
        About 10 years ago, mid-market ERP software publishers created software maintenance plans to finance ongoing research and development efforts. Publishers require a significant investment to update software to offer additional functions or support improved operating systems or databases. Several years ago, Sage eliminated the basic version of these plans and disrupted their ...
        Read More »

        On November 18, 2013 in Development, Products, Project Management, Web application, Web Development [Post:by] Comment 0
        Tagged With: CodePartners, Customization, Sage / 2500 Views

        Integrating Sage 300 ERP with Coupa

        by Hrayr Galoyan
        “What on earth is Coupa?" I asked myself this when I heard about Coupa for a recent project. I quickly learned Coupa is a procurement system designed for businesses to simplify purchasing and ensure the users’ interaction is easy and enjoyable, as if you are shopping on Amazon.com. Technology supposedly makes our lives easier and more enjoyable. However,...
        Read More »

        On October 23, 2013 in Development, Products, Project Management, Web application, Web Development [Post:by] Comment 1
        Tagged With: Accpac, AP invoices, Coupa, integration, procurement, purchasing, Sage, Sage 300 ERP / 4907 Views

        What Makes Software Development So Risky?

        by Brian Terrell 
        Often, I spend time with prospects or customers who intend to engage a software developer to automate a business process. No one considers this technology purchase trivial.  Buyers get nervous because they hear real horror stories from their peers, or the media, about the unending and ever more expensive projects. I agree that software development is risky, bu...
        Read More »

        On October 14, 2013 in Development, General, Integration, Project Management [Post:by] Comment 0
        Tagged With: Automation, Business Process, Success / 3617 Views
        123Next

        Search

        Categories

        • General (166) rss
        • Development (158) rss
        • Success Stories (40) rss
        • Products (29) rss
        • Uncategorized (18) rss
        • BTerrell Group (5) rss
        • Project Management (22) rss
        • Web Development (57) rss
        • Web application (33) rss
        • Integration (19) rss
        • Mobile Development (7) rss

        Archives

        • 2015
          • January (5)
          • February (7)
          • March (6)
          • April (5)
          • May (2)
        • 2014
          • January (13)
          • February (12)
          • March (13)
          • April (12)
          • May (11)
          • June (12)
          • July (11)
          • August (13)
          • September (10)
          • October (8)
          • November (6)
          • December (4)
        • 2013
          • April (73)
          • May (22)
          • June (20)
          • July (20)
          • August (22)
          • September (19)
          • October (13)
          • November (12)
          • December (7)

        Tags

        .NET Accpac app development application customization application development automation Azure C# cloud components Crystal Reports customization development ERP general ledger HTML5 Intacct Intacct Platform Services integration JQuery load balancer mass update mobile development OCR Order Entry outsourcing PO pricing product development project management REST Sage 300 ERP Sage CRM software integration trigger user interface Visual Studio web application web development website development Workforce Go! .NET ACA accpac Ajax Amazon AP invoices application development Arxis ASP.NET automation Axure BTerrell Group C# Cloud computing CodePartners Constant Contact credit card processing CRM crystal reports custom software Customer Service Customization Delete team project design phase Development doc-link DRILLDWNLK ERP event Excel GLAFS Intacct Intacct Advantage Intacct Platform Services Integration Java script JavaScript jQuery Kerr Consulting LinkedIn Microsoft MSSQL Offshoring outsourcing payroll PCI compliance PCI-DSS Pivot PJC project management sage Sage 300 Sage 300 ERP Sage Accpac ERP Sage CRM Smart Rule social media software testing SQL SQL Query SQL Server staff augmentation sub-ledger success success story TFS Trouble shooting UI design Visual Studio WCF Web API web application web design web development Webinar website Windows Windows Azure XML
        ABOUT US / CONTACT US / NEWS & EVENTS
        CodePartners / 17250 Dallas Parkway, Ste. 225 / Dallas, Texas 75248 / Phone: 214-647-2611 / Toll Free: 866-647-2611 / Fax: 214-647-2612 / info@codepartners.com
        © 2006 - 2015 codepartners.com All Rights Reserved.