Srinivasulu Nasam

Create Log tables and Triggers

Usually in business applications it is necessary to maintain the history of the data being modified for auditing purposes or for later analysis. Proven way to achieve this is to create a log table for each datatable with an additional column "Action" to indicate what the user has done on the data (either insert, update […]

1.17 (6)

2007-10-26 (first published: )

3,555 reads

Blogs

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

CRM Data Source Connection Error

By

This article takes us to the edge with a couple of CRM related errors...

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Read the latest Blogs

Forums

Detereming Trends in SSAS Cube

By Freefall99

I have Analysis Services cubes with over 200 dimensions in them (product requirement believe...

SSDT server setup and using 3rd party tools across servers

By dmusson17

Hello, We are a small shop and want to run, for data warehousing/reporting, 2016...

Migration sandbox

By tcroninlifepoint

Inherited about 190 2008 servers I need to migrate.  Was going to build 2014/16...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers