Archives for Language features, Development Methodologies - Page 8
High level architecture versus High level design
Architecture and design are closely related. Architecture is more abstract and is geared towards strategy, structure and purpose. High Level Design is more hands-on and geared towards implementation and practice.
How the Internet Works
Company A = large communications provider. Has a PoP (Point of Presence) in each major city. Company B = large corporate with multiple buildings - lays out it's own fiberoptic…
Static classes versus regular classes
What is a static class? How is it different from an object? A class in which everything (all fields and methods) is static is equivalent to an object. It has…
SQL Visual Query Construction tools
In order of preference (my preference , based on product maturity, knowledge base, user forums etc.): Toad for SQL Server – Pro Edition - $650 /user DB Visualizer Pro –…
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). Also read - Accuracy and error rates in…
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…