Andy Blog

Full-stack developer

SQL Server Reporting Services Tutorial 2 - Visual Studio

Install SQL Server Data Tools SQL Server Data Tools (SSDT) is a development tool that we can used to build SQL Server relational databases, Azure SQL databases, Integration Services packages, Anal...

Posted by Andy Feng on November 19, 2017

SQL Server Reporting Services Tutorial 1 - Introduction

Introduction SQL Server Reporting Services (SSRS) is a server-based report generating software by Microsoft. It is part of suite of Microsoft SQL Server services. Basically, it can be used to prep...

Posted by Andy Feng on November 17, 2017

Best practice of using Git to integrate teamwork

This article introduces GitFlow and GitHub Flow by which we can smartly use Git to integrate codes within team members. It presents two models to manage changes and merge codes. They focus on proje...

Posted by Andy Feng on November 16, 2017

Git fundamentals - branch, fork, stash, merge, rebate, squash

This article introduces Git fundamental knowledge including branch, fork, stash, merge, rebate. It explains major conceptions of Git branching model and workflow for each commands. These commands ...

Posted by Andy Feng on November 14, 2017

ASP.NET WebApi file upload implementation

This article introduces how to implement file upload using Web Api 2. Upload file(s) to a specified location of server [Route("files")] [HttpPost] public async Task<FileResult> UploadFilesA...

Posted by Andy Feng on November 5, 2017

ASP.NET MVC vs. Web Api

Introduction This article explains the differences between ASP.NET MVC and ASP.NET Web API and also describes how to combine the Web API with the MVC. ASP.NET MVC ASP.NET MVC is a web applicatio...

Posted by Andy Feng on October 30, 2017

SQL Tips - over, partition by, row_number and rank

Here are some tips of SQL functions and all scripts passed under SQL Server 2012. Prerequisite Let’s assume we have a [Order] table: create table [dbo].[Order]( Id int identity(1,1) , purchas...

Posted by Andy Feng on October 17, 2017

Timezone conversion in programming

Introduction Conversion between different timezones is a typical issue. For instance, I encourted an issue which grabbed datetimes with either EST (Eastern Standard Time), or AST (Alaskan Standard...

Posted by Andy Feng on October 3, 2017

Kobo launches new audiobook marketplace

As a bookworm, honestly, the products of my company are pretty good. It has fantastic reading experience and millions of online books. Also, you can get tons of free ebooks over online library and ...

Posted by Andy Feng on September 6, 2017

Mortgage calculator algorithm

Introduction A mortgage calculator aims to simplify real estate investment. A good calculator enables us to determine loan amounts, mortgage qualification, affordability or whether we should be re...

Posted by Andy Feng on August 26, 2017

FEATURED TAGS
ABOUT ME

Happy coding, happy life