Jan 19, 2012 |
3,815 views |
Book Description
SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server proliferates throughout smaller companies, many developers have begun to act as administrators as well. Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables you to manage the policies on hundreds of SQL Servers in your environment as if you were managing a single instance. We’ve provided a comprehensive, tutorial-based book to get you over the learning curve of how to configure and administer SQL Server 2008.
Whether you’re an administrator or developer using SQL Server, you can’t avoid wearing a DBA hat at some point. Developers often have SQL Server on their own workstations and must provide guidance to the administrator about how they’d like the production configured. Oftentimes, they’re responsible for creating the database tables and indexes. Administrators or DBAs support the production servers and often inherit the database from the developer.
This book is intended for developers, DBAs, and casual users who hope to administer or may already be administering a SQL Server 2008 system and its business intelligence features, such as Integration Services. This book is a professional book, meaning the authors assume that you know the basics about how to query a SQL Server and have some rudimentary concepts Download Now »
Jan 19, 2012 |
3,651 views |
Book Description
- Teaches solution architects, designers, and developers how to use Microsoft’s reporting platform to create reporting and business intelligence (BI) solutions
- Updated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenarios
- Includes programming examples focused on specific, scenario-based solutions
- 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
From the Back Cover
Professional Microsoft SQL Server 2008 Reporting Services
SQL Server Reporting Services makes reporting faster and easier than ever. This hands-on guide will show you how to harness the full power of Reporting Services to create reporting and business intelligence solutions that meet your company’s needs. It walks you step-by-step through the fundamentals of designing the most effective reports by following careful planning considerations.
The authors progress from beginning to advanced report design and filtering techniques, showing you the conditions where reports could be more efficient. They also explore holistic business intelligence solutions, comprehensive OLAP/Analysis Services reporting, and complete production-deployment scenarios. Download Now »
Jan 19, 2012 |
3,177 views |
Book Description
- The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS)
- Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than ever
- Case studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniques
- New chapters include coverage of data warehousing using SSIS, new methods for managing the SSIS platform, and improved techniques for ETL operations
From the Back Cover
Professional Microsoft SQL Server 2008 Integration Services
When SQL Server Integration Services (SSIS) was released to the market in SQL Server 2005, it took the Extract Transform Load (ETL) market by storm. Three years later, SQL Server 2008 has introduced an even more mature rendition of SSIS that is focused on improving the scalability and performance of SQL Server and also serves as a very powerful tool for performing ETL operations, which are central to data warehousing.
With this book, an assembled team of professionals has combined their years of experience and tried-and-true best practices to present you with the tools to take your SSIS Download Now »
Jan 08, 2012 |
5,097 views |
Book Description
Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting—no more, no less.
Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data.
Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book.
- Provides proven content from a world-renowned performance and troubleshooting expert
- Emphasizes the significance of internals knowledge to rapid identification of database performance problems
- Covers the core essentials and does not waste your time with esoterica
What you’ll learn
Jan 05, 2012 |
3,876 views |
Book Description
Service Oriented Architecture (SOA) remains a buzzword in the business and IT community, largely because the ability to react quickly is of utmost importance. SOA can be the key solution to this. The challenge lies in the tricky task of integrating all the applications in a business through a Service Oriented Architecture, and “Do more with SOA Integration: Best of Packt” will help you do just that with content from a total of eight separate Packt books.
“Do more with SOA Integration: Best of Packt” will help you learn SOA integration from scratch. It will help you demystify the concept of SOA integration, understand basic integration technologies and best practices, and get started with SOA Governance. “Do more with SOA Integration: Best of Packt” draws from eight separate titles from Packt’s existing collection of excellent SOA books:
- BPEL cookbook
- SOA Approach to Integration
- Service Oriented Architecture: An Integration Blueprint
- Building SOA-Based Composite Applications Using NetBeans IDE 6
- Oracle SOA Suite Developer’s Guide
- WS-BPEL 2.0 for SOA Composite Applications with Oracle SOA Suite 11g
- Oracle Modernization Solutions
- SOA Governance
The chapters in “Do more with SOA Integration: Best of Packt” help you to learn Download Now »
Jan 03, 2012 |
4,268 views |
Book Description
The Oracle Database 11g: SQL Fundamentals I exam is the first stepping stone in getting the Oracle Certified Associate Certification for Oracle Database 11g. The SQL programming language is used in every major relational database today and understanding the real world application of it is the key to becoming a successful DBA.
This book gives you: the essential real world skills to master relational data manipulation with Oracle SQL and prepares you to become an Oracle Certified Associate. Beginners are introduced to concepts in a logical manner while practitioners can use it as a reference to jump to relevant concepts directly.
We begin with the essentials of why databases are important in today’s information technology world and how they work.
We continue by explaining the concepts of querying and modifying data in Oracle using a range of techniques, including data projection, selection, creation, joins, sub-queries and functions. Finally, we learn to create and manipulate database objects and to use them in the same way as today’s expert SQL programmers.
This book prepares you to master the fundamentals of the SQL programming language using an example-driven method that is easy to understand
This definitive certification guide provides a disciplined approach to be adopted for successfully clearing the 1Z0-051 SQL Fundamentals I exam Download Now »
