Web Developer Looking For Good SQL Book

Jan 6, 2007

I'm looking to buy a book about SQL, T-SQL, stored procedures, etc. I'm a web developer, so I don't need a book for a SQL Server administrator. I need a book that tells me what I as a developer need to know about SQL. I'm currently using Visual Studio, SQL Server 2005, ASP.NET 2.0, and VB.NET (and fairly new to all of those) if that makes any difference. The bulk of my web developing experience has been with PHP and MySQL so this is new territory for me. I hope all that makes sense. I would appreciate any suggestions for such a book.

Thanks!

-Mathminded

p.s. I bought a bunch of Wrox books and haven't had them long enough to decide if I like them: "Professional ASP.NET 2.0", "Professional ASP.NET 2.0 Security, Membership, and Role Management", "ASP.NET 2.0 Website Programming", and "Visual Basic 2005". I thought I'd check with the experts before investing in another book. :-)

View 2 Replies

Good SQL Book

May 30, 2007

hello
i am just starting to learn sql and know the basics, but now im looking for a good book to learn some more. A book that covers stored procedure would be very useful. If possible a book with q and a would be very good because i feel this tests if u understand what was just explaned. but if there is a good book without this it is ok. All sugestions welcome

NubNub

View 1 Replies View Related

Good Book For Using DTS?

Aug 23, 2000

I have been using DTS somewhat, but I would like to read a good discussion (with cpmplex examples) of it.

Anyone found either a book on DTS or a good section in a book?

Thanks,
Judith

View 1 Replies View Related

Need A Good Book...

Apr 27, 2004

I've been a SQL Server dba for 5 or 6 years now. With the upcoming release (eventually, I'm sure) of Yukon/SQL2005, I've read that it's important for DBA's to pick up one of the .NET languages - I've figured, I'll try to learn VB.NET - I've had a little exposure to it, and can usually figure out what's going on in VB code I've read - however, I seriously doubt I could write anything in it from scratch - I want to learn it in a bad way - can you all recommend any self-paced books that will walk me thru it? I've never had any formal training with it, don't know a class from a DLL....Thanks in advance for your help!!

View 3 Replies View Related

Good SQL Book?

Jul 20, 2005

hello, for a new job i might have to learn SQL. i've neverworked with databases or SQL, so i'll need to learn. cananybody advice me on what would be a good book to learnfrom? i'm quite an experienced programmer, so it doesn'thave to be a dummies guide, and preferably not a bulky booklike the "SQL bible" or something.oh, one of my 'favourite' computer books of all times is"thinking in Java" by bruce eckel, to give you an idea.mike--not sure if there's a better group to ask these questions

View 4 Replies View Related

I'd Like To Get A Good Book Of SQL...

Apr 20, 2006

Would all of you give me a suggestion of valuable book in terms of SQL ??

I confused what kind of SQL book is going to be good for me to study since

I begin to jump into MS-SQL...

Furthermore, I'd know that various level of book as begginer, intermediate , advance...

Thanks for your help in advance..

View 6 Replies View Related

A Good SSIS Book?

Jan 7, 2007

I am new to SQL2005 and have been given the task of writing some SSIS packages to import some CSV files.
I need to cleans the data as it is imported from my CSV files before it reaches my SQL DB.
I am currently Googling the internet to discover how to do this.
Can anyone recommend a good SSIS book?
I am a C# developer, so a book that has lots of SSIS C# examples would be good.
Any help appreciated.
Regards,
Paul.

View 3 Replies View Related

Need A Good Book On Replication????

Jul 31, 2000

Anyone has a suggestion on a good book on Replication. How to set it up.. I am looking for a good detailed book on this subject.

View 2 Replies View Related

A Good Book On SP, Functions

Dec 13, 2007

Can anyone recommend a good book on Stored procedure, Functions, triggers ..Etc??

Thank you

View 1 Replies View Related

Good Book About MS-SQL Replication...

Jul 20, 2005

Hi,Does anyone know any good book(s) about MS-SQL, especially aboutReplication - basically, I need in-depth explanation about how tosetup/maintain Snap Shot, Transactional, Merge Replication anddifferent agents - with good examples? Hopefully, the book(s) isrecent enough to cover SQLCE merge replication as well. In-depthinformation about DTS is a plus ^_^Just tired of print hundreds of pages from MSDN site.Thanks,Charlie Chang

View 1 Replies View Related

