Since 1994 when he wrote his first “Hitchhiker’s Guide”, William Vaughn has been providing developers all over the world the intimate details of how SQL Server can be accessed and managed from RAD languages like Visual Basic and Visual Basic .NET. With the 7th Edition, Bill has completely rewritten this encyclopedic work from cover to cover–giving readers his insightful views on how applications should be built to maximize both developer and code performance. Visual Studio and the languages it hosts have never been as sophisticated as they are today–the same can be said for SQL Server. This makes it even more important for developers to understand how to best leverage their features without being held back by their complexity. That’s what this book is all about–making it easier for developers regardless of their know-how.

The Delta Guide to Exchange 2003 has been designed to become an invaluable resource to existing Exchange administrators, allowing you to quickly come up to speed on new features and functionality in Exchange, building on the knowledge and experience you already possess. The “Delta” series is designed to allow IT professionals to quickly update your skills based on what has changed between the previous and current software release. This book is for you if you are a system administrator who is responsible for administering a previous Exchange installation (v5.5 or 2000) or if you are an IT professional who has some experience with a previous version of Exchange and wish to update your skills. This book covers changes in installation, configuration, administration, clustering, security and many other important topics.

The purpose of this book is to help you build relational databases and get valuable information out of them by using SQL. SQL is the international standard language used around the world to create and maintain relational databases. This edition covers the latest version of the standard, SQL:2003, as augmented in 2005 with a thorough treatment of the use of XML with SQL.

This book doesn’t tell you how to design a database (I do that in Database Development For Dummies, also published by Wiley Publishing, Inc.). Here I assume that you or somebody else has already created a valid design. I then illustrate how you implement that design by using SQL. If you suspect that you don’t have a good database design, by all means, fix your design before you try to build the database. The earlier you detect and correct problems in a development project, the cheaper the corrections will be.

If you need to store or retrieve data from a DBMS, you can do a much better job with a working knowledge of SQL. You don’t need to be a programmer to use SQL, and you don’t need to know programming languages, such as Java, C, or BASIC. SQL’s syntax is like English.

If you are a programmer, you can incorporate SQL into your programs. SQL adds powerful data manipulation and retrieval capability to conventional languages. This book tells you what you need to know to use SQL’s rich assortment of tools and features inside your programs.

Author(s): Michael Kofler,
Publisher: Apress
Year: 2005
ISBN: 1-59059-535-1
Language: English
File type: PDF
Pages: 784
Size (for download): 9.64 MB


This book provides a complete application- and example-oriented introduction to the database system MySQL. No previous knowledge of SQL or database design is assumed.

MySQL is on the verge of repeating in the database market the success achieved by Linux in the operating system sector. In combination with PHP or Perl, MySQL is increasingly used as the database system for web sites. (A favorite combination is Linux + Apache + MySQL + Perl or PHP. Such systems are called “LAMP systems” for short.) MySQL is not just for small web sites; it is used by large firms with huge amounts of data, such as Yahoo!, Slashdot, and NASA.

Author(s): George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi
Publisher: Wiley
Year: 2006
ISBN: 0-471-74808-0
Language: English
File type: PDF
Pages: 746
Size (for download): 4.92 MB

Dimensional applications are best and most easily built using a dimensional language. These dimensional applications are typified by the related notions of OLAPand dimensional data warehouses and marts. MDX (for MultiDimensional eXpressions) is the most widely accepted software language used for these applications. The book you read here, MDX Solutions, is the second edition of a guide to learning and using MDX. Since the first edition of MDX Solutions, the number of analytical applications that use MDX has grown very large, and several more servers and many third-party and homegrown client tools now allow you to use MDX to express the logic you use to calculate and to retrieve your information.

As a language, MDX is rather different in style and feel from SQL, and quite different from other programming languages like C++, C#, Lisp, Fortran, and so on. You can think of the formula language of a spreadsheet like Excel as another programming language, and while it is different than Excel, characterizing MDX as a sort of Excel-like SQL or a SQL-like Excel seems more apt than any other analogy. (If you’re familiar with other OLAP query or calculation languages, it has more in common with them, but many readers will not be.)