Does anyone have suggestions for courses (offsite or CBT) to help my team come up to speed on clusters? My team members are DBAs.
Check out: www.solidqualitylearning.com
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Brenda Pingle" <Brenda Pingle@.discussions.microsoft.com> wrote in message
news:616748DE-D8DF-497F-8E9B-9B660CB0D786@.microsoft.com...
Does anyone have suggestions for courses (offsite or CBT) to help my team
come up to speed on clusters? My team members are DBAs.
|||Here is a link to Windows Clustering exam.
Exam 70-223: Installing, Configuring, and Administering Microsoft Clustering Services by Using Microsoft Windows 2000 Advanced Server
http://www.microsoft.com/learning/exams/70-223.asp
Implementing Microsoft Windows 2000 Clustering
Course 2087: Three days; Instructor-led
http://www.microsoft.com/traincert/s...2087aFINAL.ASP
I am not aware of any exam/course for SQL Server 2000 Clustering but the following books/whitepapers/webcast should be a good starting point
Microsoft SQL Server 2000 High Availability (MS Press)
ISBN 0-7356-1920-4
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...vercluster.asp
SQL Server 2000 Pricing and Licensing
http://www.microsoft.com/sql/howtobu...rlicensing.asp
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Microsoft Webcasts
Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...lurb051001.asp
Microsoft SQL Server 2000 Virtual Server: Things You Should Know
http://support.microsoft.com/default...lurb032602.asp
Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default...lurb061002.asp
Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
http://support.microsoft.com/default...lurb101802.asp
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
Microsoft Knowledge Base Articles
Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
http://support.microsoft.com/?kbid=243218
Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?kbid=260758
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||im a CTEC trainer, is their an efficient way to conduct this class course
2087 without purchasing an SCSI external hard drive for clustering? please
advise
"Uttam Parui[MS]" wrote:
> Here is a link to Windows Clustering exam.
> Exam 70-223: Installing, Configuring, and Administering Microsoft Clustering Services by Using Microsoft Windows 2000 Advanced Server
> http://www.microsoft.com/learning/exams/70-223.asp
>
> Implementing Microsoft Windows 2000 Clustering
> Course 2087: Three days; Instructor-led
> http://www.microsoft.com/traincert/s...2087aFINAL.ASP
>
> I am not aware of any exam/course for SQL Server 2000 Clustering but the following books/whitepapers/webcast should be a good starting point
> Microsoft SQL Server 2000 High Availability (MS Press)
> ISBN 0-7356-1920-4
> Microsoft Whitepaper - SQL Server 2000 Failover Clustering
> http://www.microsoft.com/SQL/techinf...vercluster.asp
> SQL Server 2000 Pricing and Licensing
> http://www.microsoft.com/sql/howtobu...rlicensing.asp
> Microsoft SQL Server 2000 High Availability Series
> http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
> Microsoft Webcasts
> Introduction to Microsoft SQL Server 2000 Clustering
> http://support.microsoft.com/default...lurb051001.asp
> Microsoft SQL Server 2000 Virtual Server: Things You Should Know
> http://support.microsoft.com/default...lurb032602.asp
>
> Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default...lurb061002.asp
> Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
> http://support.microsoft.com/default...lurb101802.asp
> Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
> http://support.microsoft.com/default...lurb020703.asp
>
> Microsoft Knowledge Base Articles
>
> Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
> http://support.microsoft.com/?kbid=243218
> Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
> http://support.microsoft.com/?kbid=260758
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>
|||You can emulate clustering through VMWare.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Benjsoft" <Benjsoft@.discussions.microsoft.com> wrote in message
news:0E6D46CF-6410-4154-9EF0-FBDC1A9CAE54@.microsoft.com...
im a CTEC trainer, is their an efficient way to conduct this class course
2087 without purchasing an SCSI external hard drive for clustering? please
advise
"Uttam Parui[MS]" wrote:
> Here is a link to Windows Clustering exam.
> Exam 70-223: Installing, Configuring, and Administering Microsoft
Clustering Services by Using Microsoft Windows 2000 Advanced Server
> http://www.microsoft.com/learning/exams/70-223.asp
>
> Implementing Microsoft Windows 2000 Clustering
> Course 2087: Three days; Instructor-led
> http://www.microsoft.com/traincert/s...2087aFINAL.ASP
>
> I am not aware of any exam/course for SQL Server 2000 Clustering but the
following books/whitepapers/webcast should be a good starting point
> Microsoft SQL Server 2000 High Availability (MS Press)
> ISBN 0-7356-1920-4
> Microsoft Whitepaper - SQL Server 2000 Failover Clustering
>
http://www.microsoft.com/SQL/techinf...vercluster.asp
> SQL Server 2000 Pricing and Licensing
> http://www.microsoft.com/sql/howtobu...rlicensing.asp
> Microsoft SQL Server 2000 High Availability Series
> http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
> Microsoft Webcasts
> Introduction to Microsoft SQL Server 2000 Clustering
>
http://support.microsoft.com/default...lurb051001.asp
> Microsoft SQL Server 2000 Virtual Server: Things You Should Know
>
http://support.microsoft.com/default...lurb032602.asp
>
> Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and
Service Pack
http://support.microsoft.com/default...lurb061002.asp
> Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
>
http://support.microsoft.com/default...lurb101802.asp
> Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for
Failover Clustering
>
http://support.microsoft.com/default...lurb020703.asp
>
> Microsoft Knowledge Base Articles
>
> Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
> http://support.microsoft.com/?kbid=243218
> Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover
Clustering
> http://support.microsoft.com/?kbid=260758
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>
Showing posts with label members. Show all posts
Showing posts with label members. Show all posts
Thursday, March 29, 2012
Sunday, March 25, 2012
Cluster Nodes and Windows Domains
Cluster Nodes and Windows Domains
All nodes in the cluster must be members of the same
domain and able to access a domain controller and a Domain
Name System (DNS) server, as well as a WINS server. The
nodes should not be configured as domain controllers if
you are going to install SQL Server, as you may encounter
some problems, including the fact that domain controller
functionality (such as Active Directory) is not cluster
aware, so all information will be local. This impacts
things such as a directory enabled program's ability to
publish under the virtual server's computer object, which
does not work in a cluster. A WINS server is still
required for Windows 2000/SQL Server 2000 in a clustered
environment if name resolution of virtual resource is
required.
My question:
After reading the above paragraph. I want to setup two
nodes as peer to peer domain controllers running Windows
2000 Advanced, SQL Server 2000, Active directory service
running on each node, in a cluster environment.
What part of this is not cluster aware?
Why do I need a WINS server if I have DNS?
Why can't my nodes be a domain controller?( I'm using the
company's DNS server)
What does this means? (directory enabled program's ability
to publish under the virtual server's computer object,
which does not work in a cluster.)I would never, ever recommend installing SQL Server on a domain controller.
The security exposure is huge.
Steve
"Tony" <tony.baks@.tdh.state.tx.us> wrote in message
news:038001c35089$9061b550$a301280a@.phx.gbl...
> Cluster Nodes and Windows Domains
> All nodes in the cluster must be members of the same
> domain and able to access a domain controller and a Domain
> Name System (DNS) server, as well as a WINS server. The
> nodes should not be configured as domain controllers if
> you are going to install SQL Server, as you may encounter
> some problems, including the fact that domain controller
> functionality (such as Active Directory) is not cluster
> aware, so all information will be local. This impacts
> things such as a directory enabled program's ability to
> publish under the virtual server's computer object, which
> does not work in a cluster. A WINS server is still
> required for Windows 2000/SQL Server 2000 in a clustered
> environment if name resolution of virtual resource is
> required.
> My question:
> After reading the above paragraph. I want to setup two
> nodes as peer to peer domain controllers running Windows
> 2000 Advanced, SQL Server 2000, Active directory service
> running on each node, in a cluster environment.
> What part of this is not cluster aware?
> Why do I need a WINS server if I have DNS?
Many applications still require WINS...
> Why can't my nodes be a domain controller?( I'm using the
> company's DNS server)
HUGE security exposure, consider using a member server for your SQL Server
implementation.
> What does this means? (directory enabled program's ability
> to publish under the virtual server's computer object,
> which does not work in a cluster.)
All nodes in the cluster must be members of the same
domain and able to access a domain controller and a Domain
Name System (DNS) server, as well as a WINS server. The
nodes should not be configured as domain controllers if
you are going to install SQL Server, as you may encounter
some problems, including the fact that domain controller
functionality (such as Active Directory) is not cluster
aware, so all information will be local. This impacts
things such as a directory enabled program's ability to
publish under the virtual server's computer object, which
does not work in a cluster. A WINS server is still
required for Windows 2000/SQL Server 2000 in a clustered
environment if name resolution of virtual resource is
required.
My question:
After reading the above paragraph. I want to setup two
nodes as peer to peer domain controllers running Windows
2000 Advanced, SQL Server 2000, Active directory service
running on each node, in a cluster environment.
What part of this is not cluster aware?
Why do I need a WINS server if I have DNS?
Why can't my nodes be a domain controller?( I'm using the
company's DNS server)
What does this means? (directory enabled program's ability
to publish under the virtual server's computer object,
which does not work in a cluster.)I would never, ever recommend installing SQL Server on a domain controller.
The security exposure is huge.
Steve
"Tony" <tony.baks@.tdh.state.tx.us> wrote in message
news:038001c35089$9061b550$a301280a@.phx.gbl...
> Cluster Nodes and Windows Domains
> All nodes in the cluster must be members of the same
> domain and able to access a domain controller and a Domain
> Name System (DNS) server, as well as a WINS server. The
> nodes should not be configured as domain controllers if
> you are going to install SQL Server, as you may encounter
> some problems, including the fact that domain controller
> functionality (such as Active Directory) is not cluster
> aware, so all information will be local. This impacts
> things such as a directory enabled program's ability to
> publish under the virtual server's computer object, which
> does not work in a cluster. A WINS server is still
> required for Windows 2000/SQL Server 2000 in a clustered
> environment if name resolution of virtual resource is
> required.
> My question:
> After reading the above paragraph. I want to setup two
> nodes as peer to peer domain controllers running Windows
> 2000 Advanced, SQL Server 2000, Active directory service
> running on each node, in a cluster environment.
> What part of this is not cluster aware?
> Why do I need a WINS server if I have DNS?
Many applications still require WINS...
> Why can't my nodes be a domain controller?( I'm using the
> company's DNS server)
HUGE security exposure, consider using a member server for your SQL Server
implementation.
> What does this means? (directory enabled program's ability
> to publish under the virtual server's computer object,
> which does not work in a cluster.)
Friday, February 10, 2012
Clever Query
MEMBER_ID FRIEND_ID
285 1
285 2
285 3
Member 285 has 3 friends. Table is set out as above.
Members 1,2 and 3 have their own friends.
MEMBER_ID FRIEND_ID
1 286
1 1654
1 556
2 56465
2 87864
3 564564
3 5454
3 4588
3 4545
So from the above we can see that the Friends of Friends count would be
9.
Using the above how could I write a query that gave me the answer 9 for
the member_id 285?
I thank clever person who can help.This is a multi-part message in MIME format.
--=_NextPart_000_0A1D_01C6D648.8662A940
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
It's not really clear what you are trying to accomplish here, but for a ='wag':
SELECT count(1)
FROM Table1 t1
JOIN Table2 t2
ON t1.Friend_ID =3D t2.Member_ID
-- Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous
<gurdipv@.gmail.com> wrote in message =news:1158075642.788596.64550@.e63g2000cwd.googlegroups.com...
> MEMBER_ID FRIEND_ID
> 285 1
> 285 2
> 285 3
> > Member 285 has 3 friends. Table is set out as above.
> > Members 1,2 and 3 have their own friends.
> > MEMBER_ID FRIEND_ID
> 1 286
> 1 1654
> 1 556
> 2 56465
> 2 87864
> 3 564564
> 3 5454
> 3 4588
> 3 4545
> > > So from the above we can see that the Friends of Friends count would =be
> 9.
> > Using the above how could I write a query that gave me the answer 9 =for
> the member_id 285?
> > I thank clever person who can help.
>
--=_NextPart_000_0A1D_01C6D648.8662A940
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
It's not really clear what you are =trying to accomplish here, but for a 'wag':
SELECT count(1)
FROM Table1 t1
JOIN Table2 =t2
=ON t1.Friend_ID =3D t2.Member_ID
-- Arnie Rowland, Ph.D.Westwood Consulting, Inc
Most good judgment comes from =experience. Most experience comes from bad judgment. - Anonymous
wrote in message news:1158075642.788596.64550@.e63g2000cwd.googlegroups.com=...> =MEMBER_ID FRIEND_ID> 285 1> 285 2> 285 3> > =Member 285 has 3 friends. Table is set out as above.> > Members 1,2 =and 3 have their own friends.> > MEMBER_ID FRIEND_ID> 1 286> 1 1654> 1 556> 2 56465> 2 87864> =3 564564> 3 5454> 3 4588> 3 4545> > => So from the above we can see that the Friends of Friends count would =be> 9.> > Using the above how could I write a query that gave =me the answer 9 for> the member_id 285?> > I thank clever =person who can help.>
--=_NextPart_000_0A1D_01C6D648.8662A940--
285 1
285 2
285 3
Member 285 has 3 friends. Table is set out as above.
Members 1,2 and 3 have their own friends.
MEMBER_ID FRIEND_ID
1 286
1 1654
1 556
2 56465
2 87864
3 564564
3 5454
3 4588
3 4545
So from the above we can see that the Friends of Friends count would be
9.
Using the above how could I write a query that gave me the answer 9 for
the member_id 285?
I thank clever person who can help.This is a multi-part message in MIME format.
--=_NextPart_000_0A1D_01C6D648.8662A940
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
It's not really clear what you are trying to accomplish here, but for a ='wag':
SELECT count(1)
FROM Table1 t1
JOIN Table2 t2
ON t1.Friend_ID =3D t2.Member_ID
-- Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous
<gurdipv@.gmail.com> wrote in message =news:1158075642.788596.64550@.e63g2000cwd.googlegroups.com...
> MEMBER_ID FRIEND_ID
> 285 1
> 285 2
> 285 3
> > Member 285 has 3 friends. Table is set out as above.
> > Members 1,2 and 3 have their own friends.
> > MEMBER_ID FRIEND_ID
> 1 286
> 1 1654
> 1 556
> 2 56465
> 2 87864
> 3 564564
> 3 5454
> 3 4588
> 3 4545
> > > So from the above we can see that the Friends of Friends count would =be
> 9.
> > Using the above how could I write a query that gave me the answer 9 =for
> the member_id 285?
> > I thank clever person who can help.
>
--=_NextPart_000_0A1D_01C6D648.8662A940
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
It's not really clear what you are =trying to accomplish here, but for a 'wag':
SELECT count(1)
FROM Table1 t1
JOIN Table2 =t2
=ON t1.Friend_ID =3D t2.Member_ID
-- Arnie Rowland, Ph.D.Westwood Consulting, Inc
Most good judgment comes from =experience. Most experience comes from bad judgment. - Anonymous
--=_NextPart_000_0A1D_01C6D648.8662A940--
Clever Query
MEMBER_ID FRIEND_ID
285 1
285 2
285 3
Member 285 has 3 friends. Table is set out as above.
Members 1,2 and 3 have their own friends.
MEMBER_ID FRIEND_ID
1 286
1 1654
1 556
2 56465
2 87864
3 564564
3 5454
3 4588
3 4545
So from the above we can see that the Friends of Friends count would be
9.
Using the above how could I write a query that gave me the answer 9 for
the member_id 285?
I thank clever person who can help.It's not really clear what you are trying to accomplish here, but for a 'wag
':
SELECT count(1)
FROM Table1 t1
JOIN Table2 t2
ON t1.Friend_ID = t2.Member_ID
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<gurdipv@.gmail.com> wrote in message news:1158075642.788596.64550@.e63g2000cwd.googlegroups.c
om...
> MEMBER_ID FRIEND_ID
> 285 1
> 285 2
> 285 3
>
> Member 285 has 3 friends. Table is set out as above.
>
> Members 1,2 and 3 have their own friends.
>
> MEMBER_ID FRIEND_ID
> 1 286
> 1 1654
> 1 556
> 2 56465
> 2 87864
> 3 564564
> 3 5454
> 3 4588
> 3 4545
>
>
> So from the above we can see that the Friends of Friends count would be
> 9.
>
> Using the above how could I write a query that gave me the answer 9 for
> the member_id 285?
>
> I thank clever person who can help.
>
285 1
285 2
285 3
Member 285 has 3 friends. Table is set out as above.
Members 1,2 and 3 have their own friends.
MEMBER_ID FRIEND_ID
1 286
1 1654
1 556
2 56465
2 87864
3 564564
3 5454
3 4588
3 4545
So from the above we can see that the Friends of Friends count would be
9.
Using the above how could I write a query that gave me the answer 9 for
the member_id 285?
I thank clever person who can help.It's not really clear what you are trying to accomplish here, but for a 'wag
':
SELECT count(1)
FROM Table1 t1
JOIN Table2 t2
ON t1.Friend_ID = t2.Member_ID
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<gurdipv@.gmail.com> wrote in message news:1158075642.788596.64550@.e63g2000cwd.googlegroups.c
om...
> MEMBER_ID FRIEND_ID
> 285 1
> 285 2
> 285 3
>
> Member 285 has 3 friends. Table is set out as above.
>
> Members 1,2 and 3 have their own friends.
>
> MEMBER_ID FRIEND_ID
> 1 286
> 1 1654
> 1 556
> 2 56465
> 2 87864
> 3 564564
> 3 5454
> 3 4588
> 3 4545
>
>
> So from the above we can see that the Friends of Friends count would be
> 9.
>
> Using the above how could I write a query that gave me the answer 9 for
> the member_id 285?
>
> I thank clever person who can help.
>
Subscribe to:
Posts (Atom)