{"id":36369,"date":"2020-06-22T12:17:00","date_gmt":"2020-06-22T19:17:00","guid":{"rendered":"https:\/\/www.dcac.com\/?p=36369"},"modified":"2020-05-29T11:46:43","modified_gmt":"2020-05-29T18:46:43","slug":"encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code","status":"publish","type":"post","link":"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/","title":{"rendered":"Encrypting Stored Procedures Doesn’t Make Me Avoid Looking at Your Code"},"content":{"rendered":"\n

Dear Vendors that encrypt stored procedures in SQL Server,<\/p>\n\n\n\n

Stop It!<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

We were having a discussion on Twitter about vendors encrypting stored procedures recently, and this justification came up that had been told about why vendors encrypt stored procedures some times.<\/p>\n\n\n\n

To this I point out, that if you’ve encrypted your code so that I won’t look at it by accident, you are actually getting the exact opposite result. Because you are encrypting code that means that I can’t see if. That means that I want to make sure that you aren’t hiding any stupid practices from me. That means that as soon as I see your encrypted procedures I’m decrypting them to see what is going on with this code.<\/p>\n\n\n\n

Along with this, because you’ve bothered to encrypt the stored procedures that means that I can’t get an execution plan, and query store can’t be used for the queries within the stored procedure. And since I’m guessing that I can performance tune your database better then your developers can, I’m going to be decrypting the procedures so that I can tune the system.<\/p>\n\n\n\n

But It’s Our IP<\/h2>\n\n\n\n

Another reason that companies have for encrypting stored procedures is that the code is their IP. Does the vendor have a patent or trademark on their code? The answer to this is no, as you can’t patent or trademark the actual code, and anyone that tells you that they can trademark their code, is wrong.<\/p>\n\n\n\n

If you have given me your code, then I can look at it. If we have an NDA in place then I can’t use the code. If there’s no NDA in place, then I can use your code all I want. You at that point have no legal way of stopping me.<\/p>\n\n\n\n

If you want to stop supporting the software that we have purchased from you, is there something in the EULA about us not decrypting the stored procedures? No, then support it or get risk getting sued for violating the EULA and support contract. And assume that you’ll be loosing us as a customer and that your competitor will be gaining us as a customer (yes I’ve done this at companies, so it’s not an empty threat).<\/p>\n\n\n\n

Running Code<\/h2>\n\n\n\n

When you sell your customer a license to run your software you are giving the customer your code, and you have to trust the customer to not use your code in order systems. The customer has to trust that you are providing them a system that will perform well. You usually don’t and someone has to to some performance tuning on the application that you provided in order to keep their business up and running. If you hamper or slow that process down, expect to have your application replaced in short order. No application is so critical to a business that it can’t be replaced, so make it so that your application doesn’t make the live of the people that have to actually maintain it suck less.<\/p>\n\n\n\n

Denny<\/p>\n","protected":false},"excerpt":{"rendered":"

Dear Vendors that encrypt stored procedures in SQL Server, Stop It! We were having a discussion on Twitter about vendors encrypting stored procedures recently, and this justification came up that had been told about why vendors encrypt stored procedures some times. To this I point out, that if you’ve encrypted your code so that I […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[551,63,579],"tags":[],"class_list":["post-36369","post","type-post","status-publish","format-standard","hentry","category-blog","category-sql","category-stored-procedures"],"yoast_head":"\nEncrypting Stored Procedures Doesn't Make Me Avoid Looking at Your Code – Denny Cherry & Associates Consulting<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Encrypting Stored Procedures Doesn't Make Me Avoid Looking at Your Code – Denny Cherry & Associates Consulting\" \/>\n<meta property=\"og:description\" content=\"Dear Vendors that encrypt stored procedures in SQL Server, Stop It! We were having a discussion on Twitter about vendors encrypting stored procedures recently, and this justification came up that had been told about why vendors encrypt stored procedures some times. To this I point out, that if you’ve encrypted your code so that I […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/\" \/>\n<meta property=\"og:site_name\" content=\"Denny Cherry & Associates Consulting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DennyCherryAssociatesConsulting\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-22T19:17:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-29T18:46:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dcac.com\/wp-content\/uploads\/2020\/05\/image-10.png\" \/>\n<meta name=\"author\" content=\"Denny Cherry\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mrdenny\" \/>\n<meta name=\"twitter:site\" content=\"@dcacco\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Denny Cherry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/\",\"url\":\"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/\",\"name\":\"Encrypting Stored Procedures Doesn't Make Me Avoid Looking at Your Code – Denny Cherry & Associates Consulting\",\"isPartOf\":{\"@id\":\"https:\/\/www.dcac.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dcac.com\/wp-content\/uploads\/2020\/05\/image-10.png\",\"datePublished\":\"2020-06-22T19:17:00+00:00\",\"dateModified\":\"2020-05-29T18:46:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/cbc8485c710a3eee0e50dcfa9518636e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/#primaryimage\",\"url\":\"https:\/\/www.dcac.com\/wp-content\/uploads\/2020\/05\/image-10.png\",\"contentUrl\":\"https:\/\/www.dcac.com\/wp-content\/uploads\/2020\/05\/image-10.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dcac.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Encrypting Stored Procedures Doesn’t Make Me Avoid Looking at Your Code\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dcac.com\/#website\",\"url\":\"https:\/\/www.dcac.com\/\",\"name\":\"Denny Cherry & Associates Consulting\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dcac.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/cbc8485c710a3eee0e50dcfa9518636e\",\"name\":\"Denny Cherry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ccade9c22d8686e4b5a46cb49a636eea?s=96&r=x\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ccade9c22d8686e4b5a46cb49a636eea?s=96&r=x\",\"caption\":\"Denny Cherry\"},\"sameAs\":[\"https:\/\/x.com\/mrdenny\"],\"url\":\"https:\/\/www.dcac.com\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Encrypting Stored Procedures Doesn't Make Me Avoid Looking at Your Code – Denny Cherry & Associates Consulting","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/","og_locale":"en_US","og_type":"article","og_title":"Encrypting Stored Procedures Doesn't Make Me Avoid Looking at Your Code – Denny Cherry & Associates Consulting","og_description":"Dear Vendors that encrypt stored procedures in SQL Server, Stop It! We were having a discussion on Twitter about vendors encrypting stored procedures recently, and this justification came up that had been told about why vendors encrypt stored procedures some times. To this I point out, that if you’ve encrypted your code so that I […]","og_url":"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/","og_site_name":"Denny Cherry & Associates Consulting","article_publisher":"https:\/\/www.facebook.com\/DennyCherryAssociatesConsulting\/","article_published_time":"2020-06-22T19:17:00+00:00","article_modified_time":"2020-05-29T18:46:43+00:00","og_image":[{"url":"https:\/\/www.dcac.com\/wp-content\/uploads\/2020\/05\/image-10.png","type":"","width":"","height":""}],"author":"Denny Cherry","twitter_card":"summary_large_image","twitter_creator":"@mrdenny","twitter_site":"@dcacco","twitter_misc":{"Written by":"Denny Cherry","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/","url":"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/","name":"Encrypting Stored Procedures Doesn't Make Me Avoid Looking at Your Code – Denny Cherry & Associates Consulting","isPartOf":{"@id":"https:\/\/www.dcac.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/#primaryimage"},"image":{"@id":"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dcac.com\/wp-content\/uploads\/2020\/05\/image-10.png","datePublished":"2020-06-22T19:17:00+00:00","dateModified":"2020-05-29T18:46:43+00:00","author":{"@id":"https:\/\/www.dcac.com\/#\/schema\/person\/cbc8485c710a3eee0e50dcfa9518636e"},"breadcrumb":{"@id":"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/#primaryimage","url":"https:\/\/www.dcac.com\/wp-content\/uploads\/2020\/05\/image-10.png","contentUrl":"https:\/\/www.dcac.com\/wp-content\/uploads\/2020\/05\/image-10.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dcac.com\/2020\/06\/22\/encrypting-stored-procedures-doesnt-make-avoid-looking-at-your-code\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dcac.com\/"},{"@type":"ListItem","position":2,"name":"Encrypting Stored Procedures Doesn’t Make Me Avoid Looking at Your Code"}]},{"@type":"WebSite","@id":"https:\/\/www.dcac.com\/#website","url":"https:\/\/www.dcac.com\/","name":"Denny Cherry & Associates Consulting","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dcac.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dcac.com\/#\/schema\/person\/cbc8485c710a3eee0e50dcfa9518636e","name":"Denny Cherry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dcac.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ccade9c22d8686e4b5a46cb49a636eea?s=96&r=x","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ccade9c22d8686e4b5a46cb49a636eea?s=96&r=x","caption":"Denny Cherry"},"sameAs":["https:\/\/x.com\/mrdenny"],"url":"https:\/\/www.dcac.com\/author\/admin\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/36369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/comments?post=36369"}],"version-history":[{"count":3,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/36369\/revisions"}],"predecessor-version":[{"id":36441,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/36369\/revisions\/36441"}],"wp:attachment":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/media?parent=36369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/categories?post=36369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/tags?post=36369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}