Books : Search |
|
Books : Search |
|
SQL Server 2000 Stored Procedures Handbook (Expert's Voice)»rank: 665007by: Tony Bain, Louis Davidson, Robin Dewson, Chuck Hawkins, Tony Bain, Louise Davidson, Robin Dewson, Chuck Hawkins
: :Stored procedures are compiled T-SQL statements that reside on the database. They are the cornerstones of successful data manipulation, and data-handling operations of every complexity make use of them. This book is an in-depth guide to a key area of database development. This book tackles real-world problems faced by developers when working with stored procedures, showing you how to solve these problems, avoid the common pitfalls, and produce faster, more robust stored procedures. Put simply: if you want to write better stored procedures, then this is the book for you. |
Beginning SQL Server 2000 DBA: From Novice to Professional (The Expert's Voice)»rank: 390493by: Tony Bain, Michael Benkovich, Brian Freeman, Baya Pavliashvili, Joseph Sack
: :SQL Server 2000 is the leading relational database in the Windows market. The increased manageability of SQL Server 2000 has also increased its popularityanyone, not just database administrators, can use a SQL Server database. This book recognizes that aspiring DBAs need more than just a basic knowledge of the available features in order to be considered 'a safe pair of hands' for the database and the mission-critical data that is stored in it. Aspiring DBAs can benefit from the direction and advice of an expert mentor who not only understands the features available and how they should be used, but also knows what it takes to be a good and effective DBA. ... |
||
VB.NET & SQL Server 2000: Building an Effective Data Layer»rank: 1042693by: Tony Bain, Denise Gosnell, Jonathan A. Walsh
: :Many VB developers choose SQL Server 2000, a robust enterprise-level database system, to provide the data layer in their applications. The introduction of Microsoft's .NET Framework brings us ADO.NET, the latest means of connecting to that data source. This book will teach the experienced VB developer, with a working knowledge of Visual Basic .NET, how to integrate SQL Server 2000 with VB .NET applications using ADO.NET. ADO.NET introduces .NET classes for: - Efficient access to multiple data sources - Data sorting - Data manipulation - Improved inter-application communication 'Building an effective data layer' illustrates how to take advantage of the new features available in the .NET Framework when working with data-centric applications. ... |
SQL server 2000 Stored Procedure Handbook»rank: 1154357by: Tony Bain, Robin Dewson, Chuck Hawkins, Louis Davidson
: :If you want to write better stored procedures, this is the book for you. This book will tackle real-world problems faced by developers when working with stored procedures, showing how to solve these problems, avoid the common pitfalls and work around them, to produce faster, more robust stored procedures. This book is for the SQL Server 2000 developer, who wants a book that starts where books like Rob Viera's Professional SQL Server 2000 Programming finish. Topics covered include: Typical uses and misuses of stored procedures Debugging and optimizing stored procedures System stored procedures and extended stored procedures Cursors, transactions and concurrency Working with triggers User defined functions Stored procedures and security |
||
Professional SQL Server 2000 Data Warehousing with Analysis Services»rank: 1556282by: Chris Graves, Mark Scott, Mike Benkovich, Paul Turley, Robert Skoglund, Robin Dewson, Sakhr Youness, Denny Lee, Sam Ferguson, Tony Bain, Terrence Joubert
: :Data warehouses have evolved to cope with the huge volumes of data flowing through the workplace by separating the data used for reporting and decision making from the operational systems. The purpose of the data warehouse is simply to store the raw data, and in combination with Microsoft SQL Server 2000 Analysis Services, this data can be transformed into accessible information that reflects the real factors affecting the enterprise. In this book, we introduce the key concepts of data warehousing, OLAP, and data mining. In addition to coverage of Data Transformation Services (DTS) and MDX, this book also demonstrates how to develop an Analysis Services client application, and how to secure and ... |
Headstart SQL Server 2000»rank: 1556282by: Curlingstone Author Team, Tony Bain
: :Data warehouses have evolved to cope with the huge volumes of data flowing through the workplace by separating the data used for reporting and decision making from the operational systems. The purpose of the data warehouse is simply to store the raw data, and in combination with Microsoft SQL Server 2000 Analysis Services, this data can be transformed into accessible information that reflects the real factors affecting the enterprise. In this book, we introduce the key concepts of data warehousing, OLAP, and data mining. In addition to coverage of Data Transformation Services (DTS) and MDX, this book also demonstrates how to develop an Analysis Services client application, and how to secure and ... |
||
Six Degrees of Danny Dickfos»rank: 1556282by: Tony Greenberg, Andrew Bain
: :Data warehouses have evolved to cope with the huge volumes of data flowing through the workplace by separating the data used for reporting and decision making from the operational systems. The purpose of the data warehouse is simply to store the raw data, and in combination with Microsoft SQL Server 2000 Analysis Services, this data can be transformed into accessible information that reflects the real factors affecting the enterprise. In this book, we introduce the key concepts of data warehousing, OLAP, and data mining. In addition to coverage of Data Transformation Services (DTS) and MDX, this book also demonstrates how to develop an Analysis Services client application, and how to secure and ... |
SQL Server 2005 Revealed»rank: 3435813by: Tony Bain, Robin Dewson, Tom Rizzo, Itay Braun
: :Data warehouses have evolved to cope with the huge volumes of data flowing through the workplace by separating the data used for reporting and decision making from the operational systems. The purpose of the data warehouse is simply to store the raw data, and in combination with Microsoft SQL Server 2000 Analysis Services, this data can be transformed into accessible information that reflects the real factors affecting the enterprise. In this book, we introduce the key concepts of data warehousing, OLAP, and data mining. In addition to coverage of Data Transformation Services (DTS) and MDX, this book also demonstrates how to develop an Analysis Services client application, and how to secure and ... |