Browse by Tags
All Tags »
pack (RSS)
If you work in Financial based Enterprise then Sarbanes-Oxley is not a new concept for you as per American law that regulates the accountability of publicly owned companies. Just to talk about t he main purpose of the law it to make sure the financial
Read More...
DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the
Read More...
Comparing data and/or schema within your SQL Server environment is a common task when you have to port the data from Development to Production environment. To compare the schema (tables) between the 2 SQL instances is very easy and you can accomplish
Read More...
Very interesting insight of security topics on Windows operating system by Aaron Margosis.
Read More...
There has been lot of issues with SSIS packages since the release of SQL Server 2005 and few of them were corrected in Service pack releases. Still there are few existing on SQL 2005 editions creating issues when a script task or a script component that
Read More...
One of the developer in our team gave me a call to seek help on the issue they are facing, they are unable to modify or open the DTS package in SQL Server Management Studio. The Server they are working is SQL 2000 version and due to the mixture of 2005
Read More...
With the latest release of SP2 Update release it has been a rumour in the community that it is a SP2a release, which I believe not as it is intended to fix a particular issue with cleanup tasks and maintenance plans. As the remaining tasks with Service
Read More...