Today I came across 2 articles relating to SQL server. The first, talks about determining events that take place during a time slice. I can see possible uses for this in scheduling, and definite use in reporting.
The second article, discusses some new features and functionality in SQL 2008. Below are some quick notes that were important to me.
- Transparent DB encryption – I’m more in interested in transparent table encryption, including indexes (in case the index contains sensitive data). Further research is needed. I know SQL 2005 has some encryption functionality, so I’m interested in what has exactly changed.
- Built in support for auditing data. Configured thru T-SQL.
- Data Compression.
- MS says slight processor performance hit on compression, but made up due to less I/O.
- It will be an interesting exercise to see how this will work on VMWare.
- Resource Governor
- Prevent users or groups from consuming high levels of resources.
- Since everyone is going to be coming in as Network Service (a rather large assumption), be interesting to see if we can still take advantage of this
- HotPlug CPU
- Don’t know if we can take advantage of this. Probably only if we were using blades.
- Performance Data
- Sql Dashboard to display
- Suggestions for improving performance
- Current and historical data
- Installation sounds allot easier
- Configuration data separate from engine, so you should be able to setup once, deploy multiple servers and then configure.
- Should help with cloning.