New to SQL server

Hi I am new to SQL Server and have a few general
questions.
1. Can anyone suggest a good book to learn how ti use SQL
Server... I am proficient with relational databases and
SQL (Not transact)
2. I would like to create a database using SQL server as
the backend and Access as the front end. If I house all
of my Queries in the Access front end and simply join the
tables to my SQL Server tables will I still be able to
take adavantage of the improvements in processing speed
and size of the SQL Server database or will I need to
change all of my Access queries to SQL views to be able to
do this?
Thanks for your help,
ChadTo get a good understanding of all aspects of SQL Server, try "Teach
yourself Microsoft SQL Server 2000 in 21 days".
For a deeper understanding of SQL Server architecture, go for "Inside
Microsoft SQL Server 2000":
http://vyaskn.tripod.com/inside_microsoft_sql_server_2000.htm
Links to these books and others are available at:
http://vyaskn.tripod.com/sqlbooks.htm
Regarding your other question, if your data is stored in SQL Server, and
accessed via queries from Access, you should be able to take advantage of
SQL Servers speed and robustness.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Chad" <ChadLucy@.msn.com> wrote in message
news:021501c38dca$91af4980$a401280a@.phx.gbl...
Hi I am new to SQL Server and have a few general
questions.
1. Can anyone suggest a good book to learn how ti use SQL
Server... I am proficient with relational databases and
SQL (Not transact)
2. I would like to create a database using SQL server as
the backend and Access as the front end. If I house all
of my Queries in the Access front end and simply join the
tables to my SQL Server tables will I still be able to
take adavantage of the improvements in processing speed
and size of the SQL Server database or will I need to
change all of my Access queries to SQL views to be able to
do this?
Thanks for your help,
Chad|||To get the best throughput from MSAccess you need to set up the MSAccess
project correctly as a SQL Server project. If you use the older project
style and "attached" tables, JET is used behind the scenes and performance
will be much worse. (I did MSAccess work a long time ago, and when they
introduced SQL projects it was a very new concept. Perhaps my advice today
is already common knowedge.) Anyway, the new style projects pass SQL
commands directly to SQL Server, and you can access database views as well
as base tables. I believe there is even a way to "wire up" the MSAccess
forms so that insert/update/delete commands can call stored procedures on
the server; a huge feature.
James|||Hello,
I have found two books to be extremely helpful -
particularly with Transact Sql:
-SQL Server 2k Stored Procedure Programming (Sunderic &
Woodhead)
-Adv T-SQL for SQL Server 2k (Ben-Gan and Moreau)
>--Original Message--
>Hi I am new to SQL Server and have a few general
>questions.
>1. Can anyone suggest a good book to learn how ti use
SQL
>Server... I am proficient with relational databases and
>SQL (Not transact)
>2. I would like to create a database using SQL server as
>the backend and Access as the front end. If I house all
>of my Queries in the Access front end and simply join the
>tables to my SQL Server tables will I still be able to
>take adavantage of the improvements in processing speed
>and size of the SQL Server database or will I need to
>change all of my Access queries to SQL views to be able
to
>do this?
>Thanks for your help,
>Chad
>.
>sql

New to SQL but want's to learn!

Hi,

I was wandering if anyone could please recommend a good book to learn the basics of SQL 2000? I have made connections etc to a sql db through Visual Studio but would really like to read up on the subject and get a complete grounding on the subject. And also prepare me for the exam 70-229.

Many thanks,
James

Hi

If you need to learn the exam for SQL, you are best buying the Microsoft suite of books for that exam but I can tell you this, it is not easy AT ALL.

To learn SQL, its best looked at examples, reading books again and trial and error.

C-sharp corner website is a good place, but also posting here is a good idea too and I am sure many people will help you out.

There is alot of ground to cover, so start with the basics and move on upwards.

New to MS SQL Server, Need help with Windows Authentication

I am new to the whole ASP .NET scene, so my knowledge is very limited, and if I’m not clear enough please let me know.

I am reading a book published by APress about ASP .NET with C# and I am at the point where I get to begin working with data (fun!!). The problem is that I’m not able to connect to the SQL Server. I have Server 2003 and SQL Server 2005 running on a separate machine than the computer that I use for development – the server is named THESERVER, the SQL server is named THESQLSERVER, and the computer I use for development is my laptop named MYLAPTOP.

So here’s my connection string (I put this in my web.config XML file):

<add name="Pubs" connectionString="DataSource=THESERVER\THESQLSERVER;
 Initial Catalog=pubs;Integrated Securit=SSPI"/> 

Now here’s what my book reads: For Windows authentication to work, the currently logged-on Windows user must have the required authorization to access the SQL database. This is all it says about Windows authentication because the book assumes that I am running MS SQL Express off localhost.

Questions:

Does the book mean that I will have to add a user to my server for my laptop? If so, how do I log into this user using the connection string?What does it mean by “the current logged-on Windows user”? Is that referring to the user on my laptop, or a user on the server?

I’ve been reading around trying to find more information on exactly how Windows authentication works, but I keep coming up dry. I know that much of this is probably trivial to a lot of you, which is why I am asking because it isn’t to me.

Well, thanks in advance for any help that you can provide me.

<add name="Pubs" connectionString="DataSource=192.168.1.56;
 userid=sa; password=mypassword"/> 

In the connecting string you need to specify an ip address a user name and password if the SQL

runs in another computer, if you got integrated windows authentication is another story, but I would try with SQL authentication

|||

Thanks for the response.

I know that I can do itthis way - using SQL authentication instead - but I was hoping thatthey may be some way of doing it through the Integrated WindowsAuthentication method. The only reason why I want to do it thisway is because of the claim that it is much more secure this way. If anyone can say otherwise and prove that it isn't that much moresecure, that is relatively the same, please tell me :D. That isthe only reason that is holding me back from using th SQLauthentication approach.

Thanks again for the quick response, I really appreciate it.

|||Anyone else with suggestions/solutions?|||Actually setting it to InProc, or ServerState is as secure as SQL Sessin State|||Setting which, MS SQL Server? How do I do that?

New SQL-NS 2005 Book

Folks,

I want to let everyone know that the 2005 update to my Notification Services book is now available for order. You can get it from http://www.amazon.com/gp/product/0672327791/.

This book has been completely updated for the 2005 release:

- All source code examples are now designed to work with the 2005 programming model and tools

- New chapters have been added to cover the new 2005 features (such as the NMO API, Hostable Execution Engine, and User-Defined Matching Logic)

I hope you find this useful. As always, I appreciate receiving any feedback you may have.

Thanks

-shyam

Hi Shyam,

I bought your book, and it's really good book which can tell me more detail.

