Configurations : Web Config or Database? Web Config: Database Connection Strings. OfCourse. You can’t connect without that details. Changes you want trigger Application Pool refresh. Things need to be available when the database is unavailable. (such as a list of email addresses and an smtp …
SQL Server System Info
SQL Server System Info This script provides SQL Server instance level configurations. GitHub Gist : https://gist.github.com/I90Runner/7bc31a10897a2168816073db781d5e77 /****************************************************************************************************** ** Project: Operations ** Issue: Gather SQL Server System Information ** ShortDesc: Gather SQL Server System Information. These commands usually gets executed by SQL Server during startup ** …
SQL Server AlwaysOn Availability Groups
SQL Server Always on Availability Related Queries: How do I switch Primary / Secondary on Switch Always on Availability Groups ( Swap Primary / Secondary ): When the automatic failover is setup , the Primary / Secondary gets swapped during maintenance tasks. To swap back …
AWS Solution Architect Preparation
AWS Solution Architect Reference Materials Load Balancing : https://aws.amazon.com/documentation/elastic-load-balancing/ Elastic Load Balancing automatically distributes incoming application traffic across multiple Amazon EC2 instances. It enables you to achieve greater levels of fault tolerance in your applications, seamlessly providing the required amount of load balancing capacity needed to …
Highly Scalable Fault Tolerant Scalable Systems Considertions
Highly Scalable Fault Tolerant Scalable Systems Considertions: Dr Tanenbaum on Fault Tolerant Operating Systems. https://en.wikipedia.org/wiki/Andrew_S._Tanenbaum Murphys Law: https://en.wikipedia.org/wiki/Edward_A._Murphy,_Jr. https://en.wikipedia.org/wiki/Murphy%27s_law If there’s more than one possible outcome of a job or tasks and one of those outcome will result in disaster or an undesirable consequence , …
AWS VPC Primer
AWS VPC : VPC are tied a specific Region. You can’t have your VPC span across multiple Regions. Security Groups: Instant Level Security NACL : Subnet Level Access Control VPC-VPC: Throgh VPC Peering CIDR : /16 – First 16 Bits are for Network CIDR : …
Random Errors
Putty Fatal Error: Network Error: Software caused connection to abort. PuTTY Fatal Error I worked with CentOS servers from Windows PCs, and I had the same problem with PuTTY. A session didn’t last more than 1-5 minutes. I tried to play with PuTTY settings (keepalives, …
Apache Drill Setup and Usuage
Apache Drill Setup and Usuage: Install and Configure Apache Drill http://drill.apache.org/docs/installing-drill-on-windows/ sqlline> !connect “jdbc:drill:zk=local” Enter username for jdbc:drill:zk=local: admin Enter password for jdbc:drill:zk=local: ***** http://localhost:8047/ SELECT derivedtable.ItemID ,AVG( CAST (derivedtable.TimeSpent AS INTEGER)) AvgTimeSpent FROM ( SELECT rawresponsetime.Time10.`id` ItemID ,rawresponsetime.Time10.`value` `TimeSpent` FROM ( SELECT (flatten(`time`)) `Time10`, …
How to handle Perennial statement of “Our Database is SLOW”?
How to handle Perennial statement of “Our Database is SLOW”? I have been involved with Database and Product Development for a decade in different Verticals. I have heard this statement more than I could count “Database is Slow”,”Database is the reason”. I worked for .COM …
Random GUID or Sequential GUID
Random GUID or Sequential GUID SQL Server has two in-built functions for creating uniqueidentifier. NEWID() NEWSEQUENTIALID() New NEWSEQUENTIALID would help to reduce page splits and fragmentation because of sequential nature of the values returned from this function. NEWID() is truly (almost) random and it would …