January 3, 2012 at 11:43 am
Brandie Tarvin (1/3/2012)
Divine Flame (1/3/2012)
I need to give a training on SQL Server 2008 Database Administration and I have to do it in next couple of days. It will be a two day training. Now the thing is I have to prepare the content (ppt) also for that & I have don't have much time available to create the presentaions from scratch.Does anybody know any link/resource where I can get some ready available material for that ??
Any help would be appreciated.:-)
Let's start at the beginning. What level of experience will your students have? What subjects do you plan on focusing on? Is this a broad "here's the entire meal, pick and choose quick because you don't have time to taste it" type of class, or a very specific "Here are three or four dishes, notice the spice, garnish, and plate presentation" type of class?
Thanks for the quick reply Brandie ๐
Students will be having around 1-2 years experience.
Following points will be discussed in detail:
1.Architecture of SQL Server Database Engine
2.Installation & configuration
3.SQL Server file & filegroup management
4.SQL Server Security
5.Backup & Recovery
6.SQL Server High Availability features
7.Performance tuning
8.Monitoring & Automation
January 3, 2012 at 11:52 am
Divine Flame (1/3/2012)
I need to give a training on SQL Server 2008 Database Administration and I have to do it in next couple of days. It will be a two day training. Now the thing is, that I have to prepare the content (ppt) also for that & I have don't have much time available to create the presentaions from scratch.Does anybody know any link/resource where I can get some ready available material for that ??
Any help would be appreciated.:-)
There is courseware you can purchase, but with only 2 days to prep, you're effectively going to be reading from the slides. Here's a place online that sells it. Last time I taught a three day course on SQL Server it took me three weeks to development materials for the course and another couple of weeks of rehearsals to get ready. I think you're in a tough situation.
"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
January 3, 2012 at 11:59 am
Brandie Tarvin (1/3/2012)
Stefan Krzywicki (1/3/2012)
GilaMonster (1/3/2012)
Brandie Tarvin (1/3/2012)
So I'm searching on thin clients and SQL Server and come up with this little gem:http://www.sql-server-performance.com/2000/implementing-oltp-environment/%5B/url%5D
It's an almost 12 year old article, so I'm not sure why you're shocked by that.
I think she's just amused that in her search she came up with a 12 year old article. That's certainly what amused me about it.
That's pretty much it. This is like my boss's boss coming up with SQL 6.5 books when he cleaned out his office last year. He tried to pawn them off on us saying this was "important information you need to know in order to do your job."
Then he offered to pay us a quarter to take the books off his hands. @=)
I just gave away 3 boxes of computer books, mostly stuff like VB5 and VB6, but there was a Borland Turbo C++ book in there and a few other gems of that era. This is what happens when you move and don't completely unpack.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
Itโs unpleasantly like being drunk.
Whatโs so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
January 3, 2012 at 12:00 pm
Grant Fritchey (1/3/2012)
There is courseware you can purchase, but with only 2 days to prep, you're effectively going to be reading from the slides. Here's a place online that sells it. Last time I taught a three day course on SQL Server it took me three weeks to development materials for the course and another couple of weeks of rehearsals to get ready. I think you're in a tough situation.
I generally budget 1 day of preparation per hour of course for any training course that I'm doing from scratch. More if it's to be demo-heavy. So for a two-day training (assuming 8 hours a day), I'd be looking at a little over 3 weeks of development and prep time if doing the course material from scratch. If I had to use someone else's material (which I prefer not to do), maybe a two days per day of course to learn the material well enough to be able to present it properly.
It takes me 1-2 days just to develop and prep a conference presentation of 75-90 minutes.
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
January 3, 2012 at 12:03 pm
I second Grant's opinion. Typically you need prep time equal 20 times the length of the first presentation, including going through the whole thing with a mock knowledgeable audience at least twice.
January 3, 2012 at 12:03 pm
I'm with Gail. About 8-10 hours per hour talk for me.
January 3, 2012 at 12:05 pm
Steve Jones - SSC Editor (1/3/2012)
About 8-10 hours per hour talk for me.
You can't really do it in much less unless you're doing what too many of the MCTs here do and read from the slides and avoid discussing anything further than the book does.
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
January 3, 2012 at 12:13 pm
Brandie Tarvin (1/3/2012)
Stefan Krzywicki (1/3/2012)
GilaMonster (1/3/2012)
Brandie Tarvin (1/3/2012)
So I'm searching on thin clients and SQL Server and come up with this little gem:http://www.sql-server-performance.com/2000/implementing-oltp-environment/%5B/url%5D
It's an almost 12 year old article, so I'm not sure why you're shocked by that.
I think she's just amused that in her search she came up with a 12 year old article. That's certainly what amused me about it.
That's pretty much it. This is like my boss's boss coming up with SQL 6.5 books when he cleaned out his office last year. He tried to pawn them off on us saying this was "important information you need to know in order to do your job."
๐
I have a book on my shelf 'Digital Computer Programming'. It covers Assembler and Fortran IV. First publication - 1967. Gift from a friend's father. Where he got it I have no idea (he was not a programmer)
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
January 3, 2012 at 12:14 pm
GilaMonster (1/3/2012)
Steve Jones - SSC Editor (1/3/2012)
About 8-10 hours per hour talk for me.You can't really do it in much less unless you're doing what too many of the MCTs here do and read from the slides and avoid discussing anything further than the book does.
Grant, Steve, Gail & all who have given me the suggestions, I completely agree with you. I always prefer to prepare it better & I try to give it as much time as I can, so that I am effective in front of audience.
But as Grant correctly said "This is a tough time." The training has been planned very sudden.
I would request them (the bosses) again to postpone it for few weeks but don't know if they will agree :hehe:.
January 3, 2012 at 12:15 pm
Divine Flame (1/3/2012)
Following points will be discussed in detail:1.Architecture of SQL Server Database Engine
2.Installation & configuration
3.SQL Server file & filegroup management
4.SQL Server Security
5.Backup & Recovery
6.SQL Server High Availability features
7.Performance tuning
8.Monitoring & Automation
And only 2 days to present these topics? Honestly, I see topics 1-3 and 5 as requiring 2-4 hours to discuss thoroughly and every other topic requiring a day (minimum) for a thorough presentation. With 2 days, you can barely scratch the surface on Security, High Availability, Performance Tuning, and Monitoring / Automation.
Ditto for what the others said. You don't have time to come up with a decent presentation on your own. Sounds like you'll have to purchase one or use the BOL tutorials to present.
January 3, 2012 at 12:20 pm
Divine Flame (1/3/2012)
I would request them (the bosses) again to postpone it for few weeks but don't know if they will agree :hehe:.
Well, it's that or you buy materials (or read from Books Online) and give a poor presentation, because you don't have time to even prep pre-done materials properly.
Oh, and there's also no way you can discuss all of those topics in detail in 2 days. High level overview with a few details, sure, but not in detail on all of them. Architecture on its own is most of a day if done in detail. Performance tuning in detail is a week, maybe two, high availability (log shipping, mirroring, clustering and replication) might fit into a day, but it would require a lot be left out. Backup and restore is at least a day (unless you're just going to discuss full and log backups and full restores)
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
January 3, 2012 at 12:23 pm
Brandie Tarvin (1/2/2012)
Evil Kraig F (12/30/2011)
My favorite RPG of all time was Shadowrun. 2nd Edition. I recently tried to GM a campaign (well, recently being a year and a half ago) in the new edition. They've shark jumped so hard the game makes me cry. If you're familiar with the system at all, I had to base it in Denver so I could have Ghostwalker 'declare' certain rediculous new things illegal, immoral, or inedible. Standard execution was wait for Ghostwalker to get hungry then he'd go through the local populace looking for 'edible law' breakers and having himself a chomp. [/rant]Wow. That sounds like the chapter I wrote for Spy Games (SR 4e). And yes, Ghostwalker is messing with the peeps. Your version isn't too far off base.
What in particular did you have problems with that you call it shark jumping?
- Magic Hackers (and the death of old-school deck building)
- RFIDs
- PDA SIN network
- Near loss of Credsticks
- Super Duper Wi-Fi Network
... are the first few that come to mind. Damn near impossible to pull off a run on the grid when your underwear is out to get you killed, the money's in a bank, hiding your SIN(s) as written is a righteous pain (imagine giving up your safehouse everytime your cell phone got hacked), and the guy next to you (to steal from River Tam) can "Kill you with his brain!", or at least your entire PDA's history, and is hacking into it because of the PDA mesh net that's pushing petabytes at speeds we could only dream of... via everyone else's PDAs.
There were a LOT of things in there that just left a bad taste, but those were a few things that stood out like sore thumbs. The only way to keep everything from being a hacker-fest because it was nearly impossible to do things in the physical world (well, in anywhere but third world countries) was to outlaw a few things and have practically every building in the country wrapped up in anti-wifi wallpaper with 'entrance gates' packed so deeply with Black IC that it practically forced the run to have to occur.
I did like a few things, in particular how they streamlined the combat. Nothing like the old system where 'Okay, we've been here an hour, someone order a pizza. We're gonna need to re-roll initiative for round 2'. BAAAAH?! ;_; Spellslinging or being the hacker during that sucked. But in general the world is currently overloaded with frustration from a GM trying not to be 'heavy handed' but looking at all the WTF that's now 'common' (remote activated RFID that can't be detected until activated and can be sprayed on you, and it's so small it gets in your dang NASAL CAVITY...) it's just... yeah, no.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 3, 2012 at 12:24 pm
Thanks Brandie. I'll see what I can do in this situation :unsure:
January 3, 2012 at 12:29 pm
GilaMonster (1/3/2012)
Steve Jones - SSC Editor (1/3/2012)
About 8-10 hours per hour talk for me.You can't really do it in much less unless you're doing what too many of the MCTs here do and read from the slides and avoid discussing anything further than the book does.
I purchased and used a 3rd party courseware about 6-7 years ago. You're going to need a couple of days to get it ordered and a couple of days to go through it, minimum. Unless they're OK with you just reading from the material, in which case, just buy a copy of my Beginning SQL Server 2008 Administration book & read that to them (stupid book doesn't sell, at all).
"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
January 3, 2012 at 12:35 pm
Start the presentation with a line like, "The need for this presenation was dumped in my lap 2 days ago, so I had to write it really fast. Hopefully you can listen fast..."
That'll break the ice a bit. It's a variation on the old joke, "I know you can't read fast, so I'm writing really slow..."
Beyond that, streamline like crazy. Define terms before you get to them, so you don't have to pause mid-presentation to define things. Stick mostly with "what to do" and not a lot of "why". "What" is fast to tell, "Why" is slow to explain.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 15 posts - 33,076 through 33,090 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply