how to manage concurrency between multiple, disconnected clients

I have a system use MS SQL 2005 & .NET 2.0, my tables don't have rowversion, but I heard SQL 2005 manage a rowversion by itself, can I use this to do a "ConflictDetection".

All I try to do is I want to get a error when I try to update a row which been modified by someone else after I read row.

Thanks.

I have never used SQL Server 2005 timestamp field which is what you are referring to as the row version. This is an autoincrementing field when a change is detected and is useful in preventing dirty writes.

I have used this practice in managing phantom data back with SQL Server 2000 just by adding a column of type INT and incrementing it each time the record is changed. Basically this is how it works, when I retrieve the record, I get a version of 1, at the same time another person gets the same record with version 1 as well. This person then updates the record causing it to increment to 2. In the meantime, I decide to update the record as well, your application or database should compare the version number you have which is 1 with the current version number at the database, if it is the same then allow update as this mean no changes were detected. In this case the version is at 2 which means the copy of the data at version 1 when i retrieved it is stale and you would alert the user that either they cannot save until they do a refresh or inform them if the choose to proceed, data will be lost.

Using row versions is optimistic locking as many people can read the same record.

You can also use pessimistic looking by locking the record once you have it. You can do this by using Transactions in .NET (System.Data.SqlClient.Transaction) and specify the Isolation levels.

How to make tables & stored procedures in MSDE?

Hello, I am a beginner using MSDE & Visual Basic.NET standard version (not Visual Studio.NET) . MSDE was downloaded from microsoft.com yesterday, which is sql2ksp3.exe.

The problem is I don't know where to input data to set up tables or stored procedures after configured the MSDE. The MS Desktop Engine pops me "configuration sucessfully", then I can just open a small window with the title of "SQL Server Service Manager", telling me SQL Server is running. But I can't find any SQL application in the Start->All Programs-> for me to run.

What's the human interface of MSDE? Can anybody tell me how you deal with MSDE?

And in my VB.NET's Server Explorer, I find there is only "Data connections" icon which allows me to connect to existing database, and no "Servers" icon as showed in many Visual Studio instruction books, which make me no chance to create new database.

My Windows system is XP professional (SP2) with IIS, .NET framework 1.1 and Server Extensions Adminstrator. What's my problem? Did I configure wrong somewhere? I want to make my computer as a local server. And does the combination of VB.NET + MSDE work?

Thanks a lot for your help! Have a good weekend!

Henry Li

There is no program that comes with msde for managing and creating databases. You can use visual studio 2003's server explorer for that. Here is an example of how to create a database with vb.net

http://www.vb-tips.com/default.aspx?ID=73eab21d-db5f-46b2-8eea-6680e677e994

|||Hello Ken,
Thanks a lot for your quick response, it's the first time for me to join this forum, and first time to get response.

