SQL Server 2000 Book Recommendations? Including Good Coverage Of Reporting Services
Jul 23, 2005What up-to-date books on this topic can people here recommend? Thanks.
- Bob
ADVERTISEMENT
Reporting Services, Good SQL 2005 Book
Jan 28, 2006What 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?
Good Integration Services Book
Apr 3, 2006ive 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 RelatedBook Recommendations?
Jul 21, 2006Ok, let me start by saying that I already checked the FAQ. There was one link, but it just seemed to go to a review page with 5 books, with pretty specific themes. So I'm surprised that such a basic topic as book recommendations for SQL newbies wasn't covered.
In my case, I'm not a total newbie. I learned to write SQL queries for work on both Oracle and SQL Server, and I've gotten pretty good at all the basics. So I've got "SQL for Dummies" down cold, so to speak. Now I'm looking to take my query writing ability to the next level, which I guess would be the intermediate level. I'm also looking for books that are specific to just SQL Server, rather than the books about general querying on any DBMS. Speaking of which, just so you all know, "SAMS Teach Yourself SQL in 21 Days" is an Oracle book, no matter what it says on the cover.
It looks like the book "Inside Microsoft SQL Server 2005: T-SQL Querying" comes highly recommended, but I flipped through it on the shelf at a bookstore the other day, and I think it's over my head. It might be a good reference to have around, but I think I'd be totally lost trying to read it from cover to cover.
So does anyone have recommendations for books that go beyond "This is how to do a SELECT, and here's how to do a JOIN", but won't make my head explode?
Thanks in advance,
--Fromper
Book Recommendations?
Jul 17, 2006I do software support for software that works with both Oracle and SQLServer, so I mostly just write queries to look at the data related tothe software. When I first started, I bought a couple of books to learnthe basics, intentionally going with generic books that would help withboth types of databases. I've got the basics down, and now I'm lookingfor a really detailed reference book that goes really indepth intoquerying for SQL Server specifically. Currently, we only work with the2000 version, but we'll be going to 2005 soon, so I think I'd rather gowith a book on 2005, although if you know one that covers thedifferences between them, that would be great. Any recommendations?Besides just writing queries, I'd also like to learn more about SQLServer in general. DBA software support, so I'd like to head mycareer in that direction. I was looking at Microsoft's newcertification path for SQL 2005. Given that my company won't pay tosend me for training, and I really don't want to have to put down$2200+ to pay for a class, I was thinking that I might be able to learnenough on my own to pass the first test and get the MCTS title. Iordered the Training Kit from Microsoft Press for that, which comeswith a 180 day trial of SQL Server 2005 to play with, along with a hugebook. Does anyone have any other recommendations for resources to helplearn this stuff?--Richard
View 4 Replies View RelatedSQL Book Recommendations For Newbie?
Sep 15, 1999Hi all,
I've recently been tasked with doing some SQL 7.0 administration and was wondering if anyone could recommend a good book to get started. The bulk of my IT experience is in SMS, IIS and messaging so my database fundamentals are pretty weak.
As I see it, it's probably a three-step process to get me at least halfway comfortable - a first book to get some solid general database / SQL-language exposure, a second book that takes the knowledge to a more advanced level and finally a MS-specific book that covers the Microsoft implementation of a SQL server.
Any comments / suggestions would be much appreciated!
Cheers,
RM
Book Recommendations Needed
Jul 20, 2005I am looking for a book that discusses query tuning, index tuning, executionplans, etc. Can anyone recommend something?--BV.WebPorgmaster - www.IHeartMyPond.comWork at Home, Save the Environment - www.amothersdream.com
View 1 Replies View RelatedAny Good Webcasts For Sql Server 2005 Reporting Services {Developer Perspective}
Mar 16, 2007Can 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
Advanced Transact-SQL Reference Book - Need Recommendations!
Jul 20, 2005I currently have two SQL server books for MS SQL Server 2000. One is aprep book for the 70-229 exam, the other is a Wrox book: "professionalSQL Server 2000 Programming."I'm looking for more T-SQL books that give me PRACTICAL tips onwriting advanced queries. What book do you refer to? Please post them.
View 3 Replies View RelatedSample Files From The Book SQL Server 2005 Reporting Services Step By Step
Jan 18, 2008
Hi All,
Please let me know where can i find the sample files and rs2005sbsDW database in msdn library as i dont have CD provided along with the book.
Please give me the link of the sample files so that i can download it for testing the sample application.
Regards,
Prabhanjana
Good SQL Book
May 30, 2007hello
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
Good Book For Using DTS?
Aug 23, 2000I 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
Need A Good Book...
Apr 27, 2004I'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 RelatedGood SQL Book?
Jul 20, 2005hello, 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 RelatedI'd Like To Get A Good Book Of SQL...
Apr 20, 2006Would 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..
Web Developer Looking For Good SQL Book
Jan 6, 2007I'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. :-)
A Good SSIS Book?
Jan 7, 2007I 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.
Need A Good Book On Replication????
Jul 31, 2000Anyone 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 RelatedA Good Book On SP, Functions
Dec 13, 2007Can anyone recommend a good book on Stored procedure, Functions, triggers ..Etc??
Thank you
Good Book About MS-SQL Replication...
Jul 20, 2005Hi,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 RelatedLooking For A Good Book On SSIS 2005
Mar 13, 2007Anyone 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 RelatedGood Book About Stored Procedure
Mar 5, 2008Hi:
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
Anyone Know Of A Good T-Sql Reference Code Book?
Nov 6, 2003Hi 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
Good Book On Sql Admistration And Performance ?
Mar 26, 2001Hello
Would you please point again on good book for admistration
Thanks
Best Book To Gain Good Knowledge In DBA
Feb 26, 2007Dear 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
SQL Server 2000 Hardware Recommendations
Jul 20, 2005I'm on the IS team of a medium-sized non-profit with internationalreach. We're trying to make some decisions regarding our Web serverand database server as we expand our web site to have more dynamiccontent. Currently the database server houses all data pertinent tothe organization (membership data, events, products, etc) in onedatabase (~2.2 GB) as well as the web site content in a separatedatabase (~40 MB). The web site pulls from both databases but hits thecontent database more often.In a nutshell, our database server appears to be struggling duringperformance testing of the new Web site. We are trying to determinewhether we simply need new hardware, or if there are things we can doto help MS SQL make better use of the resources we have. The hardwareis a COMPAQ ML370, 1266mhz Pentium III, 1gb RAM, RAID 5 with 3 HD(10,000rpm) and a COMPAQ Smart Array 5i SCSI controller. The OS isWindows 2000 (standard) running Microsoft SQL 2000, SP 3a. The Webserver is a 2.8ghz Pentium IV with 2.5gb RAM, RAID 5 with 3 HD (15,000rpm) running Windows 2000 standard and IIS 5.0. While stress testingour web site under a moderate load (simulating approximately 20simultaneous users), the database server processor tends to max outand stay that way for the duration of the test. Memory and disk accessappear to remain fairly stable -- there isn't a lot of paging goingon, and the disk queue doesn't escalate much if any. The Web servershows spikes in processor use, but appears to be coping well. However,under a heavy load, a sql-heavy page can take as long as 90 seconds toload! We've been assuming that the network is not the issue, as theservers are communicating over a gigibit backbone and while we'veidentified aspects of the ASP code that we can optimize, the databaseserver seems to be a large part of the problem.We've reviewed our SQL configuration settings, and they appear toalign with the best practices, which in our case are the defaultsettings for SQL 2000. We have rebuilt our indexes, and havedefragmented the hard disks on both the database and Web servers.This, along with changes to the structure of the Web pages themselves,has led to improvements, but the processor on the database serverseems to be groaning under the strain, and pages are still taking anunacceptable amount of time to load.What else should we be looking at? Are there steps we could take tominimize the load generated by client/server and Web-related traffic,or specific performance counters that would help us to identify theproblem? Do we just need to look at getting some new hardware? If newhardware is unavoidable, is there anyone running a similar environmentwho could suggest what minimum requirements we should be looking for?Any suggestions would be much appreciated!
View 5 Replies View RelatedGood Book For Learning The Stored Proc Language
Jul 12, 2007Though 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
Migrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services
Mar 22, 2008
Hello,
I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?
Any help is appreciated
SQL Server 2000 Reporting Services
Apr 18, 2004Hi there,
I have installed SQL Server 2000 Reporting Services with the default names for the virtual directories , (ReportServer and Reports). Is there any way i can change the name of these directories by running a script or some thing.
Also is there a way to use the Cascaded Style Sheet used in my ASP.NET application for the reports.
Thanks
SQL Server 2000 - Reporting Services
Feb 1, 2006We had someone leave work and he was responsible for the reports for our company. He used SQL 2000 w/ Reporting Services. The connection to the report server was tied to his userid and password. Since his account was disabled the website will not connect to the reporting database because it was tied to his account. Is there a way to reset the connection creditions? I looked on the server and I can't find the Reporting Services Admin Tool.
Thanks..
Sql Server 2000 And Reporting Services
Jul 6, 2007Hello there.
i would like to install Report Services on visual studio 1.1 version
using sql server 2000. i currently have sql server 2005 and visual
studio 2.0 and there is no problems and so i remember how that
works.
With sql server 2000 i saw a link to a trial version of reporting services that i can download and install but after 120 days it's no good. I think that provides the gui interface to install reporting
services like the 2005 version except less robust. But i'm wondering with the proper service packs of sql server 2000 installed if i can
bypass download.
Can somebody help me how to install reporting services with sql server 2000, pre-req and software i need. I currently have the
developer's edition of sql server 2000 already.
Please contact me at clalbert@flash.net
Sql Server 2000 Reporting Services
Jul 10, 2007is there a reporting services configuration tool for 2000 that comes with the non-trial version as the trial version did not install this tool - maybe it did not do so because i had the 2005 version already installed. ???
View 1 Replies View RelatedSql Server 2000 And Reporting Services
Jul 10, 2007i'm looking for a configuration tool that will configure my report and report server for sql server 2000 independent of sql server 2005
reporting services if any. reporting services 2005 has a configuration tool to set its own.
What i mean is way before reporting services 2005 people installed
2000 reporting services and they had to configure report and report
server so that results can be shown up via an intranet web browser
mechanism. Does reporting services 2000 offer this and if not
how is it done?
I know i can use the report server/report of 2005 to hold 2000 reports and i know how to setup a side-by-side installation using
2005 but i want to know documentation about the original way.
thank you