Looking For A Good Book On SSIS 2005

Mar 13, 2007

Anyone know a good book on SSIS. I need a good beginer book on SSIS 2005 I am very interested in using it for capturing data from other database and loading that data into the database that I'm working on . Weather it be from another database, textfiles, spread sheets. Any suggestion.

View 1 Replies View Related

Good Book About Stored Procedure

Mar 5, 2008

Hi:
Can you please recommend 1-2 good books about "stored procedure", I need a book which starts from basic and goes to developed level.
Thanks.
Jt

View 4 Replies View Related

Anyone Know Of A Good T-Sql Reference Code Book?

Nov 6, 2003

Hi does anyone know of a good book that has all the t-sql keywords and functions in?? Or a webiste that has a printable version with explanations. I knows its on msdn but its very hard to print it all off.

I need something by my side so I can refer too and use in helping me build statements and sp,s etc.

Thanks

View 3 Replies View Related

Good Book On Sql Admistration And Performance ?

Mar 26, 2001

Hello
Would you please point again on good book for admistration
Thanks

View 2 Replies View Related

Best Book To Gain Good Knowledge In DBA

Feb 26, 2007

Dear Friends,
please suggest me the best book to gain sound knowledge in DBA concepts as well as
writing in sub queries, complex queries as well as inner queries.

thank you very much

Vinod

View 4 Replies View Related

Good Integration Services Book

Apr 3, 2006

ive been learning through books online, but i just find learning from a book is better for me. have any of you bought books on integration services and if so , would you recommend them?

View 4 Replies View Related

Reporting Services, Good SQL 2005 Book

Jan 28, 2006

What are reporting services? i know asp or something like that, do i have to use asp? or can i use crystal Rpts?

Can anyone offer a good book on SQL Serv 2005?

View 1 Replies View Related

Good Book For Learning The Stored Proc Language

Jul 12, 2007

Though I have been using SQL Server for some years, it is just recently that I have need to learn how to write SP's. I would like a recommendation for a book that is rich with examples (my best learning style).

Many thanks...

Todd

View 1 Replies View Related

SQL Server 2000 Book Recommendations? Including Good Coverage Of Reporting Services

Jul 23, 2005

What up-to-date books on this topic can people here recommend? Thanks.- Bob

View 1 Replies View Related

Good SQL Developer Questions

Nov 23, 2007

Hello everyone. I have an interview for an SQL Developer graduate role, and was just wondering if anyone had any good questions for the interviewer and what would be the basic questions for me to answer.

many thanks

Rob

View 2 Replies View Related

Any Good Webcasts For Sql Server 2005 Reporting Services {Developer Perspective}

Mar 16, 2007

Can any body please point me to Any good webcasts for sql server 2005 reporting services {Developer perspective}

Also Please recommend me any good book for using and creating SSRS.

Thanks

View 1 Replies View Related

Changing Careers - Software Developer To Database Developer

Jul 10, 2006

Hello all. I'm giving serious thought on changing gears withing the IT world. For several years I have been a software developer who has been fortunate enough to have been involved in the needed databases. From just sketching out tables for the DBA to doing the database from the ground up and maintaining it during production. Along the way I've known that I didn't do as quality of a job as a knowledgeable DBA would do but given the situations I made do just fine.

I am considering switching gears to the database side only, coding as secondary. Since I am basically familier with most aspects of SQL Server in a general way, I am looking to take that knowledge and become a "Professional". What I am looking for is a few books to help out. Maybe a "Become a DBA for Software Developers" or something. I know that mining these and other forums are very valuble but I'd like some other training materials as well.

Have I been clear enough on what I am looking for? I don't quite feel like I have.

Basically, what would you recommend for a good software developer who is looking on switching to becoming a good database person?

I'd like to stay in SQL Server for now, since that is what they use here and it would give me an opportunity to practice.

Also, do you see value in the studying process for certifications in this area?

View 14 Replies View Related

Started With Express, But Installed Developer And Don't See Developer Instance...

Jun 19, 2006

I can't tell if the SQL Developer install upgraded the service, but left the SqlExpress version information, or if I'm still really only using SqlExpress.

Also, my intended target is SQL Enterprise, so if I am using SQL Express am I asking for trouble when I go to move the database over? Are the database formats compatible?

I've poked around trying to search for this answer for a while and haven't turned anything up. Maybe I'm searching on the wrong terms...

