SQLKnowledge.com

Day by day Experience of a Microsoft SQL Server production DBA & Consultant..

Audit databases – using ddl triggers

 
As a DBA, do you ever wonder what is going inside your production database? Who is changing database schema during production time without informing you. Now, you need not to worry, you can setup DDL triggers to easily records all changes in table; like what was changed, when and by whom etc. Given is two [...]

Hot topics to work on in SQL 2008

I am working on some of following topics that are considerably new in SQL 2008. Leave a comment, if you have more topics like these or experience to share with us?
- Prepare a Audit script using SQL 2008 feature for High/Moderate/Low category servers.
- Setup a Central Management Servers
- Standardize & implement Data Collector and [...]

Common logshipping issues!

While working on SQL Server logshipping a DBA must consider following points to have log shipping setup running smoothly over a long period of time.
1. Transaction log Backup and restoration jobs should work constantly (in parallel) and if backup/restoration jobs are not in sync due to network/server or any other issue it will crash logshipping [...]