Search results for 'app:weblogs' matching tags 'Testing' and 'stored procedures'

Cumulative Update Package 1 for SQL Server 2008

Anonymous — Wed, 01 Oct 2008 05:00:00 GMT

First one in the series of SQL Server 2008 version, here it comes Cumulative Update package 1! What kind of fixtures are available in this CU1 package? Cumulative Update 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed since the release of SQL Server 2008. After you apply this CU1 on SQL 2008 instance the build number should be 10.00.1763.00, this is to help you that whether the application has been applied successfully or not. As a best practice and I prefer/recommend...(read more)

SQL Server 2008 Change Data Capture - Do you really want to log all the data activities such as audit trails?

Anonymous — Fri, 01 Feb 2008 06:00:00 GMT

In continuing from the series of Change-Data-Capture tags on this site I have been testing through this CDC feature on my test environment, which has proved fruitful results (to some extent). But the in the real world scenario do you really need to log all such activites? As you may be aware that logging the data related activites is a 'must' for financial based enterprises such as Banks & Insurance in order to safeguard their data and helping in security too. This often called as Audit Trial...(read more)