Archives for Language features, Development Methodologies - Page 8
Use Case – Customer withdraws cash from Teller (or ATM machine) by filling out a withdrawal slip (or form on ATM machine)
Use Case - Customer withdraws cash from Teller (or ATM machine) by filling out a withdrawal slip (or form on ATM machine). Problem Statement: 1. Design the system so that…
Scan paper–face up or down?
If the lines are on the sheet (left image below), face up. If the lines are on the bent ear (right image below), face down.
Searchable Pdfs
The only searchable pdfs are those that are created through an OCR process which ‘captures’ a text layer separately from an image layer. A purely scanned image is like a…
Mirroring, Replication and Always On Clusters
Mirroring versus Replication SQL Server provides database-level redundancy through: backup/restore log shipping database mirroring (in SQL Server 2005 and later) Always on Clustering (SQL 2012 onwards) Mirroring means master-master replication…
SQL Server Geo Replication
Achieve database redundancy across or within AWS regions, or from on-premise to AWS, with Asynchronous SQL Server Geo-Replication. Create secondary Standby databases for Disaster Recovery (DR). Create Read Replicas to…
db_owner security risks
A typical web-tier should only need DB_USER level access to a backend SQL Server database. The DB_USER contains DB_Writer, DB_Reader – and optionally, DB_EXECUTE privileges. Sometimes, web tiers will be…
Reduce size of excel workbook
Excel uses a lot of space with empty cells. There isn’t an easy way to figure out how much space is being wasted. I was seeing an Excel file at…
Lookup hostname for IP address
Launch a cmd prompt. nbtstat -A %ipaddress% nslookup %ipaddress%
Finding family purchases in iTunes
Trust apple to hide things to where nobody can find them. All I wanted to do was download all the music that was part of my family sharing plan (…
Recursion versus Iteration ( Looping )
Overview In general, whatever problem you can solve with Recursion can also be solved with Looping (iteration). It turns out, that for most use cases, Iteration (looping) performs better than…