|
|
Who is the book for and why should I care about it? |
| |
Microsoft’s new Express suite of products offers a
powerful set of resources for creating database solutions in small
organizations and departments of midsized organizations. Beginning SQL
Server 2005 Express Database Applications shows you how to build fast,
professional, secure business applications using three of the most
powerful components of the Express suite: SQL Server 2005 Express (SSE),
Visual Basic 2005 Express (VBE), and Visual Web Developer Express (VWDE).
The first part of the book, which starts with instructions on how to
download, install, and configure SQL Server Express, focuses on T-SQL
techniques for creating databases, creating database tables, populating
tables with data, and querying that data to answer business issues. You’ll
also learn how to protect your databases from security threats and back
them up so that you can recover your data in the event of a disaster.
The book’s second part shows how to create business applications with
SQL Server Express, using VBE and VWDE. It presents comprehensive code
examples and fully demonstrates the rapid application development tools
that will allow you to build Windows applications and Web applications,
including how to create Windows and Web Forms that display data both
statically and interactively.
This book is supported on my website,
where I provide additional content and examples that will allow you to
refine and extend the techniques described in the book. Whether
you’re a developer building a tactical office/departmental solution, the
administrator who needs to look after it, or simply a hobbyist working on
a home project or nonprofit website, this book will provide you with all
of the essential skills you need to succeed. |
|
|
What is in the book? |
| |
The book contains nearly 600 pages spread across 13
chapters. The full table of
contents is available at this site. Because we include page
numbers, you can see the topics covered as well as the amount of space
devoted to each topic. |
|
|
Is there a listing of reported errata for the book
along with fixes? |
| |
Yes. We have a
page enumerating known errata and fixes. If you discover an
error that we are not listing please leave a comment in our
Guest Book enumerating the problem along with
the page on which it occurs. Thank you, in advance, for helping us
to make the book better for other readers. |
|
|
The Data Sources does not work properly for me.
Can you help me figure out how to solve this problem? |
| |
It is a known problem that the Data Sources window does
not work properly for those who used beta or CTP versions of Visual Studio
2005 or any of the Express suite editions. This problem can exist
even if you use the recommended special uninstall tool. If you are a
former beta or CTP user who cannot get the Data Sources window to operate
properly in Design view, browse either of the following resources for
help:
•
http://blogs.msdn.com/smartclientdata/archive/2005/11/18/494639.aspx
•
https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=142986&SiteID=1 |
|
|
I was using the beta software and I found that I could
refer to columns within a DataGridView control by name, but this no longer
works. The expression making the reference had the following format:
Me.CustomersDataGridView.Columns("CustomerID").Width = 65. How can I
make this expression work again? |
| |
Change the expression to refer to the column by number.
For example, modify your expression to this format:
Me.CustomersDataGridView.Columns(0).Width = 65. |
|
|
I bought the Visual Studio 2005 pro edition upgrade and
got the SQL Server 2005 Developers Edition. Does SSMS come with the
package that I bought? Can I also install SSMS EE for use with SQL
Server 2005 Express? |
| |
SSMS installs with SQL Server 2005 Developer Edition. I
would not try to install the special edition of SSMS for SQL Server 2005
Express on the same computer with a full version of SSMS from the
Developer Edition. However, if you install SQL Server 2005 Express on a
second computer without the SQL Server 2005 Developer Edition, then you
can use SSMS Express Edition on the second computer. The URL for
downloading SSMS EE is at
http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en. |
|
|
Is there a way to get a fast jump start for the content
in the book? |
| |
For those who benefit from from seminar training, we
invite you to consider our
SQL Server Express Database Applications with VB Express and VWD Express
seminar. To learn about this seminar, you can visit the
seminar home page. |
|
|
How do I get my comments listed on this page? |
| |
Sign the Guest Book. Then, fill in the Comment box
with any special info that you want to pass along. We respond to
many of the comments. One day your witty remarks may help to fill
this page. |