Right now I met a problem when I was testing SMTP delivery channel in chapter 10. with local smtp service, the musicStore worked as expected, but if I changed to use another computer in the same domain, nothing happened. Checking the application event view, it said:

Notification Class Name: NewSong

Notification Status Info: The e-mail address or SMTP server value is not valid.

SMTP Server: 192.168.1.128

Message Recipients: emily@.work.com

I have tried other setting for SMTPServer in InstanceConfiguration.xml, like "\\myServer", "myServer.myDomain" and "myServer.myDomain.local", but all got the same result. I have checked online book and some forum, but nothing helpful. Could you help it out? Thanks in advance.

Regards,

Chris

|||

HI shyam,

Just got the book this week and im finding it very useful and helpful. The std MSDN examples are very short on documentation. I dont seem to have one issue though, Im currently going through chapter 6 and am finding that the scheduled subscriptions for the Music Store sample are not working.

Working through the database i can see that my NewSongByGenreSubscriptionProcessingTimes table is not being filled in. I looked a little deeper into the SQl statements and ran this

SELECT subscriptions.SubscriptionId, subscriptions.Created
FROM [SongAlerts].[NewSongByGenre] subscriptions

This unfortunately returns nothing, which looks to be the problem as my chronicle always stays empty. I've used your tool to add the scheduled subscriptions and unfortunately that does seem to work, its adding subscriptions, so i cant understand why the query above doesnt fire.

A little deeper and i see the two tables NSCurrentNewSongByGenreSubscriptions and NSFiringNewSongByGenreInterval are empty? dont really know what they do.

Dont suppose you can test and confirm that Chapter 6 does work correctly. I've been over it 3 times and am about to get a work mate to try on their machine, but so far no luck.

Aside from that little niggle, its an excellent book, the chapter on Custom Delivery Channels was worth it alone. :)

|||

For those who consider buying this book to prepare for their new project on SQL Server Notification Services, here's what I have to say:

1. I bought the author's previous book (on SQL NS 2.0 - for SQL Server 2000). Before I got it, I had only a very dim idea about what NS is and what it can do.

2. Two weeks later, I had a fully functional prototype of my application. It had only a subset of the real huge project's functionality (the project is truly HUGE!..), including a custom content formatter and a custom event provider. But it worked, and we are now just extending it. I mean, no need to refactor the code or start from scratch. Well, to tell you the truth, in those 2 weeks I worked quite a bit more than 8 hours a day, but it was worth it. My boss is still trying to throw some tricky questions on me (like, "What happens with our application IF..."), and there have been no questions so far that I was unable to answer. The book is just great!

3. My advice to you: work through all the samples (at least, in the first half of the book, or until you get a clear idea on how all the pieces of NS fit together). It's not nearly as bad as it sounds: the explanations and step-by-step instructions on how to do every little thing are so good that even a complete moron would be able to get it (and none of us are morons... I think... ;-)

4. I usually buy technical books only when I need to get up to speed with a particular technology as fast as possible. Shyam Pather's book exceeded all my expectations. The book reads as easily as my favorite science fiction books (and way easier than "The Lord of the Rings"). And almost as interesting as they are.

New SQL-NS 2005 Book

Folks,

I want to let everyone know that the 2005 update to my Notification Services book is now available for order. You can get it from http://www.amazon.com/gp/product/0672327791/.

This book has been completely updated for the 2005 release:

- All source code examples are now designed to work with the 2005 programming model and tools

- New chapters have been added to cover the new 2005 features (such as the NMO API, Hostable Execution Engine, and User-Defined Matching Logic)

I hope you find this useful. As always, I appreciate receiving any feedback you may have.

Thanks

-shyam

Hi Shyam,

I bought your book, and it's really good book which can tell me more detail.

Right now I met a problem when I was testing SMTP delivery channel in chapter 10. with local smtp service, the musicStore worked as expected, but if I changed to use another computer in the same domain, nothing happened. Checking the application event view, it said:

Notification Class Name: NewSong

Notification Status Info: The e-mail address or SMTP server value is not valid.

SMTP Server: 192.168.1.128

Message Recipients: emily@.work.com

I have tried other setting for SMTPServer in InstanceConfiguration.xml, like "\\myServer", "myServer.myDomain" and "myServer.myDomain.local", but all got the same result. I have checked online book and some forum, but nothing helpful. Could you help it out? Thanks in advance.

Regards,

Chris

|||

HI shyam,

Just got the book this week and im finding it very useful and helpful. The std MSDN examples are very short on documentation. I dont seem to have one issue though, Im currently going through chapter 6 and am finding that the scheduled subscriptions for the Music Store sample are not working.

Working through the database i can see that my NewSongByGenreSubscriptionProcessingTimes table is not being filled in. I looked a little deeper into the SQl statements and ran this

SELECT subscriptions.SubscriptionId, subscriptions.Created
FROM [SongAlerts].[NewSongByGenre] subscriptions

This unfortunately returns nothing, which looks to be the problem as my chronicle always stays empty. I've used your tool to add the scheduled subscriptions and unfortunately that does seem to work, its adding subscriptions, so i cant understand why the query above doesnt fire.

A little deeper and i see the two tables NSCurrentNewSongByGenreSubscriptions and NSFiringNewSongByGenreInterval are empty? dont really know what they do.

Dont suppose you can test and confirm that Chapter 6 does work correctly. I've been over it 3 times and am about to get a work mate to try on their machine, but so far no luck.

Aside from that little niggle, its an excellent book, the chapter on Custom Delivery Channels was worth it alone. :)

|||

For those who consider buying this book to prepare for their new project on SQL Server Notification Services, here's what I have to say:

1. I bought the author's previous book (on SQL NS 2.0 - for SQL Server 2000). Before I got it, I had only a very dim idea about what NS is and what it can do.

2. Two weeks later, I had a fully functional prototype of my application. It had only a subset of the real huge project's functionality (the project is truly HUGE!..), including a custom content formatter and a custom event provider. But it worked, and we are now just extending it. I mean, no need to refactor the code or start from scratch. Well, to tell you the truth, in those 2 weeks I worked quite a bit more than 8 hours a day, but it was worth it. My boss is still trying to throw some tricky questions on me (like, "What happens with our application IF..."), and there have been no questions so far that I was unable to answer. The book is just great!

3. My advice to you: work through all the samples (at least, in the first half of the book, or until you get a clear idea on how all the pieces of NS fit together). It's not nearly as bad as it sounds: the explanations and step-by-step instructions on how to do every little thing are so good that even a complete moron would be able to get it (and none of us are morons... I think... ;-)

4. I usually buy technical books only when I need to get up to speed with a particular technology as fast as possible. Shyam Pather's book exceeded all my expectations. The book reads as easily as my favorite science fiction books (and way easier than "The Lord of the Rings"). And almost as interesting as they are.

