Posts Tagged ‘Internals’

Two Free Training Webcasts Open for Registration

Monday, May 24th, 2010

We’ve got two sessions that you (the “we” meaning the fine folks at Quest Software) need to sign up for right away.  The upcoming webcast for Oracle-oriented folks has huge registration numbers.  And I’m sure you’ll learn more than you expected thanks to my fine co-presenters.  Get in while you still can before we hit the limit of what LiveMeeting can handle!

Pain of the Week: SQL Server for the Oracle DBA

Webcast: SQL Server for the Oracle DBA
Date: Thursday, May 27, 2010 (Just a couple days hence!)
Time: 8 a.m. Pacific / 11 a.m. Eastern / 4 p.m. United Kingdom / 5 p.m. Central Europe
Duration: 45-60 minutes
Cost: FREE

In enterprise IT, database professionals face a mixed-bag of platforms within their environments — and the overlapping duties that go along with them. Whether you like it or not, you get asked to support Microsoft SQL Server operations even though you’re an Oracle DBA.

In this instructive webcast, experts from Microsoft and Quest with years of experience in both platforms will discuss the biggest issues and areas of interest for Oracle DBAs who need to work on Microsoft SQL Server. You’ll learn their tips and tricks for efficiency and gain a deeper understanding of SQL Server to help you add more value than ever to your organization.

Presenters:
Kevin Kline, SQL Server MVP, Quest Software
Buck Woody, Senior Technology Specialist, SQL Server, Microsoft


Pain of the Week: Easy Ways to Fix Hard SQL Server Problems – Without a Guru

Webcast: Easy Ways to Fix Hard SQL Server Problems – Without a Guru
Date: Thursday, June 17, 2010
Time: 8 a.m. Pacific / 11 a.m. Eastern / 4 p.m. United Kingdom / 5 p.m. Central Europe
Duration: 45-60 minutes
Cost: FREE
In this instructive webcast, you’ll learn straightforward methods for troubleshooting and resolving common poorly performing stored procedures and queries in SQL Server 2008. The presenters will show you how to easily:

  • Read query execution plans and identify bottlenecks in performance
  • Record system performance metrics for trend analysis
  • Design databases and write Transact–SQL code to avoid common problems
  • Understand what an index is, what it does, and how to build one
  • Use industry-accepted best practices and develop your own to arrive at optimal database performance

Much of the webcast is based on Grant’s book, “SQL Server 2008 Query Performance Tuning Distilled.

Don’t miss this chance to get practical advice from working experts instead of just theories from academics!
Presenters:
Kevin Kline, SQL Server MVP, Quest Software
Grant Fritchey, “Scary” DBA from FM Global

New Webcast – SQL Server Internals & Architecture

Tuesday, March 23rd, 2010

Join me tomorrow for the PASS DBA Virtual Chapter meeting SQL Server Internals & Architecture. It’s the most fun you’ll ever have learning about the inner workings of a relational database – I promise!

Click here to register.

You don’t have to register to attend.  But if you register today, you’ll be entered into the drawing to win one two copies of my bestselling reference SQL in a Nutshell, covering the ANSI standard plus Oracle 11, SQL Server 2008, MySQL 5.2, and PostgreSQL 8.3.

This is NOT the Chameleon in the Bud-Wise-ER commercials. At least I think it's not.

I’ve put the slide deck up in my Slides area of the website.  However, because it contains a lot of big images, I had to publish it as a PDF file to meet my size limits.  That means that all of the animations in the slide deck are shot – and this presentation relies heavily on animation.