Build agile and responsive Business Intelligence solutions Analyze tabular data using the BI Semantic Model (BISM) in Microsoft SQL Server 2012 Analysis Services—and discover a simpler method for creating corporate-level BI solutions. Led by three BI experts, you’ll learn how to build, deploy, and query a BISM tabular model with step-by-step guides, examples, and best practices. This hands-on book shows you how the tabular model’s in-memory database enables you to perform rapid analytics—whether you’re a professional BI developer new to Analysis Services or familiar with its multidimensional model. Discover how to: Determine when a tabular or multidimensional model is right for your project Build a tabular model using SQL Server Data Tools in Microsoft Visual Studio 2010 Integrate data from multiple sources into a single, coherent view of company information Use the Data Analysis eXpressions (DAX) language to create calculated columns, measures, and queries Choose a data modeling technique that meets your organization’s performance and usability requirements Optimize your data model for better performance with xVelocity storage engine Manage complex data relationships, such as multicolumn, banding, and many-to-many Implement security by establishing administrative and data user roles

EXAM PREP GUIDE Ace your preparation for the skills measured by Exam 70-462—and on the job—with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. Maximize your performance on the exam by mastering the skills and experience measured by these objectives: Install and configure SQL Server Maintain instances and databases Optimize and troubleshoot SQL Server Manage data Implement security Implement high availability PRACTICE TESTS A Note Regarding Practice Tests Assess your skills with practice tests. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies. For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

For the first time it is possible to deploy an integrated hardware platform that brings mainframe and distributed technologies together: a system that can start to replace individual islands of computing and that can work to reduce complexity, improve security, and bring applications closer to the data that they need.

FileMaker® 12 In Depth Do more in less time! FileMaker 12 In Depth is the most comprehensive, coherent, and practical guide to creating professional-quality solutions with the newest versions of FileMaker! Drawing on his unsurpassed real-world experience as a FileMaker user, consultant, and developer, Jesse Feiler helps you gain practical mastery of today’s newest, most advanced FileMaker tools and features. • Use themes to build solutions for FileMaker Pro on Windows and OS X, FileMaker Go on iOS, and Instant Web Publishing • Get the most out of new container field technology • Quickly become a FileMaker 12 power user • Make the most of FileMaker fields, tables, layouts, and parts • Iteratively design reliable, high-performance FileMaker relational databases • Work with relationships, including self-joins and cross-product relationships • Write calculation formulas and use functions • Use event-driven scripts to make databases more interactive • Build clear and usable reports, publish them, and incorporate them into workflows • Secure applications with user accounts, privileges, file-level access, network security, and authentication • Use FileMaker’s Web Viewer to access live web-based data • Convert systems from older versions of FileMaker, and troubleshoot successfully • Share, exchange, export, and publish data via SQL and XML • Instantly publish databases on the web, and use advanced Custom Web Publishing techniques • Trigger automated behaviors whenever specific events occur • Extend FileMaker’s functionality with plug-ins • Set up, configure, tune, and secure FileMaker Server All In Depth books offer • Comprehensive coverage with detailed solutions • Troubleshooting help for tough problems you can’t fix on your own • Outstanding authors recognized worldwide for their expertise and teaching style Learning, reference, problem-solving... the only FileMaker 12 book you need!

The new edition of a bestseller, now revised and update throughout! This new edition of the unparalleled bestseller serves as a full training course all in one and as the world's largest data storage company, EMC is the ideal author for such a critical resource. They cover the components of a storage system and the different storage system models while also offering essential new material that explores the advances in existing technologies and the emergence of the "Cloud" as well as updates and vital information on new technologies. Features a separate section on emerging area of cloud computing Covers new technologies such as: data de-duplication, unified storage, continuous data protection technology, virtual provisioning, FCoE, flash drives, storage tiering, big data, and more Details storage models such as Network Attached Storage (NAS), Storage Area Network (SAN), Object Based Storage along with virtualization at various infrastructure components Explores Business Continuity and Security in physical and virtualized environment Includes an enhanced Appendix for additional information This authoritative guide is essential for getting up to speed on the newest advances in information storage and management.

