{"id":3522,"date":"2017-11-22T10:19:21","date_gmt":"2017-11-22T09:19:21","guid":{"rendered":"https:\/\/monodes.com\/predaelli\/?p=3522"},"modified":"2017-11-22T10:19:21","modified_gmt":"2017-11-22T09:19:21","slug":"sql-server-why-should-an-application-not-use-the-sa-account-database-administrators-stack-exchange","status":"publish","type":"post","link":"https:\/\/monodes.com\/predaelli\/2017\/11\/22\/sql-server-why-should-an-application-not-use-the-sa-account-database-administrators-stack-exchange\/","title":{"rendered":"sql server &#8211; Why should an application not use the sa account &#8211; Database Administrators Stack Exchange"},"content":{"rendered":"<p><em><a href=\"https:\/\/dba.stackexchange.com\/questions\/39124\/why-should-an-application-not-use-the-sa-account\">sql server &#8211; Why should an application not use the sa account &#8211; Database Administrators Stack Exchange<\/a><\/em><\/p>\n<p><!--more--><\/p>\n<blockquote><p>I understand that the sa account enables complete control over a SQL Server and all the databases, users, permissions etc.<\/p>\n<p>I have an absolute belief that applications should not use the sa password without a perfected, business person focused reason why. Answers to <a href=\"https:\/\/dba.stackexchange.com\/questions\/411\/what-security-threats-does-the-sa-account-and-other-known-account-names-pose-to\">This Question<\/a> include a lot of my reasoning for an IT focused discussion<\/p><\/blockquote>\n<p>Ah, that&#8217;s why someone use it. \ud83d\ude41<\/p>\n","protected":false},"excerpt":{"rendered":"<p class=\"excerpt\">sql server &#8211; Why should an application not use the sa account &#8211; Database Administrators Stack Exchange<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"https:\/\/monodes.com\/predaelli\/2017\/11\/22\/sql-server-why-should-an-application-not-use-the-sa-account-database-administrators-stack-exchange\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"status","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":[53],"tags":[180,181],"class_list":["post-3522","post","type-post","status-publish","format-status","hentry","category-proprietary-software","tag-microsoft","tag-sql-server","post_format-post-format-status"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6daft-UO","jetpack-related-posts":[{"id":2209,"url":"https:\/\/monodes.com\/predaelli\/2017\/02\/28\/how-to-backup-sql-server-to-sql-file-stack-overflow\/","url_meta":{"origin":3522,"position":0},"title":"How to backup Sql Server to sql file? &#8211; 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 &quot;Senza categoria&quot;","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":3180,"url":"https:\/\/monodes.com\/predaelli\/2017\/07\/01\/competing-dhcp-servers\/","url_meta":{"origin":3522,"position":1},"title":"Competing DHCP servers","author":"Paolo Redaelli","date":"2017-07-01","format":"aside","excerpt":"Four months ago the main server of my company1 broke, really, really hard - two disks in a RAID5 in a week - so as I found myself solving the issue as it often happens. It was a Vmware ESXi that failed to notify that disks were failing. Not a\u2026","rel":"","context":"In &quot;Mood&quot;","block_context":{"text":"Mood","link":"https:\/\/monodes.com\/predaelli\/category\/mood\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2017\/07\/due-dhcp-510x383.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2191,"url":"https:\/\/monodes.com\/predaelli\/2017\/02\/21\/hellish\/","url_meta":{"origin":3522,"position":2},"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 &quot;Mood&quot;","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":[]},{"id":14199,"url":"https:\/\/monodes.com\/predaelli\/2025\/10\/26\/against-sql\/","url_meta":{"origin":3522,"position":3},"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 &quot;Documentations&quot;","block_context":{"text":"Documentations","link":"https:\/\/monodes.com\/predaelli\/category\/documentations\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8190,"url":"https:\/\/monodes.com\/predaelli\/2021\/02\/21\/typeorm\/","url_meta":{"origin":3522,"position":4},"title":"Typeorm","author":"Paolo Redaelli","date":"2021-02-21","format":"link","excerpt":"typeorm.io is Object\u2013relational mapping for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.","rel":"","context":"In &quot;Javascript&quot;","block_context":{"text":"Javascript","link":"https:\/\/monodes.com\/predaelli\/category\/javascript\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9172,"url":"https:\/\/monodes.com\/predaelli\/2022\/03\/23\/sql-fiddle\/","url_meta":{"origin":3522,"position":5},"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 &quot;Tricks&quot;","block_context":{"text":"Tricks","link":"https:\/\/monodes.com\/predaelli\/category\/documentations\/tricks\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts\/3522","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=3522"}],"version-history":[{"count":0,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts\/3522\/revisions"}],"wp:attachment":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/media?parent=3522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/categories?post=3522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/tags?post=3522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}