Presentations

Performance Improvements in SQL Server 2008 Analysis Services

2008-08-19T22:30:00Z

On this episode of TechNet Radio, we’ll be discussing the performance improvements in SQL Server Analysis Services, the architecture behind it, what people should expect and potential gotchas. We will also feature our first installment of a new segment on TechNet Radio – our “Tip of the Week.” Listen in for a special promo code for the upcoming SQL PASS Community Summit.

You can download the interviews here: WMA | MP3 High | MP3 Low

How Microsoft IT Leverages SQL Server 2008 SSIS Dataflow Engine Enhancements

2008-06-04T05:47:00Z

The Information Security Consolidated Event Management (ICE) system is a more than 30-terabyte data warehouse used by the Microsoft Information Security team to analyze network utilization events captured by various sources, including over 100 proxy servers, mail servers, Net logon servers, etc. The ICE database processes approximately 1 terabyte of log data each day and it has become a key component in the incident response process, in addition to forensics investigations. Analysis of the proxy data has empowered the Microsoft Information Security team to identify and remediate numerous security issues that would have gone undetected otherwise.

ICE version 4.0 is an ambitious project set to deliver almost real-time data and high-query performance to the security team using Microsoft SQL Server 2008. Moreover, ICE 4.0 is also designed to perform all sorts of data filtering and transformation during the data-loading process, so the schema of data stored in ICE is tailored for investigation analysis/reporting needs. An Online Analytical Processing (OLAP) cube is built on top of the ICE data warehouse to facilitate aggregated queries. Join this session to learn how enhancements to the Microsoft SQL Server Integration Service (SSIS) 2008 dataflow engine have significantly improved the performance of loading, filtering and transforming 1 terabyte of network log data into the ICE data warehouse.

You can download the interviews here: WMA | MP3 Hi | MP3 Low

Troubleshooting SQL Server 2005/2008 Performance and Scalability Flowchart

2008-04-18T23:21:00Z

Author: Sharon Bjeletich

The following flowchart will address the majority of the most common performance and scalability issues that can arise in SQL Server-based applications.

http://sqlcat.com/files/folders/280/download.aspx

However, working through the flowchart is also recommended for applications that do not appear to have issues in those areas, as it will set a baseline for a system with a known performance and scalability characteristic. The flowchart is designed to be worked from the top down, left to right. It addresses the most impactful issues first, such as table scans, out of date statistics, etc. and the suggested readings are considered the basics for any DBA.

Please note that to be able to accurately use this flow chart you should put your system under load, and it should only be done in a test environment. For more information on how to load test SQL Server see Visual Studio Team System documentation.

A Look Inside SQLCAT (Customer Advisory Team)

2008-04-18T22:10:00Z

On this episode of TechNet Radio, we learn more about SQL CAT (Customer Advisory Team). With the launch of Microsoft SQL 2008 on the way, the SQL CAT team has been working hard preparing lists of best practices, recommendations, technical white papers and technical end-to-end case studies on customer implementations.

You can download the interviews here: WMA | MP3 Hi | MP3 Low

Technet Radio Interview with Mark Souza

2008-04-18T17:43:00Z

A Look at TechNet Edge

On this episode of TechNet Radio, we get the scoop on the new forum for IT Pros – TechNet Edge. We also feature highlights from the recent Vista SP1 Roundtable hosted by Mark Russinovich. Plus, we have a conversation with Mark Souza from SQL CAT (Customer Advisory Team).

You can download the interviews here: WMA | MP3 Hi | MP3 Low

Data Mining applied to medical research

2008-04-18T17:36:00Z

During the PASS 2007 Community summit in Denver, Zach Owens had interviewed Denny Lee from the SQL CAT team to discuss data mining tools and techniques being applied to academic research conducted on Asthma patients. For more information, check out the webcast on Channel 8.