July 30, 2014 at 3:07 pm
Can someone tell me the best place to go n learn Performance Tuning? I know there are ways to learn (books, blogs), but the company I work for is paying for the class, so I thought why not take advantage and learn something. I have seen 5 days classes with labs but haven't seen 1 which mainly focuses on Tuning, troubleshooting etc.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
July 30, 2014 at 3:14 pm
Try these guys...
http://www.sqlskills.com/sql-server-training/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 31, 2014 at 12:59 am
Or if you are from Europe you can check out SQLPassion[/url].
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2014 at 4:23 am
I'm putting on a full day of query tuning at Connections in September and at the PASS Summit in November. The advantage of going to either of these is that you also have the rest of the conference sessions to collect additional information and details.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 31, 2014 at 4:24 am
Oh, and if you are in Europe, I'm doing a full day on execution plans at SQL Server Days.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 31, 2014 at 8:42 am
Grant Fritchey (7/31/2014)
Oh, and if you are in Europe, I'm doing a full day on execution plans at SQL Server Days.
I live in Chicago, IL
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
July 31, 2014 at 8:56 am
New Born DBA (7/31/2014)
Grant Fritchey (7/31/2014)
Oh, and if you are in Europe, I'm doing a full day on execution plans at SQL Server Days.I live in Chicago, IL
So, you're employer isn't likely to spring for a trip to Belgium then. Oh well. There's still Connections and PASS Summit.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 31, 2014 at 9:02 am
Grant Fritchey (7/31/2014)
So, you're employer isn't likely to spring for a trip to Belgium then. Oh well. There's still Connections and PASS Summit.
Well we do have an open door policy and I can ask my manager anything I want, but sometimes I don't like the way he looks at me when I ask him these kind of questions like "I am thinking of going to Belgium and I need to know if the company will pay for it".:-)
I think I will try Brent Ozar. He offers courses which mainly focus on Performance.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
July 31, 2014 at 10:31 am
New Born DBA (7/31/2014)
Grant Fritchey (7/31/2014)
So, you're employer isn't likely to spring for a trip to Belgium then. Oh well. There's still Connections and PASS Summit.
Well we do have an open door policy and I can ask my manager anything I want, but sometimes I don't like the way he looks at me when I ask him these kind of questions like "I am thinking of going to Belgium and I need to know if the company will pay for it".:-)
I think I will try Brent Ozar. He offers courses which mainly focus on Performance.
He has some good stuff and is based right there in Chicago anyway. That helps.
SQLSkills does a lot of performance tuning training in Chicago too.
You couldn't really go wrong with some of these people.
I'd say if you were traveling to a SQL Saturday, I do precons at a bunch of those where we focus on performance.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 31, 2014 at 11:32 am
SQLRNNR (7/30/2014)
Try these guys...
If your company is paying, this. If your company is not paying, this (it's that good)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 31, 2014 at 1:12 pm
Grant Fritchey (7/31/2014)
New Born DBA (7/31/2014)
Grant Fritchey (7/31/2014)
Oh, and if you are in Europe, I'm doing a full day on execution plans at SQL Server Days.I live in Chicago, IL
So, you're employer isn't likely to spring for a trip to Belgium then.
Quite the shame... 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2014 at 3:57 pm
Books should be more valuable than classes. Look for titles by Kalen Delaney particularly. For general SQL skills, look for Itzik Ben-Gan.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
August 4, 2014 at 12:59 am
ScottPletcher (7/31/2014)
Books should be more valuable than classes. Look for titles by Kalen Delaney particularly. For general SQL skills, look for Itzik Ben-Gan.
Depends on the classes, and on the books 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply