Posts Tagged ‘DMV’

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

Where you can find me at the PASS Summit

Sunday, November 1st, 2009

In previous years, I hardly had time to sit down and catch a breather at a PASS Summit.  Between my duties as an officer of PASS, exhibit hall time with Quest Software (my employer), speaking in my own sessions, and meeting with PASS volunteers and community organizers, I was busy from the crack of dawn until midnight all week long.

Fortunately, those grueling marathons are fading into the past. I still have a busy slate ahead of me for next week.  But it looks like I’ll even have time to attend some sessions.  Yeah!  Here’s what I’ve currently got planned:

Monday, Nov 2

Depart for Seattle, 5:10 am.  O.M.G. – that means I have to get up before I go to bed.

Noon, arrive in Seattle

Lunch with the PASS board of directors

Networking Seminar, by Don Gabor, from 4:30 – 6:30 pm

PASS Quiz Bowl & Welcome Reception, playing in a team with the mighty BrentO, from 6:30 – 8:00 pm

SQLServerCentral Party, from 8:00 – 10:00 pm

Collapse

Tuesday, Nov 3

Keynote, 7:45 – 10:00 am

Birds of a Feather Luncheon, 11:45 – 1:00 pm, hosting the table “Moving from Technologist to Manager”

Exhibit Hall at the Quest Software booth, 11:00 – 4:00 pm

Session “The Ultimate Free SQL Server Toolkit”, 3:00 – 4:15 pm, Room 615-617

Book Signing at the Quest Software booth, 6:00 – 8:00 pm, giving away signed copies of Database Benchmarking

Microsoft MVP Insider Event, until 10:00 pm

Collapse

Wednesday, Nov 4

Quest Breakfast seminar and live webcast, Simplify Management with DMVs, 7:00 – 8:30 am, along with other SQL Server luminaries BrentO, Buck Woody, Louis Davidson, and Tim Ford.

MVP Deep Dives Book Signing, 11:30 – 12:00 pm, Come out get a book signed by all the authors!

PASS Board Q&A, 4:30 – 6:15 pm, Room 6E

I’ll also be popping out for meetings with various Microsoft PMs, a dinner with my Quest colleagues, and plenty of time in the exhibit hall at the Quest Software booth.

Collapse

Thursday, Nov 5

Session “Team Management Crash Course”, 10:45 – 12:00 pm, Room 612

Chapter Luncheon, 12:00 – 1:00 pm, Expo Hall 4b.  Come and join me, especially if you’re anywhere near the local PASS chapter in Music City – Nashville, TN.

Friday, Nov 6

Early departure back to Nashville.  In years past, I always had to stay until Saturday morning because of all of the important PASS work going on.  The important PASS work still goes on, but it’s in the able hands of a new generation of leaders.  As for me, I get to head home to be with my family one day early.  Yippee!

I hope to see you there.  Don’t forget the really awesome and cool SQL Twitter Bingo, if you’re in to Twitter.  The rules are HERE and the bingo cards are HERE.

Cheers,

-Kevin

Twitter @kekline

New Post on my SQLMag Blog – Free DMV Monitoring Tools

Monday, September 21st, 2009

I’ve posted a new entry on my SQL Server Magazine blog about two free DMV monitoring tools available on CodePlex.

Read the article here:

http://www.sqlmag.com/Articles/ArticleID/102837/102837.html?Ad=1

Take a look at the two tools and let me know which you like better and why.  Inquiring minds want to know!

Cheers,

-Kev