Archives for Software Dev - Page 27
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…
Data warehouse versus data marts
Most data warehousing initiatives fail (mainly because this level of standardization slows down an agency/company enough that the project gets derailed; boiling the ocean phenomenon). Avoid building a Data Warehouse…
use cases versus scenarios
Scenarios are simply variations of a use case. For – Check Outstanding Balance of a Credit Customer and Check Outstanding Balance of a cash customer – are both scenarios of…
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…
Mobile versus Responsive Design
Mobile Site ( ) Given that the primary target audience here is mobile users, what is recommended is a website that is not just responsive - but also mobile designed…
Azure SQL Data Warehouse
What is it? A fully-managed, highly-scalable, data warehouse service that allows mix-n-match of OLTP and OLAP data sources. Data Warehouse (OLAP) versus OLTP Data Warehouse is essentially a star schema,…
CPUs, Cores per CPU and vCPUs
Assume that we have a piece of hardware with 4 CPUs that have 4 Cores each. Say hyperthreading is enabled; which means that each core can handle 2 threads simultaneously;…
How technology continues to alienate us
For a while now, I had been talking about the ‘blind march’ of technology –and how it was truly BLIND. This post in the New Yorker succinctly summarizes a lot…
Multiple copies of data–and editability
A book has an author –an Author has multiple books. A book would be modeled as a document in NoSQL – as would an author. So - we end up…