wGrow - Team Notes

It's essential to ensure that SQL Server is secure and protected against potential cyber threats. Government cybersecurity requirements mandate that all agencies' SQL Server must undergo hardening before being put into production. We summarize the comprehensive SQL Server hardening checklist and best practices to secure SQL Server environment for an agency data centre.

This technical article provides an overview of SQL Server Transparent Data Encryption (TDE) and demonstrates how to implement TDE in an ASP.NET web project. The article explains the benefits of TDE, the encryption process, and provides sample SQL and C# code to illustrate its use for securing sensitive data in a web application.

This article outlines the process of improving the performance of a commercial medical service provider's patient management system without resorting to expensive server upgrades. The solution involves separating employee and public portals, distributing data across multiple servers, implementing archiving and web services, and utilizing Windows Service scheduled timer jobs for report generation. The implementation is based on ASP.NET, MS SQL, and AWS infrastructure.

Efficient and accurate billing processes are crucial to the financial health of a business. In the case of a Singapore energy company, the finance department faced challenges in producing timely monthly billing reports for major corporate clients. With data spread across multiple servers and sub-system databases, the in-house IT department struggled to keep up with the demand for report generation. In this article, we discuss the design and implementation of a .NET-based report system that strea...

This article describes a secure and compliant visitor logging system for a Singapore hospital that ensures unique visitor identification while adhering to PDPA regulations. The solution uses a combination of hashed IC numbers and partial IC number verification. The implementation is built on the Microsoft .NET Framework, MS SQL, and Windows Server 2019.

In the complex world of global chemical imports, multinational corporations face the challenge of navigating diverse regulations and import limits across different countries. Furthermore, these limitations can change annually, and multi-country collaboration can lead to delays in the requirements gathering process. In this article, we discuss the implementation of a compliance check system that addresses these challenges while providing flexibility in production planning and material usage.