Read writing from Jovan Rocanov on Medium. Visual storyteller. Passionate about guiding people through the maze of narratives, symbols, and meanings. Every day, Jovan Rocanov and thousands of other voices read, write, and share important stories on Medium.

Greek illustrations

Useful T-SQL queries for SQL Server to explore database schema.

select i.[name] as index_name,
    substring(column_names, 1, len(column_names)-1) as [columns],
    case when i.[type] = 1 then 'Clustered index'
        when i.[type] = 2 then 'Nonclustered unique index'
        when i.[type] = 3 then 'XML index'
        when i.[type] = 4 then 'Spatial index'
        when i.[type] = 5 then 'Clustered columnstore index'
        when i.[type] = 6 then 'Nonclustered columnstore index'
        when i.[type] = 7 then 'Nonclustered hash index'
        end as index_type,
    case when i.is_unique = 1 then 'Unique'
        else 'Not unique' end as [unique],
    schema_name(t.schema_id) + '.' + t.[name] as table_view, 
    case when t.[type] = 'U' then 'Table'
        when t.[type] = 'V' then 'View'
        end as [object_type]
from sys.objects t
    inner join sys.indexes i
        on t.object_id = i.object_id
    cross apply (select col.[name] + ', '
                    from sys.index_columns ic
                        inner join sys.columns col
                            on ic.object_id = col.object_id
                            and ic.column_id = col.column_id
                    where ic.object_id = t.object_id
                        and ic.index_id = i.index_id
                            order by key_ordinal
                            for xml path ('') ) D (column_names)
where t.is_ms_shipped <> 1
and index_id > 0
order by i.[name]

• Stay away from unsupervised learning
• Skip neural networks
  Plugging an on off-the-shelf model from sklearn is often enough for an MVP. While weeks of tuning a neural net might provide a couple extra points of f1, it’s often not worth it in the beginning.
• Frame all problems as binary classification
• Tune your hyper-parameters

In this post, UXPin looks at using negative space in design and how you can use it to create more engaging websites and apps.

Good web design with tall line-height

Boring avatars is a tiny JavaScript React library that generates custom, SVG-based, round avatars from any username and color palette.

100 Colorful vector illustration to design website banners and landing pages, commercial license and SVG FIGMA SKETCH AI files included

Second base: pairing with other colors
After celebrating the first color down, now it’s time to give it some friends. Try to visualize the color picker — regardless of the tool of your choice — and then imagine a line that starts in the top left corner of the picker and then it bends all the way down to the bottom right, directly passing through the color you’ve just picked.

Continuing a series on table expressions, Itzik Ben-Gan explains recursive CTEs, features from the standard T-SQL is lacking, and workarounds.

Remember that the syntax of a query against a CTE is as follows:

WITH <CTE name> [ ( <with column list> ) ]
AS
(
<table expression>
)
<outer query>;

If you ever wanted to create triangles using CSS, you probably found code samples on stack-overflow or css-tricks. But how do they really work ? Understanding the process behind creating triangles…

Save hundreds by making your own DIY trim. Here's how to do it.

Here at the Getaway, we kept it simple and made all our trim 1/2-in. thick. With some basic DIY skills, you can make your own trim for your 10-ft. x 14-ft. room for $28 from just one 4×8 sheet of 1/2-in. MDF.

This 7-move circuit from trainer Yusuf Jeffers will strengthen your hips to prevent injuries and improve running efficiency.

Hip Controlled Articular Rotation

Hip Raise With Lateral Leg Lift

Over-Under Hurdle Walk

Seated Leg Lift

Single-Leg Glute Bridge With Leg Lift

Single-Leg Glute Bridge

Standing Hip Hinge With Rotation

Take on the Men's Health 30-Day Kettlebell challenge for a full month's worth of workouts using just one kettlebell that will help to build muscle and more.

Improve your posture and optimize arm swing with these shoulder exercises.

• Push-Up to Shoulder Tap
• Dumbbell Front Raise
• Dumbbell Lat Press-Down
• Mini Band External Rotation
• Mini Band Pull-Apart

Kent C. Dodds’ .filter() Trick Will Change How You Use JavaScript. This one-liner uses the Boolean constructor to magically remove all falsy values from an array ✨.

https://twitter.com/kentcdodds/status/1009918457394225152

const plugins = [
    isProd ? optimizePlug : null,
    isProd ? prodOnlyPlug : null,
    !isProd ? testingPlug : null,
    usefulPlug,
].filter( Boolean );

Text as Data - q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files).

The Formula

This is the formula making real money in almost any profession, doing almost anything, for almost anyone. Here it is:

Your income is directly dependent on your ability to produce value at scale with ownership.

• “Value is the gap between what clients can do for themselves and what we can do for them.”

Scale

1. Eliminate any and all superfluous action on your part.
2. Automate anything and everything that can be automated.
3. Delegate anything that cannot be automated.
4. Do anything that cannot be delegated.

Ownership

If you have no equity, no real ownership, the first two pieces of this formula DO NOT MATTER. YOU MUST HAVE OWNERSHIP OF YOUR VALUE!

200 Walking Lunges

100 Lunge Jumps

200 Air Squats

100 Squat Jumps

Cold, iced coffee is often associated with whipped cream and artificial syrups, but try this cold brew coffee recipe and they'll fall into distant memory.

Every element I use for the basic structure of a HTML document, with explanations why.

Usually when I start a new project, I either copy the HTML structure of the last site I built or I head over to HTML5 Boilerplate and copy their boilerplate.

https://html5boilerplate.com/

What does Cache-Control really do? In basic terms? Let’s find out!