New SQL-NS 2005 Book

Folks,

I want to let everyone know that the 2005 update to my Notification Services book is now available for order. You can get it from http://www.amazon.com/gp/product/0672327791/.

This book has been completely updated for the 2005 release:

- All source code examples are now designed to work with the 2005 programming model and tools

- New chapters have been added to cover the new 2005 features (such as the NMO API, Hostable Execution Engine, and User-Defined Matching Logic)

I hope you find this useful. As always, I appreciate receiving any feedback you may have.

Thanks

-shyam

Hi Shyam,

I bought your book, and it's really good book which can tell me more detail.

Right now I met a problem when I was testing SMTP delivery channel in chapter 10. with local smtp service, the musicStore worked as expected, but if I changed to use another computer in the same domain, nothing happened. Checking the application event view, it said:

Notification Class Name: NewSong

Notification Status Info: The e-mail address or SMTP server value is not valid.

SMTP Server: 192.168.1.128

Message Recipients: emily@.work.com

I have tried other setting for SMTPServer in InstanceConfiguration.xml, like "\\myServer", "myServer.myDomain" and "myServer.myDomain.local", but all got the same result. I have checked online book and some forum, but nothing helpful. Could you help it out? Thanks in advance.

Regards,

Chris

|||

HI shyam,

Just got the book this week and im finding it very useful and helpful. The std MSDN examples are very short on documentation. I dont seem to have one issue though, Im currently going through chapter 6 and am finding that the scheduled subscriptions for the Music Store sample are not working.

Working through the database i can see that my NewSongByGenreSubscriptionProcessingTimes table is not being filled in. I looked a little deeper into the SQl statements and ran this

SELECT subscriptions.SubscriptionId, subscriptions.Created
FROM [SongAlerts].[NewSongByGenre] subscriptions

This unfortunately returns nothing, which looks to be the problem as my chronicle always stays empty. I've used your tool to add the scheduled subscriptions and unfortunately that does seem to work, its adding subscriptions, so i cant understand why the query above doesnt fire.

A little deeper and i see the two tables NSCurrentNewSongByGenreSubscriptions and NSFiringNewSongByGenreInterval are empty? dont really know what they do.

Dont suppose you can test and confirm that Chapter 6 does work correctly. I've been over it 3 times and am about to get a work mate to try on their machine, but so far no luck.

Aside from that little niggle, its an excellent book, the chapter on Custom Delivery Channels was worth it alone. :)

|||

For those who consider buying this book to prepare for their new project on SQL Server Notification Services, here's what I have to say:

1. I bought the author's previous book (on SQL NS 2.0 - for SQL Server 2000). Before I got it, I had only a very dim idea about what NS is and what it can do.

2. Two weeks later, I had a fully functional prototype of my application. It had only a subset of the real huge project's functionality (the project is truly HUGE!..), including a custom content formatter and a custom event provider. But it worked, and we are now just extending it. I mean, no need to refactor the code or start from scratch. Well, to tell you the truth, in those 2 weeks I worked quite a bit more than 8 hours a day, but it was worth it. My boss is still trying to throw some tricky questions on me (like, "What happens with our application IF..."), and there have been no questions so far that I was unable to answer. The book is just great!

3. My advice to you: work through all the samples (at least, in the first half of the book, or until you get a clear idea on how all the pieces of NS fit together). It's not nearly as bad as it sounds: the explanations and step-by-step instructions on how to do every little thing are so good that even a complete moron would be able to get it (and none of us are morons... I think... ;-)

4. I usually buy technical books only when I need to get up to speed with a particular technology as fast as possible. Shyam Pather's book exceeded all my expectations. The book reads as easily as my favorite science fiction books (and way easier than "The Lord of the Rings"). And almost as interesting as they are.

New SQL-NS 2005 Book

Folks,

I want to let everyone know that the 2005 update to my Notification Services book is now available for order. You can get it from http://www.amazon.com/gp/product/0672327791/.

This book has been completely updated for the 2005 release:

- All source code examples are now designed to work with the 2005 programming model and tools

- New chapters have been added to cover the new 2005 features (such as the NMO API, Hostable Execution Engine, and User-Defined Matching Logic)

I hope you find this useful. As always, I appreciate receiving any feedback you may have.

Thanks

-shyam

Hi Shyam,

I bought your book, and it's really good book which can tell me more detail.

Right now I met a problem when I was testing SMTP delivery channel in chapter 10. with local smtp service, the musicStore worked as expected, but if I changed to use another computer in the same domain, nothing happened. Checking the application event view, it said:

Notification Class Name: NewSong

Notification Status Info: The e-mail address or SMTP server value is not valid.

SMTP Server: 192.168.1.128

Message Recipients: emily@.work.com

I have tried other setting for SMTPServer in InstanceConfiguration.xml, like "\\myServer", "myServer.myDomain" and "myServer.myDomain.local", but all got the same result. I have checked online book and some forum, but nothing helpful. Could you help it out? Thanks in advance.

Regards,

Chris

|||

HI shyam,

Just got the book this week and im finding it very useful and helpful. The std MSDN examples are very short on documentation. I dont seem to have one issue though, Im currently going through chapter 6 and am finding that the scheduled subscriptions for the Music Store sample are not working.

Working through the database i can see that my NewSongByGenreSubscriptionProcessingTimes table is not being filled in. I looked a little deeper into the SQl statements and ran this

SELECT subscriptions.SubscriptionId, subscriptions.Created
FROM [SongAlerts].[NewSongByGenre] subscriptions

This unfortunately returns nothing, which looks to be the problem as my chronicle always stays empty. I've used your tool to add the scheduled subscriptions and unfortunately that does seem to work, its adding subscriptions, so i cant understand why the query above doesnt fire.

A little deeper and i see the two tables NSCurrentNewSongByGenreSubscriptions and NSFiringNewSongByGenreInterval are empty? dont really know what they do.

Dont suppose you can test and confirm that Chapter 6 does work correctly. I've been over it 3 times and am about to get a work mate to try on their machine, but so far no luck.

Aside from that little niggle, its an excellent book, the chapter on Custom Delivery Channels was worth it alone. :)

|||

For those who consider buying this book to prepare for their new project on SQL Server Notification Services, here's what I have to say:

1. I bought the author's previous book (on SQL NS 2.0 - for SQL Server 2000). Before I got it, I had only a very dim idea about what NS is and what it can do.

2. Two weeks later, I had a fully functional prototype of my application. It had only a subset of the real huge project's functionality (the project is truly HUGE!..), including a custom content formatter and a custom event provider. But it worked, and we are now just extending it. I mean, no need to refactor the code or start from scratch. Well, to tell you the truth, in those 2 weeks I worked quite a bit more than 8 hours a day, but it was worth it. My boss is still trying to throw some tricky questions on me (like, "What happens with our application IF..."), and there have been no questions so far that I was unable to answer. The book is just great!

