SQL Server DBA Checklist

1. Check OS Event Logs, SQL Server Logs, and Security Logs for unusual events.
2. Verify that all scheduled jobs have run successfully.
3. Confirm that backups have been made and successfully saved to a secure location.
4. Monitor disk space to ensure your SQL Servers won’t run out of disk space.
5. Throughout the day, periodically monitor performance [...]

Read Full Post »

SQL Server 2008 Features

Please visit http://sqldbpool.blogspot.com/
(for more database related articles)

New index types
New Data Types
Intellisense
Performance Data Collection with Performance Studio
Policy-Based Management
Data Compression
Resource Governor
Transparent Data Encryption
Database Mirroring
Auditing
Change Tracking and Change Data Capture
LINQ
Multi-server script execution
Extended events
Integrated Full-Text Search
Sparse columns
PowerShell integration
For more feature

Please visit http://sqldbpool.blogspot.com/
(for more database related articles)

Read Full Post »