For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly "administrative," duties that have become much more complicated and difficult. With that in mind, a team of experienced Microsoft Certified Professionals provides you with the necessary information to be a more competent and successful database developer or administrator. 
Beginning with a foundation that features detailed coverage of typical administrative duties, the authors proceed to explain how to build complex data transformations for data import, build distributed data solutions, and maintain the security and integrity of the database. You will be able to apply what you learn to real-world scenarios, and smoothly navigate the vastly changed landscape of SQL Server 2005 administration. What you will learn from this book <ul>
<li>How to install, maintain, and manage an SQL Server 2005 installation, including high availability and security considerations</li> <li>Various features such as the Common Language Runtime, SQL Server Integration Services, Notification Service, and the Service Broker</li> <li>How to use the tools that are necessary to manage configuration, backups, restores, security, availability, performance, and monitoring</li> <li>A sampling of some of the more advanced areas and complex jobs of the broadening role of a database administrator in the enterprise</li> </ul>
Who this book is for This book is for both developers and administrators who are responsible for the management and maintenance of an SQL Server 2005 database. Familiarity with relational database concepts and SQL is assumed. Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved. Enhance Your Knowledge Advance Your Career

Beginning SQL Server 2005 Administration

Computers & Technology

Turley, Paul

Wood, Dan

Leiter, Chris

Databases & Big Data

Wrox

<ul>
<li>Teaches solution architects, designers, and developers how to use Microsoft's reporting platform to create reporting and business intelligence (BI) solutions</li> <li>Updated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenarios</li> <li>Includes programming examples focused on specific, scenario-based solutions</li> <li>Explains reporting services architecture and business intelligence, teaches the fundamentals of designing reports through the use of careful planning considerations, and covers advanced report design and filtering techniques</li> </ul>

Professional Microsoft SQL Server 2008 Reporting Services

Withee, Ken

Silva, Thiago

Smith, Bryan C.

Programming

Transact-SQL, or T-SQL, is Microsoft Corporation's powerful implementation of the ANSI standard SQL database query language, which was designed to retrieve, manipulate, and add data to relational database management systems (RDBMS).
You may already have a basic idea of what SQL is used for, but you may not have a good understanding of the concepts behind relational databases and the purpose of SQL. This book will help you build a solid foundation of understanding, beginning with core relational database concepts and continuing to reinforce those concepts with real-world T-SQL query applications.
If you are familiar with relational database concepts but are new to Microsoft SQL Server or the T-SQL language, this book will teach you the basics from the ground up. If you're familiar with earlier versions of SQL Server, it will get you up-to-speed on the newest features. And if you know SQL Server 2005, you'll learn about some exciting new capabilities in SQL Server 2008.
Information Technology professionals in many different roles use T-SQL. Our goal is to provide a guide and a reference for IT pros across the spectrum of operational database solution design, database application development, and reporting and business intelligence solutions.
Database solution designers will find this book to be a thorough introduction and comprehensive reference for all aspects of database modeling, design, object management, query design, and advanced query concepts.
Application developers who write code to manage and consume SQL Server data will benefit from our thorough coverage of basic data management and simple and advanced query design. Several examples of ready-to-use code are provided to get you started and to continue to support applications with embedded T-SQL queries.
Report designers will find this book to be a go-to reference for report query design. You will build on a thorough introduction to basic query concepts and learn to write efficient queries to support business reports and advanced analytics.
Finally, database administrators who are new to SQL Server will find this book to be an all-inclusive introduction and reference of mainstream topics. This can assist you as you support the efforts of other team members. Beyond the basics of database object management and security concepts, we recommend Beginning SQL Server 2005 Administration and Beginning SQL Server 2008 Administration from Wrox, co-authored in part by the same authors.
This book introduces the T-SQL language and its many uses, and serves as a comprehensive guide at a beginner through intermediate level. Our goal in writing this book was to cover all the basics thoroughly and to cover the most common applications of T-SQL at a deeper level. Depending on your role and skill level, this book will serve as a companion to the other Wrox books in the Microsoft SQL Server Beginning and Professional series..
This book will help you to learn:
<ul>
<li>How T-SQL provides you with the means to create tools for managing databases of different size, scope, and purpose</li>
<li>Various programming techniques that use views, user-defined functions, and stored procedures</li>
<li>Ways to optimize query performance</li>
<li>How to create databases that will be an essential foundation to applications you develop later</li>
</ul>
Each section of this book organizes topics into logical groups so the book can be read cover-to-cover or can be used as a reference guide for specific topics.
We start with an introduction to the T-SQL language and data management systems, and then continue with the SQL Server product fundamentals. This first section teaches the essentials of the SQL Server product architecture and relational database design principles. This section (Chapters 1–3) concludes with an introduction to the SQL Server administrator and developer tools.
The next section, encompassing Chapters 4 through 9, introduces the T-SQL language and teaches the core components of data retrieval, SQL functions, aggregation and grouping, and multi-table queries. We start with the basics and build on the core structure of the SQL SELECT statement, progressing to advanced forms of SELECT queries.
Chapter 10 introduces transactions and data manipulation. You will learn how the INSERT, UPDATE, and DELETE statements interact with the relational database engine and transaction log to lock and modify data rows with guaranteed consistency. You will not only learn to use correct SQL syntax but will understand how this process works in simple terms.
More advanced topics in the concluding section will teach you to create and manage T-SQL programming objects, including views, functions, and stored procedures. You learn to optimize query performance and use T-SQL in application design, applying the query design basics to real-world business solutions. Chapter 15 contains a complete tutorial on using SQL Server 2008 Reporting Services to visualize data from the T-SQL queries you create.
The book concludes with a comprehensive set of reference appendixes for command syntax, system stored procedures, information schema views, file system commands, and system management commands.
The material in this book applies to all editions of Microsoft SQL Server 2005 and 2008. To use all the features discussed, we recommend that you install the Developer Edition, although you can also use the Enterprise, Standard, or Workgroup editions.
SQL Server 2005 Developer Edition or SQL Server 2008 Developer Edition can be installed on a desktop computer running Windows 2000, Windows XP, or Windows Vista. You can also use Windows 2000 Server, Windows Server 2003, or Windows Server 2008 with the Enterprise or Standard edition. The SQL Server client tools must be installed on your desktop computer and the SQL Server relational database server must be installed on either your desktop computer or on a remote server with network connectivity and permission to access.
Consult www.microsoft.com/sql for information about the latest service packs, specific compatibilities, and minimum recommend system requirements.
The examples throughout this book use the following sample databases, which are available to download from Microsoft: the sample database for SQL Server 2005 is called AdventureWorks, and the sample database for SQL Server 2008 is called AdventureWorks2008. Because the structure of these databases differs significantly, separate code samples are provided throughout the book for these two version-specific databases.
An example using the AdventureWorks2008DW database for SQL Server 2008 is also used in Chapter 15.

