Vision Binary

As developer, you may need to develop and maintain many SSIS packages included the SQL script. and it can be a frustrated job if you need to frequently trouble shooting the problems which are caused by different data quality issues. Those package has been running well and suddenly it failed. So you always have to open… Continue reading

A collation specifies the bit patterns that represent each character,  in SQL Server it provide sorting rules, case and accent sensitivity properties. Collation in table columns are used with data type ‘CHAR’, ‘VARCHAR’, ‘NVARCHAR’,  ‘nchar’,’text’, ‘ntext’ dictate the code page and corresponding characters that can be represented for the data type. Even in one same… Continue reading

A sales process is a series steps to be completed  by a sales person to make a sale, it helps people to manage their sales pipeline.  and very easy for a company to instruct what are the standard approach to make a sale. For all the opportunities,  a sales person will choose the Sales Processes, and… Continue reading

Today I’m working on a global sales report using Tableau, my idea is trying to make all the sales/Marketing/Opportunity  reports more interesting and easy to read. Our company is a big manufacture company, all the record for sales, orders are scattered all around the world. the old report which list the locations, numbers, and some details… Continue reading

There are many ways to ETL the XML files, you can using c#(or any other language you’d like to) code parse it based on the schema and bulk insert into database, or import it into excel then load it into tables, or using SSIS, whatever you like and you feel you are comfortable with. And… Continue reading

This blog is from —http://www.ponjavic.com/wordpress/2014/09/16/setup-infor-syteline-8-03-customer-portal/#comments thanks M. Setup Infor SyteLine 8.03 Customer Portal mSeptember 16, 2014 Infor 1 Comment Below post outlines how to setup and configure Infor SyteLine 8.03.20 customer and vendor portals. SQL Account Configuration We’ll be setting up and configuring portals on a dedicated server running Microsoft Windows Server Standard 2008 R2.… Continue reading

There was an issue with cube processing with my current client, we have two cubes, one with 80 millions rows fact table, the other has 10 millions row fact table.before May everything was fine, the cube was processed twice a month, and in the weekends, both of them will take 18 hrs total, it’s very… Continue reading

In SAS , when we import raw data, a blank space is usually to determine a value end and the next begins. Then what if we want to input one value for an objective as one variable? The ampersand format modifier & solve the problem. But to really make things work, the next input variable… Continue reading

This practice is aiming to help the very beginners to get an idea how to import file without using wizard. I use SAS Enterprise Guide onDemand for academics, it´s free and you can download it through the official website: http://www.sas.com/en_us/industry/higher-education/on-demand-for-academics.html Okay, if you want to import file through code, you need either a local server(while it’s… Continue reading

Last night I came across a question posted on Experts Exchange website. The user was asking which performance would be better, case when or union. It is a very interesting question, and a lot professionals give their opinions. (well without elaborating or explain it) and the verified so called “best” answer, that developer very firmly announced… Continue reading