MSDE help

I'm looking for help getting started with MSDE. Anyone have any suggestions?

NoSpamMgbworld
Tue Aug 30 10:09:19 CDT 2005

What specifically are you aiming at?

Overall, learning about SQL Server is a good idea, as MSDE is a subset of
SQL Server. It uses the same T-SQL syntax and contains the basic SQL engine,
albeit with some caveats (5 connections active, size of database, etc.).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************


"Nathan M" wrote:

> I'm looking for help getting started with MSDE. Anyone have any suggestions?

William
Tue Aug 30 16:12:42 CDT 2005

Ah, there is no limit to the number of connections on an MSDE server. The
MSDE governor does kick in (and slow everything down) when there are more
than 5 workloads requested at once, but this is not tied to the number of
connections or users--just how much they try to do at once.
If you're getting started with MSDE, consider SQL Express instead. It's the
2005 version of SQL Server and has no governor at all. Its power and
scalability is limited in other ways.
I'm working with SQL Server Magazine to put together a weekly (?) newsletter
that will focus on SQL Express. I'm also writing a new book that includes
everything you'll ever want to know about SQL Express and its bigger
cousins--but it won't be out for awhile. I want to write about what actually
ships.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Cowboy (Gregory A. Beamer) - MVP" <NoSpamMgbworld@comcast.netNoSpamM> wrote
in message news:1869143D-B998-44B2-B920-972ACDE927B4@microsoft.com...
> What specifically are you aiming at?
>
> Overall, learning about SQL Server is a good idea, as MSDE is a subset of
> SQL Server. It uses the same T-SQL syntax and contains the basic SQL
> engine,
> albeit with some caveats (5 connections active, size of database, etc.).
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> ***************************
> Think Outside the Box!
> ***************************
>
>
> "Nathan M" wrote:
>
>> I'm looking for help getting started with MSDE. Anyone have any
>> suggestions?

NathanM
Wed Aug 31 05:52:03 CDT 2005

I was just wanting to get started on learning SQL Server, and thought I'd
start by playing around with MSDE. I guess I'll stick to the documentation
for now and wait for 2005 to come out before I do any serious reading. I'll
be one of the first to buy your book, Bill.

"William (Bill) Vaughn" wrote:

> Ah, there is no limit to the number of connections on an MSDE server. The
> MSDE governor does kick in (and slow everything down) when there are more
> than 5 workloads requested at once, but this is not tied to the number of
> connections or users--just how much they try to do at once.
> If you're getting started with MSDE, consider SQL Express instead. It's the
> 2005 version of SQL Server and has no governor at all. Its power and
> scalability is limited in other ways.
> I'm working with SQL Server Magazine to put together a weekly (?) newsletter
> that will focus on SQL Express. I'm also writing a new book that includes
> everything you'll ever want to know about SQL Express and its bigger
> cousins--but it won't be out for awhile. I want to write about what actually
> ships.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
>
> "Cowboy (Gregory A. Beamer) - MVP" <NoSpamMgbworld@comcast.netNoSpamM> wrote
> in message news:1869143D-B998-44B2-B920-972ACDE927B4@microsoft.com...
> > What specifically are you aiming at?
> >
> > Overall, learning about SQL Server is a good idea, as MSDE is a subset of
> > SQL Server. It uses the same T-SQL syntax and contains the basic SQL
> > engine,
> > albeit with some caveats (5 connections active, size of database, etc.).
> >
> > --
> > Gregory A. Beamer
> > MVP; MCP: +I, SE, SD, DBA
> >
> > ***************************
> > Think Outside the Box!
> > ***************************
> >
> >
> > "Nathan M" wrote:
> >
> >> I'm looking for help getting started with MSDE. Anyone have any
> >> suggestions?
>
>
>

William
Wed Aug 31 12:18:07 CDT 2005

SQL Express is available now. The CTPs are freely available and downloadable
(if you have the time). I would try to get a copy and start working with
it... good luck. I'll be doing sessions at VSLive in Orlando next month.
Perhaps I'll see you there.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Nathan M" <NathanM@discussions.microsoft.com> wrote in message
news:E77FB41B-02F9-4310-A335-EBB8B44CFD53@microsoft.com...
>I was just wanting to get started on learning SQL Server, and thought I'd
> start by playing around with MSDE. I guess I'll stick to the
> documentation
> for now and wait for 2005 to come out before I do any serious reading.
> I'll
> be one of the first to buy your book, Bill.
>
> "William (Bill) Vaughn" wrote:
>
>> Ah, there is no limit to the number of connections on an MSDE server. The
>> MSDE governor does kick in (and slow everything down) when there are more
>> than 5 workloads requested at once, but this is not tied to the number of
>> connections or users--just how much they try to do at once.
>> If you're getting started with MSDE, consider SQL Express instead. It's
>> the
>> 2005 version of SQL Server and has no governor at all. Its power and
>> scalability is limited in other ways.
>> I'm working with SQL Server Magazine to put together a weekly (?)
>> newsletter
>> that will focus on SQL Express. I'm also writing a new book that includes
>> everything you'll ever want to know about SQL Express and its bigger
>> cousins--but it won't be out for awhile. I want to write about what
>> actually
>> ships.
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>>
>> "Cowboy (Gregory A. Beamer) - MVP" <NoSpamMgbworld@comcast.netNoSpamM>
>> wrote
>> in message news:1869143D-B998-44B2-B920-972ACDE927B4@microsoft.com...
>> > What specifically are you aiming at?
>> >
>> > Overall, learning about SQL Server is a good idea, as MSDE is a subset
>> > of
>> > SQL Server. It uses the same T-SQL syntax and contains the basic SQL
>> > engine,
>> > albeit with some caveats (5 connections active, size of database,
>> > etc.).
>> >
>> > --
>> > Gregory A. Beamer
>> > MVP; MCP: +I, SE, SD, DBA
>> >
>> > ***************************
>> > Think Outside the Box!
>> > ***************************
>> >
>> >
>> > "Nathan M" wrote:
>> >
>> >> I'm looking for help getting started with MSDE. Anyone have any
>> >> suggestions?
>>
>>
>>