This book provides a comprehensive guide to the advanced features of PL/SQL, Oracle's procedural extension for SQL. It is especially designed for developers looking to master complex concepts, optimize code, and prepare for the Oracle 11g Advanced PL/SQL Professional certification (1Z0-146). Through clear explanations, practical examples, and exercises, you will advance your skills effectively. What this Book will help me do Master the use of advanced PL/SQL interface methods for robust database interactions. Implement Virtual Private Database settings with Fine Grained Access Control. Effectively use collections and data caching techniques to optimize your programs. Apply techniques to protect PL/SQL code from various security vulnerabilities, including injections. Implement result caching strategies and learn performance tuning methods to enhance application efficiency. Author(s) Saurabh K. Gupta is an experienced database professional specializing in Oracle technologies, with a focus on advanced PL/SQL development and optimization. He brings years of hands-on expertise to his writing, making complex subjects accessible for developers. In this book, he combines practical knowledge with certification-focused insights to guide readers towards programming excellence. Who is it for? This book is designed for PL/SQL programmers who have intermediate experience and are aiming to elevate their skills to a professional level. If you are preparing for the Oracle 1Z0-146 Professional certification or wish to deepen your understanding of advanced PL/SQL topics, this guide is ideal for you. A foundational knowledge of PL/SQL programming is assumed to fully benefit from the content.

Get up to speed on the extensive changes to the newest release of Microsoft SQL Server The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012. You'll explore the key additions and changes to this newest version, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and development of BI applications. Covers new features such as SQL Azure for cloud computing, client-connectivity enhancements, security and compliance, data replication, and data warehouse performance improvements Addresses essential topics including managing keys, writing scripts, and working with store procedures Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services Beginning Microsoft SQL Server 2012 Programming demystifies even the most difficult challenges you may face with the new version of Microsoft SQL Server.

Introduces various modeling and simulation methods and paradigms that are used to explain and solve the predominant challenges facing society Handbook of Real-World Applications in Modeling and Simulation provides a thorough explanation of modeling and simulation in the most useful, current, and predominant applied areas of transportation, homeland security, medicine, operational research, military science, and business modeling. Offering a cutting-edge and accessible presentation, this book discusses how and why the presented domains have become leading applications of modeling and simulation techniques. Contributions from leading academics and researchers integrate modeling and simulation theories, methods, and data to analyze challenges that involve technological and social issues. The book begins with an introduction that explains why modeling and simulation is a reliable analysis assessment tool for complex systems problems. Subsequent chapters provide an orientation to various modeling and simulation methods and paradigms that are used to explain and solve the predominant challenges across real-world applied domains. Additionally, the handbook: Provides a practical one-stop reference on modeling and simulation and contains an accessible introduction to key concepts and techniques Introduces, trains, and prepares readers from statistics, mathematics, engineering, computer science, economics, and business to use modeling and simulation in their studies and research Features case studies that are representative of fundamental areas of multidisciplinary studies and provides a concise look at the key concepts of modeling and simulation Contains a collection of original ideas on modeling and simulation to help academics and practitioners develop a multifunctional perspective Self-contained chapters offer a comprehensive approach to explaining each respective domain and include sections that explore the related history, theory, modeling paradigms, and case studies. Key terms and techniques are clearly outlined, and exercise sets allow readers to test their comprehension of the presented material. Handbook of Real-World Applications in Modeling and Simulation is an essential reference for academics and practitioners in the areas of operations research, business, management science, engineering, statistics, mathematics, and computer science. The handbook is also a suitable supplement for courses on modeling and simulation at the graduate level.

