Looking for training recommendations in London

Hi,
I've been using Sybase for some years but by employer is moving (you guessed it) to MSSQL.
Can anyone recommend a TSQL and performance tuning training course for MSSQL in the London area?
Thanks,
Rob.Hi rob,

My company usually uses a company called Learning Tree (www.learningtree.co.uk) as one of it contacts for it's training courses.
It just so happens i was reading through there course list today and spotted a course title "SQL Server Transact-SQL Programming: Hands-On"
This covers transact SQL and query performance tuning.
They also have other courses that cover DTS, and a Course developed towards developing "High Performance SQL Server Databases"

Learning tree are situated near Euston Station.
I've never used em but several guys in my office reccomend them.

Hope that helps

Looking for SQL perf analyzing tool

Can anyone recommend a good all-in-one application for analyzing the
performance of 25+ sql servers. We are looking for something that requires
minimal training and implementation time and will tell us which databases
are using the most resources and clearly indicates where tuning and hardware
is needed. Specifically we have more $ than time and dba expertise.
Thanks,
jim
Hi
SQL profiler is the tool that comes with SQL Server that can be used to
analyse this sort of thing, and there are many enhancements in SQL 2005 that
make it even more useful. Failing that you may want to look at products such
as those from Quest http://www.quest.com/sql_server/ or Embarcadero
http://www.embarcadero.com/products/...ter/index.html
John
"Jims" wrote:

> Can anyone recommend a good all-in-one application for analyzing the
> performance of 25+ sql servers. We are looking for something that requires
> minimal training and implementation time and will tell us which databases
> are using the most resources and clearly indicates where tuning and hardware
> is needed. Specifically we have more $ than time and dba expertise.
> Thanks,
> jim
>
>
|||Thanks - these are exactly what I'm looking for.
jim
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:56EEB7AC-2036-4534-9D16-5E6191EA4729@.microsoft.com...[vbcol=seagreen]
> Hi
> SQL profiler is the tool that comes with SQL Server that can be used to
> analyse this sort of thing, and there are many enhancements in SQL 2005
> that
> make it even more useful. Failing that you may want to look at products
> such
> as those from Quest http://www.quest.com/sql_server/ or Embarcadero
> http://www.embarcadero.com/products/...ter/index.html
> John
>
> "Jims" wrote:

Looking for SQL perf analyzing tool

Can anyone recommend a good all-in-one application for analyzing the
performance of 25+ sql servers. We are looking for something that requires
minimal training and implementation time and will tell us which databases
are using the most resources and clearly indicates where tuning and hardware
is needed. Specifically we have more $ than time and dba expertise.
Thanks,
jimHi
SQL profiler is the tool that comes with SQL Server that can be used to
analyse this sort of thing, and there are many enhancements in SQL 2005 that
make it even more useful. Failing that you may want to look at products such
as those from Quest http://www.quest.com/sql_server/ or Embarcadero
http://www.embarcadero.com/products/performancecenter/index.html
John
"Jims" wrote:
> Can anyone recommend a good all-in-one application for analyzing the
> performance of 25+ sql servers. We are looking for something that requires
> minimal training and implementation time and will tell us which databases
> are using the most resources and clearly indicates where tuning and hardware
> is needed. Specifically we have more $ than time and dba expertise.
> Thanks,
> jim
>
>|||Thanks - these are exactly what I'm looking for.
jim
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:56EEB7AC-2036-4534-9D16-5E6191EA4729@.microsoft.com...
> Hi
> SQL profiler is the tool that comes with SQL Server that can be used to
> analyse this sort of thing, and there are many enhancements in SQL 2005
> that
> make it even more useful. Failing that you may want to look at products
> such
> as those from Quest http://www.quest.com/sql_server/ or Embarcadero
> http://www.embarcadero.com/products/performancecenter/index.html
> John
>
> "Jims" wrote:
>> Can anyone recommend a good all-in-one application for analyzing the
>> performance of 25+ sql servers. We are looking for something that
>> requires
>> minimal training and implementation time and will tell us which databases
>> are using the most resources and clearly indicates where tuning and
>> hardware
>> is needed. Specifically we have more $ than time and dba expertise.
>> Thanks,
>> jim
>>

Looking for SQL perf analyzing tool

Can anyone recommend a good all-in-one application for analyzing the
performance of 25+ sql servers. We are looking for something that requires
minimal training and implementation time and will tell us which databases
are using the most resources and clearly indicates where tuning and hardware
is needed. Specifically we have more $ than time and dba expertise.
Thanks,
jimHi
SQL profiler is the tool that comes with SQL Server that can be used to
analyse this sort of thing, and there are many enhancements in SQL 2005 that
make it even more useful. Failing that you may want to look at products such
as those from Quest http://www.quest.com/sql_server/ or Embarcadero
http://www.embarcadero.com/products...nter/index.html
John
"Jims" wrote:

> Can anyone recommend a good all-in-one application for analyzing the
> performance of 25+ sql servers. We are looking for something that require
s
> minimal training and implementation time and will tell us which databases
> are using the most resources and clearly indicates where tuning and hardwa
re
> is needed. Specifically we have more $ than time and dba expertise.
> Thanks,
> jim
>
>|||Thanks - these are exactly what I'm looking for.
jim
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:56EEB7AC-2036-4534-9D16-5E6191EA4729@.microsoft.com...[vbcol=seagreen]
> Hi
> SQL profiler is the tool that comes with SQL Server that can be used to
> analyse this sort of thing, and there are many enhancements in SQL 2005
> that
> make it even more useful. Failing that you may want to look at products
> such
> as those from Quest http://www.quest.com/sql_server/ or Embarcadero
> http://www.embarcadero.com/products...nter/index.html
> John
>
> "Jims" wrote:
>

Looking for good articles/tips/tricks on reporting services.

Hi all,
Does anyone known or recommend for good publisher issues articles which have
good tips/tricks on sql reporting services. Thank you.
LThe Hitchhiker's Guide to SQL Server 2000 Reporting Services is a very good
book.
Brian Welcker has excellent webcasts.
--
Sergio
"Lam Nguyen" wrote:
> Hi all,
> Does anyone known or recommend for good publisher issues articles which have
> good tips/tricks on sql reporting services. Thank you.
>
> L
>|||There are also many sample reports at www.msbicentral.com
--
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
"Lam Nguyen" <LamNguyen@.discussions.microsoft.com> wrote in message
news:0030FA35-6653-414F-B747-70BC142051F9@.microsoft.com...
> Hi all,
> Does anyone known or recommend for good publisher issues articles which
> have
> good tips/tricks on sql reporting services. Thank you.
>
> L
>