AjaxLine Books

SQL Server 2000 Fast Answers for DBAs and Developers, Signature Edition

SQL Server 2000 Fast Answers for DBAs and Developers, Signature Edition by Joseph Sack
Publisher: Apress; Book & CD edition (August 15, 2005)
1016 pages; Language: English; ISBN: 1590595920

SQL Server 2000 is the leading relational database for the Windows platform. It?????s a full-featured, enterprise-class database server, but its ease of use and maintenance makes it suitable whether you?????re a junior, part-time, or advanced DBA or developer. SQL Server expert and author Joseph Sack covers all SQL Server 2000 features, so you?????ll be able to rely on this book when you?????re in the field and need quick, effective solutions.

Included are hundreds of practical recipes that describe and demonstrate the utility of a feature or function with the minimum necessary background theory. This quick and effective reference highlights the specifics of every SQL Server command or process. Further, this special signature edition contains a searchable PDF of the book, making it ideal to use as both a desktop reference, and a client-site field guide.

Download: SQL Server 2000 Fast Answers for DBAs and Developers, Signature Edition 9.47 Mb

Pro SQL Server 2005 Reporting Services

Pro SQL Server 2005 Reporting Services by Rodney Landrum, Walter J. Voytek II
Publisher: Apress; 1 edition (October 26, 2005)
400 pages; Language: English; ISBN: 1590594983

SQL Server Reporting Services 2005 is the latest version of the reporting technology from Microsoft, providing the means to design, author, render, and deploy business reports to users, customers, and employees, via the web or the company intranet. The reporting engine is built in to the SQL Server 2005 database (and provided as a free add-on with SQL Server 2000) and the report manager is integrated with Visual Studio 2003, providing an effective and familiar environment for all SQL Server and .NET developers.

The book was written in parallel with a migration project, moving some 200 professional healthcare reports from various reporting architectures to SQL Server Reporting Services, and so is steeped in the day-to-day challenges, discoveries, and successes involved in delivering a successful reporting solution with this technology. In this book, you will find step-by-step guides, best practices, and real code examples that cover all of the common Reporting Services tasks.

Download: Pro SQL Server 2005 Reporting Services 17.52 Mb

Data Mining with SQL Server 2005

Data Mining with SQL Server 2005 by ZhaoHui Tang, Jamie MacLennan
Publisher: Wiley (October 7, 2005)
460 pages; Language: English; ISBN: 0471462616

Your in-depth guide to using the new Microsoft(r) data mining standard to solve today?????s business problems Concealed inside your data warehouse and data marts is a wealth of valuable information just waiting to be discovered. All you need are the right tools to extract that information and put it to use. Serving as your expert guide, this book shows you how to create and implement data mining applications that will find the hidden patterns from your historical datasets. The authors explore the core concepts of data mining as well as the latest trends. They then reveal the best practices in the field, utilizing the innovative features of SQL Server 2005 so that you can begin building your own successful data mining projects.

You?????ll learn: The principal concepts of data mining How to work with the data mining algorithms included in SQL Server data mining How to use DMX-the data mining query language The XML for Analysis API The architecture of the SQL Server 2005 data mining component How to extend the SQL Server 2005 data mining platform by plugging in your own algorithms How to implement a data mining project using SQL Server Integration Services How to mine an OLAP cube How to build an online retail site with cross-selling features How to access SQL Server 2005 data mining features programmatically.

Download: Data Mining with SQL Server 2005 5.01 Mb

Wrox?????s SQL Server 2005 Express Edition Starter Kit

Wrox?????s SQL Server 2005 Express Edition Starter Kit by Rajesh George, Lance Delano
Publisher: Wrox; Bk&CD-Rom edition (January 11, 2006)
384 pages; Language: English; ISBN: 0764589237

You?????ll learn the basics of working with SSE databases, and see how the Visual Basic??? 2005 Express Edition programming environment is tailored to work well with SSE. Step-by-step examples cover major scenarios that you?????re likely to face, from installation and development to debugging and deployment. Plus, the CD-ROM features both VB Express and SSE so you can get started designing your databases right away.

What you will learn from this book

* How to create simple, single table applications without writing a single line of code
* Making the transition from SSE to a higher-level version of SQL Server
* The benefits of using XML in your database
* How to deploy your applications using Xcopy
* How to secure your database applications
* How to move your database to a multi-user scenario

Who this book is for

This book is for database or programming novices who want to create and deploy database applications. It is also useful for experienced developers and independent software vendors who intend to develop applications for SSE. Wrox Starter Kits give you a CD-ROM with the software development tools you need to get started as well as structured tutorials that walk you through all the techniques you need to begin programming right away.