Do you mean I can only use codes to generate database tables and stored procedures? Are all these tables located under the MYPC.master.dbo icon in the Server Explorer? Is there any simpler way that I just right-click something then it gives me an option to "New tables" or "New Database"? (But I don't have the Servers icon in the Server Explorer, did I configure wrong for my VB.NET package?)

And does the MSDE have interface window like Access that can give you a straight-forward and nice looking window to input table data? Can MSDE work independantly without VS.NET's help? I really have no idea how MSDE itself look like. By the way, does SQL Server Express have windows and menus to manipulate data?

I hope my questions are not too many. Thanks a lot in advance for your help!

Best wishes,
Henry Li|||Hi,
You can create databases, tables, etc in visual studio 2003 server explorer also. Right click on databases and select new database. The Sql Server Express is the free 2005 version of msde. You can download a management console for the express edition.
Ken|||

Dear Ken,
You don't really understand my problems yet.
I am using VB.NET package, not VS.NET. The interface and menu are similar, but when I did a help search of "Server Explorer" within it, it told me VB.NET doesn't have the Server node within the Server Explorer, only VS.NET package has it. I just have the first node, which is "Data Connection".

I ran your code in a new project "test1". I pasted it on the WebForms1.aspx.vb, then built it. It generated errors as below:

Build started: Project: test1, Configuration: Debug .NET

Preparing resources...
Updating references...
Performing main compilation...
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(24) : error BC30002: Type 'SqlConnection' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(26) : error BC30182: Type expected.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(27) : error BC30691: 'EventArgs' is a type in 'System' and cannot be used as an expression.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(27) : error BC30800: Method arguments must be enclosed in parentheses.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(27) : error BC30205: End of statement expected.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(33) : error BC30002: Type 'SqlConnection' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(48) : error BC30002: Type 'SqlCommand' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(54) : error BC30451: Name 'MessageBox' is not declared.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(61) : error BC30456: 'Text' is not a member of 'test1.WebForm1'.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(88) : error BC30002: Type 'SqlCommand' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(92) : error BC30002: Type 'SqlException' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(93) : error BC30451: Name 'MessageBox' is not declared.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(113) : error BC30002: Type 'SqlCommand' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(123) : error BC30002: Type 'SqlException' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(124) : error BC30451: Name 'MessageBox' is not declared.
Building satellite assemblies...
Satellite assemblies could not be built because the main project output is missing.

- Done -

Build: 0 succeeded, 1 failed, 0 skipped
I am so dissapointed with VB.NET standard edition, as it seems it can't generate new database, it can just connect to existing database that are already built up.
So I am curious whether MSDE can work independently to let me set up new database, but you ignored my question. I really feel depressed about this combination of VB.NET + MSDE.
You may search on your VS.NET help function for "Server Explorer", it will tell you VB.NET package doesn't have server node.

Thanks & Best regards,
Henry Li

|||Hello Ken,
Visual Basic.NET Standard Edition package is cheaper than VS.NET package. It has less functions than VS.NET package, and cost me $114.
On its package box it mentions it can't build device-based applications and solutions, can't build/debug/deploy powerful server software while VS.NET Professional can.

You said SQL Server Express 2005 is a new version of MSDE, I am just wondering whether it can work like Oracle Plus or Access which can let you have some windows to key in some data?

Thanks a lot!
Henry|||You need a imports system.data.sqlclient at the top of the code file.|||Sorry I thought vb.net standard had the server explorer. Here is a link to download the free sql server 2005 express.

http://msdn.microsoft.com/vstudio/express/sql/

Here is a link to the free management studio for sql server 2005 express

http://www.microsoft.com/downloads/details.aspx?FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en|||Hello Ken,
Thanks a lot! This "imports system.data.sqlclient" really helps!
Now it reduces to only 2 errors left, which are:
--
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(54) : error BC30451: Name 'MessageBox' is not declared. (under the sub createDataBase()->Try/Catch)
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(61) : error BC30456: 'Text' is not a member of 'test1.WebForm1'. (under the sub CreateClientsTable() ->me.Text)
--

I think I might need another line of "imports something"?
Sorry I am a beginner of programming in sql. And want to try your code to see if it can pass through to connect to my MSDE.

By the way, I've downloaded the SQL Server Express and the management console but haven't installed them, and still downloading the 440MB Studio Web Develop Express under the Visual Studio 2005 Express which was issued for free download just 2 weeks ago. I hope this can take place of my VB.NET package.

Thanks a lot again!

Best regards,
Henry|||I wrote that as windows forms application. Messagebox.show is not supported in web application's neither is me.text. Try changing messagebox.show to response.write and me.text = to response.write("The string" & "<br>")|||Hi, I am new one in this forum. About question: "How to make tables & stored procedures in MSDE?", try with command line tool - osql. If you need more help, I am here. Or search MS site about it.

Stevan
|||Hello Ken,
I've downloaded the Visual Web Developer 2005 Express which includes the SQL Server Express, so I installed them both.
The SQL Server 2005 Express is similar to the MSDE, although it has a configuration console, it still can't handle database.
Then I downloaded the SQL Management Studio Express, it's really good! It gives me free choices to deal with security, log-in, creation of new databases!

Then I created a database in the SQLEXPRESS via the management studio console, then in the Visual Web Dev Express I created connection with that new database, it connects!

Now I can creat tables and stored procedures either directly in the SQLEXPRESS's database (via the mgt studio), or indirectly in the Visual Web Dev Express within the database explorer window.

Now I don't use the VB.NET package anymore except if I need to create some windows exe files.

Thank you for your kindness!

Best wishes,
Henry Li|||Thank you Stevan,
I found my problem was some basic things that maybe many people took it for granted while I didn't know.
Actually I need to make a database in the MSDE first, and MSDE has no interface to let me set it up. I need the management software such as the SQL Management Studio 2005 Express.
Now I found this Mgt Studio Express is very useful, it can handle MSDE and SQLEXPRESS. I created some databases with the help of Mgt Studio Express, then I can create tables or procedures!

Best wishes,
Henry|||

Hi,

You can generate tables with osql command, i just need to indicate the command as following:

osql -U user -S server\instancename

then

1> create database test

2> GO

1>use test

2>GO

then you're inside of test database and you are ready to generate your table according you're needed

How to make tables & stored procedures in MSDE?

Hello, I am a beginner using MSDE & Visual Basic.NET standard version (not Visual Studio.NET) . MSDE was downloaded from microsoft.com yesterday, which is sql2ksp3.exe.

The problem is I don't know where to input data to set up tables or stored procedures after configured the MSDE. The MS Desktop Engine pops me "configuration sucessfully", then I can just open a small window with the title of "SQL Server Service Manager", telling me SQL Server is running. But I can't find any SQL application in the Start->All Programs-> for me to run.

What's the human interface of MSDE? Can anybody tell me how you deal with MSDE?

And in my VB.NET's Server Explorer, I find there is only "Data connections" icon which allows me to connect to existing database, and no "Servers" icon as showed in many Visual Studio instruction books, which make me no chance to create new database.

My Windows system is XP professional (SP2) with IIS, .NET framework 1.1 and Server Extensions Adminstrator. What's my problem? Did I configure wrong somewhere? I want to make my computer as a local server. And does the combination of VB.NET + MSDE work?

Thanks a lot for your help! Have a good weekend!

Henry Li

There is no program that comes with msde for managing and creating databases. You can use visual studio 2003's server explorer for that. Here is an example of how to create a database with vb.net

http://www.vb-tips.com/default.aspx?ID=73eab21d-db5f-46b2-8eea-6680e677e994

|||Hello Ken,
Thanks a lot for your quick response, it's the first time for me to join this forum, and first time to get response.

Do you mean I can only use codes to generate database tables and stored procedures? Are all these tables located under the MYPC.master.dbo icon in the Server Explorer? Is there any simpler way that I just right-click something then it gives me an option to "New tables" or "New Database"? (But I don't have the Servers icon in the Server Explorer, did I configure wrong for my VB.NET package?)

And does the MSDE have interface window like Access that can give you a straight-forward and nice looking window to input table data? Can MSDE work independantly without VS.NET's help? I really have no idea how MSDE itself look like. By the way, does SQL Server Express have windows and menus to manipulate data?

I hope my questions are not too many. Thanks a lot in advance for your help!

Best wishes,
Henry Li|||Hi,
You can create databases, tables, etc in visual studio 2003 server explorer also. Right click on databases and select new database. The Sql Server Express is the free 2005 version of msde. You can download a management console for the express edition.
Ken|||

Dear Ken,
You don't really understand my problems yet.
I am using VB.NET package, not VS.NET. The interface and menu are similar, but when I did a help search of "Server Explorer" within it, it told me VB.NET doesn't have the Server node within the Server Explorer, only VS.NET package has it. I just have the first node, which is "Data Connection".

I ran your code in a new project "test1". I pasted it on the WebForms1.aspx.vb, then built it. It generated errors as below:

Build started: Project: test1, Configuration: Debug .NET

Preparing resources...
Updating references...
Performing main compilation...
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(24) : error BC30002: Type 'SqlConnection' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(26) : error BC30182: Type expected.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(27) : error BC30691: 'EventArgs' is a type in 'System' and cannot be used as an expression.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(27) : error BC30800: Method arguments must be enclosed in parentheses.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(27) : error BC30205: End of statement expected.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(33) : error BC30002: Type 'SqlConnection' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(48) : error BC30002: Type 'SqlCommand' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(54) : error BC30451: Name 'MessageBox' is not declared.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(61) : error BC30456: 'Text' is not a member of 'test1.WebForm1'.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(88) : error BC30002: Type 'SqlCommand' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(92) : error BC30002: Type 'SqlException' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(93) : error BC30451: Name 'MessageBox' is not declared.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(113) : error BC30002: Type 'SqlCommand' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(123) : error BC30002: Type 'SqlException' is not defined.
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(124) : error BC30451: Name 'MessageBox' is not declared.
Building satellite assemblies...
Satellite assemblies could not be built because the main project output is missing.

- Done -

Build: 0 succeeded, 1 failed, 0 skipped
I am so dissapointed with VB.NET standard edition, as it seems it can't generate new database, it can just connect to existing database that are already built up.
So I am curious whether MSDE can work independently to let me set up new database, but you ignored my question. I really feel depressed about this combination of VB.NET + MSDE.
You may search on your VS.NET help function for "Server Explorer", it will tell you VB.NET package doesn't have server node.

Thanks & Best regards,
Henry Li

|||Hello Ken,
Visual Basic.NET Standard Edition package is cheaper than VS.NET package. It has less functions than VS.NET package, and cost me $114.
On its package box it mentions it can't build device-based applications and solutions, can't build/debug/deploy powerful server software while VS.NET Professional can.

You said SQL Server Express 2005 is a new version of MSDE, I am just wondering whether it can work like Oracle Plus or Access which can let you have some windows to key in some data?

Thanks a lot!
Henry|||You need a imports system.data.sqlclient at the top of the code file.|||Sorry I thought vb.net standard had the server explorer. Here is a link to download the free sql server 2005 express.

http://msdn.microsoft.com/vstudio/express/sql/

Here is a link to the free management studio for sql server 2005 express

http://www.microsoft.com/downloads/details.aspx?FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en|||Hello Ken,
Thanks a lot! This "imports system.data.sqlclient" really helps!
Now it reduces to only 2 errors left, which are:
--
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(54) : error BC30451: Name 'MessageBox' is not declared. (under the sub createDataBase()->Try/Catch)
c:\inetpub\wwwroot\test1\WebForm1.aspx.vb(61) : error BC30456: 'Text' is not a member of 'test1.WebForm1'. (under the sub CreateClientsTable() ->me.Text)
--

I think I might need another line of "imports something"?
Sorry I am a beginner of programming in sql. And want to try your code to see if it can pass through to connect to my MSDE.

By the way, I've downloaded the SQL Server Express and the management console but haven't installed them, and still downloading the 440MB Studio Web Develop Express under the Visual Studio 2005 Express which was issued for free download just 2 weeks ago. I hope this can take place of my VB.NET package.

Thanks a lot again!

Best regards,
Henry|||I wrote that as windows forms application. Messagebox.show is not supported in web application's neither is me.text. Try changing messagebox.show to response.write and me.text = to response.write("The string" & "<br>")|||Hi, I am new one in this forum. About question: "How to make tables & stored procedures in MSDE?", try with command line tool - osql. If you need more help, I am here. Or search MS site about it.

Stevan|||Hello Ken,
I've downloaded the Visual Web Developer 2005 Express which includes the SQL Server Express, so I installed them both.
The SQL Server 2005 Express is similar to the MSDE, although it has a configuration console, it still can't handle database.
Then I downloaded the SQL Management Studio Express, it's really good! It gives me free choices to deal with security, log-in, creation of new databases!

Then I created a database in the SQLEXPRESS via the management studio console, then in the Visual Web Dev Express I created connection with that new database, it connects!

Now I can creat tables and stored procedures either directly in the SQLEXPRESS's database (via the mgt studio), or indirectly in the Visual Web Dev Express within the database explorer window.

Now I don't use the VB.NET package anymore except if I need to create some windows exe files.

Thank you for your kindness!

Best wishes,
Henry Li|||Thank you Stevan,
I found my problem was some basic things that maybe many people took it for granted while I didn't know.
Actually I need to make a database in the MSDE first, and MSDE has no interface to let me set it up. I need the management software such as the SQL Management Studio 2005 Express.
Now I found this Mgt Studio Express is very useful, it can handle MSDE and SQLEXPRESS. I created some databases with the help of Mgt Studio Express, then I can create tables or procedures!

Best wishes,
Henry|||

Hi,

You can generate tables with osql command, i just need to indicate the command as following:

osql -U user -S server\instancename

then

1> create database test

2> GO

1>use test

2>GO

then you're inside of test database and you are ready to generate your table according you're needed

how to make select query to access view in other server

Dear All,

i am making small web application using asp.net, C# ,sql2000.

i want a about regarding how to access view or table from other server to local server. i have base database where there is a view which need to access in my database of local server.
that is how to make select query to access view in other server

Please help

thanks

You have to add you second server to linked servers (server objects-> linked servers-> right click new linked server) and next in your query use server name in table name like:

select * from [server].[database].dbo.[tablename]

or use open query

Select * from OPENQUERY([servername],'SELECT * from [database].dbo.[tablename]')

second is faster but use it only if your query will hit only data on second server.

Thanks

sql

how to make select query to access view in other server

Dear All,

i am making small web application using asp.net, C# ,sql2000.

i want a about regarding how to access view or table from other server to local server. i have base database where there is a view which need to access in my database of local server.
that is how to make select query to access view in other server
Please help

thanks

there are many ways to access other server.database.table

(a) Configure LinkedServer

b)OPENDATASOURCE

(c) OpenQuery

read about this in BOL

Madhu

How to maintain transaction between two databases?

Hi All,

Pandon me for asking such question, I am still a beginner to ASP.NET.

I have a project that require me to do single operation that is suppose to update two databases, wonder how do I maintain transaction between these two databases? Please advise, thank you!

Are these two different databases ?? Or two different tables in a database ?

If there are two tables inside one database, then you can keep a transaction object of ADO.NET

regards

|||

They are two different database. One database in each server sitting in a WAN. =(

|||

Hi,

To use transactions across database or servers, I suggest you use the TransactionScope class.

Here is an article for your reference.

http://msdn2.microsoft.com/en-us/library/ms973865.aspx

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!

sql

How to load a Legacy DTS Package from .NET?

If I have an object of type "Microsoft.SqlServer.DTS.Runtime.Application,"

can I use one of the following functions
- ExistsOnDTSServer
- ExistsOnSQLServer
- LoadFromDTSServer
- LoadFromSQLServer
- LoadFromSQLServer2

to interact/load with a Legacy (SQL 2000) DTS package, stored on a SQL 2005 machine?

If so, can someone post an example first-argument (the Package Path) ?
Thanks.

I suspect that this is not possible.

Why would you not use the DTS object model to load and run a DTS package? Although it's a COM library, you can certainly use it from .NET...

-Doug|||You're probably right. It was worth someone verifying before assuming correctly/incorrectly.

The "Microsoft DTSPackage Object" COM object is an adequate alternative.
But this would require SQL 2000 Client Tools to be installed on the machine, in addition to SQL 2005 Client Tools, to gain use of both objects.

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
> >
>
>