{"id":3263,"date":"2012-08-09T10:00:00","date_gmt":"2012-08-09T17:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/"},"modified":"2024-01-22T22:49:35","modified_gmt":"2024-01-23T06:49:35","slug":"thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/","title":{"rendered":"Thai law enforcement optimizes investigations with Microsoft big data solution"},"content":{"rendered":"

If you\u2019ve been watching Be the Next Microsoft Employee <\/i>along with us, you probably know about the real-world filter on the competition\u2019s challenges \u2013 a metric that ensures that competitors are solving the same issues that companies face. And, just like we love seeing how participants approach the competition\u2019s challenges, we also love to share stories about how our customers are using our technology to tackle their real-life challenges. <\/span><\/p>\n

One of those customers is the Department of Special Investigation (DSI), a law enforcement agency for Thailand\u2019s Ministry of Justice, which maintains a large amount of data to support their criminal investigations. The agency\u2019s previous technology setup made it difficult for them to get useful information from their data, which, on top of containing images, videos and documents from crime scenes, also came from multiple sources within the agency. In fact, working with their data was so complicated that the agency was often forced to send employees back to crime scenes to re-gather information, slowing down important criminal investigations and costing DSI money. Additionally, the agency\u2019s existing system couldn\u2019t run automatic searches for obvious suspicious activity like large money transfers or mass movement by known criminals, limiting their ability to be proactive. <\/span><\/p>\n

Since their previous system was holding them back, DSI implemented a big data solution based on SQL Server 2012 and Apache Hadoop software. The result? A remarkable change in how they used their existing data to analyze cases. In a test case, identifying suspects took only 15 days, compared to the two years it took using a traditional investigative approach. <\/span><\/p>\n

Now investigators can receive and share actionable information more quickly, increasing the efficiency of their investigations. And, automatic, real-time notifications of suspicious activity mean the agency can take steps to prevent crimes from happening in the first place. According to DSI\u2019s Police Colonel Yannaphon Youngyuen, their big data solution optimizes the speed and accuracy of the agency\u2019s investigation processes, while solving issues that normally go hand-in-hand with managing large volumes of complex data. That\u2019s the kind of success story we\u2019re proud to be a part of!<\/span><\/p>\n

For more information about DSI\u2019s solution, check out the <\/span>case study<\/span><\/a>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

If you\u2019ve been watching Be the Next Microsoft Employee along with us, you probably know about the real-world filter on the competition\u2019s challenges \u2013 a metric that ensures that competitors are solving the same issues that companies face.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2445],"topic":[2451],"coauthors":[2487],"class_list":["post-3263","post","type-post","status-publish","format-standard","hentry","content-type-thought-leadership","topic-big-data"],"yoast_head":"\nThai law enforcement optimizes investigations with Microsoft big data solution - Microsoft SQL Server 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=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Thai law enforcement optimizes investigations with Microsoft big data solution - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"If you\u2019ve been watching Be the Next Microsoft Employee along with us, you probably know about the real-world filter on the competition\u2019s challenges \u2013 a metric that ensures that competitors are solving the same issues that companies face.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-09T17:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Thai law enforcement optimizes investigations with Microsoft big data solution\",\"datePublished\":\"2012-08-09T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/\"},\"wordCount\":377,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/\",\"name\":\"Thai law enforcement optimizes investigations with Microsoft big data solution - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2012-08-09T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Thai law enforcement optimizes investigations with Microsoft big data solution\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Thai law enforcement optimizes investigations with Microsoft big data solution - Microsoft SQL Server 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":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/","og_locale":"en_US","og_type":"article","og_title":"Thai law enforcement optimizes investigations with Microsoft big data solution - Microsoft SQL Server Blog","og_description":"If you\u2019ve been watching Be the Next Microsoft Employee along with us, you probably know about the real-world filter on the competition\u2019s challenges \u2013 a metric that ensures that competitors are solving the same issues that companies face.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2012-08-09T17:00:00+00:00","article_modified_time":"2024-01-23T06:49:35+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Thai law enforcement optimizes investigations with Microsoft big data solution","datePublished":"2012-08-09T17:00:00+00:00","dateModified":"2024-01-23T06:49:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/"},"wordCount":377,"commentCount":1,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/","name":"Thai law enforcement optimizes investigations with Microsoft big data solution - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2012-08-09T17:00:00+00:00","dateModified":"2024-01-23T06:49:35+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/08\/09\/thai-law-enforcement-optimizes-investigations-with-microsoft-big-data-solution\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Thai law enforcement optimizes investigations with Microsoft big data solution"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=3263"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3263\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=3263"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=3263"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=3263"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=3263"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=3263"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=3263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}