SQL: All about Time
SQL Server How to add time into a datetime variable? [sql] declare @startDate = ’05 Nov 2017′ SET @startDate = DATEADD(week, 3, @startDate); –’22 Nov […]
100 things every designer needs to know about people (book review from blinkist)
What’s in it for me? Find out what makes great design great. What comes to mind when you think of great design? Probably something that […]
What they don’t teach you at Harvard Business School (book review from blinkist)
What’s in it for me? Walk and talk like a street-smart business savant. Perhaps you’ve aced all of your exams at business school, and maybe […]
Web App: Caching
Concept How many caching form does ASP.NET have? Page level output caching The simplest form of caching, output caching simply keeps a copy of the […]
SQL: How to use “order by” with “select distinct”?
A query with SELECT DISTINCT can be rewritten using GROUP BY. So this [sql] SELECT DISTINCT city FROM HR.Employees WHERE country = N’USA’ AND region […]
Web App: Access Limitation
Concept DB design 1 “users” table [sql] 1 AA 2 BB [/sql] “authority_groups” table [sql] group_auto name 1 Admin 2 Writer [/sql] “authority_group_items” table [sql] […]
Web App: Common area – Menu, Header, Footer
Concept ASP.NET Use ASCX file. A file with the ASCX file extension is an ASP.NET Web User Control file. Basically, ASCX files make it easy […]
ASP.NET: C# – How to scale image and save to DB?
DB design Create table IMAGE to save image [sql] sample_image varbinary(MAX) [/sql] Create SP to save image [sql] CREATE PROCEDURE [insert_image] @input varbinary(MAX), @length bigint […]
I’m OK, you’re OK (book review from blinkist)
What’s in it for me? Master your inner child and parent. We’ve all been there. In the heat of an argument, or when discussing a […]
ASP.NET & Ajax in Javascript
GET (https://www.w3schools.com/xml/ajax_intro.asp) [js] var xhttp = new XMLHttpRequest(); xhttp.open(“GET”, “ajax_info.txt”, true); xhttp.send(); xhttp.onreadystatechange = function() { if (this.readyState == 4 && this.status == 200) { […]