Archives for Software Dev - Page 30
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…
Server Farm versus SErver cluster
In general, a cluster refers to a two machine setup where one is active and other is passive (or active/active in a true cluster environment). The actual processing is handled…