Dan English and I are doing another webcast this Wednesday, October 15th @ 1:00 pm CST:

Driving Business Intelligence with: Microsoft SQL Server 2008

Business Users and Developers:

Get the latest info on how SQL Server platform enhancements have taken developer productively and the end-user experience to unprecedented levels.

Join Magenic as we discuss and demonstrate some of SQL Server 2008’s latest, most important improvements and show business users and developers how to leverage them.

Magenic’s Aaron Lowe and Dan English will examine these specific features:

• New features including SQL Server Change Data Capture, SSIS Data Profiling Task, SSIS Cache Transform, SSIS Lookup Transform Improvements, SSRS Tablix, SSRS New Data Visualizations and Improvements and Report Builder 2.0
• Highlights of SSAS Data Management Views, SSAS Designer Enhancements, SSAS AMO Warnings, T-SQL Merge Statement and T-SQL Grouping Sets Syntax
• Predictive Analysis

Feel free to register here and make sure to check out other Magenic events.

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 

Presentation: SQL Server 2008 – What do you want to know about it?

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

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.