Mitch Wheat - Treat the cause, not the symptoms!

We are fortunate to have Brad McGehee present two sessions while he is in Perth. The second session is "Introduction to the SQL Server 2008 Data Collector". In previous versions of SQL Server, performance tuning was often difficult because the available tools weren't always easy to use or interpret. In SQL Server 2008, Microsoft is introducing the Performance Data Collector. This comprehensive new toolset has been designed to integrate the collection, analysis, troubleshooting, and persistence of SQL Server diagnostic information, making the jobs of DBAs much easier. 

• TOPIC: Introduction to the SQL Server 2008 Data Collector - Brad McGehee
• DATE:   Friday, Oct 2nd, 5:30pm - 7:00pm
• VENUE: Excom, Ground Floor, 23 Barrack Street, Perth
• COST:   Free. All welcome

Brad McGehee is a MCSE+I, MCSD, and MCT (former) with a Bachelors’ degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 14 years’ SQL Server experience, over 6 years’ training experience, and has been involved in the industry since 1982. He is a frequent speaker at SQL PASS, European PASS, SQL Connections, SQLTeach, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL Server user groups, and other industry seminars.

RedGate have generously donated a license to their excellent SQL Compare Pro.

More details here.

Join us at the Perth .NET User Group in October for two talks with a SQL Server focus, aimed at both Developers and DBAs. We are fortunate to have RedGate's Brad McGehee present two sessions while he is in Perth. Brad is a frequent speaker at conferences around the world.

The first talk is Thurs October 1st, where Brad will present on "How to Interpret Graphical Execution Plans". One of the SQL Server black arts is how to read and interpret graphical Query Execution Plans. This is a key thing to understand as Execution Plans provide valuable clues as to why a particular query may be running slowly. In this session, you will learn how to read an Execution Plan, and learn what to do with the information you have gained from reading it.

• TOPIC: How to Interpret Graphical Execution Plans - Brad McGehee
• DATE:     Thursday, Oct 1st, 5:30pm - 7:00pm
• VENUE:  Excom, Ground Floor, 23 Barrack Street, Perth
• COST:     Free. All welcome

Brad McGehee is a MCSE+I, MCSD, and MCT (former) with a Bachelors’ degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 14 years’ SQL Server experience, over 6 years’ training experience, and has been involved in the industry since 1982. He is a frequent speaker at SQL PASS, European PASS, SQL Connections, SQLTeach, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL Server user groups, and other industry seminars.

We will have pizza at this session courtesy of INETA.

RedGate have generously donated a license to their excellent ANTS Memory Profiler Pro. There is also a door prize of a choice of license from JetBrains (one of ReSharper , TeamCity Build Agent, dotTrace Profiler, RubyMine, IntelliJ IDEA).

Try to arrive early if you want a seat!

More details here.

Microsoft has launched a new initiative, WebSiteSpark, aimed specifically at independent web developers and small web development companies.  The only two requirements to join the program are:

1. Your company builds web sites and web application on behalf of others.
2. Your company currently has less than 10 employees.

The Australian launch of WebSiteSpark will be on the 8th of October.

What do you get?

Software licenses that you can use for three years AT NO COST.  Once enrolled, you can download and immediately use the following software from Microsoft:

• 3 licenses of Visual Studio 2008 Professional Edition
• 1 license of Expression Studio 3 (which includes Expression Blend, Sketchflow, and Web)
• 2 licenses of Expression Web 3
• 4 processor licenses of Windows Web Server 2008 R2
• 4 processor licenses of SQL Server 2008 Web Edition
• DotNetPanel control panel (enabling easy remote/hosted management of your servers)

The Windows Server and SQL Server licenses can be used for both development and production deployment.  You can either self-host the servers on your own, or use the licenses with a hoster. 

For more info see Scott Guthrie’s post: Announcing the WebsiteSpark Program

Even though you no longer have to worry about disk partition alignment for SQL Server on Windows Server 2008 (you did on Windows Server 2003 and Earlier; see Disk Partition Alignment Best Practices for SQL Server), there are still important tuning parameters and settings that can result in improved performance for the Windows Server 2008 R2 operating system. You can download the document from here: Performance Tuning Guidelines for Windows Server 2008 R2.

It is often said that Richard Feynman was truly a magician. The Tuva project (apparently Bill Gates is its sponsor) at Microsoft Research is showing Richard Feynman’s ‘Messenger Series’ lectures. Although the format is slightly dated (check out the non-wireless microphone!), it does nothing to hide Richard Feynman’s infectious enthusiasm for science and its exposition. As Bill notes in his introduction, his motivation for making these publicly available is "...everybody ought to see these, as they make science interesting...".

If this has whet your appetite, check out The Feynman Lectures on Physics including Feynman's Tips on Physics: The Definitive and Extended Edition