3. My advice to you: work through all the samples (at least, in the first half of the book, or until you get a clear idea on how all the pieces of NS fit together). It's not nearly as bad as it sounds: the explanations and step-by-step instructions on how to do every little thing are so good that even a complete moron would be able to get it (and none of us are morons... I think... ;-)

4. I usually buy technical books only when I need to get up to speed with a particular technology as fast as possible. Shyam Pather's book exceeded all my expectations. The book reads as easily as my favorite science fiction books (and way easier than "The Lord of the Rings"). And almost as interesting as they are.

sql

New SQL Server User Questions

I have installed SQL Server 2005 Express. I am having trouble understanding
how to connect up with the AdventureWorksDB. Looking at the online book, I
found these instructions:
1) Open the command prompt on the server.
2) From the command prompt, connect to an instance of SQL Server by using
the following sqlcmd command:
sqlcmd -S Server\Instance
Where Server is the name of the computer and Instance is the name of the
instance.
These instructions assume you have some previous knowledge.
1) I am assuming that you are in the SQL Server Management Express Console.
2) How do you open the command prompt? Or where is it?
3) The "sqlcmd -S Server\Instance" instruction. I looked at the SQL Server
Service Manager and I believe I have the right information for my
installation: Server = NGT\SQLEXPRESS and Instance = SQL Server which came
from the Services:.
If this is not correct, what name do I use for the Server and Instance?
After I run this command, what will the results be and how will I know they
have run correctly?
I believe I can follow the remaining instructions if I can get past this part.
Thank you for your help.
Regards,
SailFL
You get a command prompt by going to Start->Run and typing CMD. From that,
you run SQLCMD. From what you have given us, try:
SQLCMD -S NGT\SQLEXPRESS
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"SailFL" <SailFL@.discussions.microsoft.com> wrote in message
news:28954F43-0CBC-42FC-B7BC-B14C3E67BC83@.microsoft.com...
I have installed SQL Server 2005 Express. I am having trouble understanding
how to connect up with the AdventureWorksDB. Looking at the online book, I
found these instructions:
1) Open the command prompt on the server.
2) From the command prompt, connect to an instance of SQL Server by using
the following sqlcmd command:
sqlcmd -S Server\Instance
Where Server is the name of the computer and Instance is the name of the
instance.
These instructions assume you have some previous knowledge.
1) I am assuming that you are in the SQL Server Management Express Console.
2) How do you open the command prompt? Or where is it?
3) The "sqlcmd -S Server\Instance" instruction. I looked at the SQL Server
Service Manager and I believe I have the right information for my
installation: Server = NGT\SQLEXPRESS and Instance = SQL Server which came
from the Services:.
If this is not correct, what name do I use for the Server and Instance?
After I run this command, what will the results be and how will I know they
have run correctly?
I believe I can follow the remaining instructions if I can get past this
part.
Thank you for your help.
Regards,
SailFL
|||SQLCMD can be issued from the commadn prompt of Windows, so
Start->Run->cmd
int he doscommand you can type in e.g.
sqlcmd.exe -S NGT\SQLEXPRESS -E
-Whereas NGT is the servername and SQLEXPRESS the instancename
-E if you are using Trusted authentication to connect to the database
server.
You can test the successfull connection therefore that you get no error
are issue a Select command to any table:
USE AdventureWorks
GO
SELECT * from Person.Contact
GO
--or simpler
SELECT 1
GO
HTH, jens Suessmeyer.
|||Thank both you for your assistance.
I was able to use the commands and to attach the AdventureWorks Database to
my SQL server.
SailFL
"Jens" wrote:

> SQLCMD can be issued from the commadn prompt of Windows, so
> Start->Run->cmd
> int he doscommand you can type in e.g.
> sqlcmd.exe -S NGT\SQLEXPRESS -E
> -Whereas NGT is the servername and SQLEXPRESS the instancename
> -E if you are using Trusted authentication to connect to the database
> server.
> You can test the successfull connection therefore that you get no error
> are issue a Select command to any table:
> USE AdventureWorks
> GO
> SELECT * from Person.Contact
> GO
> --or simpler
> SELECT 1
> GO
>
> HTH, jens Suessmeyer.
>

New SQL Server User Questions

I have installed SQL Server 2005 Express. I am having trouble understanding
how to connect up with the AdventureWorksDB. Looking at the online book, I
found these instructions:
1) Open the command prompt on the server.
2) From the command prompt, connect to an instance of SQL Server by using
the following sqlcmd command:
sqlcmd -S Server\Instance
Where Server is the name of the computer and Instance is the name of the
instance.
These instructions assume you have some previous knowledge.
1) I am assuming that you are in the SQL Server Management Express Console.
2) How do you open the command prompt? Or where is it?
3) The "sqlcmd -S Server\Instance" instruction. I looked at the SQL Server
Service Manager and I believe I have the right information for my
installation: Server = NGT\SQLEXPRESS and Instance = SQL Server which came
from the Services:.
If this is not correct, what name do I use for the Server and Instance?
After I run this command, what will the results be and how will I know they
have run correctly?
I believe I can follow the remaining instructions if I can get past this part.
Thank you for your help.
Regards,
--
SailFLYou get a command prompt by going to Start->Run and typing CMD. From that,
you run SQLCMD. From what you have given us, try:
SQLCMD -S NGT\SQLEXPRESS
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"SailFL" <SailFL@.discussions.microsoft.com> wrote in message
news:28954F43-0CBC-42FC-B7BC-B14C3E67BC83@.microsoft.com...
I have installed SQL Server 2005 Express. I am having trouble understanding
how to connect up with the AdventureWorksDB. Looking at the online book, I
found these instructions:
1) Open the command prompt on the server.
2) From the command prompt, connect to an instance of SQL Server by using
the following sqlcmd command:
sqlcmd -S Server\Instance
Where Server is the name of the computer and Instance is the name of the
instance.
These instructions assume you have some previous knowledge.
1) I am assuming that you are in the SQL Server Management Express Console.
2) How do you open the command prompt? Or where is it?
3) The "sqlcmd -S Server\Instance" instruction. I looked at the SQL Server
Service Manager and I believe I have the right information for my
installation: Server = NGT\SQLEXPRESS and Instance = SQL Server which came
from the Services:.
If this is not correct, what name do I use for the Server and Instance?
After I run this command, what will the results be and how will I know they
have run correctly?
I believe I can follow the remaining instructions if I can get past this
part.
Thank you for your help.
Regards,
SailFL|||SQLCMD can be issued from the commadn prompt of Windows, so
Start->Run->cmd
int he doscommand you can type in e.g.
sqlcmd.exe -S NGT\SQLEXPRESS -E
-Whereas NGT is the servername and SQLEXPRESS the instancename
-E if you are using Trusted authentication to connect to the database
server.
You can test the successfull connection therefore that you get no error
are issue a Select command to any table:
USE AdventureWorks
GO
SELECT * from Person.Contact
GO
--or simpler
SELECT 1
GO
HTH, jens Suessmeyer.|||Thank both you for your assistance.
I was able to use the commands and to attach the AdventureWorks Database to
my SQL server.
--
SailFL
"Jens" wrote:
> SQLCMD can be issued from the commadn prompt of Windows, so
> Start->Run->cmd
> int he doscommand you can type in e.g.
> sqlcmd.exe -S NGT\SQLEXPRESS -E
> -Whereas NGT is the servername and SQLEXPRESS the instancename
> -E if you are using Trusted authentication to connect to the database
> server.
> You can test the successfull connection therefore that you get no error
> are issue a Select command to any table:
> USE AdventureWorks
> GO
> SELECT * from Person.Contact
> GO
> --or simpler
> SELECT 1
> GO
>
> HTH, jens Suessmeyer.
>

