There are between 10 and 15 books in the set. I recall an index, developer's book, administrator's book, and two T-SQL reference books. I don't remember what the other books were. Does this sound familiar to anyone? I had these books at my disposal at my last place of employment and I'm trying to get the same books here. If this sounds familiar to anyone, can you point me in the right direction?
Thanks
I am not new to the SQL Server world, but am somewhat new to the SQL Server 2005 world. I am just getting into the reporting tool. By just messing around for about an hour or so, I was able to get what I wanted somewhat. Basically, I'd like to get up to speed on the reporting side of things fairly quickly. So I am looking at some books, and was wondering if anyone had any suggestions on any.
Here is a few that caught my eye:
-MS SQL Server 2005 Reporting Services by Brian Larson
-MS SQL Server 2005 Reporting Services for Dummies
-Professional SQL Server 2005 Reporting Services by Paul Turley
-The Rational Guide to SQL Server Reporting Services
I am thinking the 1st two would probably be my best bet, but wanted to get you folks suggestions.
Let me know as soon as you can as I am planning on going to the book store tonight or this weekend.
Thanks in Advance!!!
Tony
Hi All,
Can anybody list out good books for Sql server 2000 Database Administration for a beginer level to the expert.
And also the good resource /sites/forums for learning ,administering and for certification. Which is the best way to busy and where???
I am an oracle //informix DBA
Thx in Advance
Kpai
Hi,
I am an Oracle DBA with over 7 yrs of experience.I am new to sql server 2000 and am given the responsibility of sql server 2000 production databases in a few weeks.I already have the sql server 2000 DBA survival guide.
I would like to know if there are any good books out there for
a)backup and recovery
b)General DBA tasks
c)Performance tuning.
Thanks,
Copernicus
My uncle runs a small networking company and has extra licenses for Windows 2003 Server as well as SQL Server 2000. Since I just graduated from college and have started working as a database programmer (for a different company) I'd like to setup a small server at home to learn more about SQL (as well as networking, but SQL is my primary concern). I know I can setup SQL Server 2000 on my main PC, but I'd still like to set everything up in a server environment.
So, what I'm wondering is if any books (or web sites?) exist that walk you through setting up Windows 2003 Server and SQL Server 2000. I've actually set these up before (it's not very complicated) but I'm not sure if I did it the "correct" way.
Ideally if any books exist on O'Reilly's Safari Bookshelf that would be even better.
Thanks in advance,
John
Hello there everyone!!
I've just joined this community and already feel alot better in doing so!!
My question is aimed at SQL Server 2000. Part ofmy job role has swicthed to SQL Developer to Database Administrator.
To learn SQL Server 2000 (latest version available to me) I wanted to find out about courses (based in London, UK) which help teach along the lines of the following topics:
Fundamental concepts
SQL Server installation and upgrade
Database management
Backup and recovery
Alerts and jobs
Security
Replication
Monitoring SQL Server
Converting and migrating data
This is what I understand to be prior importance for the role.
My main question to you guys: Can anyone recommend a reference book which is a good desktop companion which covers all of these topics to detailed depth??
I'm running SQL Server 2000 on Windows 2003 Server. I'm aware some books may be old, but the later they are the better?
I've studied SQL at uni, covering RDMS, OLAP, Data manipulation, Data Definition. But now its to be applied to SQL SERVER 2000
Any suggestions please?
Thank you for your support
5SP
With SQL 2000 and MSDE 2000, I only had to put a "." for the server name in a connection string. Now with SQL Express 2005 I have to acually reference the server instance name ".SQLEXPRESS".
Why is this?
Also, when running the command line tools for running scripts, I have to include the parameter "-S MACHINESQLEXPRESS" in the command line where as before I never used the -S parameter at all.
Anyone know why? I am curious because it is going to cause an impact on our upgrades for the client.
My only answer to these questions is that there is no SQL Agent running anymore.
Thanks in advance,
Scott
I have a couple of years of light experience with SQL server. I'd like to start studying to take the SQL 2000 exams. I have a good test environment set up and I'm reading through the Books Online. Can anyone recommend a book or books that might be helpful for me? My end goal here is to pass the test in the near future, but I want to really learn SQL rather than just learn to pass the test.
Thanks,
Allie
Well, after having a crash course on backups, tlogs and some other good stuff, I pretty much made the decision that I need to get some good books to further help me progress in my database admin path.
Right now, we are running SQL 2000 SP4, but we are planning on upgrading to 2005. With that, and the fact I am pretty new to databases, what books are recommended?
I want to get a book that will help me:
-better administration
-write SQL query code as well as understand it (what is difference between SQL programming and SQL query (such as on the sqlteam bookstore)
I feel that my career path is going to start heading down a Database path, so anything that you recommend with that is great as well.
I can't thank everyone enough for the help and input here. Everyone has been great!
Cheers
TheCoffeeguy
Hi,
I'm trying to insert the Url for the image control in the Report designer. As per your article there should be an option (radio button) in Image Wizard to use set the URL for the reports. But i do not get that option at all. All i get is these options
a) - Embedded
b) - Project
c) - Database
I do not get a URL option.
My problem is that i have a URL path to the images that are stored on a Web Server. I would like to this path to be the source of the Image control. I can't make it work. Any help will be appreciated.
Thanks,
GJ
Any recommendations from DBA's on good books for performance monitoring for sql 2000
View 2 Replies View RelatedI hve been using this group, Micrsoft Books Online, and the MS SQL 2000 home site for reference.
Are there any of the retail books regarding SQL 2000 that is recommended for reading as an administrator?
Thanks,
Steve
I am working in SSRS 2000, and I have a report using a table. In the footer of the table I want to do a calcuation. I have a textbox in the table called "SumAmtCurrent", which is a sum value for a field in my dataset. I have another field in my dataset, "TotalRevCurrent", and I would like to take this second field, subtract the value in the textbox "SumAmtCurrent", and have the result in the footer of the table. I tried to reference the textbox using ReportItems!SumAmtCurrent.Value - but that gives me the following error
"...The value expression for the textbox €˜textbox7€™ refers to the report item €˜SumAmtCurrent€™. Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope..."
Is there a way I can get this total into my report?
Thanks in advance!
Can anyone recommend books on SQL Server 7.0 Data Transformation Services?
Looking to find info on importing data from a Sybase server to SQL server (need good examples). Thanks.
Hi,
Can anyone suggest good books on exclusively sql server development..Not for the beginners but at intermediate to advanced level.. Books which gives good understanding on Stored Procedures, Triggers, Cursors, Functions...
Hi all
i am beginner with sql server 2005
and i need good books for good beginning
i found many books but i dont know which book i chose ...
what is the books you advice me to read for stability begnning ??
thank you
Can anyone make some good book recommendations for SQLServer2000 other than the Microsoft BOL?
Thanks
Hi,
I am trying to determine a couple of books that will help me understand SQL Server 2005 from a few of perspectives:
Optimizing databases, specifically from SQL 2000 - I have a recommended book Pro SQL Server 2005 Database Design and Optimization
Developing SQL Server 2005 based applications using VIsual Studio 2005 and .NET 2.0 - I have been unable to narrow down to a specific book here. I learn best by example, so I was hoping for a book that basically goes through implementing a "real world" project from scratch to finish. I am going to be using the full-blown enterprise edition of SQL 2005, not the Express Edition; but a book that uses the Express Edition trumps any other book, I would be open to it. Any suggestions on such a book?
Understanding T-SQL and Stored Procedures from a SQL Server 2005 perspective -- Any suggestions? A book that spells out the differences from SQL 2000 would be an added advantage.
Thanks.
Hi,
I am new in this dbforums. i working on SQL SERVER REPLICATION. I need some books related to only SQL SERVER REPLICATION. If any body konwn then reply me
dear friends please provide me some free downloadable books for sql server DBA's.
i tried i google. but not got any book to download.
Hi,
Can anyone suggest me good books for learning sql server development ie stored procedures etc..
Can you guys pls suggest Good books on SQL Server 2005 ??
Thx
Windows 2003 Server x64, SP1SQL Server 2005 x64, SP2Installed Books Online Feb 2007.
Error displayed when launching Books Online:
'Microsoft Document Explorer cannot be shown because the
specified help collection 'ms-help://MS.SQLCC.v9' is
invalid.'
Work-around detailed in KB here (http://support.microsoft.com/kb/913392/en-us) does not work.
Un-installing Feb 2007 BOL and installing original makes no difference.
Help!
are a mess, reminiscent of the structurless "goto" programming of days past. One of you brainiacs need to erect a "real" getting started section, with procedural steps on how a first time user can successfully download, install, and use SQL Server Express. Not all of us are working in corporations where the guy in the next cubicle can answer questions for newbies.
I will try once again, nicely, to ask a question about installing SQL Server Express Edition SP2 onto a Windows Vista machine. That drama will take place in another post.
I just downloaded the SQL Server Express w/ Advanced Services and did not see a specific Books On Line for this edition. I know there is a new SQL Server 2005 BOL - I downloaded this as well, and will use to complement the old SQL Server Express BOL.
I was looking for specific information about the differences between SQL Server Express and the Advanced Services edition. I think the Microsoft sites are pretty vague - why is the advanced services edition better for multiuser applications?
Jane
I am using vs 2010 to write my dtsx import scripts.I use a script component as a source to create a flat file destination file.Everything have been working fine,but then my development machine crashed and we have to install everything again.Now when i use the execute package utility to test my scripts i get the following error:
Error system.NullReferenceException: Object refrence not set to an instance reference.
In PreExecute section
TextReader = new system.io.streamreader(" file name")
In the CreateNewOutputRows:
dim nextLine as string
nextLine = textReader.ReadLine
[code]...
is there something which i did not install or what can be the error?
Could some body suggest some good books and online resources for:
1. T-SQL Intermediate level/Advanced
2. SQL Server 2005
Thanks a bunch
Csharplearner
I am trying to install sql server 2005 books online but I am failing and I am getting this message
"This installation pakage could not be opened.Contact the application vendor to verify that this is a valid windows installer package"
am I doing anything wrong or has the version of books online changed? Do I have to install anything else before installing it? or does my operating system not support it?
Thanks
I downloaded and tried to install the file "SqlServer2K5_BOL_May2007.msi" and got a message:
"This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package."
Please advise.
Can some one give me detail instruction to installing the SQL Server 2005 Express Books Online.
I am new to SQL Server and want to install the MS training material.
Hi,I have been trying to download the latest update to SQL Server BOL forquite some time without any success. I have tried downloading around3-4 times. Every time (size of msi file would be around 25 KB) I try toextract the msi file, I get an error message to the effect that 'it isnot a valid windows installer package'. Has anyone come across thisproblem?Have been trying to download from this URL -http://www.microsoft.com/downloads/...A6F79CB1-A420-445F-8A4B-BD77A7DA194B&displaylang=enThanks,Harish*********************************Long way to go before I sleep ..*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies View Related1. I need to find the names of the customers who have purchased academic books. (Coding required as Subquery NOT as Join)
2. Here, I need to show a list of authors who have written books and list the books they have written.
Sort the list by last name
(Coding required as Subquery)
I'm creating a trigger in an Sql Server Project that needs to execute some code. Is it possible to reference any assembly? When I click "add reference" to the project I cannot browse to an assembly.
What are the limitations of this feature? I was under the impression you could execute any .net code.