Beginning SQL Server Book?
Jul 23, 2005
Greetings:
I would like to ask for recommendations for a good beginning book on
SQL Server. My web host offers a 100MB SQL Server database as part of
the package, and I'd like to use the feature to learn.
I am proficient in Access and familiar with basic connectivity to it
via ASP. I don't have my own license for SQL Server (and currently
can't afford one) so all development will need to be done by
interfacing with the remote database. As such, I won't need a lot of
explanation regarding installation and software setup.
Does anyone here know of a good study resource for someone in this
scenario?
Many thanks in advance,
Kay
View 5 Replies
ADVERTISEMENT
Dec 22, 2006
Dan Tuohy writes "Hi Guys, im working for a company who have asked me to create a database to store there client information. They have totally left everything up to me and are aware that i know little about SQL server. I have downloaded SQL Server Express edition for use as the database engine. The server that the company have is a Linux server but the workstation machines are Windows :s
I am overwhelmed by the pro's and cons of SQL Server, Oracle blah blah blah lol.
Can you give me some pointers, ie books that would guide me step by step, or just some helpfull points to get me started?
Thanks ever so much,
Dan Tuohy"
View 2 Replies
View Related
Dec 12, 2006
Hi all,
I am just starting to look into this interesting piece of technology, but am a little confused on how this works. I apologize if this has been asked earlier. My question is with this specific SQL server distribution, what is being used as the front end (to create and view your database & tables)? I read that SQL Server Compact Edition RC1 will have runtime only - How will you then get an application to point to a database via SQL compact?
View 3 Replies
View Related
Feb 19, 2008
before this, i used sql 2005 express to create .sql file to learn sql and it's perfectly fine since the connect to server prompt offers me a default server to connect to but when i use sql server 2005 there is no server for me to connect to. My question is how to create a server to connect to.
View 1 Replies
View Related
Jun 23, 2006
Hi mates,
My company has just started in the SQL Server's world and we are going to buy books
on this software. Our systems will run on SQL Server Standard Ed. 2000.
The question is: should I buy books on SQL Server 2005 ? Or 2000?
I'm not quite sure what kind of material to buy nor the differences between them.
Could anyone give me a hand with this?
Cheers
Bruno
View 4 Replies
View Related
Mar 20, 2015
I am trying to find a beginning date from multiple date ranges, for example:
RowNumberidBegin dtEnd Dt
107933192014-09-022015-06-30
207933192013-09-032014-09-01
307933192012-09-042013-09-02
407933192011-09-062012-09-03
For this id: 0793319, my beginning date is 2011-09-06
108203492014-09-022015-06-30
208203492013-09-032014-09-01
308203492012-09-042013-09-02
408203492011-12-122012-07-03--not a continuous date range
For this id: 0793319, my beginning date is 2012-09-04
108203492014-09-022015-06-30
For this id: 0820349, my beginning date is 2014-09-02
To find continuous date, you look at the beginning date in row 1 and end date in row 2, then if no break in dates, row 2 beginning date to row 3 end date, if no break continue until last date There could multiple dates up to 12 which I have to check for "no break" in dates, if break, display beginning date of last continuous date.
View 9 Replies
View Related
Feb 18, 2007
Hi,I am looking for a book on SQL Server 2000. One that covers enterprise manager, query profiler, stored procedure syntax etc.I have about intermediate knowledge of both SQL and SQL Server 2000 but want to expand my knowledge for work etc. as I will be using it more and more for work.
I will predominately be using SQL Server as a backend for web and software applications, programming in .NET.Any recommendations?
View 3 Replies
View Related
Jun 14, 2007
Hi,
I have been using SQL Server 2000 for sometime now but I am still not very familiar with some of the functionalities.
Just wondering if anyone can recommend me some "must have" SQL Server 2000 reference books.
Thank you.
Danny.
View 7 Replies
View Related
Nov 29, 2007
We are currently have SQLS ERVER 2000 . We are planning to upgrade to SQL SERVER 2005 Next month. I believe DTSPkgs have changed significantly in 2005.. I have not used SQLS ERVER 2005 a whole lot yet. Can you pl recommend me aa GOOD Book that I can read, to get a GOOD understanding of SQL SERVER 2005.
View 7 Replies
View Related
May 24, 2007
Dear all
Please can u suggest a good reference book available to study report server..
Regards
Polachan
View 3 Replies
View Related
Feb 19, 2008
Hi,
Could anyone recommend a good book on the SQL-Server, please? I need to understand how to retrieve data with select statements and commands. It is urgent!
TIA
View 1 Replies
View Related
May 28, 1999
I am looking for a set of books that realy cover the SQL
7.0 cert exams. Do you have any comments on the
following and or any suggestions.
Microsoft Sql Server 7.0 System Administration Training Kit
Microsoft Sql Server 7.0 Database Implementation Training Kit
Thank You,
Andy Robbins
Sr. Dba at Aurora Loan Services
View 3 Replies
View Related
Jan 8, 2007
Dear all,
Can you please help me to get Inside SQL Server 2005 e-book.
Where i can download this book?
Regards
Magesh
View 4 Replies
View Related
Jul 20, 2005
Greetings All, I would be much obliged if anyone can point me to agood book on Java/JDBC and SQL Server.Regards, Louis.
View 1 Replies
View Related
Jul 26, 2005
hi,are there any good books or tutorials anyone can recommend to someone who wants to get more into stored proc in sql server? i'm already good with sql, use it everyday at work, but want to start learning more about stored proc, know just a little, how to write simple ones to retrieve and insert/update, but want to get more into them. a book for beginners to advanced, thanks.
View 2 Replies
View Related
Aug 24, 2006
Can someone recommend a good book for a beginner to learn MSFT SQL SEVER 2000 ? Thank you. lar
View 2 Replies
View Related
Mar 7, 2006
i am new to sql. plz let me know from where can i get free book to study sql server 2000.
View 3 Replies
View Related
Aug 7, 2007
Hello,
I am new to SQL and in need to find a good book to learn.
I am from a small town in Canada and dont have access to local book store. I will need to order a teach yourself book on SQL server 2005 express edition.
Is there a book that is specially tailor for this with example from C# .NET instead of VB.NET?
Thanks
View 1 Replies
View Related
Aug 26, 2007
Hello everyone ,
I am looking for an useful sql server 2005 performance tuning book. i have been searching for a real nice book as i m going to start my job from next month in a financial domain with one of the requirement as sql server 2005 performance tuning.so i m looking forward a book which can help me doing well at my workplace. Any suggestions and links appreciated in advance .
View 1 Replies
View Related
Oct 24, 2007
Hi all,
Is this book still the only book written for SQL2005's data mining? Does anyone know where I can find its errata? I have never seen so many editorial errors (typos, mislabeling, etc.) in other books. I am not worried about those obvious errors, but I am afraid that some errors may be so deceiving that when I find out, a lot of time will have been spent on misguided effort.
View 4 Replies
View Related
Mar 5, 2001
Hello,
I have been using Access for quite some time now, and am very comfortable with it. I would like to take the next step though, and start working with SQL server.
What do I need to begin? Windows NT? Which version of SQL? enterprise or professional? (I noticed it's very expensive) Any other things I need to know before I begin?
Thank you,
Carrie
View 1 Replies
View Related
Jan 10, 2007
I'm pretty new at Mdx , so bare with me. I want to make a calculated member called Occupant Fatalities.
The occupant fatalities looks like this right now:
( [Measures].[Fatalities] , [Crash Person].[Person Type].&[Driver])
Now the question is , How do i add another person type to this calculated member. It wont work when i do this.
( [Measures].[Fatalities] , [Crash Person].[Person Type].&[Driver].&[Passenger])
whats the code for having more then one member from a hierachy? or having 2 members from different hierarchies?
any help is appreciated.
View 1 Replies
View Related
Mar 2, 2006
I purchased SQL Server 2005 and intend to take a class this month. I have installed it. How do I get started trying it out? I took an online tutorial, but I don't understand the mechanics of accessing the db to start with or if I even have a db to work with. Any suggestions?
View 1 Replies
View Related
Aug 2, 2007
Hello, I would like to be able to construct a small SQL data base with Visual Basic.Net code for practice. I want to be able to add to the data base, subtract from the data base, perform all Sql procedures ( Select, delete, etc.) I would also like to include the ExecuteNonQuery, ExecuteScalar, and ExecuteReader methods. Can anybody out there recommend a good tutorial for me? Thank you so much. MarcAbelson_2000@yahoo.com
View 1 Replies
View Related
Jul 23, 2005
How to learn sql from beginning?I would like to learn sql but don't have a clue.can you help me?where would I start?
View 1 Replies
View Related
Oct 10, 2006
Hi everyone,
I want to set a database which will be made of two parts:
- One main set of files which is shared among users
- Another set of files which is proper to each users and will be mainly used for processing infos.
Because I must support Windows 2000 and XP as O/S platforms, I can't use SQL Everywhere. It seems that I'm stuck with SQL Express. My questions are the following:
- Can SQL Express manage database files with variable namepath?
- How can I configure SQL Express so that such a file may reside on a dynamically configurable path, I mean, which would be configured by application?
Many thanks in advance for your help,
Stéphane
View 12 Replies
View Related
Aug 7, 2004
I have a table .. has 3 fields.. first is ID (Autoincrement) the other two are texts like
ID | Text1 |Text2
1 |aaa |aaa2
2 |bbb |bbb2
3 |ccc |ccc2
etc..
now there is a change in my requrement I need to add 4 more rows at the beginning like.
ID | Text1 | Tex2
1 |xxx |xxx2
2 |yyy |yyy2
.,
.
5 |aaa |aaa2
6 |bbb |bbb2
How can I add rows in the beginning by auto adjusting the ID colum.
I'm using the enterptice manager to do this>.
HELP!
View 1 Replies
View Related
Oct 30, 2006
Hello, I would love to know where people are discussing the book Microsoft SQL Server 2005 Integration Services book by Kirk Hasleden.
I'm on page 41 and I'm getting an error with the example in the "SELECT "2004" FROM Sales.vSalesPersonSalesByFiscalYears"
part because there is not a table called Sales.vSalesPersonSalesByFiscalYears in the AdventureWorks database.
Thank youo
View 3 Replies
View Related
Nov 23, 1999
We are currently trying to install SQL Server 7 Enterprise edition using MS SELECT CDs. The install wizard stops at the beginning telling us that the used CD can only be used to install SQL Server clients with this computer although we used exactly this CD-ROM to install all other SQL Servers, too.
Did anybody have the same problem and knows what the reason for the abortion is?
Thanks
Axel
View 2 Replies
View Related
Dec 14, 2005
Some of my records starts with a double quote, when I do a search for all records starting with A I can get all except the ones that start "A fine day ...
View 4 Replies
View Related
Jul 23, 2005
Hello,I have a query that I would like to schedule in DTS. The criteria ofthis query checks for records in the table that are within the currentquarter. Here is what I have.WHERE submit_date BETWEEN '01/01/2005' AND '03/31/2005'I would like to dynamically generate the Quarter End and QuarterBeginning dates within my where clause based on the date that DTWSpackage is being executed on. Can anyone show me how this can beaccomplished?Thank You.
View 3 Replies
View Related
Feb 14, 2006
Hi all, I have never used SSIS before, but am looking to use it in this aspect:
1) A user uploads an Excel file into Sharepoint. This will be through a Document Library in a Sharepoint page.
2) When this file is uploaded, I'd like SSIS to notice there is a new file and process it - it will pull information from the Excel file, put it into a database, and - if this is possible - delete the new file.
3) This is iffy. Can SSIS then generate an InfoPath document from the information stored in the database? If not, I can just have a InfoPath query form.
I'd just like to know if this is possible. If you have any helpful links, please let me know - I would greatly appreciate it!
Thanks,
James
View 8 Replies
View Related
Nov 19, 2007
Hi, My package hangs and the log says DTS.Pipeline: Validation phase is beginning. Any ideas why this is happennig? This same package runs fine when I run it without turning on the transaction.
View 4 Replies
View Related