Showing posts with label analysis. Show all posts
Showing posts with label analysis. Show all posts

Monday, March 19, 2012

How to load Fact table and dimension using SSIS?

Hi All,

I am just curious to know how I can load data from a data warehouse to an Analysis Service Cube (both to the fact tables and dimensions).

Does any body have some way to achieve this?

I appreciate if any body provide me a good material which describe this scenario.

Sincerely,

--Amde

Amde wrote:

Hi All,

I am just curious to know how I can load data from a data warehouse to an Analysis Service Cube (both to the fact tables and dimensions).

Does any body have some way to achieve this?

I appreciate if any body provide me a good material which describe this scenario.

Sincerely,

--Amde

this link should help: http://www.microsoft.com/technet/prodtechnol/sql/2005/rtbissas.mspx

How to load data from a data warehouse to a Cube ?

Hi All,

I am just curious to know how I can load data from a data warehouse to an Analysis Service Cube (both to the fact tables and dimensions). Whenever there is a change in the data warehouse, it should be reflected to the fact table and dimension

Does any body have some way to achieve this?

I appreciate if any body provide me a good material which describe this scenario.

Sincerely,

--Amde

Hi Amde,

You should process your cube, every time that you have news records in your fact table. If you have data every month, for example, then you could use partitions cubes by month.

Good coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

|||

You mean I can load the data automatically using partitions cubes? Because, the thing is we are developing a product that will be delivered to a client. So in this case the user is not supposed to use the analysis service environment to proceess the cube, instead I want to schedule the process so that it will automatically populate the cube with the new records.

Would you please send me a link which talks about this scenario?

Thanks

--Amde

|||

If you open Analysis Services 2005 in management studio and expand the database with the cubes and dimension you want to schedule, you do the following.

Right click on a dimension and choose process. In the dialoge you are presented with you are able to script this command to a file or the clipboard.

After this you expand the SQL Server Agent in SQL Server 2005. Under this you expand job and choose new job(right click). After you choose new step. In this dialoge you paste the code in to the large window att the bottom. Do not forget to change the type of the command to an Analysis Services command.

Repeat this process for each dimension and finally each cube.

When the job is complete you need to add some parameters and command for the job.

You can also build a workflow for processing cubes in SSIS. Perhaps this is easier.

HTH

Thomas Ivarsson

|||

I understand what you are saying. I want to confirm one thing. Let's say we have 6 dimension, we need to create 6 jobs and schedule them at the same time. Am I right saying that?

--Amde

Friday, March 9, 2012

How to limit number of connections in Analysis Services

Hi All,

Our users accesses the OLAP database using excel with large data reporting. When the number of connections reaches to 20-30, the generation of reports becomes very slow. My question is, is there a way in order to limit the number of connections that can access the olap, in this way we can use this approach to let user create their reports by batch with only let say 5 connections.

Thanks...

There is no property or knob allowing you to limit number of connections.

You can use different ways to scale your application. One: is to install several machines and configure them to run as NLB cluster. This way your users will be connecting to the same IP and NLB will distribute the load between several physical machines.

You can try and implement simple application based on the DISCOVER_CONNECTIONS request ( see ActivityViewer sample application for example of it) and starts cancelling any new connections after reaching some threashold.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Wednesday, March 7, 2012

How to learn .Net

Hi there,
I'm a SQL Server professional, specialising in DTS & Analysis Services. I have an appreciation of a few development tools such as Visual Basic v5, Java, C++ although have never developed anything in anger using them.
I read everywhere at the moment that SQL Server professionals need to start getting up to speed with .Net in advance of Yukon and I figured its about time I started doing the same. I also want to satisfy my own curiosity about the "new world" of .Net.
What is the best way to start for someone with my background? A SQL Server-centric learning curve would be preferable.
thanks in advance
Jamie Thomson
Jamie,
I think this is a rather subjective question. Some people learn best in
a classroom where they can intereact with a teacher. Others prefer to
learn from a book where they can work at their own pace and try the
demos and examples in the book. Others prefer to just dive in and start
"hacking around" by referring to the MSDN Library when they get stuck.
You need to decide on whether you would benefit more from a structured
learning experience, i.e. classroom training, or a self-paced
experience, such as books, online learning libraries, or MELL.
I personally prefer a classroom experience for something that I am
totally new to, and once I have grasped the basics, I prefer to learn
from books or some other form of self paced learning.
Horses for courses...
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jamie wrote:
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I have an appreciation of a few development tools such as Visual Basic v5, Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to start getting up to speed with .Net in advance of Yukon and I figured its about time I started doing the same. I also want to satisfy my own curiosity about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>
|||Jamie,
a really good place to start is the Modern Software Development seminar
series by Joe Hummel as per link below. VB focussed but does a great job of
explaining the concepts / issues. Also a lot of real world stuff , about
when its best to use certain language / .Net features etc that is missing
from a lot of the other stuff I've seen.
http://msdn.microsoft.com/vbasic/com...n/default.aspx
Andy.
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>
|||Mark,
Classroom learning is not an option as I intend to do this off my own back and can't afford a course.
I guess I'm looking for advice on either:
a) Good books for beginners or
b) Free online training resources.
Any advice from someone in the know as to what I should concentrate on would be useful as well.
Thanks for the reply Mark, thats very useful.
Regards
Jamie Thomson
"Mark Allison" wrote:
[vbcol=seagreen]
> Jamie,
> I think this is a rather subjective question. Some people learn best in
> a classroom where they can intereact with a teacher. Others prefer to
> learn from a book where they can work at their own pace and try the
> demos and examples in the book. Others prefer to just dive in and start
> "hacking around" by referring to the MSDN Library when they get stuck.
> You need to decide on whether you would benefit more from a structured
> learning experience, i.e. classroom training, or a self-paced
> experience, such as books, online learning libraries, or MELL.
> I personally prefer a classroom experience for something that I am
> totally new to, and once I have grasped the basics, I prefer to learn
> from books or some other form of self paced learning.
> Horses for courses...
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Jamie wrote:

>
|||Hi Jamie
Fernando Guerrero, from my company Solid Quality Learning, has offered a
seminar at various conferences on .NET for the DBA, designed for just this
purpose and is VERY SQL Server centric. We are looking at ways to allow
Fernando to deliver this online in a publicly available format and should
have something scheduled by the end of the summer. Information will be
available on our site when we have all the details in place.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>
|||I agree with Kalen, than Fernando would do an excellent job... You might
also try out some books like the Hitchihikers guide ( if there is a version
for Dot. Net.)
Companies like Learnkey also provide CD, and video based training
(www.learnkey.com)...
Getting involved with a local dot net group would be helpful as well.. (
Perhaps INETA (www.ineta.org) )
And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
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
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>
|||Jamie,
if you're already familiar with VB 5/6 then I highly recommend this book:
http://www.amazon.co.uk/exec/obidos/...043104-6361455
Regards,
Paul Ibison
|||Thank you to all. Some very useful information there.
I shall check out Andy's link immediately. Kalen, I'll keep a check on your site as well.
Thanks again all.
"Wayne Snyder" wrote:

> I agree with Kalen, than Fernando would do an excellent job... You might
> also try out some books like the Hitchihikers guide ( if there is a version
> for Dot. Net.)
> Companies like Learnkey also provide CD, and video based training
> (www.learnkey.com)...
> Getting involved with a local dot net group would be helpful as well.. (
> Perhaps INETA (www.ineta.org) )
> And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
> --
> 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
> "Jamie" <Jamie@.discussions.microsoft.com> wrote in message
> news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> have an appreciation of a few development tools such as Visual Basic v5,
> Java, C++ although have never developed anything in anger using them.
> start getting up to speed with .Net in advance of Yukon and I figured its
> about time I started doing the same. I also want to satisfy my own curiosity
> about the "new world" of .Net.
> Server-centric learning curve would be preferable.
>
>

How to learn .Net

