New to SQL -- Any good reads?

With my recent employment at my internship, I've been given the task to start
learning as much about SQL servers and querying(sp?) as possible.
I was wondering if there is anybody out there knows of some good
articles/books that would send me on my way?
I'm not looking for "super" basic stuff but as I've been exposed to
databases in the past but would like to get into more deeper topics. I guess
something along the lines of not a novice but no where near being able to
administer a DB myself.
Thanks,
BenSome good ones.
Microsoft SQL Server Books
http://vyaskn.tripod.com/sqlbooks.htm
AMB
"Ben" wrote:
> With my recent employment at my internship, I've been given the task to start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben|||Kalen Delaney's Inside SQL Server is my desktop bible, offers enough info on
almost all facets in depth enough to make it invaluable.
"Ben" wrote:
> With my recent employment at my internship, I've been given the task to start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben|||Hi,
SQL Server Books online will be a very good option.
Thanks
Hari
SQL Server MVP
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:BEA56BB4-BE39-4C1B-89EB-24B2AEE2BC81@.microsoft.com...
> With my recent employment at my internship, I've been given the task to
> start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I
> guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben

New to SQL -- Any good reads?

With my recent employment at my internship, I've been given the task to start
learning as much about SQL servers and querying(sp?) as possible.
I was wondering if there is anybody out there knows of some good
articles/books that would send me on my way?
I'm not looking for "super" basic stuff but as I've been exposed to
databases in the past but would like to get into more deeper topics. I guess
something along the lines of not a novice but no where near being able to
administer a DB myself.
Thanks,
Ben
Some good ones.
Microsoft SQL Server Books
http://vyaskn.tripod.com/sqlbooks.htm
AMB
"Ben" wrote:

> With my recent employment at my internship, I've been given the task to start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben
|||Kalen Delaney's Inside SQL Server is my desktop bible, offers enough info on
almost all facets in depth enough to make it invaluable.
"Ben" wrote:

> With my recent employment at my internship, I've been given the task to start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben
|||Hi,
SQL Server Books online will be a very good option.
Thanks
Hari
SQL Server MVP
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:BEA56BB4-BE39-4C1B-89EB-24B2AEE2BC81@.microsoft.com...
> With my recent employment at my internship, I've been given the task to
> start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I
> guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben
sql

New to SQL -- Any good reads?

With my recent employment at my internship, I've been given the task to star
t
learning as much about SQL servers and querying(sp?) as possible.
I was wondering if there is anybody out there knows of some good
articles/books that would send me on my way?
I'm not looking for "super" basic stuff but as I've been exposed to
databases in the past but would like to get into more deeper topics. I gues
s
something along the lines of not a novice but no where near being able to
administer a DB myself.
Thanks,
BenSome good ones.
Microsoft SQL Server Books
http://vyaskn.tripod.com/sqlbooks.htm
AMB
"Ben" wrote:

> With my recent employment at my internship, I've been given the task to st
art
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I gu
ess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben|||Kalen Delaney's Inside SQL Server is my desktop bible, offers enough info on
almost all facets in depth enough to make it invaluable.
"Ben" wrote:

> With my recent employment at my internship, I've been given the task to st
art
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I gu
ess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben|||Hi,
SQL Server Books online will be a very good option.
Thanks
Hari
SQL Server MVP
"Ben" <Ben@.discussions.microsoft.com> wrote in message
news:BEA56BB4-BE39-4C1B-89EB-24B2AEE2BC81@.microsoft.com...
> With my recent employment at my internship, I've been given the task to
> start
> learning as much about SQL servers and querying(sp?) as possible.
> I was wondering if there is anybody out there knows of some good
> articles/books that would send me on my way?
> I'm not looking for "super" basic stuff but as I've been exposed to
> databases in the past but would like to get into more deeper topics. I
> guess
> something along the lines of not a novice but no where near being able to
> administer a DB myself.
> Thanks,
> Ben

New to Instances: Dont have sa of newly created instance