Beginning T-SQL with Microsoft SQL Server 2005 and 2008

Reference

Wrox Pr Inc

Learn to design more effective and sophisticated business reports While most users of SQL Server Reporting Services are now comfortable designing and building simple reports, business today demands increasingly complex reporting. In this book, top Reporting Services design experts have contributed step-by-step recipes for creating various types of reports. Written by well-known SQL Server Reporting Services experts, this book gives you the tools to meet your clients' needs

Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports

Bruckner, Robert M.

Networking & Cloud Computing

What is this book about? SQL Server Reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET. Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of a revolutionary new tool. What does this book cover? Here are just some of the things you'll learn in this book: <ul>
<li>Details of programming reports and report scripting</li> <li>Advanced report design, including drill-down reports, nested lists, drill-through, links, and dynamic content</li> <li>How to manage reports using Report Manager or program code</li> <li>High-level strategies for business support systems</li> <li>Rendering reports using .NET code, .NET IO namespace classes, and URL rendering</li> <li>Deployment strategies to handle hardware, software, and platform considerations, licensing issues, and scaling options</li> </ul>
Who is this book for? This book is for developers and report designers using VB, C#, and ASP.NET who need to tie into SQL Server to build customized reports or to integrate reports into Windows or Web-based applications.

Professional SQL Server Reporting Services

Bryant, Todd

Counihan, James

McKee, George

DuVarney, Dave

Programming Languages

Beginning Transact-SQL with SQL Server 2000 and 2005 Transact-SQL is a powerful implementation of the ANSI standard SQL database query language. In order to build effective database applications, you must gain a thorough understanding of these features. This book provides you with a comprehensive introduction to the T-SQL language and shows you how it can be used to work with both the SQL Server 2000 and 2005 releases. Beginning with an overview of the SQL Server query operations and tools that are used with T-SQL, the author goes on to explain how to design and build applications of increasing complexity. By gaining an understanding of the power of the T-SQL language, you'll be prepared to meet the ever-increasing demands of programming. What you will learn from this book <ul>
<li>How T-SQL provides you with the means to create tools for managing hundreds of databases</li> <li>Various programming techniques that use views and stored procedures</li> <li>Ways to optimize query performance</li> <li>How to create databases that will be an essential foundation to applications you develop later</li> </ul>
Who this book is for This book is for database developers and administrators who have not yet programmed with Transact-SQL. Some familiarity with relational databases and basic SQL is helpful, and some programming experience is helpful. Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Beginning Transact-SQL With SQL Server 2000 and 2005

A must-have guide for the latest updates to the new release of Reporting ServicesSQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions. With this updated resource, a team of experts shows you how Reporting Services makes reporting faster, easier and more powerful than ever in web, desktop, and portal solutions. New coverage discusses the new reporting tool called Crescent, BI semantic model's impact on report design and creation, semantic model design, and more. You'll explore the major enhancements to Report Builder and benefit from best practices shared by the authors.
<ul>
<li>Builds on the previous edition while also providing coverage of the new features introduced with SQL Server 2012</li>
<li>Explains Reporting Services architecture and BI fundamentals </li>
<li>Covers advanced report design and filtering techniques, walking you through each design, discussing its purpose and the conditions where it could be more efficient </li>
<li>Discusses semantic model design, Report Builder, Crescent, and more </li>
<li>Targets business analysts and report designers as well as BI solution developers </li>
</ul>
Professional Microsoft SQL Server 2012 Reporting Services is mandatory reading if you are eager to start using the newest version of SQL Server Reporting Services.