Hi there,
I'm a SQL Server professional, specialising in DTS & Analysis Services. I ha
ve an appreciation of a few development tools such as Visual Basic v5, Java,
C++ although have never developed anything in anger using them.
I read everywhere at the moment that SQL Server professionals need to start
getting up to speed with .Net in advance of Yukon and I figured its about ti
me I started doing the same. I also want to satisfy my own curiosity about t
he "new world" of .Net.
What is the best way to start for someone with my background? A SQL Server-c
entric learning curve would be preferable.
thanks in advance
Jamie ThomsonJamie,
I think this is a rather subjective question. Some people learn best in
a classroom where they can intereact with a teacher. Others prefer to
learn from a book where they can work at their own pace and try the
demos and examples in the book. Others prefer to just dive in and start
"hacking around" by referring to the MSDN Library when they get stuck.
You need to decide on whether you would benefit more from a structured
learning experience, i.e. classroom training, or a self-paced
experience, such as books, online learning libraries, or MELL.
I personally prefer a classroom experience for something that I am
totally new to, and once I have grasped the basics, I prefer to learn
from books or some other form of self paced learning.
Horses for courses...
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jamie wrote:
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5, Jav
a, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to star
t getting up to speed with .Net in advance of Yukon and I figured its about
time I started doing the same. I also want to satisfy my own curiosity about
the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL Server
-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Jamie,
a really good place to start is the Modern Software Development seminar
series by Joe Hummel as per link below. VB focussed but does a great job of
explaining the concepts / issues. Also a lot of real world stuff , about
when its best to use certain language / .Net features etc that is missing
from a lot of the other stuff I've seen.
http://msdn.microsoft.com/vbasic/co...rn/default.aspx
Andy.
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Mark,
Classroom learning is not an option as I intend to do this off my own back a
nd can't afford a course.
I guess I'm looking for advice on either:
a) Good books for beginners or
b) Free online training resources.
Any advice from someone in the know as to what I should concentrate on would
be useful as well.
Thanks for the reply Mark, thats very useful.
Regards
Jamie Thomson
"Mark Allison" wrote:

> Jamie,
> I think this is a rather subjective question. Some people learn best in
> a classroom where they can intereact with a teacher. Others prefer to
> learn from a book where they can work at their own pace and try the
> demos and examples in the book. Others prefer to just dive in and start
> "hacking around" by referring to the MSDN Library when they get stuck.
> You need to decide on whether you would benefit more from a structured
> learning experience, i.e. classroom training, or a self-paced
> experience, such as books, online learning libraries, or MELL.
> I personally prefer a classroom experience for something that I am
> totally new to, and once I have grasped the basics, I prefer to learn
> from books or some other form of self paced learning.
> Horses for courses...
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Jamie wrote:
[vbcol=seagreen]
>|||Hi Jamie
Fernando Guerrero, from my company Solid Quality Learning, has offered a
seminar at various conferences on .NET for the DBA, designed for just this
purpose and is VERY SQL Server centric. We are looking at ways to allow
Fernando to deliver this online in a publicly available format and should
have something scheduled by the end of the summer. Information will be
available on our site when we have all the details in place.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||I agree with Kalen, than Fernando would do an excellent job... You might
also try out some books like the Hitchihikers guide ( if there is a version
for Dot. Net.)
Companies like Learnkey also provide CD, and video based training
(www.learnkey.com)...
Getting involved with a local dot net group would be helpful as well.. (
Perhaps INETA (www.ineta.org) )
And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
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
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Jamie,
if you're already familiar with VB 5/6 then I highly recommend this book:
361455" target="_blank">http://www.amazon.co.uk/exec/obidos...6
361455
Regards,
Paul Ibison|||Thank you to all. Some very useful information there.
I shall check out Andy's link immediately. Kalen, I'll keep a check on your
site as well.
Thanks again all.
"Wayne Snyder" wrote:

> I agree with Kalen, than Fernando would do an excellent job... You might
> also try out some books like the Hitchihikers guide ( if there is a versio
n
> for Dot. Net.)
> Companies like Learnkey also provide CD, and video based training
> (www.learnkey.com)...
> Getting involved with a local dot net group would be helpful as well.. (
> Perhaps INETA (www.ineta.org) )
> And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
> --
> 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
> "Jamie" <Jamie@.discussions.microsoft.com> wrote in message
> news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> have an appreciation of a few development tools such as Visual Basic v5,
> Java, C++ although have never developed anything in anger using them.
> start getting up to speed with .Net in advance of Yukon and I figured its
> about time I started doing the same. I also want to satisfy my own curiosi
ty
> about the "new world" of .Net.
> Server-centric learning curve would be preferable.
>
>