An essential how-to guide for experienced DBAs on the most significant product release since 2005! Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of SQL Server and deciphers how these changes will affect the methods that administrators have been using for years. Loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server admin issues, this how-to guide deciphers topics such as performance tuning, backup and recovery, scaling and replication, clustering, and security. Serves as a must-have how-to guide on the new features of the 2012 release of Microsoft SQL Server Walks you through ways to manage and monitor SQL Server and automate administration Guides you through SQL Azure for cloud computing, data replication, and data warehouse performance improvements Addresses client-connectivity enhancements, new features that ensure high availability of mission-critical applications, and tighter integration with Excel and SharePoint for data analysis and reporting Highlights major changes to the suite of SQL Server BI tools, including integration, reporting, and analysis services Includes real-world case examples and best practices from Microsoft insiders If you're a database administrator eager to get started with the newest version of SQL Server, then this book is essential reading.

Dive into the intricacies of BizTalk Server 2010 with this comprehensive cookbook. By learning from over 50 detailed recipes, you'll enhance both your technical skills in BizTalk implementation and guiding principles for setting up durable, efficient environments. Written by expert Steef-Jan Wiggers, this book provides practical models to create robust orchestration and messaging solutions. What this Book will help me do Learning to deploy robust and high-performing BizTalk environments with optimal settings. Enhancing orchestration designs using well-defined BizTalk patterns for scalability. Utilizing best practices for BizTalk artifact instrumentation and error handling. Strengthening knowledge of BizTalk messaging security and SOA pattern application. Expanding BizTalk solutions to integrate with modern cloud-based technologies. Author(s) Steef-Jan Wiggers is a recognized expert and Microsoft MVP in BizTalk Server. With extensive experience as both a developer and an administrator, Steef-Jan brings a wealth of practical knowledge to this book. His approach to teaching BizTalk is grounded in real-world applications, focusing on equipping professionals with actionable insights and clear guidance. Who is it for? This book is ideal for BizTalk developers and administrators who have foundational knowledge of BizTalk Server, SOA, and enterprise application integration concepts. Whether advancing professional ambitions, honing skills, or tackling specific BizTalk challenges, readers can rely on this book to deliver essential knowledge and actionable techniques.

Implement Proven Database Optimization Solutions Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 11g Release 2 Performance Tuning Tips & Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to find and fix bottlenecks, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide. Properly index and partition Oracle Database 11 g Release 2 Work with Oracle Exadata and Oracle Exalogic Elastic Cloud Efficiently manage disk drives, RAID arrays, and memory Tune queries with Oracle SQL hints and the TRACE utility Troubleshoot databases using V$ views and X$ tables Distribute workload using Oracle Real Application Testing Generate reports using Oracle's Statspack and Automatic Workload Repository tools Use sar, vmstat, and iostat to monitor system statistics “This is a timely update of Rich’s classic book on Oracle Database performance tuning to cover hot new topics like Oracle Database 11g Release 2 and Oracle Exadata. This is a must-have for DBAs moving to these new products.” --Andrew Mendelsohn, Senior Vice President, Oracle Database Server Technologies

"IBM DB2 9.7 Advanced Application Developer Cookbook" is your guide to mastering advanced techniques for database application development with IBM DB2. This practical book provides over 70 hands-on recipes that cover everything from performance tuning to utilizing the latest DB2 features. By diving into these solutions, you will be able to design secure, robust, and cutting-edge DB2 applications. What this Book will help me do Implement and leverage new features of DB2 9.7 for enhanced application development. Apply performance tuning techniques to improve the efficiency of your database applications. Design secure DB2 applications while understanding advanced security configurations. Migrate Oracle database objects to DB2, enabling Oracle application support on DB2. Utilize advanced DB2 capabilities such as pureXML efficiently for Web 2.0 and SOA integrations. Author(s) The author is a seasoned database professional with extensive experience in IBM DB2 development and administration. Having worked on numerous high-profile DB2 applications, their expertise spans the full application lifecycle, from design to optimization. They present complex technical concepts in a clear and approachable way, ensuring that readers can easily grasp and apply advanced database techniques. Who is it for? This book is ideal for professional IBM DB2 developers who wish to deepen their expertise in advanced application development. It's suited for individuals with a foundational understanding of DB2 who aim to leverage its powerful features for building robust and optimized applications. If you are tasked with migrating Oracle applications to DB2 or enhancing DB2's performance for high-demand systems, this guide is for you.

