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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2006-09-26 : 07:21:03
|
| hello friends, i heard from my colleagues that xml and activex are necessary for DBAis it so? how could we use in our daily activities?can any one provide me good links for this concepts please?thank you very much. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-09-26 : 07:29:22
|
| It all depends on what you want to do, but its best to start here http://www.sqlteam.com/store.asphttp://www.google.com/search?hl=en&q=learn+ms+sql |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-09-26 : 07:34:18
|
| That's flat out inaccurate, really silly. Ask your colleagues how ActiveX and XML help you to:- do database backups- profile database performance- tune hardware and software to improve performance- audit security and establish proper security protocols- provide a comprehensive database source control procedure (may actually be useful here, but not likely)I've never used XML or ActiveX for any admin tasks, and can count on one hand the times I've used them AT ALL inside SQL Server.I suspect all of your colleagues are developers who've never done any of the above tasks, which are some of the primary responsibilities of a DBA. And I'm serious about having them explain it, if they can't, I'd ignore any advice they give you in the future if I were you.You can look up XML and ActiveX in Books Online, and maybe have your colleagues do the same. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2006-09-26 : 08:16:44
|
| thank you for the information Mr.robvolk |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-09-26 : 08:37:35
|
| While I don't personally have too much knowledge of XML, and virtually none in ActiveX, there are areas where it would be USEFUL (not a definite requirement, though) for a DBA to have some knowledge on both XML and ActiveX. Specifically:- XML where it is a requirement to shred/build XML in stored procedures, and store XML in the DB. This has, in my experience, been a very in-frequent requirement ... to the extent that now, after 6 years as a SQL DBA, I am having to handle it for the first time. But, depending on your environment, XML may be m,ore prevalent, and hence more of a relevant techonology. Also, this depends on the role of a DBA in your organization ... i.e. do they code SP's, or review them? Most of the itmes that Rob referred to fall into what I refer to as 'production dba' tasks, while design, creation and implementation of DB's, and the SP's etc. can boradly be classified as 'Development DBA' type tasks. Please note that these are borad categorizations, and many companies will have DBA's do all of these, and more.- ActiveX may be used in DTS packages. Some organization see the creation and maintenance of DTS packages as a DBA activity, and thus the DBA may be required to learn/know activeX to the extent of managing/altering the DTS packages that need to use this. Again, in my 6 years of being a SQL DBA, I've never had to use this ... just lucky I guess. I am finding, now, that I have had to write a (VERY) little .Net scripting in some SQL2005 SSIS packages.So, to summarize - it depends. It depends on your organizations use of technology (like XML in the DB, and XML in SP's). It depends on teh role of a DBA in your organization - does he also get called upon to write SP's, and new DTS packages which end up using ActiveX to do some of the more difficult things in DTS? (I say that because I've obviously only had relateviely straight forward DTS requirements, and have not needed to use ActiveX).Finally, the scope of those technolgies, against all the other things a DBA should know, is probably quite a small percentage.HTH*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-09-26 : 14:55:40
|
I agree with everything Wanderer says, it does depend on what kind of environment you're in and what your responsibilities are. Still, for purely administrative functions, XML and ActiveX don't do anything for the DBA.From a design perspective, XML will almost certainly come up, and if it does you may want to read this and the accompanying links and comments:http://thedailywtf.com/forums/thread/91205.aspxIf you find your developers supporting that kind of design, either don't get involved at all or find another job.  Your sanity is more important. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-09-26 : 18:41:46
|
| From my expirience, XML could be used in ASP pages, to execute a server call to another server using post or get and to read the results of the remote server and pass back to the client website without the client knowing what happened. e.g. could be a domain name search facilty, sending of sms etcIt works in MS SQL via SP but not widely used. |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-09-27 : 06:47:09
|
quote:
Originally posted by X002548
quote:
Originally posted by sunsanvin
Mr.robvolk
Now there's a WTF
I couldn't agree more. No wait... I can. I agree MORE!  quote:
Originally posted by X002548I agree about XML
.. you mean I'm not talking !"£%$ ? Someone call the press  quote:
Originally posted by X002548http://weblogs.sqlteam.com/brettk/archive/2004/09/01/1999.aspxhttp://weblogs.sqlteam.com/brettk/archive/2006/07/27/10869.aspxBut I don't see how ActiveX plays any part..plus isn't M$ moving away from it anyway. Learn .net if anything.
True and VERY true. I've just been doing some SSIS packages, and having to use .Net in them to achieve some things.quote:
I betcha these bozos are DTS ActiveX Wizards...which completely the wrong thing to be doing...especially since DTS itselfis going away (ok into another form)Brett
Well, as I understand it - and again, I'm probably talking !£"$ - ActiveX was sometimes required to get DTS to do things it ordinarily wouldn't allow you to do. Yes, it is being replaced by a better (although still sometimes confusing) product - SSIS. But realistically it will still be quite a while before most people are onto SQL2005, so SQL2K, DTS and (where necessary) ActiveX will still have a place in the DBA's world. Just not a large one...*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
|
|
|
|
is xml ,activeX necessary for a DBA?