Nice things inside SQL Server, System Center Configuration Manager

Introduction In the real world customer scenarios, the customer data can be of heterogeneous and semi structured stored inside SQL Sever tables. In such tables, the data can have different properties applying to different set of subsets of rows. In...

Prior to SQL Server 2008, the only way to audit the SELECT statements is to use SQL Server Profiler or server side trace. Now using SQL Server 2008 Enterprise, auditing feature is used to audit on SELECT statements. We cannot use triggers as triggers...