A new instance has been setup on one of our pilot servers. I do not have th
e
sa password to that instance, and it appears that the group who set up the
instance also removed the built-in/admin group. Am I doomed to never access
this instance?
Should I bring flowers, donoughts AND cookies when begging for the sa
password?I would suggest that you get those that built it to come back and fix it.
The sa password will only help if the thing is running in mixed mode - you
can change this if you are an admin on the windows box by changing the
registry key for LoginMode of the instance (do a search down the
hkey_localmachine\software path) and changing the value to 2, then stopping
and restarting the sql server service.
You could also ask if they set up another admin group before deleting
built-in/admin, and get into it.
Good luck
Mary Bray [SQL Server MVP]
Please reply only to newsgroups
"wxd" <wxd@.discussions.microsoft.com> wrote in message
news:81522A36-6D2E-4532-9593-2E194D8638EF@.microsoft.com...
>A new instance has been setup on one of our pilot servers. I do not have
>the
> sa password to that instance, and it appears that the group who set up the
> instance also removed the built-in/admin group. Am I doomed to never
> access
> this instance?
> Should I bring flowers, donoughts AND cookies when begging for the sa
> password?|||Thank you for the response. Checking on what you wrote, I found the
LoginMode is already set to 2, and my administrator still receives a "failed
login" message when attempting to connect to the instance through Windows
Authentication. I did not think it was possible to lock out the net admin
group?
"Mary Bray" wrote:

> I would suggest that you get those that built it to come back and fix it.
> The sa password will only help if the thing is running in mixed mode - you
> can change this if you are an admin on the windows box by changing the
> registry key for LoginMode of the instance (do a search down the
> hkey_localmachine\software path) and changing the value to 2, then stoppin
g
> and restarting the sql server service.
> You could also ask if they set up another admin group before deleting
> built-in/admin, and get into it.
> Good luck
> --
> Mary Bray [SQL Server MVP]
> Please reply only to newsgroups
> "wxd" <wxd@.discussions.microsoft.com> wrote in message
> news:81522A36-6D2E-4532-9593-2E194D8638EF@.microsoft.com...
>
>|||NEVERMIND! Thank you very much for your assistance.
I have found out what this instance is and am discovering that all SQL logic
no longer applies. This is an ACT! installation. ACT! installs an extremel
y
hacked up version of the SQL engine. It is my understanding that the normal
SQL login processes are not present on the server for me to get into this
instance. The company that produces ACT desperately wants people to use
their client vs. any other tool to access their database.
Thank you for your help and insight.
"Mary Bray" wrote:

> I would suggest that you get those that built it to come back and fix it.
> The sa password will only help if the thing is running in mixed mode - you
> can change this if you are an admin on the windows box by changing the
> registry key for LoginMode of the instance (do a search down the
> hkey_localmachine\software path) and changing the value to 2, then stoppin
g
> and restarting the sql server service.
> You could also ask if they set up another admin group before deleting
> built-in/admin, and get into it.
> Good luck
> --
> Mary Bray [SQL Server MVP]
> Please reply only to newsgroups
> "wxd" <wxd@.discussions.microsoft.com> wrote in message
> news:81522A36-6D2E-4532-9593-2E194D8638EF@.microsoft.com...
>
>

New to Instances: Dont have sa of newly created instance

A new instance has been setup on one of our pilot servers. I do not have the
sa password to that instance, and it appears that the group who set up the
instance also removed the built-in/admin group. Am I doomed to never access
this instance?
Should I bring flowers, donoughts AND cookies when begging for the sa
password?
I would suggest that you get those that built it to come back and fix it.
The sa password will only help if the thing is running in mixed mode - you
can change this if you are an admin on the windows box by changing the
registry key for LoginMode of the instance (do a search down the
hkey_localmachine\software path) and changing the value to 2, then stopping
and restarting the sql server service.
You could also ask if they set up another admin group before deleting
built-in/admin, and get into it.
Good luck
Mary Bray [SQL Server MVP]
Please reply only to newsgroups
"wxd" <wxd@.discussions.microsoft.com> wrote in message
news:81522A36-6D2E-4532-9593-2E194D8638EF@.microsoft.com...
>A new instance has been setup on one of our pilot servers. I do not have
>the
> sa password to that instance, and it appears that the group who set up the
> instance also removed the built-in/admin group. Am I doomed to never
> access
> this instance?
> Should I bring flowers, donoughts AND cookies when begging for the sa
> password?
|||Thank you for the response. Checking on what you wrote, I found the
LoginMode is already set to 2, and my administrator still receives a "failed
login" message when attempting to connect to the instance through Windows
Authentication. I did not think it was possible to lock out the net admin
group?
"Mary Bray" wrote:

