Archives for Software Dev - Page 28
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…
Business process modeling and mapping tool
There are tools that model business processes (think flow diagrams) - all variants of what Visio provides you. However, once you start getting into the actual requirements for your new…
Sharepoint for IMAGE STORAGE
Some thoughts on using sharepoint to store images. In the past, Scalability of the underlying sharepoint collections was a bit of a challenge. Recent versions of sharepoint (and the underlying…
Business continuity in the cloud – DR in Azure and AWS
Data Recovery - point-in-time restore Capability Basic tier Standard tier Premium tier Point in Time Restore from backup Any restore point within 7 days Any restore point within 35…
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…
DoES your app need a certificate SerVER?
Typically, no! There are some use cases where it may be justified : VPN Authentication Use Case A certificate can also be the second factor for VPN access. In…
Static code analysis
Static code analysis helps identify code vulnerabilities (and performance issues) before code makes it to production. Most 'code coverage' tools require the full source code (compilable source code) to run…
DMZ versus Public versus Web
‘Public Facing’, ‘DMZ’ and ‘Web Tier’ are all used interchangeably. A DMZ, in essence, is a way to ISOLATE your PUBLIC facing assets. These assets DO NOT have to be…
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…
Tracking relationships in NOSQL
In NoSQL, there is no way to 'relate' the post with the comments. So, what do you do? Well - you essentially store the postId and the commentId - for…