Western United States Landscapes

-

These are 5K resolution (5120x2880 pixels) that I clicked, for your personal use only as desktop wallpapers.  Click on an image for a larger version and if you want the 5K resolution, right-click and open image in a new tab.

Rainbow after a storm high up on Pike's Peak, Colorado


Beautiful winter morning in Albuquerque, New Mexico


Thunderstorm, high up in the Rocky Mountain National Park, Colorado


Aspen trees in Autumn near Aspen, Colorado


Clouds hanging, Mount Evans, Colorado


Beautiful lake and reflections, somewhere near the Continental Divide in Colorado


Autumn colors at Maroon Bells, Colorado


Clouds and Mountains, Sandia Mountains, New Mexico


Layers of blue, driving up Mount Evans, Colorado


The kind of day you read about, a prairie on the Kansas-Colorado border


On the ledge, looking at the valley, Mount Evans, Colorado


Fascinating God's Rays near Kansas-Colorado border











Comments

Post a Comment

Popular posts from this blog

Database 101 - The Art of Gathering Requirements

-
Image
A client (if you're self-employed) or a Business Analyst (if you're employed) approaches you and demands "We have a new project that we need you to create a database for". In the conversations below, I will show you how I approach the process of requirements gathering.  I am by no means an expert and I learn new things and correct my old mistakes daily, so if you have better suggestions or see mistakes, please feel free to reach out and let me know.  I love to learn new things all the time.  Lines in blue/italics are their statements, while lines in black regular are mine. Part 1 We have to store geo political data for some of our states By our states, do you mean the USA only? Well, for now, yes. So in future you do see this project growing to other countries? hmmm, probably Canada and Mexico How about Britain or France or Brazil or .. You know what, let's assume this will cover the entire world at some point if it goes well This type of conversation represents m...
Read more

PostgreSQL Trigger Example

-
Image
 Triggers can be handy at times, but I tend to stay away from them as long as possible, because they can cause performance degradation at times, plus I tend to forget they're hiding behind the scenes, doing random things.  In any case, let's see how you can create a simple trigger in Postgres. Steps Create a lookup table Create a parent table Create a child table Create trigger function to convert lookup value to handle Inserts/Updates/Deletes For inserts and updates, convert lookup value to look up id Create trigger Test .. by running several 1000 inserts, updates and deletes Replace myschema with the name of your schema -- Create Lookup Table create table myschema.lookuptable ( lookupid integer not null , lookupvalue varchar ( 50 ) not null , constraint pk_lookuptable primary key (lookupid) ); insert into  myschema.lookuptable (lookupid, lookupvalue) values ( 1 , 'hello' ), ( 2 , 'bonjour' ), ( 3 ...
Read more

SQL Server Offset Pagination

-
Image
When you have few rows in your tables, you may be tempted to return all rows to an API or Client call, and let that layer deal with pagination.  This works, till a certain tipping point, after which calls will become slow and your APIs are cursed at and your UIs cussed out by users who're waiting and waiting.  You can avoid this in different ways, and one of my favorite methods is to paginate right from the database, with a cap of how many rows you will return in a call. Coupled with good indexing on the columns the API or UI requests the sorting/ordering on, you can scale better.  Let's look at a simple example of Offset pagination. Step 1 = Create Table for our demo CREATE TABLE dbo . OffsetPaginationUsers ( UserId integer not null identity Primary Key , FirstName varchar ( 255 ) not null, LastName varchar ( 255 ) not null ) Step 2 = Add dummy rows IN SERT INTO dbo . OffsetPaginationUsers ( FirstName , LastName ) SELECT TOP 100 Nam...
Read more