Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-08-12 : 12:49:45
|
is that all a part of modernizing your company, brett?  Go with the flow & have fun! Else fight the flow  |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-08-12 : 13:44:59
|
| What took all the time? Lots of queations?Or did they just want to know how to display a query plan with TSO? CODO ERGO SUM |
|
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2005-08-12 : 14:46:22
|
| The good news is that they retained about 20 minutes of it.AjHey, it compiles. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-08-12 : 15:18:48
|
| Are you kidding....a glazed over the EM...barely talked about security....explained what the sql server agent was and what a scheduled Job was, the rest was going over tables and the like....explained to them that they would NOT be working in EM much (several times). All the long trying to draw analogies to the mainframe. That was the first hour. gave them 10 minutes. Then discussed QA for another hour...talked about TSQL, what sprocs are, how f'ed up the system tables are compared to DB2, information schemas...Show plan and why they should always check the performance, indexes and what index intersection was, how to create sprocs, why they should never use SELECT *, why they should never use cursors(yeah I know, but I was going to them in certain instances it was ok). Went back to EM to show them how to script tables, and how the TABLE Design GUI saves the script for them.That's about it....Got them set up to access Northwind on a test box.I got some feedback from my director and it was pretty good.Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
|
|
|
|
|
Overview