New SQL Server User Questions

I have installed SQL Server 2005 Express. I am having trouble understanding
how to connect up with the AdventureWorksDB. Looking at the online book, I
found these instructions:
1) Open the command prompt on the server.
2) From the command prompt, connect to an instance of SQL Server by using
the following sqlcmd command:
sqlcmd -S Server\Instance
Where Server is the name of the computer and Instance is the name of the
instance.
These instructions assume you have some previous knowledge.
1) I am assuming that you are in the SQL Server Management Express Console.
2) How do you open the command prompt? Or where is it?
3) The "sqlcmd -S Server\Instance" instruction. I looked at the SQL Server
Service Manager and I believe I have the right information for my
installation: Server = NGT\SQLEXPRESS and Instance = SQL Server which came
from the Services:.
If this is not correct, what name do I use for the Server and Instance?
After I run this command, what will the results be and how will I know they
have run correctly?
I believe I can follow the remaining instructions if I can get past this par
t.
Thank you for your help.
Regards,
SailFLYou get a command prompt by going to Start->Run and typing CMD. From that,
you run SQLCMD. From what you have given us, try:
SQLCMD -S NGT\SQLEXPRESS
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"SailFL" <SailFL@.discussions.microsoft.com> wrote in message
news:28954F43-0CBC-42FC-B7BC-B14C3E67BC83@.microsoft.com...
I have installed SQL Server 2005 Express. I am having trouble understanding
how to connect up with the AdventureWorksDB. Looking at the online book, I
found these instructions:
1) Open the command prompt on the server.
2) From the command prompt, connect to an instance of SQL Server by using
the following sqlcmd command:
sqlcmd -S Server\Instance
Where Server is the name of the computer and Instance is the name of the
instance.
These instructions assume you have some previous knowledge.
1) I am assuming that you are in the SQL Server Management Express Console.
2) How do you open the command prompt? Or where is it?
3) The "sqlcmd -S Server\Instance" instruction. I looked at the SQL Server
Service Manager and I believe I have the right information for my
installation: Server = NGT\SQLEXPRESS and Instance = SQL Server which came
from the Services:.
If this is not correct, what name do I use for the Server and Instance?
After I run this command, what will the results be and how will I know they
have run correctly?
I believe I can follow the remaining instructions if I can get past this
part.
Thank you for your help.
Regards,
SailFL|||SQLCMD can be issued from the commadn prompt of Windows, so
Start->Run->cmd
int he doscommand you can type in e.g.
sqlcmd.exe -S NGT\SQLEXPRESS -E
-Whereas NGT is the servername and SQLEXPRESS the instancename
-E if you are using Trusted authentication to connect to the database
server.
You can test the successfull connection therefore that you get no error
are issue a Select command to any table:
USE AdventureWorks
GO
SELECT * from Person.Contact
GO
--or simpler
SELECT 1
GO
HTH, jens Suessmeyer.|||Thank both you for your assistance.
I was able to use the commands and to attach the AdventureWorks Database to
my SQL server.
SailFL
"Jens" wrote:

> SQLCMD can be issued from the commadn prompt of Windows, so
> Start->Run->cmd
> int he doscommand you can type in e.g.
> sqlcmd.exe -S NGT\SQLEXPRESS -E
> -Whereas NGT is the servername and SQLEXPRESS the instancename
> -E if you are using Trusted authentication to connect to the database
> server.
> You can test the successfull connection therefore that you get no error
> are issue a Select command to any table:
> USE AdventureWorks
> GO
> SELECT * from Person.Contact
> GO
> --or simpler
> SELECT 1
> GO
>
> HTH, jens Suessmeyer.
>

New SQL Book Scam or Not?

