Archive for May, 2010

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

The Data Detective is on the Case (And I Can Hook You Up for Free!)

Wednesday, May 19th, 2010

You may have seen a new super sleuth around Quest.com and Toad World – The Data Detective!

Toad for Data Analysis

Everyone wants good data, but not everyone wants to work hard to get it

The team at Quest Software has created a new comic series where users can learn how Toad for Data Analysts will help you find, understand and report on data.  Plus, you can take part in a contest to win a free one-year license of TDA!

The first in the comic book series is posted here.  And there’s one each month.  If you contact me directly, I can help you get to the front of the line for the contest!

SQL Saturday is Coming to Nashville! Won’t You?

Monday, May 17th, 2010

How ‘Bout a Little Context?

Let me be direct with you.  I love SQL Saturday.  If it were a woman, I’d marry it.  (Avoiding all extraneous thoughts of what my real wife would say, etc etc).

Check out this fun Flickr Feed from the recent SQL Saturday in Chicago or these picks by Jorge Segara (blog | twitter) to see the sort of fun that’s in store.  But who can argue with a day of free SQL Server training and a chance to network with great presenters and a wide swath of your peers?

Kevin keynoting with Brent Ozar at the Chicago SQL Saturday

Keynotes are more fun when the put-downs fly!

I’ve tried to support SQL Saturday as much as I can since Andy Warren (blog | twitter) launched the program a couple years back and have spoken at several.  You might say to yourself, “Self, Kevin works for a vendor. Don’t they want him to speak at as many SQL Saturdays as is humanly possible?”  Well, Mr. Self, you’d be mistaken.  You see there’s a keyword in the name that might reveal why my employer doesn’t provide unlimited enthusiasm for me to speak … it’s the SATURDAY part of the whole thing.  Yes, of course, my employer wants me there.  But they also recognize that Saturdays are my own and that, if I spend a day or two there on the weekend (including the travel time), then that’s a sacrifice of my own choice.  I would still need to be at work and on task bright and early on Monday morning.  Not that they’d make me, it’s just that my job is the sort that work is never simply skipped, it is only ever deferred.  So if I took a comp day, which they’d gladly provide, I’d still have to finish the work somehow, someway.  All of this goes to say that I really, really love SQL Saturday, the community vibe that it creates, the volunteers who drive it, the folks who attend.  So I’m happy to give up a few days throughout the year to support it.

Come to Nashville in August!

Guitar, Cowboy Boots, Cowboy Hat, and Tight Denim NOT Required

My good friends Joe Webb (blog | twitter) and Louis Davidson (blog | twitter) have been angling to host a SQL Saturday here in Nashville for quite a while.  As co-leaders of the local PASS chapter in middle Tennessee, it made a lot of sense to host an event like this.  I wasn’t at all resistant to the idea, I just didn’t want to do the work myself.  However, they did a great job of getting the ball rolling and even took on the majority of work themselves.  Together with other volunteers in our local chapter – Shelton Dickson, Roberto Lopez, and Christina Leo – we’ve all set to work to host SQL Saturday #51.

The event will be hosted on Saturday, August 21st at the shiny new facility of Nashville State Community College located at 120 White Bridge Rd. Nashville, TN 37209:

Provided at No Charge by the Wonderful Folks at Nashville State Community College

  • If you’d like to attend, check out all the details here.  Joe Webb and Christina Leo get all the credit for logistics.
  • If you’d like to speak, read the details in our call for speakers here.  Louis Davidson is running the program selection process.
  • If you’d like to sponsor, sign up on-line here.  This one is my responsibility.
  • It’s free to register, there is a $10 fee if you want us to provide lunch.  And remember, seats always fill up fast!
  • If you’re going to attend and you have a twitter account, be sure to tweet using #sqlsat51!

I hope to see you there in August!

Join Me in N’Orleans at Microsoft TechEd 2010!

Friday, May 7th, 2010

Microsoft Tech·Ed North America 2010

June 7-10, 2010

New Orleans Morial Convention Center
900 Convention Center Boulevard
New Orleans, LA USA

I'll be there with bells on! Look for me at the Ask-the-Experts lounge or the Quest Software exhibit.

CONFERENCE AGENDA

Wondering if you should go?  It’s all about the education.  So check for the most current and detailed conference agenda at https://northamerica.msteched.com.

TECH·ED ONLINE www.microsoft.com/teched

Can’t make it in person?  There’s still good things in store for you!  Tech·Ed Online offers on-demand technical sessions recorded at our Worldwide Tech·Ed events that explore all aspects of current and soon-to-release Microsoft technologies, tools, platforms and services. View TechTalks, Panel Discussions, and Breakout sessions delivered by industry experts and leaders, engage with community influencers on Tech·Ed Blogs, and share your onsite Tech·Ed experience on the photo page.

I hope to see you there!

-Kevin

-Twitter @kekline