Serguei_Tarassov's blog

Windows 10 services

Submitted by Serguei_Tarassov on

Here is the check list of Windows 10 services that may be deactivated to free some memory and other resources.

  • 'Connected User Experiences and Telemetry' service (previously 'Diagnostics Tracking Service' in Windows 7/8/2012). Unfortunately, it is not sufficient, you should also go to Task Sheduler and disable all tasks in the folder \Microsoft\Windows\Application Experience. Also check that they are still disabled after any Windows update

To be continued...

It dominates или о доминировании

Submitted by Serguei_Tarassov on

Цитата.

Les Etats-Unis... sont la seule et unique hyperpuissance. Elle est prédominante dans tous les domaines : économique, technologique, militaire, monétaire, linguistique, culturel. Cette situation est sans précédent
Hubert Védrine, Ministre des Affaires étrangères de la République Française, 2000 (1)

Types of joins in SQL (cheatsheet for beginners)

Submitted by Serguei_Tarassov on

This article is used in my book "Programming with databases".

Better to see once than to hear a hundred times. This small article explains what are the different kinds of joins in SQL.

At the first time you should take into account that SQL is a declarative 4th generation language. So the best way to use it (especially for beginners) is to write the query and let SQL optimizer do its job. That means thinking in set-oriented terms and avoiding sub-queries.

Let's take two example tables: Companies and Contacts.

Pages

Subscribe to RSS - Serguei_Tarassov's blog