Aaron's space

You may have noticed I haven't blogged much lately, well that's because I have been working on my new Internet home.  Please update your links to http://www.aaronlowe.net as I will continue to blog there.  Live spaces was good but I wanted  a little bit more flexibility.

Just saw a post by Jason here about http://www.sqlservervideos.com/.  I immediately went to check it out and wasn't disappointed.  I especially liked the fact that they had 400 level videos.  So what are you waiting for?  Go check it out!

I'm speaking at the Wisconsin SQL Server User Group in Waukesha, WI this Tuesday (8/12).  If you are interested, RSVP to SQLDBA@new.rr.com 

SQL Server 2008 introduces a framework for collecting, storing and reporting on server, database, and query performance data.  In order to store and persist performance information, SQL Server 2008 includes a Management Data Warehouse designed to house performance metrics from multiple instances of SQL Server.  In addition, SQL Server 2008 provides Data Collectors to facilitate scheduled capture of common system and database performance measures including DMVs, Windows Performance Counters, T-SQL queries, and SQL Trace.  Microsoft completes the picture with a series of reports and views into the system and database performance.

In this session, we will take a closer look at the SQL Server 2008 Management Data Warehouse capabilities including:

· Setup and structure of the Management Data Warehouse database

· approaches Review the standard data collection types included with SQL Server 2008

· Demonstrate the reporting and analysis capabilities

· Discuss to defining and creating custom data collectors

Share this post :

Transparent data encryption (TDE) performs real-time I/O encryption and decryption of the data and log files.

Encryption of the database file is performed at the page level. The pages in an encrypted database are encrypted before they are written to disk and decrypted when read into memory.

TDE provides the ability to comply with many laws, regulations, and guidelines established in various industries. This enables software developers to encrypt data by using AES and 3DES encryption algorithms without changing existing applications.

Check out a screencast about the new Transparent Data Encryption feature in SQL Server 2008 via MSN Video below, or if you prefer YouTube or download.

Well it looks like SQL 2008 RTM'd at TechEd in South Africa.  Take a look at Aaron Bertrand's post or sqlmag