Interested in my various performance tuning and troubleshooting videos about SQL Server? These videos feature my good buddies (and uber-SQL Server experts) Brent Ozar (blog | twitter) and Buck Woody (blog | twitter). View these insight-packed training videos from our SQL Server training events originally presented on March 3 and July 21 of 2010:HERE.
You can watch the videos now at the URL above or order a DVD, shipped free of charge in the USA and Canada, HERE.
Kevin Kline will offer insight into best practices for SQL Server 2005 set up, configuration and queries. He will also discuss tuning for both the server and hardware to help an application perform better after it is deployed. This presentation will offer a better understanding of several SQL Server performance related areas including:
* Hardware design
* SQL Server configuration settings
* Database configuration settings
* Application design
* SQL Tuning
Need to troubleshoot SQL Server 2005 memory settings? Not sure where to look to measure SQL 2000 memory pressure? Kevin lays out your options in today’s podcast.
You can view this video in higher quality or your favorite portable formats at:
Gain insight into best practices for SQL Server optimization and ways to alleviate many root causes that can impact performance of your SQL Server database. Kevin also will discuss how to manage for planned and unplanned changes, speed time to implementation of your applications and ensure that your databases are running as they should.
You will learn how to:
* Identify the root cause of bottlenecks that hinder performance of your SQL Server environment
* Diagnose and fix T-SQL errors in development before code goes into production
* Learn new best practices for project planning and formatting your code
* Ensure that your code is scalable, optimized and validated
* Resolve 60-80% of the performance bottlenecks attributed to poorly written SQL
Since the release of SQL Server 2005, companies have been investing heavily in SQL Server for their business-critical applications. DBAs are now challenged with supporting ever-growing datasets and making efficient use of allocated disk space in both production and enterprise storage environments. Yet DBAs seldom have a clear picture of their data storage and therefore cannot determine whether they are getting a worthwhile return on their storage investment or if an out-of-disk situation is looming.
In this presentation, Kevin will address these challenges and explore methodologies to help you efficiently use allocated disk space for enterprise storage and production environments.
Microsoft SQL Server’s relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 provided a much-needed equivalent to Oracle’s long-standing and capable V$ and X$ system views. SQL Server 2008 has provided another dramatic improvement to its instrumentation with Extended Events (also known as XEvents) that promises to offer even greater opportunities to tune, trace and troubleshoot the inner workings of a SQL Server application. All of this stands in stark contrast with the anemic instrumentation offered in SQL Server Analysis Services, Microsoft’s wonderful multi-dimensional data repository that is a free feature-set within the SQL Server product. [READ MORE]
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!
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
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
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
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.
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.
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.
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.
