October 21, 2011 at 7:01 am
Jack Corbett (10/20/2011)
On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?
How about basic database security - how to get it right, particularly SQL Security for web-facing apps: the proper way to use roles, parametrised queries and SPs instead of ad hoc SQL, database encryption, certificates, identifying users, granting data access only to special users who own the SPs instead of to the principals that the apps run as (those principals get access only to SPs), when to use SQL users and when to use NT users/groups, what OS privileges should the data engine, sql agent, and so on run with.
I'm pretty sure that more than 90% of people I've know who work with databases haven't really got a clue about any of this (a system with blank SA password on production database behind firewall with port 1433 open and engine and agent running with enterprise admin privilege ought to be extremely rare - but I'm not even convinced it is particularly unusual). The world is currently suffering another demonstration that most people are too poorly educated to prevent injection attacks with more than 2,000,000 sites infected in the last 10 days and not yet fixed (if Google's counts are to be believed). That's two indications that such a presentation is sorely needed.
Tom
October 21, 2011 at 8:51 am
Jack Corbett (10/20/2011)
On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?
Not to dissuade you, but do you need a new one? You can do an intro one on some new feature, but has everyone seen your Profiler/Trace or other ones? I find the intro stuff to appeal to a lot of people. And no matter how many times you've given it, there are always new people that might not have seen it.
October 21, 2011 at 9:08 am
Steve Jones - SSC Editor (10/21/2011)
Jack Corbett (10/20/2011)
On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?Not to dissuade you, but do you need a new one? You can do an intro one on some new feature, but has everyone seen your Profiler/Trace or other ones? I find the intro stuff to appeal to a lot of people. And no matter how many times you've given it, there are always new people that might not have seen it.
I agree, if you're putting together a new presentation because you'd like to branch out or are doing several presentations close together, then sure create a new one. If you think everyone's heard your current one already, unless you know the group has going with the presentation you already have is a good idea. Goodness knows I could use a presentaion on Profiler/Trace and I'll bet lots of other people could too.
--------------------------------------
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
October 21, 2011 at 10:08 am
Jack Corbett (10/20/2011)
On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?
Throw out an old one and completely redo it. You know more about presenting now. You have a better idea how slides should go. You can rearrange the way you explain the topic. Then, give it a new name.
"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
October 21, 2011 at 11:45 am
Grant Fritchey (10/21/2011)
Jack Corbett (10/20/2011)
On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?Throw out an old one and completely redo it. You know more about presenting now. You have a better idea how slides should go. You can rearrange the way you explain the topic. Then, give it a new name.
Do you work for M$? 😀
October 21, 2011 at 11:56 am
Ninja's_RGR'us (10/21/2011)
Grant Fritchey (10/21/2011)
Jack Corbett (10/20/2011)
On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?Throw out an old one and completely redo it. You know more about presenting now. You have a better idea how slides should go. You can rearrange the way you explain the topic. Then, give it a new name.
Do you work for M$? 😀
Naw. Apple. Or ... well ... plug in any software company that's survived long enough to issue v2.0 software.
- 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
October 21, 2011 at 1:03 pm
Grant Fritchey (10/21/2011)
Jack Corbett (10/20/2011)
On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?Throw out an old one and completely redo it. You know more about presenting now. You have a better idea how slides should go. You can rearrange the way you explain the topic. Then, give it a new name.
That's an interesting idea. My problem is a lack of creativity.
Jack Corbett
Consultant - Straight Path Solutions
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
October 21, 2011 at 1:06 pm
Steve Jones - SSC Editor (10/21/2011)
Jack Corbett (10/20/2011)
On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?Not to dissuade you, but do you need a new one? You can do an intro one on some new feature, but has everyone seen your Profiler/Trace or other ones? I find the intro stuff to appeal to a lot of people. And no matter how many times you've given it, there are always new people that might not have seen it.
I like to do one new presentation per year for a couple of reasons:
1. Improve my own knowledge of an area
2. Add another presentation to my "library" so I have a variety to pull from.
But, you have given me an idea. Microsoft's road map seems to be heading toward Extended Events so I could do an intro on that as an extension of my Profiler one.
Jack Corbett
Consultant - Straight Path Solutions
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
October 21, 2011 at 1:15 pm
Jack Corbett (10/21/2011)
Steve Jones - SSC Editor (10/21/2011)
Jack Corbett (10/20/2011)
On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?Not to dissuade you, but do you need a new one? You can do an intro one on some new feature, but has everyone seen your Profiler/Trace or other ones? I find the intro stuff to appeal to a lot of people. And no matter how many times you've given it, there are always new people that might not have seen it.
I like to do one new presentation per year for a couple of reasons:
1. Improve my own knowledge of an area
2. Add another presentation to my "library" so I have a variety to pull from.
But, you have given me an idea. Microsoft's road map seems to be heading toward Extended Events so I could do an intro on that as an extension of my Profiler one.
Great idea. I'm planning on expanding on extended events any where I can.
"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
October 22, 2011 at 2:54 pm
"Extended Events"... is that like planning on Friday to actually return to work on Monday? 😛 Or is it an event that lasts more than one day like PASS does? 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2011 at 3:04 pm
Lol
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
October 23, 2011 at 5:45 am
Ah bugger. New Zealand won the Rugby Union World Cup. A certain someone is gonna be absolutely intolerable now. 😛
Steve.
October 23, 2011 at 6:00 am
Fal (10/23/2011)
Ah bugger. New Zealand won the Rugby Union World Cup. A certain someone is gonna be absolutely intolerable now. 😛Steve.
Now?
😀
"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
October 23, 2011 at 6:08 am
Fal (10/23/2011)
Ah bugger. New Zealand won the Rugby Union World Cup. A certain someone is gonna be absolutely intolerable now. 😛Steve.
No change, then?
Tom
October 24, 2011 at 12:22 am
Fal (10/23/2011)
Ah bugger. New Zealand won the Rugby Union World Cup. A certain someone is gonna be absolutely intolerable now. 😛Steve.
Options were cholera or plague. What did you expect :w00t:
Anyway, the game itself apparently has been quite tensed for both teams.
I always love a good oldfashioned game.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 31,111 through 31,125 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply