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
how good are certmagic.com to prepare
for ccna and mcse exams . i have a long
learning ahead to do and will realy like
some practice questions to practice
myself . anyone have any idea about certmagic
exams , plz let me know
Hello,
I have a SQL 2005 test system set up that I need to test with protocol encryption, and had in mind to peform this test using a self-signed SSL certificate. I have read the guides and requirements from MS as well as the few blogs I could find on the subject and I've *almost* gotten it to work, but I'm failing at what seems to be the last step - getting clients to connect.. Here is what I've done:
-Created a self-signed certificate (I've tried using SSL Diagnostics from the IIS Diagnostics package, makecert.exe from .NET SDK, and OpenSSL) with the 'Server Authentication' purpose, with a CN that matches the server name, along with a private key. I've imported the cert in the local computer's personal store (also in LC's Trusted Root).
-SQL Server Configuration Manager sees the certificate and allows selecting it in the configuration. I've done this and selected 'Force Encryption' in the protocol settings.
-Restarted SQL Server, errorlog says 'The certificate was sucessfully loaded for encryption'.
-Tried connecting locally using SSMS and setting encryption: No problem.
-Exported the cert from the store and imported it into the LC's Trusted Root store on the client comp.
Here's where the problems begin.
1: Client is still apparently able to connect *unencrypted* to the SQL Server (I tested with SSMS on the client machine, it states under connection properties that the conn is not encrypted)
2: When trying to connect encrypted, SSMS returns an error during the pre-login handshake saying "The certificate's CN name does not match the passed value." When using the same cert in IIS there are no problems whatsoever, and the CN in the cert does indeed match the server name so I'm thinking the real error is hiding beneath the one that is thrown.
Also tried to configure the SQL Client Network Utility to force encryption from the client side, but this didn't seem to have any effect. I tried to use Network Monitor to capture network traffic, but since it appears to be encrypted (SQL encrypts login handshake anyway afaik) I couldn't get much out of it.. Does anyone have any tips?
When sql 2005 is created a cert is also created in the Data directory of that instance. What is that cert? Is it the Service Master Key? I noticed that I can movecopydelete it while sql server is running so it doesn't appear to be very secure..
TIA,
Barkingdog
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
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?
Greetings:I would like to ask for recommendations for a good beginning book onSQL Server. My web host offers a 100MB SQL Server database as part ofthe package, and I'd like to use the feature to learn.I am proficient in Access and familiar with basic connectivity to itvia ASP. I don't have my own license for SQL Server (and currentlycan't afford one) so all development will need to be done byinterfacing with the remote database. As such, I won't need a lot ofexplanation regarding installation and software setup.Does anyone here know of a good study resource for someone in thisscenario?Many thanks in advance,Kay
View 5 Replies View Related
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.
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.
Dear all
Please can u suggest a good reference book available to study report server..
Regards
Polachan
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
Dear all,
Can you please help me to get Inside SQL Server 2005 e-book.
Where i can download this book?
Regards
Magesh
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 Relatedhi,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 RelatedCan someone recommend a good book for a beginner to learn MSFT SQL SEVER 2000 ? Thank you. lar
View 2 Replies View Relatedi am new to sql. plz let me know from where can i get free book to study sql server 2000.
View 3 Replies View RelatedHello,
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
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 .
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.
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
What up-to-date books on this topic can people here recommend? Thanks.- Bob
View 1 Replies View RelatedI am attempting to create the "Classification - Children at Home" Data Mining Model as described in Larson's book.
Each time that I create it.. ONLY the ALL LEVEL is shown and it is impossible to expand the model to look at the Decision Tree, Neural Network, or the Clustering model etc. Drill down is enabled (tried it with and without enabling the drill down).
The Children at Home field has been populated with values from 0 - 4.
Any ideas would be greatly appreciated.
regards Steve
I am attempting to create the "Classification - Children at Home" Data Mining Model as described in Larson's book.
Each time that I create it.. ONLY the ALL LEVEL is shown and it is impossible to expand the model to look at the Decision Tree, Neural Network, or the Clustering model etc. Drill down is enabled (tried it with and without enabling the drill down).
The Children at Home field has been populated with values from 0 - 4.
Any ideas would be greatly appreciated.
regards Steve
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
Can anyone recommend a good book on DTS?
View 1 Replies View RelatedFor 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
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 RelatedI 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
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.
View 2 Replies View RelatedHi
Which is the best book to refer for SQL Server 2005
thanks
Hi to all, I ask to everybody which is the best book of the MS SQl Server 2000.I search in particulary a book complete and advanced.ThanksAlex Palermo
View 6 Replies View RelatedIt seems that there are only two books on SSIS
The Rational Guide to Scripting SQL Server 2005 - BETA preview
Professional SQL Server 2005 Integration Services by wrox
Has anyone read these or any other ones out there?
Any thoughts on which to get?
I am very new to SSIS.
Thanks
Hi,
Can you recommend a book on SSIS.
I am particularly interested in books which demonstrate a particular project from start to finish while going through chapters.
Thanks