-
Continue reading →: (Java) Design Pattern part 1. What is design pattern?
What is design pattern? Design pattern is a general solutions for common case that happen in the programming world. But, we should adapt with with the actual condition. The Design pattern was initiated by Gang of Four (Erich Gamma, John Vlissides, Ralph Johnson, Richard Helm) in the book titled “Design Patterns: Elements of…
-
Continue reading →: Agile User Story & Task
What is user story in Agile? User story is a functionality requirement of a system that required by the user. A user story can be defined in two kind of sentences As a <User Role> I want <Functionality> so that <Business Value> In order to <Business value> as a <User…
-
Continue reading →: Agile Planning
How Agile plan the work? Agile works in iterations tp deliver user stories which already prioritized on the product backlog, based on the team capacity to decide how much scope they have to plan Point A Point defines how much a team can commit. A point usually refers to 8…
-
Continue reading →: Agile
Agile is a software development methodology which use short iteration process (about 1-4 weeks) to get frequent feedback for aligning business requirement changes. There are roles in Agile : Scrum Master Scrum master is the leader and facilitator who ensures/helps agile process can be implemented well. Functional Responsibilities : Lead…
-
Continue reading →: ASP.Net #if DEBUG always return true
Change project properties. In Build tab, change configuration into “Release” and uncheck “Define DEBUG constant”
-
Continue reading →: ASP.net C# Reading Datetime value From Excel sheet
Try this : string sDate = (xlRange.Cells[4, 3] as Excel.Range).Value2.ToString(); double date = double.Parse(sDate); var dateTime = DateTime.FromOADate(date).ToString(“MMMM dd, yyyy”); I hope it can help you 🙂
-
Continue reading →: SQL Server – How To Find First And Last Date of Current Month
Here are the way how to find first and last date of current month DECLARE @today DATE SELECT @today = GETDATE() SELECT DATEADD(dd,-(DAY(@today)),@today) AS Date, ‘Last Date of Previous Month’ AS DateText UNION SELECT DATEADD(dd,-(DAY(@today)-1),@today) AS Date, ‘First Date of Current Month’ AS DateText UNION SELECT @today AS Date, ‘Today’…
-
Continue reading →: SQL Server – How to find stored procedure containing text
This is the way how to find stored procedure containing some text. We can search with table name or other sql object name. SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE ‘%blablabla%’ AND ROUTINE_TYPE=’PROCEDURE’ Thank you. Hopefully it is useful for you
-
Continue reading →: SQL Server – How To Find Tables With Foreign Key Name
I face condition where I have to find table with certain foreign key name. It is condition when I have to recreate (drop first) the table for rearrange table column. So how to find tables with certain foreign key name? Here is the script SELECT f.name AS ForeignKey , OBJECT_NAME(f.parent_object_id)…
-
Continue reading →: How to become system analyst – Understand what is going on
The very basic idea for a system analyst is understanding what is going on. Further,it is about understand the process of existing system. Analize the problem,or improvement point. And conduct a solution. But it is very important,to ensure whether the solution is solutive (I mean it really can solve the…
VISITOR COUNTER
33.196 hit
Hello,
I’m Riza
Welcome to my website. I’m happy to share my knowledge and experience here, especially related with my expertise in digital solution for enterprise. I’ll talk many topics around technology, AI, and others. Happy to know you!
You can find me in network platform below
Join the fun!
Stay updated with our latest tutorials and ideas by joining our newsletter.
M. FAISOL RIZA 