ICT Hakathon 2018

Hi, it is such a long time that I didn't update the blog. I have been very busy lately due to my jobs and it caused many of my snippets/topics still kept in my OneNote.

Last week, I had a chance to be able to be a committee in ICT Hackathon 2018 hosting by Mahidol University. The event was held during 24-25 Mar 2018. It is an joint event which sponsored by Atos (my current place), and Innotech. It was very good chance to see what is the current state of academic, and very proud to know that it is still in good shape. Maybe, it is even better than during my studied time here.

For this Hackathon event, it was asked to create a platform to solve specific business issues. In this time, I had been a secondary judge to help verifying their works and provide technical score (one of the judges from my company is not from technical area). So, it was a good experience for me to a judge for a first time (first row seat LOL). It is also good opportunities to let me learn new things from students, because most of time when I doing my work, technology being used in the project is locked. So, sometimes this limit my experience for try implementing new technology into real project.

At the end, it was fun and feel like to be a student again. If I have more chance to participate this kind of event, I hope I am be able to do it again :D.

Links:
- Main web site
- Organizing Committees
- Judges

"This feature has been disabled by your administrator" error in Office 2013

"This feature has been disabled by your administrator" error in Office product is really annoying due to maybe from company policy or something else. Some people, like me, use OneNote a lot to keep important stuffs for work but it was blocked!! To trying to solve this problem follow the steps in the following link:
https://support.microsoft.com/en-us/help/3039000/-this-feature-has-been-disabled-by-your-administrator-error-in-office

The newer version of Microsoft Office may be fixed by follow the steps in this link.

Useful CMD tips

Space Problem in CMD

Pass a path with space to a batch file as a parameter

How to run a “.bat” file during installation?

SSRS - By pass specific user to Reporting Server

When we browse to Reporting Server, it usually ask a username and password to access. However, sometime we want to avoid that by using specific account (treat like webapp that know db password). To do that we have to implement a custom web application that host a web page which can load ReportViewer. Then that page have to specifically implement parameter specification before by pass its parameters to ReportViewer control. The steps are shown below:

By pass anonymous access for reports using custom web app as a proxy

1. Create ReportViewer in custom web app
2. Using the WebForms ReportViewer Control
3. Set credentials for ReportViewer
4. Set Report Parameters with Credential

Create self WCF Windows Service

Check out these links, it help me a lot to allow me creating self WCF and installed it as Windows Service.

Walkthrough: Creating a Windows Service Application in the Component Designer

Automatically start a Windows Service on install

How to run a “.bat” file during installation?

Call JSON in WCF

Custom Behavior in web.config

Enable CORS in WCF

1. Converting WCF CORS restful service from .Net 4.5 to 3.5 causes preflight request to break
2. Implementing CORS support in WCF
3. http://stackoverflow.com/questions/8854137/i-have-implemented-afterreceiverequest-method-from-idispatchmessageinspector-a
4. AJAX JQuery SelfHost WCF -> ByPassCrossDomain Method
5. Implementing CORS support in WCF

SSIS - Parameter things

In SQL Server Integration Services, sometime we have to use the values that can be varied on circumstances e.g. parameter. For my frequent cases, there are 2 cases listed below:

1. SSIS Variables Object - read from DB
2. Map Query Parameters to Variables in an Execute SQL Task

These links explain how to load parameter which values are from database, and how to use parater into SQL query task.

How to add parameters into a WebRequest?

Take a look at this link: http://stackoverflow.com/questions/3279888/how-to-add-parameters-into-a-webrequest

Conditional Logic in PowerShell

http://www.powershellpro.com/powershell-tutorial-introduction/powershell-tutorial-conditional-logic/

Operator	Description
-eq	Equal to
-lt	Less than
-gt	Greater than
-ge	Greater than or Eqaul to
-le	Less than or equal to
-ne	Not equal to

perator	Description
-not	Not
!	Not
-and	And
-or	Or

Query SQL in Powershell

The following snippet will query data from SQL into DataSet format:

$ServerName = "_ServerName_"
$DatabaseName = "_DatabaseName_"
$Query = "SELECT * FROM Table WHERE Column = 'XXX'"

#Timeout parameters
$QueryTimeout = 120
$ConnectionTimeout = 30

#Action of connecting to the Database and executing the query and returning results if there were any.
$conn=New-Object System.Data.SqlClient.SQLConnection
$ConnectionString = "Server={0};Database={1};Integrated Security=True;Connect Timeout={2}" -f $ServerName,$DatabaseName,$ConnectionTimeout
$conn.ConnectionString=$ConnectionString
$conn.Open()
$cmd=New-Object system.Data.SqlClient.SqlCommand($Query,$conn)
$cmd.CommandTimeout=$QueryTimeout
$ds=New-Object system.Data.DataSet
$da=New-Object system.Data.SqlClient.SqlDataAdapter($cmd)
[void]$da.fill($ds)
$conn.Close()
$ds.Tables

From <http://stackoverflow.com/questions/8423541/how-do-you-run-a-sql-server-query-from-powershell> 

Run Unit Test as 64 bit in Visual Studio

Sometime you cannot run unit test because it ask you to run on 64 bit. However, changing debug mode does not help and cause you do not see any unit test methods. In order to make it work, You need to go to Test Settings under Test tab then set Default Processor Architecture.