Wow! eBook – Blog

Book Description

SQL Server MVP Deep Dives, Volume 2 lets you learn from the best in the business—64 SQL Server MVPs offer completely new content in this second volume on topics ranging from testing and policy management to integration services, reporting, and performance optimization techniques…and more.

To become an MVP requires deep knowledge and impressive skill. Together, the 64 MVPs who wrote this book bring about 1,000 years of experience in SQL Server administration, development, training, and design. This incredible book captures their expertise and passion in 60 concise, hand-picked chapters.

SQL Server MVP Deep Dives, Volume 2 picks up where the first volume leaves off, with completely new content on topics ranging from testing and policy management to integration services, reporting, and performance optimization. The chapters fall into five parts: Architecture and Design, Database Administration, Database Development, Performance Tuning and Optimization, and Business Intelligence.

What’s Inside

• Discovering servers with PowerShell
• Using regular expressions in SSMS
• Tuning the Transaction Log for OLTP
• Optimizing SSIS for dimensional data
• Real-time BI Download Now »

Book Description

Data have become a highly valued asset for governments, industries and individuals, and the management of these data collections remains a critical technical challenge.. The challenges of managing terabytes and exabytes of data and expanding data management to include other data modalities while maintaining the fundamental tenets of database management (data independence, data integrity, data consistency, etc) are important issues for any organization today. Published as five volumes with over 4000 pages, the Encyclopedia of Database Systems provides easy access to important concepts relevant information on all aspects of very large databases, data management, and database systems, including areas of current interest and research results of historical significance.. This comprehensive reference contains 1,300 illustrated entries, organized alphabetically. Each entry presents basic terminology, concepts, methods and algorithms, key results to date, references to the literature, and cross-references to other entries. Topics for the Encyclopedia — including areas of current interest as well as research results of historical significance — were selected by a distinguished international advisory board and written by world class experts in the field. Encyclopedia of Database Systems is designed to meet the needs of researchers, professors, graduate and undergraduate students in computer science and engineering. Industry professionals such as database specialists and software developers will also benefit from this reference work.

Table of Contents

• Storage structures. Download Now »

Book Description

A report is only useful if those who receive it understand what it means. Knowing how to use Crystal Reports gives you the edge in producing reports from your database that really are crystal clear.

Crystal Reports 2008 For Dummies is a quick and easy guide to get you going with the latest version of this bestselling report-writing software. In fact, it’s so popular that previous editions have made it a bestseller too. Crystal Reports 2008 For Dummies gives you just what you should know to produce the reports you’ll need most often, including how to:

• Pull specific information from your database, sort and group it, and find the details you need
• Use dynamic or cascading prompts
• Troubleshoot and print reports and save time with templates
• View reports on your LAN
• Write formulas to retrieve specific information
• Create and update OLAP reports
• Format reports, control page breaks, and even add graphics or Flash files
• Enhance your reports with charts and maps
• Use Crystal Reports in the enterprise

There’s also a companion Web site with sample reports from the book and links to sites with more related information. With Crystal Reports 2008 For Dummies by your side Download Now »

Book Description

Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java provides resources that every Java and Oracle database application programmer needs to ensure that they have guarded the security of the data and identities entrusted to them. You’ll learn to consider potential vulnerabilities, and to apply best practices in secure Java and PL/SQL coding. Author David Coffin shows how to develop code to encrypt data in transit and at rest, to accomplish single sign-on with Oracle proxy connections, to generate and distribute two-factor authentication tokens from the Oracle server using pagers, cell phones (SMS), and e-mail, and to securely store and distribute Oracle application passwords.

Early chapters lay the foundation for effective security in an Oracle/Java environment. Each of the later chapters brings example code to a point where it may be applied as-is to address application security issues. Templates for applications are also provided to help you bring colleagues up to the same secure application standards. If you are less familiar with either Java or Oracle PL/SQL, you will not be left behind; all the concepts in this book are introduced as to a novice and addressed as to an expert.

• Helps you protect against data loss, identity theft, SQL injection, and address spoofing
• Provides techniques for encryption on network and disk, code obfuscation and wrap, database hardening, single sign-on and two-factor
• Provides what database administrators need to know about secure password distribution, Java secure programming, Java stored procedures, secure application roles in Oracle, logon triggers, database design, various connection pooling schemes, and much more Download Now »

Book Description

Throughout history, advances in technology have come in spurts. A single great idea can often spur rapid change as the idea takes hold and is propagated, often in totally unexpected directions. Exadata embodies such a change in how we think about and manage relational databases. The key change lies in the concept of offloading SQL processing to the storage layer. That concept is a huge win, and its implementation in the form of Exadata is truly a game changer.

Expert Oracle Exadata will give you a look under the covers at how the combination of hardware and software that comprise Exadata actually work. Authors Kerry Osborne, Randy Johnson, and Tanel Põder share their real-world experience, gained through multiple Exadata implementations with the goal of opening up the internals of the Exadata platform. This book is intended for readers who want to understand what makes the platform tick and for whom—”how” it does what it is does is as important as what it does. By being exposed to the features that are unique to Exadata, you will gain an understanding of the mechanics that will allow you to fully benefit from the advantages that the platform provides.

• Will changes the way you think about managing SQL performance and processing
• Provides a roadmap to laying out the Exadata platform to best support your existing systems
• Dives deeply into the internals, removing the “black box” mystique and showing how Exadata actually works

Download Now »

Book Description

Demonstrate your expertise with Microsoft Access by earning a MOS 2010 certification. This Study Guide is designed to help you practice and prepare for Exam 77-885: Access 2010, and features:

• Full objective-by-objective review
• Procedures and hands-on practice tasks
• Ready-made, downloadable practice files
• Exam-discount and pre-test offer

Use the in-depth exam prep, practice, and review to help advance your proficiency with Access 2010—and earn the credential that proves it!

NOTE: This same content is also available as part of the MOS 2010 Study Guide for Microsoft Word Expert, Excel Expert, Access, & SharePoint Exams (ISBN 9780735657885)

Table of Contents
Chapter 1. Using the Access Workspace
Chapter 2. Building Tables
Chapter 3. Building Forms
Chapter 4. Creating and Managing Queries
Chapter 5. Designing Reports

About the Author
John Pierce is a writer with Microsoft’s Information Worker New Markets group Download Now »