Books/Online Resources For SQL Server 2005?
Jul 16, 2007Could some body suggest some good books and online resources for:
1. T-SQL Intermediate level/Advanced
2. SQL Server 2005
Thanks a bunch
Csharplearner
ADVERTISEMENT
Installing Sql Server 2005 Books Online
May 3, 2008I 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
SQL Server 2005 Books Online (May 2007)
Nov 6, 2007I 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.
SQL Server 2005 Books Online - How To Install?
Oct 23, 2007Can 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.
SQL Server Express Books Online
Dec 1, 2007are 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.
Good Online Resources For Teaching SQL For SQL Server 2000
Oct 27, 2005my freind asked me to look for him for online book or something very good that teach SQL for SQL server 2000 ... what i need is something like hands on examples that will take user from level 1 to level * .... i have seen alot of stuff in google but i think some of you might know what i need and can direct me to better resources as i could not find someting specail !!!
View 2 Replies View RelatedSQL Server Books Online January 2004 Update
Jul 20, 2005Hi,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 RelatedBooks Online
Aug 10, 2005How do you use BOL? I've heard time again that there is much info in BOL but when i look at it it seems too brief and not detailed. I find it hard to find what i'm looking for anyway. How do you use it?
Thanks!
Online Books / Tutorials
Aug 2, 2002Hi All...
Can anyone guide me to a place where I can download some Tutorials / Books (Not that new) covering Microsoft SQL 2000 essentials ? I tried to find here, but artices are too advanced for me.. I need something that covers the Basic and that could be used as a small reference/guide while I am learing...
Thanks to ALL
Books Online Downloads For Ver 6.5/6.0/4
Sep 14, 2006Dear all
Where can I download Sql Server Books Online for any versions of 6.5 or 6.0 or 4.
thanks
Books Online Download Link Please
Aug 30, 2006please provide me the link of books online of sql server.
i've this with my sql server, but un installed. i need this book immiedietly please give me the link
Books OnLine (chm Files) Problem
Jul 20, 2005Hi All,I searched this news group but couldn't find that problem whichis suprising... maybe I'm doing something stupid.I start one of the chm files (books on line help files).I read about a topic. There are links.I click on them. It tells me "Selection is not associated with anytopic. Please try again.". Its ahref link to jscript function:javascript:hhobj_1.Click() but I do not have it and cannot find it.So I have to go between all those chm files hoping to find the topicof my choice.Plus I want to search them all at once.There must be a (smart) and easy way to do this.Please, do you have any suggestions.ThankfullyJimmy Ol' Boy
View 1 Replies View RelatedNew Books Online Search Functionality On MSDN...
Mar 30, 2007 Check out the new Books Online search functionality online. The link below provides a scoped search of Books Online that returns a more precise and targeted result set. You can use it to search Books Online content quickly.
http://search.live.com/macros/sql_server_user_education/booksonline
Please direct your feedback to SQLServerUE@hotmail.com.
Trouble Going Thru The Deployment Tutorial In Books Online
Apr 9, 2008I am trying to go thru the deployment tutorial, but I'm running into some trouble. The two sample packages I need to work with are called DataTransfer.dtsx and LoadXMLData.dtsx found in the samples.
When I examine these packages, they are writing to tables called dbo.HighIncomeCustomers and dbo.OrderDatesByCountryRegion. These tables don't exist in my copy of AdventureWorks database.
Also, when I try to open the Connection Manager for the target tables, I get a message that says, "The specified provider is not suported. Please choose different provider in connection manager."
Is it possible I'm having these issues because I'm working with a different version of the sample packages?
Books For Sql Server 2005
Jun 3, 2006Hi 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
Best SQL Server 2005 Books
Aug 17, 2006Hi,
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.
Recovery :: Server Cluster Resource Fails To Come Online And Pending Online State
Nov 3, 2015We have SQL cluster installed on top of windows cluster on VM environment. Node1 and Node2 under Windows Failover Cluster. SQL instance is currently on node2 the instance is up and running, but SQL Cluster service remains online pending and it restarts the instance on every 5 minutes.
SQL Browser service are running successfully.TCP/IP ports are enabled and configured.If we start the SQL server agent it is on for seconds and stopped immediately  .Cluster Service is attempt to connect to the SQL service every few minutes (setting in SQL cluster resource) for the IsAlive check, if this fails then the SQL resource is restarted even if the instance was online. Hope this is what happening exactly.
[sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. (268435455)
00001024.00053314::2015/10/30-19:57:50.772 ERRÂ Â [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [HYT00] [Microsoft][SQL Server Native Client 11.0]Login timeout expired (0)
00001024.00053314::2015/10/30-19:57:50.772 ERRÂ Â [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server
Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books
Online. (268435455)
00001024.00053314::2015/10/30-19:57:50.772 INFOÂ [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] Could not connect to SQL Server (rc -1
Good Books On SQL Server 2005
Feb 22, 2008Can you guys pls suggest Good books on SQL Server 2005 ??
Thx
SQL Server 2005 Books Unavailable
Mar 18, 2007Windows 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!
SQL Server,SQL Server Agent,SQL Analysis Resources Failing In SQL 2005 Cluster
Aug 17, 2007Hi.
I have installed an SQL 2005 Failover Cluster on a Two Node Active Passive Windows 2003 Cluster.If i am trying to failover from the Active node to the passive Node,The Sql Server,Sql Server Agent and SQL Analysis resources fail,However if i reset the passowrd in the services tab of the above three services on the pasive node,the resources come online.
Below is the brief of my setup
1.I have two Active directory domain controllers running Windows 2003 R2 Standard edition with SP2.
2.i have installed a Windows 2003 Two Node Active Passive Cluster as NODE1 and NODE2.
3.The Domain account used to install WIndows 2003 A/P Cluster is Clusteradmin.This account is the member of Administartors on the Domain as well as the Local Admin on NODE1 and NODE2.
4.SQL 2005 with SP2 is installed on both the Nodes as SQL 2005 Failover Cluster.The account used to install SQL 2005 is sqadmin.This account is the member of Administartors on the domain and the member of Local Admins on NODE1 and NODE2.
5.SLQ 2005 has four domain groups for 4 SQL Services.The Services are SQL Server,SQL Server Agent,SLQ Anaylisis Server and Full text Search.
6.Each of these servcie has a seperate service account created for them.All these service accounts areb the members of domain admin and the member of Local Admin on NODE1 and NODE2.
7.Each of these servcies is running under these servcie accounts in the Servcies tab in NODE1 and NODE2.
8.If i fail the resources from NODE1 to NODE2 ,The SQL Server,SQL Server Agent and SQL Anaylisis resources are failing.on going to the service tab of NODE 2 I reset the password for these services,the services come online.
10.The Cluster resources and MSDTC Resources are Failing over successfully.They are coming online successfully.
11,I have a problem with the SQL Server Resources,even if i failback to NODE1 from NODE2,the same resources are failing again.
Plz Advice.
Regards
Khalid
SQL Server 2005 Reporting - Books / Reference Guides, Etc, Need Advice!!!
Apr 18, 2008
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
Online Query Tool SQL Server 2005
Feb 18, 2008Hi,I was wondering if someone could help advise me.Basically i have a client who wants to upgrade from a desktop msaccess solution to a web based system using MS SQL Server 2005.Basically their main concern is in losing the ability to write ad-hocqueries using the MS Access query manager. I can obviously writestatic reports etc but whats the best way to give them someflexibility ??Can anyone advise me if there is any product that can do this for SQLServer 2005 (which im sure there is) but will work in a webenvironment.Or does anyone have any helpful ideas ???all help / advice greatly appreciatedCG
View 1 Replies View RelatedWorking With An Online And Office SQL Server 2005 Database
Sep 18, 2006I'm not experienced with SQL Server 2005.I've got a live copy of my database running on the web server.I've got another copy running on my desktop that I make changes to.Whats the best way to sync between the two so:1. I don't have to take the application offline2. I don't loose any data from the live database3. But I can implement changes to tables and/or add new tables
View 1 Replies View RelatedMoving A SQL Server 2005 Database From The Local Network To An Online Server.
Mar 7, 2006Hi All, first post.
I have done a bit of searching around and cant find a clear answer to this question.
Current Setup
Desktop application (c#) that connects to a SQL Server 2005 express database on the same local network as the application (currently 3 users)
It is only a very small company and has just taken on their first remote worker, but expects to take on another 6-8 over the next few months. They have asked for the database to be moved online.
The application was written in such a way that everything has been done using no stored procs, or views, it is all native SQL.
This will be my first DB hosted online and before I go ahead and do anything I just wanted to make sure what I have to do is correct, sorry if this is a very basic question, although I have been programming for a long time, I have never had the chance to do any online databases before.
Will this work.
1.Find a SQL Server 2005 Hosting company.
2.Move the database to the server.
3.Setup the users permissions.
3.Alter the connection string in the application to point to the new location.
So the only thing that would change would be a new connection string in the application preferences?
Or am I living in a dream world, because nothing is ever that simple.
One thing I am worried about is the security/visiblity of the database and data as it travels from the server to the client and back.
Thanks for any advise you can give.
Mark
Importing Online XML File Into SQL Server 2005 Tables – No Data Transferred
Oct 12, 2006Does anyone have any great suggestions on how I can import an online XML file into an SQL 2005 table?
So far I tried to accomplish it with SSIS Data Flow Task where my source is XML Source (Data access mode: XML file location; XML location: URL, Use inline schema = True). This set up properly identified the columns to be imported.
I used Copy Column data flow transformation task to load data to OLE DB destination table that has same structure.
When I run the task it does execute with no errors, however the table remains empty. It looks like I am failing to read the actual data.
Do you have any suggestions? I am willing to go around this approach with stored procs/com/you name it €“ just make it work!
Thanks a lot for your help!
LoveDanger
SQL 2005 Express Resources
Jun 9, 2007Will I am running SQL 2005 Express on windows 2003 sp1 with a P4 3.4Gh (with hyperthreading), 2GB ECC RAM.
I am running software that connects to SQL and reads/saves data.
One of the programs which is CPU hungry manages data and the other manages the SQL connection and reads/saves the data.
My problem is that I am recieving an error that usually means connection to SQL is lost, this tends to be because the CPU hungry application is denying SQL from functioning.
However the annoying thing is the CPU use rarely passes 45% and in a another test environment never passed 5%. RAM is the same, consumption is less than 35%.
Please advise
Thanks a lot!
AS 2005 References/Books
May 4, 2007Hi All -
I have come across the need to use a cube in AS 2005 for an application. Unfortunately this will be the first time writting an ASP.Net application which uses one. I was wondering if any of you had any good books or references that I could look at to get an idea of how I should approach this issue.
Thanks in advance.
Books For SQL 2000/2005
Dec 7, 2006Well, 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
SQL 2005 Express Memory Resources
Sep 28, 2007Dear All,
I have 1 problem here. I developed a desktop application and I am using SQL 2005 Express as my application database.
I found that after I closed my application, the SQL 2005 Express memory resources do not release. How do I release the memory resources except of restart the SQL services?
Do you guy have any better recommendation of other database is more suitable for desktop application?
SQL 2005 Cluster Behavior - Re Authenticate After Moving Resources...
Oct 30, 2007On a SQL 2005 Cluster, when you move the SQL resources you generally have to kind of "reauthenticate". For example, in SSMS and after you have moved the SQL cluster resources, you run a query in SSMS and you get a connection failure. Run it again and it works.
Does anyone else notice this? I am assuming it is because the resources are now on a differen't server. But then what's the purpose of the SQL virtual server name and instance? I thought when you authenticate to SQL it's to the virtual SQL server like so... VirtualServerSQLInstance.
Can someone straighten out my poor mangled mind?
I'd like to avoid this reauthentication thing.
Thanks
MSDE Or SQL 2005 Deployment Resources - Real World Input
Feb 9, 2006I have traditionally done web app and client server programming and am have been playing around with a new tool (Win forms) app that I eventually want to distribute to other developers and a couple of business people in our organization. I have done apps in the past that all connect to a central server for data access. The I'm working on now will have an individual DB per user and should be available locally for a desktop version of the software.
I am looking for more resources on things to consider when deploying an app with either MSDE or SQL 2005 Express. More specifically, items like long term maintenance of the db once it's installed with the user, etc. (DB bloat, transaction files, auto maintenance routines I may want to build in, etc)
I have seen all of the msdn docs on what you need to deploy (and how to do it), but I'm looking fro input from people that have deployed it and any significant pitfalls they have run into with that sort of deployment.
Any links or book references would be appreciated, thank you,
Cy Huckaba
Online/Offline Application That Must Synchronize With SQL 2005
Mar 10, 2007Hi !
I must developp a WPF Application with online and offline capabilities! First I think to use XML file on the local application and transfer these XML files to a webservice that will synchronize them with the SQL 2005 Server
BUT
I read about "Replication"... and I think it will be much simpler to implement!!!
Do you think it is a good idea to have a "local" SQL Express database and replicate it (when connection available is) with the principal database that will run a standard SQL 2005 version!
Do you have another suggestion to make such an application??
Thanks for help!!!
PlaTyPuS
PS: when the sql express solution a good idea is, does it give a simple solution to programm an automatic synchronization every hour?
SQL Server Deadlock On Resources??
May 30, 2007We've got a 3rd party application that periodically runs SQL commands throughout the day. We've been getting issues with this application showing a sql error:
Transaction (Process ID 71) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
In checking the processes on SQL Server, there were a lot, and process ID 71 was actually hitting a completely different database.
Is there a way to streamline how SQL Server handles processes, and what's the limit at any given time?