| Author |
Topic |
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
 Posted - 2005-12-14 : 00:45:17
|
| Folks,I'm the project lead for SQL Server Express in Microsoft (as well as owning the Storage Engine). I'm going to make sure that threads on this forum get answered - I see a bunch with no answer so far.Now to the point - we’re in the process of assessing the content that exists to help people learn and use SQL Server Express. This includes demos, tutorials, whitepapers, Webcasts, Starter Kits, and any other type of content you could imagine. So this is a great chance to TELL US WHAT YOU WANT! We’ll integrate your feedback and make sure that we try and address the most requested areas of content. Please be as specific as you can. Thanks in advance for your feedback.Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-12-14 : 12:48:53
|
| Paul,So is Express and XM Manager now available and no longer beta?What I want:I want instructions on how to install Express and connect to it over a network.I also want a best practices example of how to use Express with Access. Like SQL Server, I would imagine everything should be unbound.Perhaps also a C# application that use Express.Also, how about a sample database that has sample code that shows how all the features are built and what they do.Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-14 : 12:58:55
|
"I'm the project lead for SQL Server Express in Microsoft (as well as owning the Storage Engine)"You haven't gone and volunteered for something extra, have you?  Did I hear that PUBS and NORTHWIND aren't there any more?There are lots of examples that utilise those ... perhaps an easy, and documented way, to create & import those DBs for the benefit of training / worked examples?Just thinking out loud really ...Kristen |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-12-14 : 13:52:33
|
| I think I might go a little outside the scope of your question, but this is what I would like to see from microsoft - especially for SQL Express.1. Creation of an official SQL Server client that runs on unix/linux2. Support for python/perl/php/ruby/etc. with officially supported bindings to SQL Server3. Improve the JDBC driver so that it is at least as good as jtds - or better yet contribute to jtds and improve it.I don't think we will ever see this, but I thought I would at least throw it out there. -ec |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-12-14 : 14:22:40
|
Hi Paul,I would like to see a primer on normal forms, relation algebra.Some theoretical background on how a relational database is designed.Just did a search on normal form in BOL(2000)19 hits, none of which were about any normal forms  Regards,Claes Welander |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-12-14 : 14:43:48
|
| Some documentation on the "proper" way to write a query so that the query processor can optimize it and use the right indexes would be nice. This goes along with what RockMoose said.What about some documentation that talks about when you should use TSQL vs .Net for your stored procs.Also, some sort of "why should I upgrade" that we can share with management. I suspect something like this exists already though.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda> |
|
|
|
j_m
Starting Member
3 Posts |
Posted - 2005-12-14 : 18:16:22
|
| I would like to see a tutorial of how to port an access database to SSE. I know that you already have something that explains the process for an older version of SQL Server. However, when I try it, I cant connect to the database.The type of tutorial I would like to see is one where it not only walks you through the process, but also identifies key areas where a new user may experience problems and what to do to overcome them. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-12-14 : 19:10:03
|
quote:
Originally posted by MichaelPWhat about some documentation that talks about when you should use TSQL vs .Net for your stored procs.
I wholeheartedly agree with this, and if you'd like a really good suggestion about which points to cover:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57930Graz's PASS presentation can be downloaded (Zipped Powerpoint) from the link in the first item in that thread. He really nails 99.9% of the common issues facing developers and the things they do wrong as beginners, or just not/never knowing any better. I agree with everyone who also suggested more material on database basics. Since SQL Express is targeted at beginners, students, and other non-database oriented audiences, it would help to include some good foundation before they start jumping into XML Web Services via Service Broker.<tiny rant> In other words, let them know that CREATE TABLE and CREATE INDEX are available and you don't need a .Net procedure to do the same thing. For a change. </tiny rant>  |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-12-15 : 19:44:05
|
| Great stuff folks - thanks for the suggestions. Will see what we can do - keep 'em coming!Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
jmarkjewett
Starting Member
1 Post |
Posted - 2005-12-20 : 21:28:32
|
| Thanks everyone for so much great feedback - and feel free to send more!I've looked through all of the very good feedback above. Some suggested topics do indeed have existing content - I've included pointers below and would welcome feedback on whether the content meets the mark. Some are good suggestions for content to consider - let me know if I've not captured them correctly below. Existing Content: (perhaps we need to do a better job of making people aware of this content)* PUBS/NORTHWIND DBs - http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034* How to configure for network - http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx* C# application that use Express - http://msdn.microsoft.com/vstudio/express/visualcsharp/starterkit/default.aspx#amazon* Why should I upgrade? - http://www.microsoft.com/sql/techinfo/whitepapers/why-upgrade.mspxNew Content needed:* Documentation on best ways to write an optimized query, including indexes.* Stored Procs - when to use T-SQL versus .NET.* Access and SQL Server Express - how to use together, how to migrate.* Always can use more samples* More "basics" content for beginnersIn addition, I'll review Graz's presentation at http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57930 for additional suggestions - thanks for the pointer robvolk.Thanks, MJMark Jewettmajewett@microsoft.comMicrosoft Corporation |
|
|
|
|
What Express content do you want MS to provide?