Professional Microsoft SQL Server 2012 Reporting Services

Paisley, Grant

Optimize reporting and BI with Microsoft SQL Server 2016 Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach. You'll learn effective report solution design based upon many years of experience with successful report solutions. Improve your own reports with advanced, best-practice design, usability, query design, and filtering techniques. Expert guidance provides insight into common report types and explains where each could be made more efficient, while providing step-by step instruction on Microsoft SQL Server 2016. All changes to the 2016 release are covered in detail, including improvements to the Visual Studio Report Designer (SQL Server Data Tools) and Report Builder, Mobile Dashboard Designer, the new Report Portal Interface, HTML-5 Rendering, Power BI integration, Custom Parameters Pane, and more. The Microsoft SQL Server 2016 release will include significant changes. New functionality, new capabilities, re-tooled processes, and changing support require a considerable update to existing knowledge. Whether you're starting from scratch or simply upgrading, this book is an essential guide to report design and business intelligence solutions. <ul>
<li>Understand BI fundamentals and Reporting Services architecture</li> <li>Learn the ingredients to a successful report design</li> <li>Get up to speed on Microsoft SQL Server 2016</li> <li>Grasp the purpose behind common designs to optimize your reporting</li> </ul>
Microsoft SQL Server Reporting Services makes reporting faster, easier, and more powerful than ever in web, desktop and portal solutions. Compatibility with an extensive variety of data sources makes it a go-to solution for organizations across the globe. The 2016 release brings some of the biggest changes in years, and the full depth and breadth of these changes can create a serious snag in your workflow. For a clear tutorial geared toward the working professional, Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports is the ideal guide for getting up to speed and producing successful reports.

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports (Wrox Professional Guides)

If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-on recipes, helping you get to grips with SQL Server Analysis Services fast. Overview <ul>
<li>Develop Business Intelligence solutions using a multi-dimensional model as well as a tabular model</li> <li>Explore cube maintenance with partitions and design effective aggregations, as well as analyzing options for scaling analytics solutions</li> <li>Includes recipes for administering, securing, monitoring, and troubleshooting Analysis Services solutions</li> </ul>
In Detail Microsoft SQL Server is a relational database management system. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications. SQL Server Analysis Services adds OLAP and data mining capabilities for SQL Server databases. OLAP (online analytical processing) is a technique for analyzing business data for effective business intelligence. This practical guide teaches you how to build business intelligence solutions using Microsoft's core product - SQL Server Analysis Services. The book covers the traditional multi-dimensional model which has been around for over a decade as well as the tabular model introduced with SQL Server 2012. Starting with comparing MultiDimensional and tabular models - discussing the values and limitations of each, you will then cover the essential techniques for building dimensions and cubes. Following on from this, you will be introduced to more advanced topics, such as designing partitions and aggregations, implementing security, and synchronizing databases for solutions serving many users. The book also covers administrative material, such as database backups, server configuration options, and monitoring and tuning performance. We also provide a primer on MultiDimensional eXpressions (MDX) as well as Data Analysis expressions (DAX) languages. This book provides you with data cube development techniques, and also the ongoing monitoring and tuning for Analysis Services. What you will learn from this book <ul>
<li>Design commonly encountered dimensions</li> <li>Extend your cubes to include advanced features such as actions, translations, and key performance indicators</li> <li>Maintain cubes by adding/removing data using partitions</li> <li>Administer Analysis Services instance</li> <li>Scale out your solution by synchronizing cube data</li> <li>Build tabular model solutions</li> </ul>
Approach A practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS. Who this book is written for If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL development is required.

SQL Server Analysis Services 2012 Cube Development Cookbook: More Than 100 Recipes to Develop Business Intelligence Solutions Using Analysis Services

Dewald, Baya

Hughes, Steve

Web Development & Design

Packt Pub Ltd

Access 2000 is the database of choice for many small to medium businesses. Using Access in conjunction with VBA, VB or ASP it is possible to develop sophisticated systems for storing and manipulating business data. Office 2000 and Access 2000 offer many new features that can be used with VB to create great user interfaces and applications. This book concentrates on the issues involved with this type of development, and shows how to create database-driven internet and intranet applications with Access as the underlying datastore.

Professional Access 2000 Programming

Thompson, Steven K.

Sussman, David

Dewson, Robin

Martins, Felipe

Hanselman, Scott

Matsik, Brian

Hatfield, Hope

Johnson, Trey

Liske, David

Salguero, Dennis

Shelby, Kevin

Slager, David

Townsend, Roberta

Watson, Helmut

Apress

See the best price to sell, buy, or rent books by Turley, Paul. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Turley, Paul