> I would suggest that you get those that built it to come back and fix it.
> The sa password will only help if the thing is running in mixed mode - you
> can change this if you are an admin on the windows box by changing the
> registry key for LoginMode of the instance (do a search down the
> hkey_localmachine\software path) and changing the value to 2, then stopping
> and restarting the sql server service.
> You could also ask if they set up another admin group before deleting
> built-in/admin, and get into it.
> Good luck
> --
> Mary Bray [SQL Server MVP]
> Please reply only to newsgroups
> "wxd" <wxd@.discussions.microsoft.com> wrote in message
> news:81522A36-6D2E-4532-9593-2E194D8638EF@.microsoft.com...
>
>
|||NEVERMIND! Thank you very much for your assistance.
I have found out what this instance is and am discovering that all SQL logic
no longer applies. This is an ACT! installation. ACT! installs an extremely
hacked up version of the SQL engine. It is my understanding that the normal
SQL login processes are not present on the server for me to get into this
instance. The company that produces ACT desperately wants people to use
their client vs. any other tool to access their database.
Thank you for your help and insight.
"Mary Bray" wrote:

> I would suggest that you get those that built it to come back and fix it.
> The sa password will only help if the thing is running in mixed mode - you
> can change this if you are an admin on the windows box by changing the
> registry key for LoginMode of the instance (do a search down the
> hkey_localmachine\software path) and changing the value to 2, then stopping
> and restarting the sql server service.
> You could also ask if they set up another admin group before deleting
> built-in/admin, and get into it.
> Good luck
> --
> Mary Bray [SQL Server MVP]
> Please reply only to newsgroups
> "wxd" <wxd@.discussions.microsoft.com> wrote in message
> news:81522A36-6D2E-4532-9593-2E194D8638EF@.microsoft.com...
>
>

New SQL Server Registration failure

Hi,

I have 3 SQL Servers running here. Here are their configurations:

SERVER 1:
OS: Windows 2000 SP 4
SQL: SQL Server 2000 SP 4

SERVER 2:
OS: Windows 2000 SP 4
SQL: SQL Server 2000 SP 4

SERVER 3:
OS: Windows XP Professionnal
SQL: SQL Server 2000 SP 3

Now, as you can see, SERVER 1 and SERVER 2 have identical configurations. Plus, both will accept Windows Authentication and SQL Authentication.

If I try to add a new Registration from SERVER 3 to SERVER 1, it works fine but from SERVER 3 to SERVER 2 it doesn't. I always get an error (SQL Server does not exist or access denied). But, using the exact same user name and password, a connection can be established from SERVER 1 to SERVER 2 and vice-versa. Only when trying to connect froms SERVER 3 to SERVER 2 fails.

Any ideas?

Thanks,

Skip.I thought we only have sp3a in sql 2000. Where did you get the sp4?|||Originally posted by joejcheng
I thought we only have sp3a in sql 2000. Where did you get the sp4?

I don't know, I'm not the sysadmin responsible for updating software. It's just what is says in the about menu option.

Skip.

New SQL Server Registration

I have two (Server A & Server B)SQL Servers located in a
different site and they are connected via DSL internet. I
want to add the other server B to server A using New SQL
Server Registration in server A. How should I do it? Both
sides is using Firewall.
Thanks a lot in advance!Hi
You may want to check out:
http://support.microsoft.com/?id=287932
John
"sim" <anonymous@.discussions.microsoft.com> wrote in message
news:008b01c3ac00$c5230550$a001280a@.phx.gbl...
> I have two (Server A & Server B)SQL Servers located in a
> different site and they are connected via DSL internet. I
> want to add the other server B to server A using New SQL
> Server Registration in server A. How should I do it? Both
> sides is using Firewall.
> Thanks a lot in advance!sql

New Server Setup

I am trying to install two new SQL 2000 servers, but need them to be
mirrored. I had asked the question a while back and it was suggested i use
Virtual servers , which to be honest i havent found much on how it would
work. Can anybody explain how this can be done or recomend some reading
material that i may look at
The reason for the mirroring is , we deal with electronic payments and if
one server goes down i dont want ant intruption in service to our clients. I
suppose im trying to replicate the way the old Novell mirrored servers work.
Also i would want a rthird off site server kept in the loop and updated
In SQL 2000, you can use fail-over clustering to provide high-availability.
This feature is implemented in conjunction with OS clustering and is
described in detail in the Books Online. Be aware that the OS and hardware
requirements necessitate careful planning. All hardware must be MSCS HCL
certified.
SQL 2005 introduces a database mirroring feature, which is essentially a
software solution. This feature is scheduled to be released in the first
half of this year but can also be enabled for evaluation purposes in the
current release by using a trace flag.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter Newman" <PeterNewman@.discussions.microsoft.com> wrote in message
news:803B26A4-D2AA-4707-B61A-64ED12EFD180@.microsoft.com...
>I am trying to install two new SQL 2000 servers, but need them to be
> mirrored. I had asked the question a while back and it was suggested i
> use
> Virtual servers , which to be honest i havent found much on how it would
> work. Can anybody explain how this can be done or recomend some reading
> material that i may look at
> The reason for the mirroring is , we deal with electronic payments and if
> one server goes down i dont want ant intruption in service to our clients.
> I
> suppose im trying to replicate the way the old Novell mirrored servers
> work.
> Also i would want a rthird off site server kept in the loop and updated
>