IBM’s Definitive One-Stop Guide to IMS Versions 12, 11, and 10: for Every IMS DBA, Developer, and System Programmer Over 90% of the top Fortune® 1000 companies rely on IBM’s Information Management System (IMS) for their most critical IBM System z® data management needs: 50,000,000,000+ transactions run through IMS databases every day. What’s more, IBM continues to upgrade IMS: Versions 12, 11, and 10 meet today’s business challenges more flexibly and at a lower cost than ever before. In An Introduction to IMS, Second Edition, leading IBM experts present the definitive technical introduction to these versions of IMS. More than a complete tutorial, this book provides up-to-date examples, cases, problems, solutions, and a complete glossary of IMS terminology. Prerequisite reading for the current IBM IMS Mastery Certification Program, it reflects major recent enhancements such as dynamic information generation; new access, interoperability and development tools; improved SOA support; and much more. Whether you’re a DBA, database developer, or system programmer, it brings together all the knowledge you’ll need to succeed with IMS in today’s mission critical environments. Coverage includes What IMS is, how it works, how it has evolved, and how it fits into modern enterprise IT architectures Providing secure access to IMS via IMS-managed application programs Understanding how IMS and z/OS® work together to use hardware and software more efficiently Setting up, running, and maintaining IMS Running IMS Database Manager: using the IMS Hierarchical Database Model, sharing data, and reorganizing databases Understanding, utilizing, and optimizing IMS Transaction Manager IMS application development: application programming for the IMS Database and IMS Transaction Managers, editing and formatting messages, and programming applications in Java™ IMS system administration: the IMS system definition process, customizing IMS, security, logging, IMS operations, database and system recovery, and more IMS in Parallel Sysplex® environments: ensuring high availability, providing adequate capacity, and balancing workloads

Many large and medium-sized organizations have made strategic investments in the SAP NetWeaver technology platform as their primary application platform. In fact, SAP software is used to manage many core business processes and data. As a result, it is critical for all organizations to manage the life cycle of user access to the SAP applications while adhering to security and risk compliance requirements. In this IBM® Redbooks® publication, we discuss the integration points into SAP solutions that are supported by the IBM Security access and identity management product capabilities. IBM Security software offers a range of identity management (IdM) adapters and access management components for SAP solutions that are available with IBM Tivoli® Identity Manager, IBM Tivoli Directory Integrator, IBM Tivoli Directory Server, IBM Access Manager for e-business, IBM Tivoli Access Manager for Enterprise Single Sign-On, and IBM Tivoli Federated Identity Manager. This book is a valuable resource for security officers, consultants, administrators, and architects who want to understand and implement an identity management solution for an SAP environment.

Portable and precise, this pocket-sized guide delivers ready answers for the day-to-day administration of SQL Server. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get the focused information you need to save time and get the job done—whether at your desk or in the field! Get fast facts to: Manage SQL Server services and clients Configure, manage, and tune servers Implement policy-based management Administer security and access Monitor server activity and tune performance Automate maintenance Perform backups and recovery

This IBM® Redbooks® publication highlights the key enhancements of IBM DB2® 10 for SAP. These enhancements include performance, scalability for several threads, new and more granular privileges, and auditing capabilities. This book is for IT specialists and architects who are interested in how SAP NetWeaver v7.3 interacts and uses the new features of DB2 10 for z/OS®. This book focuses on the SAP Business Suite of applications and how these applications run on IBM zEnterprise™ infrastructures. It begins with a brief overview of the SAP NetWeaver products and hardware and explains the software implementations when DB2 10 for z/OS is used as the database server. It highlights the SAP NetWeaver system architecture. It continues by describing how SAP products benefit from the recent developments by IBM on the hardware side with the zEnterprise 196 (z196) server, in z/OS, and in DB2 10 for z/OS. In addition, this Redbooks publication explains how you can extend an SAP system or change a server configuration by using the IBM zEnterprise Unified Resource Manager. It explores SAP high availability concepts, virtualization, and security enhancements of DB2 10 for SAP solutions.

