Good online resources

Hi,
I am a newbie in the world of the SQL server . However I have a
reasonable idea of SQL and a little bit of Oracle. Could you please suggest
some good online resources for me preferable starting from scratch... but
leading in real deep.
Anupam
--
We all want to destroy evil. But the line dividing evil and good is
insidiously hidden in each of our hearts and who wants to destroy a piece of
his own heartThere are lots of resources out there with a mixture of content difficulty
and area of specialisation
here is a good starter index for you
http://www.microsoft.com/sql/community/relcommunities.asp
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Anupam" <anupam_mukherjee@.persistent.co.in> wrote in message
news:uPh0E2vkDHA.2012@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am a newbie in the world of the SQL server . However I have a
> reasonable idea of SQL and a little bit of Oracle. Could you please
suggest
> some good online resources for me preferable starting from scratch... but
> leading in real deep.
> Anupam
> --
> We all want to destroy evil. But the line dividing evil and good is
> insidiously hidden in each of our hearts and who wants to destroy a piece
of
> his own heart
>|||See here for some links:
http://www.microsoft.com/sql/community/relcommunities.asp
Also, don't forget SQL's own essential help file, Books Online.
--
David Portas
--
Please reply only to the newsgroup
--
"Anupam" <anupam_mukherjee@.persistent.co.in> wrote in message
news:uPh0E2vkDHA.2012@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am a newbie in the world of the SQL server . However I have a
> reasonable idea of SQL and a little bit of Oracle. Could you please
suggest
> some good online resources for me preferable starting from scratch... but
> leading in real deep.
> Anupam
> --
> We all want to destroy evil. But the line dividing evil and good is
> insidiously hidden in each of our hearts and who wants to destroy a piece
of
> his own heart
>|||Hi,
Thanx guys for the info. Its highly appreciated.
Regards,
Anupam
--
We all want to destroy evil. But the line dividing evil and good is
insidiously hidden in each of our hearts and who wants to destroy a piece of
his own heart

good book for AS

Cam someone recommend a good newbie book for Analysis Services? One with
step by step labs would be ideal.
TIA, ChrisR
go on to amazon and look for analysis services step by step. This
should give you what you want.
Steve
|||A great one:
Microsoft SQL Server 2000 Reporting Services by Brian Larson, Osborne.
Uytkownik "ChrisR" <ChrisR@.noEmail.com> napisa w wiadomoci
news:Ok4%23u395EHA.2876@.TK2MSFTNGP12.phx.gbl...
> Cam someone recommend a good newbie book for Analysis Services? One with
> step by step labs would be ideal.
> TIA, ChrisR
>
|||Looks as though this book is it. Thanks.
"Steve McHugh" <steve@.oneleg.net> wrote in message
news:1103711889.745639.179170@.c13g2000cwb.googlegr oups.com...
> go on to amazon and look for analysis services step by step. This
> should give you what you want.
> Steve
>
|||Thank you but I was looking for a book on Analysis Services.
"pexiak" <mpeksa@.poczta.onet.pl> wrote in message
news:cqbntd$kbb$1@.news.onet.pl...
> A great one:
> Microsoft SQL Server 2000 Reporting Services by Brian Larson, Osborne.
> Uytkownik "ChrisR" <ChrisR@.noEmail.com> napisa w wiadomoci
> news:Ok4%23u395EHA.2876@.TK2MSFTNGP12.phx.gbl...
>
|||Some additional suggestions:
http://www.mosha.com/msolap/books.htm
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"ChrisR" <bla@.noemail.com> wrote in message
news:O$aZzPH6EHA.3612@.TK2MSFTNGP14.phx.gbl...
> Looks as though this book is it. Thanks.
> "Steve McHugh" <steve@.oneleg.net> wrote in message
> news:1103711889.745639.179170@.c13g2000cwb.googlegr oups.com...
>
|||Thanks Mosha. Which one is your favorite?
"Mosha Pasumansky [MS]" <moshap@.online.microsoft.com> wrote in message
news:uyRXZhI6EHA.2788@.TK2MSFTNGP15.phx.gbl...
> Some additional suggestions:
> http://www.mosha.com/msolap/books.htm
>
> --
> ==================================================
> Mosha Pasumansky - http://www.mosha.com/msolap
> Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
> Development Lead in the Analysis Server team
> All you need is love (John Lennon)
> Disclaimer : This posting is provided "AS IS" with no warranties, and
> confers no rights.
> ==================================================
> "ChrisR" <bla@.noemail.com> wrote in message
> news:O$aZzPH6EHA.3612@.TK2MSFTNGP14.phx.gbl...
>
|||> Thanks Mosha. Which one is your favorite?
Mine of course Seriously, each book has its strong sides. Probably I
would recommend them in following scenarios
Analysis Services Step By Step - First book to get overall introduction into
Analysis Services.
Microsoft OLAP Solutions - More detailed book, but also outdated, since it
was written for OLAP Services 7.0. But I still like it
Fast Track To MDX - Your introduction book to MDX (even before you read MDX
sections of Step By Step). Very easy read. [I am coauthor for this one]
MDX Solutions - The ultimite MDX guide - everything you need to know about
MDX is there. But material is very dense, not an easy read.
Microsoft SQL Server 2000 Resouce Guide - Advanced content about performance
tuning, internals etc.
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
|||"Mosha Pasumansky [MS]" <moshap@.online.microsoft.com> wrote in message
news:%23mhIJkS6EHA.3236@.TK2MSFTNGP15.phx.gbl...
> Microsoft SQL Server 2000 Resouce Guide - Advanced content about
performance
> tuning, internals etc.
FYI, this book is out of print; but you can read it online here:
http://www.microsoft.com/sql/techinf...it/default.asp
Unfortunately, the online version doesn't come w/ the CD ROM, which has
some good samples on it.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic

Global Stored Proc Find and Replace

Hello all,
Being a relative newbie to large scale MSSQL development, I'd like to try and find out if there is some sort of utility, command or stored proc that I can use to globally change all text within my database's stored procedures.

For example... I would like to change a table name from dbo.xtable... to dbo.ytable... Is this possible?

Actually, I'd be happy with some way to search through all my stored procs to find a specific string (i.e. xtable in the example above).

Any help provided will be greatly appreciated!

Jordan StradtmanDo you know how to scipt a database?

First off, all sprocs syhould be stored individually in .sql files, preferably in a version control app, or at least on a server...

To do them all script the db and do a search in notepad...|||Notepad?!

What a lame-ass app that is.

PFE32 dude.|||What's a PFE32?|||Programmer's File Editor. Search Google. It's freeware.

Lots and lots of goodies, such as templates, macros, etc. It's basic, small, love it.

Once you use it, you can never go back...|||Here they shoved down our throught this SlickEdit piece of s%$&, and deinstalled my TextPad. Well, thanks for the link, I'll go check it out.|||I should also mention that I have been using PFE for about 6+ years, which might be why I am so attached to it.|||Jordy,

In Enterprise Manager, right-click the database you wish to script, pick "All Tasks", then "Generate SQL Scripts". Click the button "Show All" to list the database objects, the move the objects you wish to script to the right window. There are some check boxes to assist in selecting various groups of object types.

After selecting what you want scripted, click the "Preview" button. When it appears with the scripts for the objects, click the "Copy" button, close up the windows, and paste the scripts into the text editor of your choice.

Stay warm - hope things are going well for you.

-- Greg H., Digital Marketing