New Server Setup

I am trying to install two new SQL 2000 servers, but need them to be
mirrored. I had asked the question a while back and it was suggested i use
Virtual servers , which to be honest i havent found much on how it would
work. Can anybody explain how this can be done or recomend some reading
material that i may look at
The reason for the mirroring is , we deal with electronic payments and if
one server goes down i dont want ant intruption in service to our clients. I
suppose im trying to replicate the way the old Novell mirrored servers work.
Also i would want a rthird off site server kept in the loop and updatedIn SQL 2000, you can use fail-over clustering to provide high-availability.
This feature is implemented in conjunction with OS clustering and is
described in detail in the Books Online. Be aware that the OS and hardware
requirements necessitate careful planning. All hardware must be MSCS HCL
certified.
SQL 2005 introduces a database mirroring feature, which is essentially a
software solution. This feature is scheduled to be released in the first
half of this year but can also be enabled for evaluation purposes in the
current release by using a trace flag.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter Newman" <PeterNewman@.discussions.microsoft.com> wrote in message
news:803B26A4-D2AA-4707-B61A-64ED12EFD180@.microsoft.com...
>I am trying to install two new SQL 2000 servers, but need them to be
> mirrored. I had asked the question a while back and it was suggested i
> use
> Virtual servers , which to be honest i havent found much on how it would
> work. Can anybody explain how this can be done or recomend some reading
> material that i may look at
> The reason for the mirroring is , we deal with electronic payments and if
> one server goes down i dont want ant intruption in service to our clients.
> I
> suppose im trying to replicate the way the old Novell mirrored servers
> work.
> Also i would want a rthird off site server kept in the loop and updated
>

New Server Setup

I am trying to install two new SQL 2000 servers, but need them to be
mirrored. I had asked the question a while back and it was suggested i use
Virtual servers , which to be honest i havent found much on how it would
work. Can anybody explain how this can be done or recomend some reading
material that i may look at
The reason for the mirroring is , we deal with electronic payments and if
one server goes down i dont want ant intruption in service to our clients. I
suppose im trying to replicate the way the old Novell mirrored servers work.
Also i would want a rthird off site server kept in the loop and updatedIn SQL 2000, you can use fail-over clustering to provide high-availability.
This feature is implemented in conjunction with OS clustering and is
described in detail in the Books Online. Be aware that the OS and hardware
requirements necessitate careful planning. All hardware must be MSCS HCL
certified.
SQL 2005 introduces a database mirroring feature, which is essentially a
software solution. This feature is scheduled to be released in the first
half of this year but can also be enabled for evaluation purposes in the
current release by using a trace flag.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter Newman" <PeterNewman@.discussions.microsoft.com> wrote in message
news:803B26A4-D2AA-4707-B61A-64ED12EFD180@.microsoft.com...
>I am trying to install two new SQL 2000 servers, but need them to be
> mirrored. I had asked the question a while back and it was suggested i
> use
> Virtual servers , which to be honest i havent found much on how it would
> work. Can anybody explain how this can be done or recomend some reading
> material that i may look at
> The reason for the mirroring is , we deal with electronic payments and if
> one server goes down i dont want ant intruption in service to our clients.
> I
> suppose im trying to replicate the way the old Novell mirrored servers
> work.
> Also i would want a rthird off site server kept in the loop and updated
>

New indexes not shipped to secondary server

