Column Level Encryption in SQL Server

Introduction Encryption… it’s one of the oldest methodologies that began thousands of years back during the time of the Greeks. With advancement in engineering and technology in the 21st century and with larger and powerful supercomputers there’s a necessity to create stronger encrypting algorithms with an mathematical approach to the subject than a digital one.“Elliptical […]

Read more "Column Level Encryption in SQL Server"

CLR Based Objects In SQL Server

SQL Server inherently supports only TSQL (Microsoft proprietary extension of SQL) programming language. But with the advent of SQL Server 2005 it became possible to execute and create SQL Server objects using the CLR (Common Language Runtime) of the .Net framework.The .Net framework was natively integrated into SQL Server 2005 and is still being supported […]

Read more "CLR Based Objects In SQL Server"

Dynamics AX 2012: Make manual changes to InventTrans? Recalculate the InventSum table automatically

If you were forced to make manual updates to the InventTrans table, your on-hand inventory counts may look off. Fortunately, there’s a built-in class to recalculate the InventSum table: InventSumRecalcItem InventSumRecalcItem; InventSumRecalcItem = new InventSumRecalcItem(“ItemID”, TRUE, checkfix::fix); InventSumRecalcItem.updatenow(); Replace “ItemID” with the ItemID of the item you wish to correct. The second parameter (TRUE or […]

Read more "Dynamics AX 2012: Make manual changes to InventTrans? Recalculate the InventSum table automatically"