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


Improve SQL Performance

by Derek Du

Recently, we were asked to improve the performance of some SQL queries that run for 15 seconds and 30 seconds. At first, we were not sure whether the performance could be improved, given that there were about 80 million data pieces in the database. I have to admit that SQL Server is really powerful as eventually we reduced the time to 2 seconds and 6 seconds!

During the proces...

Read More »

On April 30, 2015 in Development [Post:by] Comment 0
Tagged With: SQL performance, SQL Server, trouble shooting / 3814 Views

Paging Data for SQL Server

by Jacky Xu

Before a new version of SQL server is released, we always implement data paging through the transact-SQL function “ROW_NUMBER” and it always needs a nested SQL script. Microsoft released new scripts “OFFSET” and “FETCH” for data paging functions. Here are two sample queries for different SQL server version paging function.

First, we query all dat...
Read More »

On February 9, 2015 in Development [Post:by] Comment 0
Tagged With: offset script, fetch script, Microsoft, SQL server / 2665 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 / 2673 Views

User Already Exists in the Current Database – Orphaned Users in SQL Server

by Derek Du

Today, when moving databases via backup and restoring, I had an issue of re-creating User Mappings on the new databases. An error, “User Already Exists in the Current Database,” prevents me from adding any mapping to the existing databases. Below is a solution:
This script shows the existing users of the selected database:
EXEC sp_change_users_login ‘Repor...
Read More »

On May 28, 2014 in Development [Post:by] Comment 0
Tagged With: SQL server / 2253 Views

Export Data with SSIS, Part 2

by Sheila Zhang
In a previous blog, I started explaining how to perform complex data transfers. When you need to manipulate the source data much to fit the destination -- such as the ETL process (extract – transform – load) -- you can use SSDT (SQL Server Data Tool) to develop a SSIS solution.
The development language of SSIS is different from other development languages that need you ...
    Read More »

    On April 23, 2014 in Development [Post:by] Comment 0
    Tagged With: export data, SSDT, SQL server, visual studio / 2688 Views

    Top Articles for the Week of March 14, 2014

    by Kristi Feng
    Here are the three most interesting articles I read this week:
    1.  8 Enhancements you can find in Sage CRM 2014 R1 
    Find out the 8 key Sage CRM builder enhancements and how these enhancements make building custom entities and business modules easier.

    2.  Applying The Scientific Method to SQL Server Performance Tuning 
    Approach SQL performance tuning from the s...
    Read More »

    On March 14, 2014 in General [Post:by] Comment 0
    Tagged With: Sage 300 ERP, Sage CRM, SQL Server / 1926 Views

    Using Windows Functions in SQL Server

    by Emma Tsai
    As a business analyst, I not only work with clients to get the requirements, but also perform functional testing for software applications. Sometimes, I need to work with SQL server to do database query and compare the results while testing. Recently, I found using Windows functions to perform data analysis computations in SQL server is pretty handy.
    Basically, Windows aggregate funct...
    Read More »

    On March 10, 2014 in Development [Post:by] Comment 1
    Tagged With: Windows, application development, SQL server / 2223 Views

    Web Application ROI Testing Tool

    By Emma Tsai

    For the past few weeks, I introduced some integration solutions we created for our clients and gave a high-level overview about how these different applications work together and how the user interface looks. In addition to system integration, we also have strong web application development techniques and experience.   
    This ROI (Return on Investment) tool we developed for ...
    Read More »

    On July 26, 2013 in Success Stories , Web application [Post:by] Comment 0
    Tagged With: web application, .NET Framework 4.0, IIS 7, SQL Server, web development / 2020 Views

    Making .Net Work with SQL Server Reporting Service

    By Jacky Xu
    Recently, we have a project that needed to print a report through SQL server reporting service. It’s my first time to work on the SQL server reporting service, so I had to spend some time researching this. I think reporting service is a great tool to show reports, and easy to use. Below are some steps to print reports:
    1. Create a new Windows Form solution in VS2010.
    2.&n...
    Read More »

    On June 24, 2013 in Development [Post:by] Comment 1
    Tagged With: SQL Server, .Net, SQL server reports, Windows Forms / 3052 Views

    Which Port is SQL Server Instance Using?

    By Derek Du
    When dealing with firewalls, you must have a clear understanding of which port your application is using.
    Today I took it for granted that a SQL Server named instance such as \SQLEXPRESS is sharing the same 1433 port with the default SQL Server instance. Later after I found out it didn’t work, it finally occurred to me that two processes cannot listen to the same port.
    Anyways...
    Read More »

    On June 18, 2013 in Development [Post:by] Comment 0
    Tagged With: Named Instance, Port, SQL Express, SQL Server / 2058 Views

    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.