Skip to main content Microsoft Intelligent Data Platform Azure Arc Azure databases Power BI SQL Server 2025 SQL Server BI SQL Server 2022 SQL Server 2019 SQL Server 2017 SQL Server 2016 SQL Server 2005 - 2014 Downloads Community SQL End of Support Data Security - SQL Server Encryption SQL Server blog SQL Server and Azure SQL workshops Browse Microsoft Solutions Hub SQL Server Tech Community Azure Databases Tech Community Azure Synapse Analytics Tech Community Developer Find a partner Become a partner Partner resources Try SQL Server 2025 Microsoft Security Azure Dynamics 365 Microsoft 365 Microsoft Teams Windows 365 Microsoft AI Azure Space Mixed reality Microsoft HoloLens Microsoft Viva Quantum computing Sustainability Education Automotive Financial services Government Healthcare Manufacturing Retail Find a partner Become a partner Partner Network Microsoft Marketplace Marketplace Rewards Software development companies Blog Microsoft Advertising Developer Center Documentation Events Licensing Microsoft Learn Microsoft Research View Sitemap

Thai law enforcement optimizes investigations with Microsoft big data solution

If you’ve been watching Be the Next Microsoft Employee along with us, you probably know about the real-world filter on the competition’s challenges – 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’s challenges, we also love to share stories about how our customers are using our technology to tackle their real-life challenges.

One of those customers is the Department of Special Investigation (DSI), a law enforcement agency for Thailand’s Ministry of Justice, which maintains a large amount of data to support their criminal investigations. The agency’s 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’s existing system couldn’t run automatic searches for obvious suspicious activity like large money transfers or mass movement by known criminals, limiting their ability to be proactive.

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.

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’s Police Colonel Yannaphon Youngyuen, their big data solution optimizes the speed and accuracy of the agency’s investigation processes, while solving issues that normally go hand-in-hand with managing large volumes of complex data. That’s the kind of success story we’re proud to be a part of!

For more information about DSI’s solution, check out the case study.

English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Microsoft Privacy Manage cookies Terms of use Trademarks Safety & eco Recycling About our ads