Thanks,
Geoff

View 6 Replies View Related

Can I Use SQL Server 2005 Developer With Visual Web Developer?

Nov 24, 2007

There are conflicting postings everywhere about this. I built a small site using VWD and SQL Server Express, but need to convert to Sql Server 2005 Developer because the DB will exceed 4Gb. Tried to install and could not connect or use from VWD. Tried to uninstall, got into large mess with the byzantine uninstall process, and have now started with a clean machine.

I installed SQL Server 2005 Developer first, then installed VWD Express 2008 without installing SQL Server Express. VWD won't let me connect to an existing database, won't let me add a new database and doesn't even show the Database Tools option under the Tools menu.

Is there someone with specific knowledge that can provide any enlightenment? Would be much appreciated.

View 2 Replies View Related

Visual Web Developer 2005 Express -- With SQL Server Developer 2005?

May 4, 2006

Can someone here confirm or deny that Visual Web Developer 2005 Express Edition doesn't work with SQL Server Developer Edition 2005?

I
was about to order SQL Server Developer Edition 2005 on Amazon, to use
with Visual Web Developer 2005 Express, when I read a user comment that
the two are incompatible with each other. Does anyone know for sure if
that is true?

What I'm wanting to do is develop an ASP.NET web
application on a web host using a SQL Server database. I use VS2003 and SQL
Server Enterprise 2000 at work, but I'd like to learn the 2005 editions
for this side project. I don't own any of the developer tools/IDEs
personally, so I'm trying to find the most affordable way to do this
for my home business.

Thanks for any advice,

Keith

View 3 Replies View Related

Connect From 2005 Developer Edition To 2000 Developer Edition

Jun 1, 2007

Hi, all -

I'm trying to register a developer's 2000 pc from my 2005 pc.

i'm not sure this is even something possible from Dev Edition to Dev Edition- I can register a 2000 server just fine.

I can ping him. Both our systems have remote access 'on'. His server is (local), i've tried connecting to it by just entering his machine name and by using just the ip address. The error I get is "timeout expired. The timeout elapsed prior to completion of the operation or the server is not responding."

Am I just not registering this properly? I entered just the ip address in the 'server' box. I am connecting as sa with the pw he gave me. When i connect to my server, I use the ip addressinstance. However, I am not sure what to use for the instance when all I see when I look at his machine is (local).

I haven't needed to do this before.

Suggestions?

View 2 Replies View Related

Installing SQL Server 2005 Developer Edition On Same Box As SQL Server 2000 Developer Edition

Nov 1, 2005

I tried to install this on the same box and I'm not sure how to reply to setup questions since I want to keep my SQL Server 2000 intact.

View 5 Replies View Related

DTS Book

Jul 19, 2000

Can anyone recommend a good book on DTS?

View 1 Replies View Related

New DTS Book

Feb 23, 2001

For those of us struggling with DTS, you've probably all seen
Professional SQL Server 2000 DTS
Mark Chaffin, Brian Knight, and Todd Robinson
WROX
ISBN 1-861004-41-9

This is brand new:
Microsoft SQL Server 2000 DTS
Timothy Peterson
SAMS
ISBN 0-672-32011-8

I have both and they're both worth owning.

I also just found a reference to the following, but I haven't seen it so I count vouch for it. (I also wonder why I haven't stumbled across it previously...)
Professional SQL Server 7.0 Development Using SQL-DMO, SQL-NA and DTS
Frank Miller & Rachelle Reese
WROX
ISBN 1861002807

View 1 Replies View Related

Book

Jul 27, 2004

I read alot of Technical books on SQL and I have found that SQL for dummies is actually a pretty good book(nice reference)

View 1 Replies View Related

Got Done W/ Book, Anyone Want It ?

Mar 9, 2004

I really like to pass my books on, for small price to anyone who could use them, since I no longer need 'em. I've got one , the SQL 2000 Administrator's Companion. Please take a look, I put it on ebay:

http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&category=36313&item=3593450436

Thanks

/rob

View 9 Replies View Related

BEST SQL BOOK

Apr 15, 2008

Ok, look. I could sit here and ask about 1,000 different queries that I would like to have. I'd much rather prefer to find it on my own however. Could someone please recommend a book that will tell me all I need to know about performing different kinds of queries? I have limited Mysql, JavaDB experience. A beginner compared to most of you. Thx in advance for any replies.