{"id":8531,"date":"2021-06-23T20:15:00","date_gmt":"2021-06-23T18:15:00","guid":{"rendered":"https:\/\/monodes.com\/predaelli\/?p=8531"},"modified":"2021-06-23T09:16:37","modified_gmt":"2021-06-23T07:16:37","slug":"take-your-sql-from-good-to-great-part-3","status":"publish","type":"post","link":"https:\/\/monodes.com\/predaelli\/2021\/06\/23\/take-your-sql-from-good-to-great-part-3\/","title":{"rendered":"Take your SQL from Good to Great: Part 3"},"content":{"rendered":"

 <\/p><\/blockquote>\n

A quick inforgrafic of SQL joins: \"\"\/<\/a>Time to join the JOIN movement.<\/p>\n

Take your SQL from Good to Great: Part 3 | by Taylor Brownlow | Jun, 2021 | Towards Data Science<\/a><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

  A quick inforgrafic of SQL joins: Time to join the JOIN movement. Take your SQL from Good to Great: Part 3 | by Taylor Brownlow | Jun, 2021 | Towards Data Science<\/p>\n

Read more →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"link","meta":{"inline_featured_image":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"activitypub_content_warning":"","activitypub_content_visibility":"","activitypub_max_image_attachments":4,"activitypub_interaction_policy_quote":"anyone","activitypub_status":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[72],"tags":[],"class_list":["post-8531","post","type-post","status-publish","format-link","hentry","category-documentations","post_format-post-format-link"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6daft-2dB","jetpack-related-posts":[{"id":14199,"url":"https:\/\/monodes.com\/predaelli\/2025\/10\/26\/against-sql\/","url_meta":{"origin":8531,"position":0},"title":"Against SQL","author":"Paolo Redaelli","date":"2025-10-26","format":false,"excerpt":"Against SQL Against SQL Published 2021-07-09 TLDR The relational model is great: A shared universal data model allows cooperation between programs written in many different languages, running on different machines and with different lifespans. Normalization allows updating data without worrying about forgetting to update derived data. Physical data independence allows\u2026","rel":"","context":"In "Documentations"","block_context":{"text":"Documentations","link":"https:\/\/monodes.com\/predaelli\/category\/documentations\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9172,"url":"https:\/\/monodes.com\/predaelli\/2022\/03\/23\/sql-fiddle\/","url_meta":{"origin":8531,"position":1},"title":"SQL Fiddle","author":"Paolo Redaelli","date":"2022-03-23","format":"link","excerpt":"SQL Fiddle Application for testing and sharing SQL queries.","rel":"","context":"In "Tricks"","block_context":{"text":"Tricks","link":"https:\/\/monodes.com\/predaelli\/category\/documentations\/tricks\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3522,"url":"https:\/\/monodes.com\/predaelli\/2017\/11\/22\/sql-server-why-should-an-application-not-use-the-sa-account-database-administrators-stack-exchange\/","url_meta":{"origin":8531,"position":2},"title":"sql server – Why should an application not use the sa account – Database Administrators Stack Exchange","author":"Paolo Redaelli","date":"2017-11-22","format":"status","excerpt":"sql server - Why should an application not use the sa account - Database Administrators Stack Exchange I understand that the sa account enables complete control over a SQL Server and all the databases, users, permissions etc. I have an absolute belief that applications should not use the sa password\u2026","rel":"","context":"In "Proprietary software"","block_context":{"text":"Proprietary software","link":"https:\/\/monodes.com\/predaelli\/category\/software\/proprietary-software\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2209,"url":"https:\/\/monodes.com\/predaelli\/2017\/02\/28\/how-to-backup-sql-server-to-sql-file-stack-overflow\/","url_meta":{"origin":8531,"position":3},"title":"How to backup Sql Server to sql file? – Stack Overflow","author":"Paolo Redaelli","date":"2017-02-28","format":"link","excerpt":"In \"Back UP\" I only get a bak file, but I would like to create .sql file Sorgente: How to backup Sql Server to sql file? - Stack Overflow I may need it pretty soon up vote 25 down vote Use SQL Server's Generate Scripts commend right click on the\u2026","rel":"","context":"In "Senza categoria"","block_context":{"text":"Senza categoria","link":"https:\/\/monodes.com\/predaelli\/category\/senza-categoria\/"},"img":{"alt_text":"apple-touch-icon@2","src":"https:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2017\/02\/apple-touch-icon%402-150x150-1.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":14160,"url":"https:\/\/monodes.com\/predaelli\/2025\/10\/21\/harlequin\/","url_meta":{"origin":8531,"position":4},"title":"Harlequin","author":"Paolo Redaelli","date":"2025-10-21","format":false,"excerpt":"Harlequin The Portable, powerful, colorful SQL IDE for Your Terminal. On Debian apt install harlequin","rel":"","context":"In "Software"","block_context":{"text":"Software","link":"https:\/\/monodes.com\/predaelli\/category\/software\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2191,"url":"https:\/\/monodes.com\/predaelli\/2017\/02\/21\/hellish\/","url_meta":{"origin":8531,"position":5},"title":"Hellish\u00a0","author":"Paolo Redaelli","date":"2017-02-21","format":false,"excerpt":"Hell must be full of Microsoft servers that must be administered and reinstalled over and over again. I thought of being non proficient in Ms administration since I tried for two full days to install SQL server 2008 on a freshly installed Windows server 2008. I discovered that a whole-life\u2026","rel":"","context":"In "Mood"","block_context":{"text":"Mood","link":"https:\/\/monodes.com\/predaelli\/category\/mood\/"},"img":{"alt_text":"","src":"http:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2017\/02\/wp-image-1265243403jpeg.jpeg?w=528&resize=350%2C200","width":350,"height":200,"srcset":"http:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2017\/02\/wp-image-1265243403jpeg.jpeg?w=528&resize=350%2C200 1x, http:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2017\/02\/wp-image-1265243403jpeg.jpeg?w=528&resize=525%2C300 1.5x"},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts\/8531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/comments?post=8531"}],"version-history":[{"count":0,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts\/8531\/revisions"}],"wp:attachment":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/media?parent=8531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/categories?post=8531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/tags?post=8531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}