How to learn .Net

Hi there,
I'm a SQL Server professional, specialising in DTS & Analysis Services. I have an appreciation of a few development tools such as Visual Basic v5, Java, C++ although have never developed anything in anger using them.
I read everywhere at the moment that SQL Server professionals need to start getting up to speed with .Net in advance of Yukon and I figured its about time I started doing the same. I also want to satisfy my own curiosity about the "new world" of .Net.
What is the best way to start for someone with my background? A SQL Server-centric learning curve would be preferable.
thanks in advance
Jamie ThomsonJamie,
I think this is a rather subjective question. Some people learn best in
a classroom where they can intereact with a teacher. Others prefer to
learn from a book where they can work at their own pace and try the
demos and examples in the book. Others prefer to just dive in and start
"hacking around" by referring to the MSDN Library when they get stuck.
You need to decide on whether you would benefit more from a structured
learning experience, i.e. classroom training, or a self-paced
experience, such as books, online learning libraries, or MELL.
I personally prefer a classroom experience for something that I am
totally new to, and once I have grasped the basics, I prefer to learn
from books or some other form of self paced learning.
Horses for courses...
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jamie wrote:
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I have an appreciation of a few development tools such as Visual Basic v5, Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to start getting up to speed with .Net in advance of Yukon and I figured its about time I started doing the same. I also want to satisfy my own curiosity about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Jamie,
a really good place to start is the Modern Software Development seminar
series by Joe Hummel as per link below. VB focussed but does a great job of
explaining the concepts / issues. Also a lot of real world stuff , about
when its best to use certain language / .Net features etc that is missing
from a lot of the other stuff I've seen.
http://msdn.microsoft.com/vbasic/community/webcasts/modern/default.aspx
Andy.
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Hi Jamie
Fernando Guerrero, from my company Solid Quality Learning, has offered a
seminar at various conferences on .NET for the DBA, designed for just this
purpose and is VERY SQL Server centric. We are looking at ways to allow
Fernando to deliver this online in a publicly available format and should
have something scheduled by the end of the summer. Information will be
available on our site when we have all the details in place.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||I agree with Kalen, than Fernando would do an excellent job... You might
also try out some books like the Hitchihikers guide ( if there is a version
for Dot. Net.)
Companies like Learnkey also provide CD, and video based training
(www.learnkey.com)...
Getting involved with a local dot net group would be helpful as well.. (
Perhaps INETA (www.ineta.org) )
And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
--
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
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Jamie,
if you're already familiar with VB 5/6 then I highly recommend this book:
http://www.amazon.co.uk/exec/obidos/ASIN/0672322641/qid%3D1088783844/202-5043104-6361455
Regards,
Paul Ibison|||Thank you to all. Some very useful information there.
I shall check out Andy's link immediately. Kalen, I'll keep a check on your site as well.
Thanks again all.
"Wayne Snyder" wrote:
> I agree with Kalen, than Fernando would do an excellent job... You might
> also try out some books like the Hitchihikers guide ( if there is a version
> for Dot. Net.)
> Companies like Learnkey also provide CD, and video based training
> (www.learnkey.com)...
> Getting involved with a local dot net group would be helpful as well.. (
> Perhaps INETA (www.ineta.org) )
> And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
> --
> 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
> "Jamie" <Jamie@.discussions.microsoft.com> wrote in message
> news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> > Hi there,
> > I'm a SQL Server professional, specialising in DTS & Analysis Services. I
> have an appreciation of a few development tools such as Visual Basic v5,
> Java, C++ although have never developed anything in anger using them.
> >
> > I read everywhere at the moment that SQL Server professionals need to
> start getting up to speed with .Net in advance of Yukon and I figured its
> about time I started doing the same. I also want to satisfy my own curiosity
> about the "new world" of .Net.
> >
> > What is the best way to start for someone with my background? A SQL
> Server-centric learning curve would be preferable.
> >
> > thanks in advance
> >
> > Jamie Thomson
> >
>
>