Showing posts with label administration. Show all posts
Showing posts with label administration. Show all posts

Thursday, March 8, 2012

70-228 Exam Questions.

Hello all,
I am preparing for 70-228 (SQL server Administration) exam. I was looking on the internet for some exam oriented questions or question bank kind of thing. I found couple of them but those are not sufficient. I would appreciate if you could let me know if you know any sites where i can get some more questions to solve. I would really appreciate if anybody has a questions bank and would like to share it with me.
Thanking in advance.
MandarThere are tons of web sites with this material for your review. You can also purchase testing software like transcender. Also, if you don't already have sql server to use - get an eval copy.

70-228 Exam Book?

Hello
Can anyone suggest a good book for preparing 70-228? I found this
MCSA/MCSE/MCDBA: SQL Server 2000 Administration Study Guide (70-228) by
Sybex pub. But I am not sure about this really. Someone was really
praising Wrox - Professional SQL Server 2000 Programming. I have no
previous experience of SQL Server 2000, but I am comfortable with
programming and SQL language.
Thanks for your suggestions in advance.
Kappa
Hi
You may want to check out http://www.microsoft.com/sql/techinfo/books.mspx
you may also want to check out the (SQL 2005) e-learning courses at
https://www.microsoftelearning.com/c...aspx#sqlServer which are
currently being offered for free (till Nov 2006).
John
"Trying2Learn" wrote:

> Hello
>
> Can anyone suggest a good book for preparing 70-228? I found this
> MCSA/MCSE/MCDBA: SQL Server 2000 Administration Study Guide (70-228) by
> Sybex pub. But I am not sure about this really. Someone was really
> praising Wrox - Professional SQL Server 2000 Programming. I have no
> previous experience of SQL Server 2000, but I am comfortable with
> programming and SQL language.
>
> Thanks for your suggestions in advance.
>
> Kappa
>

70-228 Exam Book?

Hello
Can anyone suggest a good book for preparing 70-228? I found this
MCSA/MCSE/MCDBA: SQL Server 2000 Administration Study Guide (70-228) by
Sybex pub. But I am not sure about this really. Someone was really
praising Wrox - Professional SQL Server 2000 Programming. I have no
previous experience of SQL Server 2000, but I am comfortable with
programming and SQL language.
Thanks for your suggestions in advance.
KappaHi
You may want to check out http://www.microsoft.com/sql/techinfo/books.mspx
you may also want to check out the (SQL 2005) e-learning courses at
https://www.microsoftelearning.com/...aspx#sqlServer which are
currently being offered for free (till Nov 2006).
John
"Trying2Learn" wrote:

> Hello
>
> Can anyone suggest a good book for preparing 70-228? I found this
> MCSA/MCSE/MCDBA: SQL Server 2000 Administration Study Guide (70-228) by
> Sybex pub. But I am not sure about this really. Someone was really
> praising Wrox - Professional SQL Server 2000 Programming. I have no
> previous experience of SQL Server 2000, but I am comfortable with
> programming and SQL language.
>
> Thanks for your suggestions in advance.
>
> Kappa
>

70-228 Exam Book?

Hello
Can anyone suggest a good book for preparing 70-228? I found this
MCSA/MCSE/MCDBA: SQL Server 2000 Administration Study Guide (70-228) by
Sybex pub. But I am not sure about this really. Someone was really
praising Wrox - Professional SQL Server 2000 Programming. I have no
previous experience of SQL Server 2000, but I am comfortable with
programming and SQL language.
Thanks for your suggestions in advance.
KappaHi
You may want to check out http://www.microsoft.com/sql/techinfo/books.mspx
you may also want to check out the (SQL 2005) e-learning courses at
https://www.microsoftelearning.com/catalog/itproDev.aspx#sqlServer which are
currently being offered for free (till Nov 2006).
John
"Trying2Learn" wrote:
> Hello
>
> Can anyone suggest a good book for preparing 70-228? I found this
> MCSA/MCSE/MCDBA: SQL Server 2000 Administration Study Guide (70-228) by
> Sybex pub. But I am not sure about this really. Someone was really
> praising Wrox - Professional SQL Server 2000 Programming. I have no
> previous experience of SQL Server 2000, but I am comfortable with
> programming and SQL language.
>
> Thanks for your suggestions in advance.
>
> Kappa
>

Thursday, February 9, 2012

3rd party Data Administration Tools

I'm looking for a 3rd party tool to manage
disabling/enabling triggers. I evaluated Teratraw
Database Manager and it easily allows disabling/enabling
triggers via the gui but only 1 trigger at a time. I need
a tool that can disable/enable ALL triggers in a database
easily. (Similar to TOAD for Oracle).
Anyone know of such a management tool?
Thanks Rich
SQLExecMS from www.laplas-soft.com will help you
"Rich" <rstoll@.cadencenet.com> wrote in message
news:1c5701c5317f$dc1023a0$a601280a@.phx.gbl...
> I'm looking for a 3rd party tool to manage
> disabling/enabling triggers. I evaluated Teratraw
> Database Manager and it easily allows disabling/enabling
> triggers via the gui but only 1 trigger at a time. I need
> a tool that can disable/enable ALL triggers in a database
> easily. (Similar to TOAD for Oracle).
> Anyone know of such a management tool?
> Thanks Rich
|||Would a stored procedure work for you?
"Rich" wrote:

> I'm looking for a 3rd party tool to manage
> disabling/enabling triggers. I evaluated Teratraw
> Database Manager and it easily allows disabling/enabling
> triggers via the gui but only 1 trigger at a time. I need
> a tool that can disable/enable ALL triggers in a database
> easily. (Similar to TOAD for Oracle).
> Anyone know of such a management tool?
> Thanks Rich
>
|||
> I'm looking for a 3rd party tool to manage
> disabling/enabling triggers. I evaluated Teratraw
> Database Manager and it easily allows disabling/enabling
> triggers via the gui but only 1 trigger at a time. I need
> a tool that can disable/enable ALL triggers in a database
> easily. (Similar to TOAD for Oracle).
> Anyone know of such a management tool?
Database Workbench - www.upscene.com
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com
|||Hello Rich,
TOAD for SQL Server is currently in freeware (http://www.toadsoft.com/toadsqlserve..._sqlserver.htm), but a -much- more feature-laden version will go into beta in June. Take a look at the current version and stay on the lookout for the beta announceme
nt for the big summer release.
Hope this helps,
-Kev
~~~
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)

> I'm looking for a 3rd party tool to manage disabling/enabling
> triggers. I evaluated Teratraw Database Manager and it easily allows
> disabling/enabling triggers via the gui but only 1 trigger at a time.
> I need a tool that can disable/enable ALL triggers in a database
> easily. (Similar to TOAD for Oracle).
> Anyone know of such a management tool?
> Thanks Rich
>