Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Career
»
Presentations and Speaking
»
Critique: SQL Agent for the Beginner DBA
Critique: SQL Agent for the Beginner DBA
Rate Topic
Display Mode
Topic Options
Author
Message
Craig Purnell
Craig Purnell
Posted Saturday, April 09, 2011 9:01 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 6:14 PM
Points: 199,
Visits: 468
Hello,
I have noticed that there are not any presentations on SQL Agent at the various SQL Saturday events and thought to fill a gap:
SQL Agent for the Beginner DBA
"An Introduction to some basic concepts and tricks to effectively use SQL Agent on one or more production servers. We'll cover job scheduling, alerts, operators, and failure handling. Finally, a review of the capabilities of Agent vs. the Windows task scheduler. "
Do you think there is enough material there for an hour presentation ?
Thanks,
Craig
Post #1091092
SQLRNNR
SQLRNNR
Posted Saturday, April 09, 2011 10:49 AM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733,
Visits: 12,332
I think there could be enough info. Have you presented this to a Usergroup or two?
Would you like to give it a go via livemeeting for my UG?
Presenting to UGs a few times would be a good way of knowing if the preso has enough info or not and then take it to a SQLSat.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1091106
Jack Corbett
Jack Corbett
Posted Saturday, April 09, 2011 8:17 PM
SSChampion
Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571,
Visits: 11,871
I definitely think there is enough material on SQL Agent to fill an hour. The only way to be sure is to write the presentation and then practice it. If you can do it between 40-60 minutes with no one around you'll probably have enough for an hour presentation. Remember that there will be questions.
For the abstract I think it is important to list 3 specific things you expect the attendees to learn from the presentation. For SQL Agent I'd do something like:
"After this presentation attendees will be able to:
1. Identify scenarios where SQL Agent should be used
2. Schedule jobs to run at selected times.
3. Define an operator to be alerted when a job fails.
"
Jack Corbett
Applications Developer
Don't let the good be the enemy of the best. --
Paul Fleming
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1091140
Jeff Moden
Jeff Moden
Posted Saturday, April 09, 2011 11:50 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 1:51 PM
Points: 32,906,
Visits: 26,789
I think you'll actually have a difficult time keeping it down to only an hour. As the others have said, the only way to know is to deliver the presentation several times. Start off by delivering it to an imaginary group of people in the comfort of your own home just as if it were a real group. Then present it at your local PASS chapter meeting or to a remote user group as has already been suggested. They'll be happy to have one of their own presenting. After you get the kinks and the butterfly's out, you do very well at an SQL Saturday or other public event.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1091142
Craig Purnell
Craig Purnell
Posted Sunday, April 10, 2011 7:20 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 6:14 PM
Points: 199,
Visits: 468
CirquedeSQLeil (4/9/2011)
I think there could be enough info. Have you presented this to a Usergroup or two?
Would you like to give it a go via livemeeting for my UG?
.
Yes, I would be happy to - after I get it written. I will let you know.
Thanks, Craig
Post #1091172
Craig Purnell
Craig Purnell
Posted Sunday, April 10, 2011 7:30 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 6:14 PM
Points: 199,
Visits: 468
Jack Corbett (4/9/2011)
For the abstract I think it is important to list 3 specific things you expect the attendees to learn from the presentation. For SQL Agent I'd do something like:
"After this presentation attendees will be able to:
1. Identify scenarios where SQL Agent should be used
2. Schedule jobs to run at selected times.
3. Define an operator to be alerted when a job fails.
"
That's a great point. Thanks for the feedback !
Post #1091173
Craig Purnell
Craig Purnell
Posted Sunday, April 10, 2011 7:31 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 6:14 PM
Points: 199,
Visits: 468
Jeff Moden (4/9/2011)
I think you'll actually have a difficult time keeping it down to only an hour. As the others have said, the only way to know is to deliver the presentation several times. Start off by delivering it to an imaginary group of people in the comfort of your own home just as if it were a real group. Then present it at your local PASS chapter meeting or to a remote user group as has already been suggested. They'll be happy to have one of their own presenting. After you get the kinks and the butterfly's out, you do very well at an SQL Saturday or other public event.
Appreciate the suggestions, Jeff. I will give it a try.
Post #1091174
Grant Fritchey
Grant Fritchey
Posted Monday, April 11, 2011 4:20 PM
SSChampion
Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 13,375,
Visits: 25,159
Craig Purnell (4/9/2011)
Hello,
I have noticed that there are not any presentations on SQL Agent at the various SQL Saturday events and thought to fill a gap:
SQL Agent for the Beginner DBA
"An Introduction to some basic concepts and tricks to effectively use SQL Agent on one or more production servers. We'll cover job scheduling, alerts, operators, and failure handling. Finally, a review of the capabilities of Agent vs. the Windows task scheduler. "
Do you think there is enough material there for an hour presentation ?
Thanks,
Craig
I think it's a great idea and you'll absolutely get an hour out of it. I agree with all the other comments. As far as the abstract goes, I'd want to see a problem definition up front. What issue are you assuming I have? Tell me that, then tell me about how you're going to address that issue. Finally, I'd like to know what I'm going to take away from the session. To my point of view, you've got a third of the abstract here, and it's good. Add the other two thirds and I'm sure you'll be there.
----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans
Product Evangelist for
Red Gate Software
Post #1091812
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.