Has anyone heard of this book? I got this e-mail and the book looks good, but I'm afraid it's a scam because I can't find the book online anywhere else. I also can't locate this Beyond Books, Inc. See Email below:
FROM: "Microsoft Professional Learning Series" <msdev_book-offers@.in-the-trenches.com>"
Dear Microsoft Professional,
We would like to inform you that the book that you've been looking & waiting for is finally here!
This hot new book has the industry buzzing about its hardhitting & revealing content. It drives deep into issues no other industry guru or MVP has properly addressed and follows through with powerful solutions to them. Learn advanced & secret techniques u
sed by the pros "in the trenches" and get complete solutions & code that can literally save you thousands of hours of research, design, development, coding, and testing (not to mention all the frustration, headaches, hair pulling, forehead smacking, & oth
er pains from the process).
If you are a SQL Server developer, a .NET developer, or a Development Team Lead, an I.T. Manager or Project Manager for a software product built on .NET & SQL Server, you owe it to yourself to buy & read this book. The information that you’ll get will b
e priceless. Forget all those lame "bibles" out there. This book will be the prize of your library, the key book that will guide you in your decisions & provide you with hardhitting information.
From the author:
This new book truly reveals advanced & secret techniques of SQL Server & .NET professionals and provides complete & customizable solutions to real world problems. Face it, you don’t want to buy another developer’s book that turns out to be just anothe
r big reference manual. You also don’t want to go to yet another mindless or boring developer’s conference or seminar where you’ll end up wondering if you’ll ever use any of the stuff you’ve just “learned”. And those online discussion boards
can only help so much by pointing you in a certain direction, but fall short in providing you with a complete solution or the big picture. Believe me, as a professional developer, I’ve done all those things, and I know that you’ll find this book is t
he only learning resource available that GOES THE DISTANCE when it comes to discussing, solving, & providing these solutions. This book has over 600 pages of golden information, complete solutions, and valuable code you will not find anywhere else. You wi
ll even find sections that cover SQL Server or .NET issues or topics that have never been addressed or shared in any other developer resources or public media. You won’t find these techniques in any other book, developer seminar, or online resource anyw
here.
Click here to find out more about the contents of this hot new book:
<http://www.in-the-trenches.com/mssql.net/toc.asp>
In The Trenches I.T. Professional Learning Series -- "We Go The Distance"
Beyond Books, Inc.
Las Vegas, NV
<http://www.in-the-trenches.com>
************************************************** *******
To be taken off this list, simply reply to this email
************************************************** *******
"atchleykl" <atchleykl@.discussions.microsoft.com> wrote in message
news:109CDD33-5CF3-47C5-8E61-1A8AE3626852@.microsoft.com...
> Has anyone heard of this book? I got this e-mail and the book looks good,
but I'm afraid it's a scam because I can't
> find the book online anywhere else. I also can't locate this Beyond
Books, Inc. See Email below:
The fact that no author is listed scares me, personally. No one wanted
to put their name on it? Information that "no one else has"? Please...
|||"secret techniques", "golden information", "revealing content"
(I see why they are based in Las Vegas ;-))
and that all in 600 pages...
Jacco Schalkwijk
SQL Server MVP
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uyHxkRdZEHA.3012@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> "atchleykl" <atchleykl@.discussions.microsoft.com> wrote in message
> news:109CDD33-5CF3-47C5-8E61-1A8AE3626852@.microsoft.com...
good,
> but I'm afraid it's a scam because I can't
> Books, Inc. See Email below:
> The fact that no author is listed scares me, personally. No one
wanted
> to put their name on it? Information that "no one else has"? Please...
>
|||Personally, I wouldn't even consider a book marketed via spam.
Hope this helps.
Dan Guzman
SQL Server MVP
"atchleykl" <atchleykl@.discussions.microsoft.com> wrote in message
news:109CDD33-5CF3-47C5-8E61-1A8AE3626852@.microsoft.com...
> Has anyone heard of this book? I got this e-mail and the book looks good,
but I'm afraid it's a scam because I can't find the book online anywhere
else. I also can't locate this Beyond Books, Inc. See Email below:
> FROM: "Microsoft Professional Learning Series"
<msdev_book-offers@.in-the-trenches.com>"
> Dear Microsoft Professional,
> We would like to inform you that the book that you've been looking &
waiting for is finally here!
> This hot new book has the industry buzzing about its hardhitting &
revealing content. It drives deep into issues no other industry guru or MVP
has properly addressed and follows through with powerful solutions to them.
Learn advanced & secret techniques used by the pros "in the trenches" and
get complete solutions & code that can literally save you thousands of hours
of research, design, development, coding, and testing (not to mention all
the frustration, headaches, hair pulling, forehead smacking, & other pains
from the process).
> If you are a SQL Server developer, a .NET developer, or a Development Team
Lead, an I.T. Manager or Project Manager for a software product built on
..NET & SQL Server, you owe it to yourself to buy & read this book. The
information that you'll get will be priceless. Forget all those lame
"bibles" out there. This book will be the prize of your library, the key
book that will guide you in your decisions & provide you with hardhitting
information.
> From the author:
> This new book truly reveals advanced & secret techniques of SQL Server &
..NET professionals and provides complete & customizable solutions to real
world problems. Face it, you don't want to buy another developer's book that
turns out to be just another big reference manual. You also don't want to go
to yet another mindless or boring developer's conference or seminar where
you'll end up wondering if you'll ever use any of the stuff you've just
"learned". And those online discussion boards can only help so much by
pointing you in a certain direction, but fall short in providing you with a
complete solution or the big picture. Believe me, as a professional
developer, I've done all those things, and I know that you'll find this book
is the only learning resource available that GOES THE DISTANCE when it comes
to discussing, solving, & providing these solutions. This book has over 600
pages of golden information, complete solutions, and valuable code you will
not find anywhere else. You will even find sections that cover SQL Server or
..NET issues or topics that have never been addressed or shared in any other
developer resources or public media. You won't find these techniques in any
other book, developer seminar, or online resource anywhere.
> Click here to find out more about the contents of this hot new book:
> <http://www.in-the-trenches.com/mssql.net/toc.asp>
> In The Trenches I.T. Professional Learning Series -- "We Go The Distance"
> Beyond Books, Inc.
> Las Vegas, NV
> <http://www.in-the-trenches.com>
> ************************************************** *******
> To be taken off this list, simply reply to this email
> ************************************************** *******
>
|||Or a book where the Author does not even put his/her/their names to it and
they claim to be experts.
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
Specialist SQL Server Solutions and Consulting
MVP Program: http://www.microsoft.com/mvp
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:eL$VnroZEHA.228@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Personally, I wouldn't even consider a book marketed via spam.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "atchleykl" <atchleykl@.discussions.microsoft.com> wrote in message
> news:109CDD33-5CF3-47C5-8E61-1A8AE3626852@.microsoft.com...
good,
> but I'm afraid it's a scam because I can't find the book online anywhere
> else. I also can't locate this Beyond Books, Inc. See Email below:
> <msdev_book-offers@.in-the-trenches.com>"
> waiting for is finally here!
> revealing content. It drives deep into issues no other industry guru or
MVP
> has properly addressed and follows through with powerful solutions to
them.
> Learn advanced & secret techniques used by the pros "in the trenches" and
> get complete solutions & code that can literally save you thousands of
hours[vbcol=seagreen]
> of research, design, development, coding, and testing (not to mention all
> the frustration, headaches, hair pulling, forehead smacking, & other pains
> from the process).
Team
> Lead, an I.T. Manager or Project Manager for a software product built on
> .NET & SQL Server, you owe it to yourself to buy & read this book. The
> information that you'll get will be priceless. Forget all those lame
> "bibles" out there. This book will be the prize of your library, the key
> book that will guide you in your decisions & provide you with hardhitting
> information.
> .NET professionals and provides complete & customizable solutions to real
> world problems. Face it, you don't want to buy another developer's book
that
> turns out to be just another big reference manual. You also don't want to
go
> to yet another mindless or boring developer's conference or seminar where
> you'll end up wondering if you'll ever use any of the stuff you've just
> "learned". And those online discussion boards can only help so much by
> pointing you in a certain direction, but fall short in providing you with
a
> complete solution or the big picture. Believe me, as a professional
> developer, I've done all those things, and I know that you'll find this
book
> is the only learning resource available that GOES THE DISTANCE when it
comes
> to discussing, solving, & providing these solutions. This book has over
600
> pages of golden information, complete solutions, and valuable code you
will
> not find anywhere else. You will even find sections that cover SQL Server
or
> .NET issues or topics that have never been addressed or shared in any
other
> developer resources or public media. You won't find these techniques in
any[vbcol=seagreen]
> other book, developer seminar, or online resource anywhere.
Distance"
>
|||Yep. Big red flag.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eTD4XPpZEHA.3420@.TK2MSFTNGP12.phx.gbl...
> Or a book where the Author does not even put his/her/their names to it and
> they claim to be experts.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Epprecht Consulting (PTY) LTD
> Johannesburg, South Africa
> Mobile: +27-82-552-0268
> IM: mike@.epprecht.net
> Specialist SQL Server Solutions and Consulting
> MVP Program: http://www.microsoft.com/mvp
>
|||You should look at the website, especially the description of the chapters
included in the book. Chapters include "Soft Skills" and a chapter on how
to get good performance reviews (e.g. the kind that gets you pay raises)...!
Since when is that a specific SQL or .Net skill? There's also a chapter on
Tools, which according to the website is just a list of software, the
website you can get it from, and a brief description...
All of that for the low, low (discounted!) cost of $130... And as it's a
600-page book, you know that the rest must be thoroughly jam-packed in order
to have all of the secrets for BOTH SQL Server *and* .Net, two topics which
I happen to have probably 15,000+ pages of books on, with not a whole lot of
overlap... So this person ("The Saint", according to the website) is either
the tersest writer in history or the font is 0.5-point and the book comes
with a special magnifying glass.
Definitely worth a chuckle, but you gotta respect someone who has the gall
to sell such obvious trash for such a high price...
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:uS3hatpZEHA.384@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Yep. Big red flag.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:eTD4XPpZEHA.3420@.TK2MSFTNGP12.phx.gbl...
and
>

