Is it possible to grant permissions (select, insert, delete, update, exec)
to a db user to all tables and all stored procedures in a specific db in an
easy (lazy!) way?
I mean, except for clicking in all permission checkboxes in Enterprise
Manager or writing a huge sql script like
grant select, insert, delete, update
on mytable1
to myuser
grant select, insert, delete, update
on mytable2
to myuser
...
grant exec
on mySP1
to myuser
grant exec
on mySP2
to myuser
...
?
Is there another way, like
GRANT select, insert, delete, update
on AllMyTables
to myuser
GRANT exec
on AllmySP
to myuser
?You can use a script like to example below to grant mass permissions
according to your requirements.
SET NOCOUNT ON
DECLARE @.GrantStatement nvarchar(500)
DECLARE @.LastError int
DECLARE GrantStatements CURSOR LOCAL FAST_FORWARD FOR
SELECT
N'GRANT ' +
CASE
WHEN OBJECTPROPERTY([ob].[id], 'IsUserTable') = 1 OR
OBJECTPROPERTY([ob].[id], 'IsView') = 1 THEN
N'SELECT, INSERT, UPDATE, DELETE'
WHEN OBJECTPROPERTY([ob].[id], 'IsTableFunction') = 1 OR
OBJECTPROPERTY([ob].[id], 'IsInlineFunction') = 1 THEN
N'SELECT'
WHEN OBJECTPROPERTY([ob].[id], 'IsScalarFunction') = 1 OR
OBJECTPROPERTY([ob].[id], 'IsProcedure') = 1 THEN
N'EXECUTE'
END +
N' ON ' +
QUOTENAME(USER_NAME([ob].[uid])) + '.' + QUOTENAME([ob].[nam
e]) +
N' TO MyRole'
FROM
sysobjects ob
WHERE
OBJECTPROPERTY([ob].[id], 'IsMSShipped') = 0 AND
(OBJECTPROPERTY([ob].[id], 'IsProcedure') = 1 OR
OBJECTPROPERTY([ob].[id], 'IsUserTable') = 1 OR
OBJECTPROPERTY([ob].[id], 'IsView') = 1 OR
OBJECTPROPERTY([ob].[id], 'IsInlineFunction') = 1 OR
OBJECTPROPERTY([ob].[id], 'IsTableFunction') = 1)
OPEN GrantStatements
WHILE 1 = 1
BEGIN
FETCH NEXT FROM GrantStatements INTO @.GrantStatement
IF @.@.FETCH_STATUS = -1 BREAK
RAISERROR (@.GrantStatement, 0, 1) WITH NOWAIT
EXECUTE sp_ExecuteSQL @.GrantStatement
END
CLOSE GrantStatements
DEALLOCATE GrantStatements
Hope this helps.
Dan Guzman
SQL Server MVP
"Siri" <Siri@.discussions.microsoft.com> wrote in message
news:51FFF23E-3543-4A4C-B6FE-8FCE4026CCA3@.microsoft.com...
> Is it possible to grant permissions (select, insert, delete, update, exec)
> to a db user to all tables and all stored procedures in a specific db in
> an
> easy (lazy!) way?
> I mean, except for clicking in all permission checkboxes in Enterprise
> Manager or writing a huge sql script like
> grant select, insert, delete, update
> on mytable1
> to myuser
> grant select, insert, delete, update
> on mytable2
> to myuser
> ...
> grant exec
> on mySP1
> to myuser
> grant exec
> on mySP2
> to myuser
> ...
> ?
> Is there another way, like
> GRANT select, insert, delete, update
> on AllMyTables
> to myuser
> GRANT exec
> on AllmySP
> to myuser
> ?
>|||Thank you very much! This really helped!
Siri
"Dan Guzman" wrote:
> You can use a script like to example below to grant mass permissions
> according to your requirements.
> SET NOCOUNT ON
> DECLARE @.GrantStatement nvarchar(500)
> DECLARE @.LastError int
> DECLARE GrantStatements CURSOR LOCAL FAST_FORWARD FOR
> SELECT
> N'GRANT ' +
> CASE
> WHEN OBJECTPROPERTY([ob].[id], 'IsUserTable') = 1 OR
> OBJECTPROPERTY([ob].[id], 'IsView') = 1 THEN
> N'SELECT, INSERT, UPDATE, DELETE'
> WHEN OBJECTPROPERTY([ob].[id], 'IsTableFunction') = 1 OR
> OBJECTPROPERTY([ob].[id], 'IsInlineFunction') = 1 THEN
> N'SELECT'
> WHEN OBJECTPROPERTY([ob].[id], 'IsScalarFunction') = 1 OR
> OBJECTPROPERTY([ob].[id], 'IsProcedure') = 1 THEN
> N'EXECUTE'
> END +
> N' ON ' +
> QUOTENAME(USER_NAME([ob].[uid])) + '.' + QUOTENAME([ob].&#
91;name]) +
> N' TO MyRole'
> FROM
> sysobjects ob
> WHERE
> OBJECTPROPERTY([ob].[id], 'IsMSShipped') = 0 AND
> (OBJECTPROPERTY([ob].[id], 'IsProcedure') = 1 OR
> OBJECTPROPERTY([ob].[id], 'IsUserTable') = 1 OR
> OBJECTPROPERTY([ob].[id], 'IsView') = 1 OR
> OBJECTPROPERTY([ob].[id], 'IsInlineFunction') = 1 OR
> OBJECTPROPERTY([ob].[id], 'IsTableFunction') = 1)
> OPEN GrantStatements
> WHILE 1 = 1
> BEGIN
> FETCH NEXT FROM GrantStatements INTO @.GrantStatement
> IF @.@.FETCH_STATUS = -1 BREAK
> RAISERROR (@.GrantStatement, 0, 1) WITH NOWAIT
> EXECUTE sp_ExecuteSQL @.GrantStatement
> END
> CLOSE GrantStatements
> DEALLOCATE GrantStatements
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Siri" <Siri@.discussions.microsoft.com> wrote in message
> news:51FFF23E-3543-4A4C-B6FE-8FCE4026CCA3@.microsoft.com...
>
>
Showing posts with label lots. Show all posts
Showing posts with label lots. Show all posts
Monday, March 26, 2012
Monday, March 12, 2012
Good Performance Training
I'm looking for a good SQL Server performance training class - I
finally wore my boss down and he gave me $. I've done lots of Oracle
courses in the past but have had a hard time finding a Microsoft
certified course and I just missed TechEd so I was thinking about this
one:
http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
Kimberley Tripp is a good teacher - it was promoted at the last
Chi-SSUG so I guess its ok? What does everyone else think? Are there
other better things on offer? The dates work for me (gotta do a big
release in Sep so the dust'll settle by then :-)
I want an instructor led classroom course so's I can ask questions
about our own systems and design, and it has to be technical to keep me
interested and I hate it when the teacher is just a page ahead of the
class and knows nothing
TonyCar
Senior Programmer/DBA
Midwest Exchange, IL
Kimberly is an extraordinary speaker, you can't miss with her. Besides her,
Kalen Delaney is just as good - check
http://www.solidqualitylearning.com/...nceTuning.htm.
Yes, women rule :-)
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>
|||I agree with Dejan...
Also consider Scalability Experts, if they are doing anything in your
area... ONe of the SQL MVPs works for them...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>
finally wore my boss down and he gave me $. I've done lots of Oracle
courses in the past but have had a hard time finding a Microsoft
certified course and I just missed TechEd so I was thinking about this
one:
http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
Kimberley Tripp is a good teacher - it was promoted at the last
Chi-SSUG so I guess its ok? What does everyone else think? Are there
other better things on offer? The dates work for me (gotta do a big
release in Sep so the dust'll settle by then :-)
I want an instructor led classroom course so's I can ask questions
about our own systems and design, and it has to be technical to keep me
interested and I hate it when the teacher is just a page ahead of the
class and knows nothing
TonyCar
Senior Programmer/DBA
Midwest Exchange, IL
Kimberly is an extraordinary speaker, you can't miss with her. Besides her,
Kalen Delaney is just as good - check
http://www.solidqualitylearning.com/...nceTuning.htm.
Yes, women rule :-)
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>
|||I agree with Dejan...
Also consider Scalability Experts, if they are doing anything in your
area... ONe of the SQL MVPs works for them...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>
Good Performance Training
I'm looking for a good SQL Server performance training class - I
finally wore my boss down and he gave me $. I've done lots of Oracle
courses in the past but have had a hard time finding a Microsoft
certified course and I just missed TechEd so I was thinking about this
one:
http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
Kimberley Tripp is a good teacher - it was promoted at the last
Chi-SSUG so I guess its ok? What does everyone else think? Are there
other better things on offer? The dates work for me (gotta do a big
release in Sep so the dust'll settle by then :-)
I want an instructor led classroom course so's I can ask questions
about our own systems and design, and it has to be technical to keep me
interested and I hate it when the teacher is just a page ahead of the
class and knows nothing
TonyCar
Senior Programmer/DBA
Midwest Exchange, ILKimberly is an extraordinary speaker, you can't miss with her. Besides her,
Kalen Delaney is just as good - check
http://www.solidqualitylearning.com...anceTuning.htm.
Yes, women rule :-)
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>|||I agree with Dejan...
Also consider Scalability Experts, if they are doing anything in your
area... ONe of the SQL MVPs works for them...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>
finally wore my boss down and he gave me $. I've done lots of Oracle
courses in the past but have had a hard time finding a Microsoft
certified course and I just missed TechEd so I was thinking about this
one:
http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
Kimberley Tripp is a good teacher - it was promoted at the last
Chi-SSUG so I guess its ok? What does everyone else think? Are there
other better things on offer? The dates work for me (gotta do a big
release in Sep so the dust'll settle by then :-)
I want an instructor led classroom course so's I can ask questions
about our own systems and design, and it has to be technical to keep me
interested and I hate it when the teacher is just a page ahead of the
class and knows nothing
TonyCar
Senior Programmer/DBA
Midwest Exchange, ILKimberly is an extraordinary speaker, you can't miss with her. Besides her,
Kalen Delaney is just as good - check
http://www.solidqualitylearning.com...anceTuning.htm.
Yes, women rule :-)
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>|||I agree with Dejan...
Also consider Scalability Experts, if they are doing anything in your
area... ONe of the SQL MVPs works for them...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>
Good Performance Training
I'm looking for a good SQL Server performance training class - I
finally wore my boss down and he gave me $. I've done lots of Oracle
courses in the past but have had a hard time finding a Microsoft
certified course and I just missed TechEd so I was thinking about this
one:
http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
Kimberley Tripp is a good teacher - it was promoted at the last
Chi-SSUG so I guess its ok? What does everyone else think? Are there
other better things on offer? The dates work for me (gotta do a big
release in Sep so the dust'll settle by then :-)
I want an instructor led classroom course so's I can ask questions
about our own systems and design, and it has to be technical to keep me
interested and I hate it when the teacher is just a page ahead of the
class and knows nothing
TonyCar
Senior Programmer/DBA
Midwest Exchange, ILKimberly is an extraordinary speaker, you can't miss with her. Besides her,
Kalen Delaney is just as good - check
http://www.solidqualitylearning.com/Classes/InternalsPerformanceTuning.htm.
Yes, women rule :-)
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>|||I agree with Dejan...
Also consider Scalability Experts, if they are doing anything in your
area... ONe of the SQL MVPs works for them...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>
finally wore my boss down and he gave me $. I've done lots of Oracle
courses in the past but have had a hard time finding a Microsoft
certified course and I just missed TechEd so I was thinking about this
one:
http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
Kimberley Tripp is a good teacher - it was promoted at the last
Chi-SSUG so I guess its ok? What does everyone else think? Are there
other better things on offer? The dates work for me (gotta do a big
release in Sep so the dust'll settle by then :-)
I want an instructor led classroom course so's I can ask questions
about our own systems and design, and it has to be technical to keep me
interested and I hate it when the teacher is just a page ahead of the
class and knows nothing
TonyCar
Senior Programmer/DBA
Midwest Exchange, ILKimberly is an extraordinary speaker, you can't miss with her. Besides her,
Kalen Delaney is just as good - check
http://www.solidqualitylearning.com/Classes/InternalsPerformanceTuning.htm.
Yes, women rule :-)
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>|||I agree with Dejan...
Also consider Scalability Experts, if they are doing anything in your
area... ONe of the SQL MVPs works for them...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>
Subscribe to:
Posts (Atom)