Download: Wrox?????s SQL Server 2005 Express Edition Starter Kit 4.08 Mb

Microsoft SQL Server 2005 For Dummies

Microsoft SQL Server 2005 For Dummies by Andrew Watt
Publisher: For Dummies; Book and CD-ROM edition (February 6, 2006)
432 pages; Language: English; ISBN: 0764577557

Check out enhanced security, Integration Services, Reporting Services, and more. What?????s new in SQL Server 2005? Plenty, and this guide will help make it all clear! You?????ll get the rundown on how to create databases, create queries using the traditional Transact-SQL language, work with the Common Language Runtime, use the new user interface to manage SQL Server 2005, generate business intelligence applications, and more ????? in plain English.

Discover how to:

* Formulate and run queries
* Create databases, tables, and relationships
* Create stored procedures and triggers
* Secure your data and protect it from loss
* Create business intelligence applications
* Maintain a SQL Server system

Download: Microsoft SQL Server 2005 For Dummies 5.74 Mb

Beginning SQL Server 2005 Programming

Beginning SQL Server 2005 Programming by Robert Vieira
Publisher: Wrox (February 20, 2006)
550 pages; Language: English; ISBN: 0764584332

* After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release
* Once readers have grasped the fundamentals of database design and SQL concepts, they will then learn how to implement those concepts with Microsoft SQL Server 2005
* Addresses creating and changing tables, managing keys, database normalization, writing scripts, working with stored procedures, programming with XML, and using SQL Server reporting and data transformation services
* The companion Web site provides all of the code found in the book

Download: Beginning SQL Server 2005 Programming 5.04 Mb

Microsoft SQL Server 2005 Notification Services

Microsoft SQL Server 2005 Notification Services by Shyam Pather
Publisher: Sams; 1st edition (February 14, 2006)
720 pages; Language: English; ISBN: 0672327791

Microsoft SQL Server 2005 Notification Services covers the basic problems of notification applications, describes the SQL Notification Services platform and describes how to use it to build rich, scalable notification applications. Written by Shyam Pather, the Technical Lead for the SQL Notification Services Team, this book is based on his three years of experience teaching SQL Notification Services to new customers. This book is your complete resource for learning SQL Notification Services application development and the underlying architectural concepts.

Download: Microsoft SQL Server 2005 Notification Services 3.07 Mb

MDX Solutions: with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase 2nd edition

MDX Solutions: with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase 2nd edition
Publisher: Wiley; 2 edition (March 6, 2006) by George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi
744 pages; Language: English; ISBN: 0471748080

Serving as both a tutorial and a reference guide to the MDX (Multidimensional Expressions) query language, this book shows data warehouse developers what they need to know to build effective multidimensional data warehouses After a brief overview of the MDX language and a look at how it is used to access data in sophisticated, multidimensional databases and data warehousing, the authors move directly to providing practical examples of MDX in use New material covers changes in the MDX language itself as well as major changes in its implementation with the latest software releases of Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase Also covers more advanced techniques, like aggregation, query templates, and MDX optimization, and shows users what they need to know to access and analyze data to make better business decisions

Download: MDX Solutions: with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase 2nd edition 5.15 Mb

Professional SQL Server 2005 Reporting Services 2Rev Ed edition

Professional SQL Server 2005 Reporting Services by Paul Turley, Todd Bryant, James Counihan, Dave DuVarney
Publisher: Wrox; 2Rev Ed edition (March 6, 2006)
720 pages; Language: English; ISBN: 0764584979

Professional SQL Server Reporting Services can be used by C#, VB, and ASP.NET developers, as well as SQL Server developers who are looking to develop customizable reports for the end user. Professional SQL Server Reporting Services is filled with detailed examples on building reports and designing report solutions, as well as hands-on deployment strategies for interacting with a variety of platforms.

What does this book cover?

This book covers all of the fundamentals of working with Reporting Services. It begins by explaining reporting services architecture and business intelligence. You learn the fundamentals of designing reports and planning considerations, and then move on to advanced report design and filtering techniques. The book also includes saving, retrieving, and rendering reports.

You will discover the specifics of the following:

* Programming reports
* Reporting service namespaces and the object model
* Report scripting
* Rendering scenarios
* Consuming and providing data in the .NET framework
* Browser compatibility considerations
* Designing reporting solutions and deployment strategies

Download: Professional SQL Server 2005 Reporting Services 2Rev Ed edition 13.25 Mb