Entries tagged with sql - TechNet Edge

SQL 2008 Virtualization and Consolidation with Charley Hanania

extreme — Fri, 22 Aug 2008 07:01:00 GMT

Charley Hanania is a Senior Database Specialist, working as the Production Product Owner of the MS SQL Server platform at UBS. Charley talks a little about how SQL 2008 will help to resolve some key enterprise database challenges. He talks about Policy Based Management (PBM, formerly known as DMF), resource governor, consolidation and virtualization of SQL Server.

Some other topics he talks about:

Considerations to think about when going from SQL 2005 to 2008
Data compression helping with IO for consolidation and virtualization

At 2:48 we do a whiteboard session with Charley on database consolidation and virtualization in the environment. He also gives us insight into what implications SQL 2005 versus SQL 2008 have in this scenario.

Some useful links from Charley:

Trivadis and SQL Server 2008 Customer story

extreme — Fri, 08 Aug 2008 07:01:00 GMT

Meinrad Weiss is a principal consultant at Trivadis AG and Microsoft MSDN Regional Director Switzerland who among other things conduct database migration, like for example from SQL 2005 to SQL 2008. In this video, he tells us:

- Advantages they have seen with SQL 2008 analysis services over SQL 2005

- Some benefits of SQL 2008 reporting services (such as up to 10 times faster performance on certain queries)

- Highlights improvements in the relational database with SQL 2008

- Things to look out for when implementing filestreams

SQL 2008 has hit RTM!

Learn more about SQL 2008

TechNet Radio: How Microsoft IT Leverages SQL Server 2008 SSIS Dataflow Engine Enhancements

erickingfrog — Tue, 20 May 2008 17:48:00 GMT

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.

SQL Server Auditing and Compliance

Joey — Wed, 23 Apr 2008 07:01:00 GMT

A hot topic for the IT Pro is compliance. Government and other regulation compliance challenges exist all over the IT infrastructure. I had a chance to sit down with JC Cannon in the SQL product group to discuss how SQL Server 2008 addresses compliance and auditing in SQL Server 2008, as well as how new tools such as Policy Based Management can help in the IT Pro's mission to achieve compliance.

SQL Server Upgrade with Joe Yong

Joey — Mon, 07 Apr 2008 16:33:00 GMT

One of the biggest challenges when a new product is released is upgrades. I had a chance to sit down with SQL upgrade guru Joe Yong from Scalability Experts. We chat about upgrading from SQL Server 2000 and SQL Server 2005 to SQL Server 2008. Joe explains the differences in the Upgrade tools in SQL Server 2008 as well as providing us some guidance in setting up lab environments for upgrade testing. Visit Joe's blog at http://blog.scalabilityexperts.com/.

TechNet Radio: A look inside SQLCAT (Customer Advisory Team)

erickingfrog — Tue, 25 Mar 2008 19:10:00 GMT

On this episode of TechNet Radio, We learn more about SQL CAT – the SQL Customer Advisory Team. With Launch of SQL 2008 on the way, the SQL CAT team has been working hard preparing lists of best practices, recommendations, technical whitepapers and technical end-to-end case studies on customer implementations.

TechNet Radio: A Look at TechNet Edge

erickingfrog — Tue, 18 Mar 2008 16:48:00 GMT

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).

TechNet Radio: SQL 2008 Part 2 of 2: Management, Troubleshooting and Throttling

erickingfrog — Tue, 11 Mar 2008 19:46:00 GMT

Listen to this two-part series as Bryan von Axelson talks with industry experts Kimberly Tripp and Paul S. Randal about what’s new in SQL 2008. Part two focuses on Management, Troubleshooting and Throttling. We also have our monthly Security Bulletin.