{"id":17,"date":"2014-01-02T21:08:36","date_gmt":"2014-01-02T13:08:36","guid":{"rendered":"http:\/\/suherman.asia\/w2\/?p=17"},"modified":"2014-08-26T11:54:18","modified_gmt":"2014-08-26T03:54:18","slug":"using-hash-algorithms-in-sql-server","status":"publish","type":"post","link":"https:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html","title":{"rendered":"Using Hash Algorithms in SQL Server"},"content":{"rendered":"<p>Sambil menunggu waktu berbuka puasa, saya coba isi untuk bereksplorasi mengenai pengamanan data menggunakan Hash Algorithms di SQL Server.<\/p>\n<p>SQL Server yang saya gunakan saat ini adalah SQL Server 2008, jadi artikel ini belum saya coba di SQL Server versi yang lain.<\/p>\n<p>Sama-sama kita ketahui bahwa ada 2 bentuk untuk melakukan Enkripsi. pertama adalah Enkripsi satu arah, yang kedua adalah Enkripsi dua arah. Enkripsi satu arah pemahaman paling simplenya adalah begitu kita melakukan enkripsi terhadap suatu data, maka sangat tidak mungkin untuk bisa melakukan proses dekripsi. Sedangkan Enkripsi dua arah bisa melakukan proses Dekripsi. Salah satu contoh Enkripsi dua arah bisa dilihat disini<\/p>\n<p><a title=\"Cell and Column-Level Encryption\" href=\"http:\/\/suherman.asia\/w2\/cell-column-level-encryption.html\">http:\/\/suherman.asia\/w2\/cell-column-level-encryption.html<\/a><\/p>\n<p>Hash Algorithms adalah salah satu metode untuk melakukan enkripsi satu arah. Namun perlu dicatat bahwa metode enkripsi satu arah sangat tidak disarankan untuk meng enkripsi data seperti Tanggal, Nilai Gaji pegawai atau misalkan nama-nama kota. Karena data \u2013data tersebut bisa dicoba dengan <a href=\"http:\/\/en.wikipedia.org\/wiki\/Brute_force_attack\" target=\"_blank\">Brute Force Attack<\/a>.<\/p>\n<p>Sample penggunaan Hash Algorithms di SQL Server :<\/p>\n<pre class=\"lang:tsql decode:true \">DECLARE @Pass1 varchar(20),   \r\n@Pass2 varchar(20),   \r\n@Pass3 varchar(20)   \r\n   \r\nset @Pass1='SUHERMAN_BANJARMASIN'   \r\nset @Pass2='SUHERMAN_banjarmasin'   \r\nset @Pass3='suherman_banjarmasin'   \r\n    \r\nselect Hashbytes('MD5',@Pass1) Pass1  \r\nselect Hashbytes('MD5',@Pass2) Pass2  \r\nselect Hashbytes('MD5',@Pass3) Pass3  \r\ngo<\/pre>\n<p>bila T-SQL diatas dijalankan, hasilnya adalah sbb :<\/p>\n<p><a href=\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/hash_5F00_509B66AD.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" title=\"hash\" src=\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/hash_5F00_thumb_5F00_32BCE2AC.jpg\" alt=\"hash\" width=\"359\" height=\"196\" border=\"0\" \/><\/a><\/p>\n<p>tampak pada gambar, walaupun data text yang di enkripsi sama-sama terdiri dari huruf \u2018suherman_banjarmasin\u2019, namun karena ditulis dengan cara yang berbeda, maka hasil enkripsinya juga berbeda.<\/p>\n<p>Salahsatu keuntungan menggunakan Hash algorithms adalah bila enkripsi tersebut dibuat menggunakan aplikasi Java, .NET atau php sekalipun, hasilnya adalah sama. Hash Algorithms juga sering digunakan untuk mengenkripsi password untuk login.<\/p>\n<p>demikian, semoga bermanfaat.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sambil menunggu waktu berbuka puasa, saya coba isi untuk bereksplorasi mengenai pengamanan data menggunakan Hash Algorithms di SQL Server. SQL Server yang saya gunakan saat ini adalah SQL Server 2008, jadi artikel ini belum saya coba di SQL Server versi yang lain. Sama-sama kita ketahui bahwa ada 2 bentuk untuk \u2026<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html\">Continue reading<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[7,87],"class_list":["post-17","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-hash-algorithms","tag-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using Hash Algorithms in SQL Server - Suherman Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Hash Algorithms in SQL Server - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"Sambil menunggu waktu berbuka puasa, saya coba isi untuk bereksplorasi mengenai pengamanan data menggunakan Hash Algorithms di SQL Server. SQL Server yang saya gunakan saat ini adalah SQL Server 2008, jadi artikel ini belum saya coba di SQL Server versi yang lain. Sama-sama kita ketahui bahwa ada 2 bentuk untuk \u2026 Continue reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html\" \/>\n<meta property=\"og:site_name\" content=\"Suherman Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-02T13:08:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-08-26T03:54:18+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/hash_5F00_thumb_5F00_32BCE2AC.jpg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"Using Hash Algorithms in SQL Server\",\"datePublished\":\"2014-01-02T13:08:36+00:00\",\"dateModified\":\"2014-08-26T03:54:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html\"},\"wordCount\":232,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/hash_5F00_thumb_5F00_32BCE2AC.jpg\",\"keywords\":[\"Hash Algorithms\",\"SQL Server\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html\",\"url\":\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html\",\"name\":\"Using Hash Algorithms in SQL Server - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#primaryimage\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/hash_5F00_thumb_5F00_32BCE2AC.jpg\",\"datePublished\":\"2014-01-02T13:08:36+00:00\",\"dateModified\":\"2014-08-26T03:54:18+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#primaryimage\",\"url\":\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/hash_5F00_thumb_5F00_32BCE2AC.jpg\",\"contentUrl\":\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/hash_5F00_thumb_5F00_32BCE2AC.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/suherman.asia\/w2\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Hash Algorithms in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/suherman.asia\/w2\/#website\",\"url\":\"http:\/\/suherman.asia\/w2\/\",\"name\":\"Suherman Blog\",\"description\":\"Just Another Geek Site\",\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/suherman.asia\/w2\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"caption\":\"admin\"},\"logo\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/suherman.asia\",\"https:\/\/www.facebook.com\/emantin34\",\"https:\/\/x.com\/emantin34\"],\"url\":\"https:\/\/suherman.asia\/w2\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using Hash Algorithms in SQL Server - Suherman Blog","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":"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html","og_locale":"en_US","og_type":"article","og_title":"Using Hash Algorithms in SQL Server - Suherman Blog","og_description":"Sambil menunggu waktu berbuka puasa, saya coba isi untuk bereksplorasi mengenai pengamanan data menggunakan Hash Algorithms di SQL Server. SQL Server yang saya gunakan saat ini adalah SQL Server 2008, jadi artikel ini belum saya coba di SQL Server versi yang lain. Sama-sama kita ketahui bahwa ada 2 bentuk untuk \u2026 Continue reading","og_url":"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html","og_site_name":"Suherman Blog","article_publisher":"https:\/\/www.facebook.com\/emantin34","article_author":"https:\/\/www.facebook.com\/emantin34","article_published_time":"2014-01-02T13:08:36+00:00","article_modified_time":"2014-08-26T03:54:18+00:00","og_image":[{"url":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/hash_5F00_thumb_5F00_32BCE2AC.jpg","type":"","width":"","height":""}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#article","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"Using Hash Algorithms in SQL Server","datePublished":"2014-01-02T13:08:36+00:00","dateModified":"2014-08-26T03:54:18+00:00","mainEntityOfPage":{"@id":"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html"},"wordCount":232,"commentCount":0,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"image":{"@id":"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#primaryimage"},"thumbnailUrl":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/hash_5F00_thumb_5F00_32BCE2AC.jpg","keywords":["Hash Algorithms","SQL Server"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html","url":"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html","name":"Using Hash Algorithms in SQL Server - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"primaryImageOfPage":{"@id":"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#primaryimage"},"image":{"@id":"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#primaryimage"},"thumbnailUrl":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/hash_5F00_thumb_5F00_32BCE2AC.jpg","datePublished":"2014-01-02T13:08:36+00:00","dateModified":"2014-08-26T03:54:18+00:00","breadcrumb":{"@id":"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#primaryimage","url":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/hash_5F00_thumb_5F00_32BCE2AC.jpg","contentUrl":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/hash_5F00_thumb_5F00_32BCE2AC.jpg"},{"@type":"BreadcrumbList","@id":"http:\/\/suherman.asia\/w2\/using-hash-algorithms-in-sql-server.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/suherman.asia\/w2"},{"@type":"ListItem","position":2,"name":"Using Hash Algorithms in SQL Server"}]},{"@type":"WebSite","@id":"http:\/\/suherman.asia\/w2\/#website","url":"http:\/\/suherman.asia\/w2\/","name":"Suherman Blog","description":"Just Another Geek Site","publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/suherman.asia\/w2\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","caption":"admin"},"logo":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/suherman.asia","https:\/\/www.facebook.com\/emantin34","https:\/\/x.com\/emantin34"],"url":"https:\/\/suherman.asia\/w2\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/comments?post=17"}],"version-history":[{"count":4,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/17\/revisions"}],"predecessor-version":[{"id":389,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/17\/revisions\/389"}],"wp:attachment":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=17"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=17"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}