I am running SQL 2k on WinS2003 servers. We are using Log Shipping,
leaving our secondary in a Read-Only state to be used for reporting. I
have a need to get a new index on the secondary server (to decrease the
14 hour run time for a report). Our primary is in Full Recovery mode
as well.
I have created the index on my primary and expected it to be created on
the secondary when the logs were shipped this morning, only to find
that the Index was not created on the secondary.
I am not very familiar with Log Shipping and our in house expert is
unavailable.
Any thoughts on what gives?
I would even take pointers on where to start looking to find the
problem.
Meredith Ryan> I have created the index on my primary and expected it to be created on
> the secondary when the logs were shipped this morning, only to find
> that the Index was not created on the secondary.
>
You need the logs shipped AND applied for this to occur.
"mryan" <coffegrl@.gmail.com> wrote in message
news:1143761656.789619.3450@.v46g2000cwv.googlegroups.com...
> I am running SQL 2k on WinS2003 servers. We are using Log Shipping,
> leaving our secondary in a Read-Only state to be used for reporting. I
> have a need to get a new index on the secondary server (to decrease the
> 14 hour run time for a report). Our primary is in Full Recovery mode
> as well.
> I have created the index on my primary and expected it to be created on
> the secondary when the logs were shipped this morning, only to find
> that the Index was not created on the secondary.
> I am not very familiar with Log Shipping and our in house expert is
> unavailable.
> Any thoughts on what gives?
> I would even take pointers on where to start looking to find the
> problem.
> Meredith Ryan
>|||The logs had been applied. I guess I should have been a bit more
specific.

New indexes not shipped to secondary server

I am running SQL 2k on WinS2003 servers. We are using Log Shipping,
leaving our secondary in a Read-Only state to be used for reporting. I
have a need to get a new index on the secondary server (to decrease the
14 hour run time for a report). Our primary is in Full Recovery mode
as well.
I have created the index on my primary and expected it to be created on
the secondary when the logs were shipped this morning, only to find
that the Index was not created on the secondary.
I am not very familiar with Log Shipping and our in house expert is
unavailable.
Any thoughts on what gives?
I would even take pointers on where to start looking to find the
problem.
Meredith Ryan
> I have created the index on my primary and expected it to be created on
> the secondary when the logs were shipped this morning, only to find
> that the Index was not created on the secondary.
>
You need the logs shipped AND applied for this to occur.
"mryan" <coffegrl@.gmail.com> wrote in message
news:1143761656.789619.3450@.v46g2000cwv.googlegrou ps.com...
> I am running SQL 2k on WinS2003 servers. We are using Log Shipping,
> leaving our secondary in a Read-Only state to be used for reporting. I
> have a need to get a new index on the secondary server (to decrease the
> 14 hour run time for a report). Our primary is in Full Recovery mode
> as well.
> I have created the index on my primary and expected it to be created on
> the secondary when the logs were shipped this morning, only to find
> that the Index was not created on the secondary.
> I am not very familiar with Log Shipping and our in house expert is
> unavailable.
> Any thoughts on what gives?
> I would even take pointers on where to start looking to find the
> problem.
> Meredith Ryan
>
|||The logs had been applied. I guess I should have been a bit more
specific.

New indexes not shipped to secondary server

I am running SQL 2k on WinS2003 servers. We are using Log Shipping,
leaving our secondary in a Read-Only state to be used for reporting. I
have a need to get a new index on the secondary server (to decrease the
14 hour run time for a report). Our primary is in Full Recovery mode
as well.
I have created the index on my primary and expected it to be created on
the secondary when the logs were shipped this morning, only to find
that the Index was not created on the secondary.
I am not very familiar with Log Shipping and our in house expert is
unavailable.
Any thoughts on what gives?
I would even take pointers on where to start looking to find the
problem.
Meredith Ryan> I have created the index on my primary and expected it to be created on
> the secondary when the logs were shipped this morning, only to find
> that the Index was not created on the secondary.
>
You need the logs shipped AND applied for this to occur.
"mryan" <coffegrl@.gmail.com> wrote in message
news:1143761656.789619.3450@.v46g2000cwv.googlegroups.com...
> I am running SQL 2k on WinS2003 servers. We are using Log Shipping,
> leaving our secondary in a Read-Only state to be used for reporting. I
> have a need to get a new index on the secondary server (to decrease the
> 14 hour run time for a report). Our primary is in Full Recovery mode
> as well.
> I have created the index on my primary and expected it to be created on
> the secondary when the logs were shipped this morning, only to find
> that the Index was not created on the secondary.
> I am not very familiar with Log Shipping and our in house expert is
> unavailable.
> Any thoughts on what gives?
> I would even take pointers on where to start looking to find the
> problem.
> Meredith Ryan
>|||The logs had been applied. I guess I should have been a bit more
specific.