Hot topics to work on in SQL 2008
Posted on | June 4, 2010 | No Comments
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 Management Data Warehouse for High category SQL Servers
- Implement Data Compression to reduce the size of your VLDB
- Apply policy based management for all DB Servers in your orgaziation
- Distribute your high volume application’s workload/T-SQL streams using resource governor
- Use TDE in your environment.
Category: SQL DBA
Tags: audit > compression > data collector > management > policy > resource governor > vldb > warehouse > workload
Tags: audit > compression > data collector > management > policy > resource governor > vldb > warehouse > workload
Comments
Leave a Reply
Categories
Archives
Recent Posts
Tags
administrator
alarm
audit
bufer
cache
change log
checkpoint
compression
data collector
DBA
dbcc checkdb update sql perfmon
DDL Triggers
DDL_DATABASE_LEVEL_EVENTS
disk space shrink dbcc shrinkfile database sql server shrink
email
event
event_instance
high availability
lazywriter
log
logshipping
management
memory
mirroring
msdb
notification
policy
resource governor
restart
restore
shipping
sp
sql
sql audit
sql server
stored procedure
vldb
warehouse
workload
SQLKnowledge.com
- Audit databases – using ddl triggers
- Hot topics to work on in SQL 2008
- Common logshipping issues!
- Join us on LinkedIn
- List of Undocumented DBCC command..
- How long does a SP stay in the cache?
- Get Notification as soon as SQL Services are restarted
- Script to find used and free space in Database files
- Website renovated