Essential Microsoft SQL Server 2012 Skills Made Easy Get up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition starts by explaining fundamental relational database system concepts. Then, you'll learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis, business intelligence, and reporting tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial. Install, configure, and customize SQL Server 2012 Create and modify database objects with Transact SQL statements Write stored procedures and user-defined functions Handle backup and recovery Automate administrative tasks Tune your database system for optimal performance, availability, and reliability Implement security measures using authentication, encryption, and authorization Work with SQL Server Analysis Services, SQL Server Reporting Services, and other business intelligence tools Store, display, and query XML documents Manage spatial data Query documents using MS Full-Text Search (FTS)

One of a firm's most valuable resources is its data: client lists, accounting data, employee information, and so on. This critical data has to be securely managed and controlled, and simultaneously made available to those users authorized to see it. The IBM® z/VSE™ system has extensive capabilities to simultaneously share the firm's data among multiple users and protect them. Threats to this data come from a variety of sources. Insider threats, as well as malicious hackers, are not only difficult to detect and prevent—they could have been using resources without the business even being aware that they are there. This IBM Redbooks® publication was written to assist z/VSE support and security personnel in providing the enterprise with a safe, secure and manageable environment. This book provides an overview of the security provided by z/VSE and the processes for the implementation and configuration of z/VSE security components, Basic Security Manager (BSM), IBM CICS® security, TCP/IP security, single sign-on using LDAP, and connector security.

Today, organizations face tremendous challenges with data explosion and information governance. InfoSphere™ Optim™ solutions solve the data growth problem at the source by managing the enterprise application data. The Optim Data Growth solutions are consistent, scalable solutions that include comprehensive capabilities for managing enterprise application data across applications, databases, operating systems, and hardware platforms. You can align the management of your enterprise application data with your business objectives to improve application service levels, lower costs, and mitigate risk. In this IBM® Redbooks® publication, we describe the IBM InfoSphere Optim Data Growth solutions and a methodology that provides implementation guidance from requirements analysis through deployment and administration planning. We also discuss various implementation topics including system architecture design, sizing, scalability, security, performance, and automation. This book is intended to provide various systems development professionals, Data Solution Architects, Data Administrators, Modelers, Data Analysts, Data Integrators, or anyone who has to analyze or integrate data structures, a broad understanding about IBM InfoSphere Optim Data Growth solutions. By being used in conjunction with the product manuals and online help, this book provides guidance about implementing an optimal solution for managing your enterprise application data.

Step-by-step lessons for using PHP and MySQL in a unique book-and-video combination Assuming no previous experience with PHP or MySQL, this book-and-video package is ideal reading for anyone who wants to go beyond HTML/CSS in order to provide clients with the most dynamic web sites possible. The approachable tone breaks down the basics of programming and PHP and MySQL in individual lessons starting with the installation of the programs necessary to run PHP. You begin with a static web site and then watch and learn as PHP functionality is added as you work through the lessons. When working with databases, the MySQL database is introduced with demonstrations that show how to interact with it. The accompanying videos enhance your learning experience, as each lesson in the book is portrayed in the video exercises. Lessons include: Getting started with PHP Setting up your workspace Adding PHP to a web page Learning PHP syntax Working with variables Debugging code Working with complex data Making decisions Repeating program steps Learning about scope Reusing code with functions Creating forms Introducing object-oriented programming Defining classes Using classes Using advanced techniques Handling errors Writing secure code Introducing databases Introducing MySQL Creating and connecting to the Creating tables Entering data Selecting data Using multiple tables Changing data Deleting data Preventing database security issues Creating user logins Turn the case study into a content management system Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.