New SQL Book Scam or Not?

Has anyone heard of this book? I got this e-mail and the book looks good, b
ut I'm afraid it's a scam because I can't find the book online anywhere else
. I also can't locate this Beyond Books, Inc. See Email below:
FROM: "Microsoft Professional Learning Series" <msdev_book-offers@.in-the-tre
nches.com>"
Dear Microsoft Professional,
We would like to inform you that the book that you've been looking & waiting
for is finally here!
This hot new book has the industry buzzing about its hardhitting & revealing
content. It drives deep into issues no other industry guru or MVP has prope
rly addressed and follows through with powerful solutions to them. Learn adv
anced & secret techniques u
sed by the pros "in the trenches" and get complete solutions & code that can
literally save you thousands of hours of research, design, development, cod
ing, and testing (not to mention all the frustration, headaches, hair pullin
g, forehead smacking, & oth
er pains from the process).
If you are a SQL Server developer, a .NET developer, or a Development Team L
ead, an I.T. Manager or Project Manager for a software product built on .NET
& SQL Server, you owe it to yourself to buy & read this book. The informati
on that you’ll get will b
e priceless. Forget all those lame "bibles" out there. This book will be the
prize of your library, the key book that will guide you in your decisions &
provide you with hardhitting information.
From the author:
This new book truly reveals advanced & secret techniques of SQL Server & .NE
T professionals and provides complete & customizable solutions to real world
problems. Face it, you don’t want to buy another developer’s book that
turns out to be just anothe
r big reference manual. You also don’t want to go to yet another mindless
or boring developer’s conference or seminar where you’ll end up wonderin
g if you’ll ever use any of the stuff you’ve just “learned”. And tho
se online discussion boards
can only help so much by pointing you in a certain direction, but fall short
in providing you with a complete solution or the big picture. Believe me, a
s a professional developer, I’ve done all those things, and I know that yo
u’ll find this book is t
he only learning resource available that GOES THE DISTANCE when it comes to
discussing, solving, & providing these solutions. This book has over 600 pag
es of golden information, complete solutions, and valuable code you will not
find anywhere else. You wi
ll even find sections that cover SQL Server or .NET issues or topics that ha
ve never been addressed or shared in any other developer resources or public
media. You won’t find these techniques in any other book, developer semin
ar, or online resource anyw
here.
Click here to find out more about the contents of this hot new book:
<http://www.in-the-trenches.com/mssql.net/toc.asp>
In The Trenches I.T. Professional Learning Series -- "We Go The Distance"
Beyond Books, Inc.
Las Vegas, NV
<http://www.in-the-trenches.com>
****************************************
*****************
To be taken off this list, simply reply to this email
****************************************
*****************"atchleykl" <atchleykl@.discussions.microsoft.com> wrote in message
news:109CDD33-5CF3-47C5-8E61-1A8AE3626852@.microsoft.com...
> Has anyone heard of this book? I got this e-mail and the book looks good,
but I'm afraid it's a scam because I can't
> find the book online anywhere else. I also can't locate this Beyond
Books, Inc. See Email below:
The fact that no author is listed scares me, personally. No one wanted
to put their name on it? Information that "no one else has"? Please...|||"secret techniques", "golden information", "revealing content"
(I see why they are based in Las Vegas ;-))
and that all in 600 pages...
Jacco Schalkwijk
SQL Server MVP
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uyHxkRdZEHA.3012@.tk2msftngp13.phx.gbl...
> "atchleykl" <atchleykl@.discussions.microsoft.com> wrote in message
> news:109CDD33-5CF3-47C5-8E61-1A8AE3626852@.microsoft.com...
good,[vbcol=seagreen]
> but I'm afraid it's a scam because I can't
> Books, Inc. See Email below:
> The fact that no author is listed scares me, personally. No one
wanted
> to put their name on it? Information that "no one else has"? Please...
>|||Personally, I wouldn't even consider a book marketed via spam.
Hope this helps.
Dan Guzman
SQL Server MVP
"atchleykl" <atchleykl@.discussions.microsoft.com> wrote in message
news:109CDD33-5CF3-47C5-8E61-1A8AE3626852@.microsoft.com...
> Has anyone heard of this book? I got this e-mail and the book looks good,
but I'm afraid it's a scam because I can't find the book online anywhere
else. I also can't locate this Beyond Books, Inc. See Email below:
> FROM: "Microsoft Professional Learning Series"
<msdev_book-offers@.in-the-trenches.com>"
> Dear Microsoft Professional,
> We would like to inform you that the book that you've been looking &
waiting for is finally here!
> This hot new book has the industry buzzing about its hardhitting &
revealing content. It drives deep into issues no other industry guru or MVP
has properly addressed and follows through with powerful solutions to them.
Learn advanced & secret techniques used by the pros "in the trenches" and
get complete solutions & code that can literally save you thousands of hours
of research, design, development, coding, and testing (not to mention all
the frustration, headaches, hair pulling, forehead smacking, & other pains
from the process).
> If you are a SQL Server developer, a .NET developer, or a Development Team
Lead, an I.T. Manager or Project Manager for a software product built on
.NET & SQL Server, you owe it to yourself to buy & read this book. The
information that you'll get will be priceless. Forget all those lame
"bibles" out there. This book will be the prize of your library, the key
book that will guide you in your decisions & provide you with hardhitting
information.
> From the author:
> This new book truly reveals advanced & secret techniques of SQL Server &
.NET professionals and provides complete & customizable solutions to real
world problems. Face it, you don't want to buy another developer's book that
turns out to be just another big reference manual. You also don't want to go
to yet another mindless or boring developer's conference or seminar where
you'll end up wondering if you'll ever use any of the stuff you've just
"learned". And those online discussion boards can only help so much by
pointing you in a certain direction, but fall short in providing you with a
complete solution or the big picture. Believe me, as a professional
developer, I've done all those things, and I know that you'll find this book
is the only learning resource available that GOES THE DISTANCE when it comes
to discussing, solving, & providing these solutions. This book has over 600
pages of golden information, complete solutions, and valuable code you will
not find anywhere else. You will even find sections that cover SQL Server or
.NET issues or topics that have never been addressed or shared in any other
developer resources or public media. You won't find these techniques in any
other book, developer seminar, or online resource anywhere.
> Click here to find out more about the contents of this hot new book:
> <http://www.in-the-trenches.com/mssql.net/toc.asp>
> In The Trenches I.T. Professional Learning Series -- "We Go The Distance"
> Beyond Books, Inc.
> Las Vegas, NV
> <http://www.in-the-trenches.com>
> ****************************************
*****************
> To be taken off this list, simply reply to this email
> ****************************************
*****************
>|||Or a book where the Author does not even put his/her/their names to it and
they claim to be experts.
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
Specialist SQL Server Solutions and Consulting
MVP Program: http://www.microsoft.com/mvp
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:eL$VnroZEHA.228@.TK2MSFTNGP10.phx.gbl...
> Personally, I wouldn't even consider a book marketed via spam.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "atchleykl" <atchleykl@.discussions.microsoft.com> wrote in message
> news:109CDD33-5CF3-47C5-8E61-1A8AE3626852@.microsoft.com...
good,[vbcol=seagreen]
> but I'm afraid it's a scam because I can't find the book online anywhere
> else. I also can't locate this Beyond Books, Inc. See Email below:
> <msdev_book-offers@.in-the-trenches.com>"
> waiting for is finally here!
> revealing content. It drives deep into issues no other industry guru or
MVP
> has properly addressed and follows through with powerful solutions to
them.
> Learn advanced & secret techniques used by the pros "in the trenches" and
> get complete solutions & code that can literally save you thousands of
hours
> of research, design, development, coding, and testing (not to mention all
> the frustration, headaches, hair pulling, forehead smacking, & other pains
> from the process).
Team[vbcol=seagreen]
> Lead, an I.T. Manager or Project Manager for a software product built on
> .NET & SQL Server, you owe it to yourself to buy & read this book. The
> information that you'll get will be priceless. Forget all those lame
> "bibles" out there. This book will be the prize of your library, the key
> book that will guide you in your decisions & provide you with hardhitting
> information.
> .NET professionals and provides complete & customizable solutions to real
> world problems. Face it, you don't want to buy another developer's book
that
> turns out to be just another big reference manual. You also don't want to
go
> to yet another mindless or boring developer's conference or seminar where
> you'll end up wondering if you'll ever use any of the stuff you've just
> "learned". And those online discussion boards can only help so much by
> pointing you in a certain direction, but fall short in providing you with
a
> complete solution or the big picture. Believe me, as a professional
> developer, I've done all those things, and I know that you'll find this
book
> is the only learning resource available that GOES THE DISTANCE when it
comes
> to discussing, solving, & providing these solutions. This book has over
600
> pages of golden information, complete solutions, and valuable code you
will
> not find anywhere else. You will even find sections that cover SQL Server
or
> .NET issues or topics that have never been addressed or shared in any
other
> developer resources or public media. You won't find these techniques in
any
> other book, developer seminar, or online resource anywhere.
Distance"[vbcol=seagreen]
>|||Yep. Big red flag.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eTD4XPpZEHA.3420@.TK2MSFTNGP12.phx.gbl...
> Or a book where the Author does not even put his/her/their names to it and
> they claim to be experts.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Epprecht Consulting (PTY) LTD
> Johannesburg, South Africa
> Mobile: +27-82-552-0268
> IM: mike@.epprecht.net
> Specialist SQL Server Solutions and Consulting
> MVP Program: http://www.microsoft.com/mvp
>|||You should look at the website, especially the description of the chapters
included in the book. Chapters include "Soft Skills" and a chapter on how
to get good performance reviews (e.g. the kind that gets you pay raises)...!
Since when is that a specific SQL or .Net skill? There's also a chapter on
Tools, which according to the website is just a list of software, the
website you can get it from, and a brief description...
All of that for the low, low (discounted!) cost of $130... And as it's a
600-page book, you know that the rest must be thoroughly jam-packed in order
to have all of the secrets for BOTH SQL Server *and* .Net, two topics which
I happen to have probably 15,000+ pages of books on, with not a whole lot of
overlap... So this person ("The Saint", according to the website) is either
the tersest writer in history or the font is 0.5-point and the book comes
with a special magnifying glass.
Definitely worth a chuckle, but you gotta respect someone who has the gall
to sell such obvious trash for such a high price...
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:uS3hatpZEHA.384@.TK2MSFTNGP10.phx.gbl...
> Yep. Big red flag.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:eTD4XPpZEHA.3420@.TK2MSFTNGP12.phx.gbl...
and[vbcol=seagreen]
>

New in Replication

There is now a decent book on replication by Hilary
Cotter who posts regularly here. Have a look at
http://www.nwsu.com/0974973602p.html. Apart from that,
there is books on line, which although it doesn't have
screenshots, is certainly enough to get started. There is
a Microsoft 3-day course run at many CTECs, and there are
a few resources on the web - have a look at the links on
www.replicationanswers.com.
Once you've got a grounding in the fundamentals, I'd
recommend setting up as many different scenarios as
possible on a test environment which will bring up many
further questions, and the newsgroup is ideal for this.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Thanks
Amish M Shah
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:168201c4db97$432fb080$a301280a@.phx.gbl...
> There is now a decent book on replication by Hilary
> Cotter who posts regularly here. Have a look at
> http://www.nwsu.com/0974973602p.html. Apart from that,
> there is books on line, which although it doesn't have
> screenshots, is certainly enough to get started. There is
> a Microsoft 3-day course run at many CTECs, and there are
> a few resources on the web - have a look at the links on
> www.replicationanswers.com.
> Once you've got a grounding in the fundamentals, I'd
> recommend setting up as many different scenarios as
> possible on a test environment which will bring up many
> further questions, and the newsgroup is ideal for this.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>