Your cart is empty
A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. - Provides the perfect mix of practice and theory - Helps you become a DIY Excel modelling specialist - Includes updates for Excel 2019/365 and Excel for Mac - May be used as an accompaniment to the author's online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling.
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. * Understand BI fundamentals and Reporting Services architecture * Learn the ingredients to a successful report design * Get up to speed on Microsoft SQL Server 2016 * Grasp the purpose behind common designs to optimize your reporting 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.
For Database Systems and Database Design and Application courses offered at the junior, senior and graduate levels in Computer Science departments. Written by well-known computer scientists, this introduction to database systems offers a comprehensive approach, focusing on database design, database use, and implementation of database applications and database management systems. The first half of the book provides in-depth coverage of databases from the point of view of the database designer, user, and application programmer. It covers the latest database standards SQL:1999, SQL/PSM, SQL/CLI, JDBC, ODL, and XML, with broader coverage of SQL than most other texts. The second half of the book provides in-depth coverage of databases from the point of view of the DBMS implementor. It focuses on storage structures, query processing, and transaction management. The book covers the main techniques in these areas with broader coverage of query optimization than most other texts, along with advanced topics including multidimensional and bitmap indexes, distributed transactions, and information integration techniques. Resources: * Open access Author Website 'http://infolab.stanford.edu/~ullman/dscb. html'includes Power Point slides, teaching notes, assignments, projects, Oracle Programming Guidelines, and solutions to selected exercises. * Instructor only Pearson Resources: Complete Solutions Manual (click on the Resources tab above to view downloadable files)
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Apply Your SQL Server DBA Skills to Oracle Database AdministrationUse your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide. Install and configure Oracle Database on Windows or Linux systems Administer and monitor databases from Oracle Enterprise Manager Implement robust security using roles, permissions, and privileges Back up and restore databases with Oracle Recovery Manager Use the Oracle cost-based optimizer to tune performance Write, debug, and execute PL/SQL queries using Oracle SQL Developer Maximize availability with Oracle Real Application Clusters Build standby and failover servers using Oracle Data Guard
This book describes the next generation of business applications in the innovative new SAP Business Suite 4 SAP HANA (SAP S/4HANA), exploiting the revolutionary capabilities of the SAP HANA in-memory database. Numerous real-world examples are presented illustrating the disruptive potential of this technology and the quantum leap it has facilitated in terms of simplicity, flexibility, and speed for new applications. The intuitive structure of this book offers a straightforward business perspective grounded in technology in order to enable valuable business insights drawn from the wealth of real-world experience of the book's two authors, both prominent figures in the field of business application systems: Hasso Plattner and Bernd Leukert. Hasso Plattner is the co-founder of SAP and the founder of the Hasso Plattner Institute, affiliated with the University of Potsdam, Germany. Bernd Leukert is a member of the SAP Executive Board and the Global Managing Board of SAP.
"Robert Pearl, a well-known DBA in the SQL community, explains his holistic vision of a database instance that needs regular check-ups and gives the tools, scripts, and best practices he has collected over the years." Alberto Bolchini, Computing Reviews, May 9, 2016 Healthy SQL is about ensuring the ongoing performance health of a SQL Server database. An unhealthy database is not just an inconvenience; it can bring a business to its knees. And if you are the database administrator, the health of your SQL Server implementation can be a direct reflection on you. It's in everyone's best interest to have a healthy SQL implementation. Healthy SQL is built around the concept of a medical checkup, giving you the tools you need to assess the current health of your database and take action to improve upon that health and maintain good performance to your business. Healthy SQL aids in developing a rigorous routine so that you know how healthy your SQL Server machines are, and how you can keep those same servers healthy and fit for duty. The book is filled with practical advice and a time-tested strategy, helping you put together a regimen that will ensure your servers are healthy, your implementation is fully optimized, your services are redundant and highly available, and you have a plan for business continuity in the event of a disaster. If your current environment doesn't match up with these criteria, then pick up a copy of Healthy SQL today and start your journey on the road to a fit and tight SQL Server deployment.
Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you'll also discover that PostgeSQL is more than a database system-it's an impressive application platform as well. With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper (FDW) enhancements; new full text functions and operator syntax introduced in version 9.6; XML constructs new in version 10; query parallelization features introduced in 9.6 and enhanced in 10; built-in logical replication introduced in Version 10.e. If you're a current PostgreSQL user, you'll pick up gems you may have missed before. Learn basic administration tasks such as role management, database creation, backup, and restore Apply the psql command-line utility and the pgAdmin graphical administration tool Explore PostgreSQL tables, constraints, and indexes Learn powerful SQL constructs not generally found in other databases Use several different languages to write database functions Tune your queries to run as fast as your hardware will allow Query external and variegated data sources with foreign data wrappers Learn how to use built-in replication to replicate data
Find the right big data solution for your business or organization
Big data management is one of the major challenges facing business, industry, and not-for-profit organizations. Data sets such as customer transactions for a mega-retailer, weather patterns monitored by meteorologists, or social network activity can quickly outpace the capacity of traditional data management tools. If you need to develop or manage big data solutions, you'll appreciate how these four experts define, explain, and guide you through this new and often confusing concept. You'll learn what it is, why it matters, and how to choose and implement solutions that work.Effectively managing big data is an issue of growing importance to businesses, not-for-profit organizations, government, and IT professionalsAuthors are experts in information management, big data, and a variety of solutionsExplains big data in detail and discusses how to select and implement a solution, security concerns to consider, data storage and presentation issues, analytics, and much moreProvides essential information in a no-nonsense, easy-to-understand style that is empowering
"Big Data For Dummies" cuts through the confusion and helps you take charge of big data solutions for your organization.
Database Management Systems provides comprehensive and up-to-date coverage of the fundamentals of database systems. Coherent explanations and practical examples have made this one of the leading texts in the field. The third edition continues in this tradition, enhancing it with more practical material. The new edition has been reorganized to allow more flexibility in the way the course is taught. Now, instructors can easily choose whether they would like to teach a course which emphasizes database application development or a course that emphasizes database systems issues. New overview chapters at the beginning of parts make it possible to skip other chapters in the part if you don't want the detail. More applications and examples have been added throughout the book, including SQL and Oracle examples. The applied flavor is further enhanced by the two new database applications chapters.
Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to improve efficiency and maintainability. Executing dynamic SQL is key to large-scale searching based on user-entered criteria. Dynamic SQL can generate lists of values and even code with minimal impact on performance. Dynamic SQL enables dynamic pivoting of data for business intelligence solutions as well as customizing of database objects. Yet dynamic SQL is feared by many due to concerns over SQL injection or code maintainability. Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server helps you bring the productivity and user-satisfaction of flexible and responsive applications to your organization safely and securely. Your organization's increased ability to respond to rapidly changing business scenarios will build competitive advantage in an increasingly crowded and competitive global marketplace. With a focus on new applications and modern database architecture, this edition illustrates that dynamic SQL continues to evolve and be a valuable tool for administration, performance optimization, and analytics. What You'ill Learn Build flexible applications that respond to changing business needs Take advantage of creative, innovative, and productive uses of dynamic SQL Know about SQL injection and be confident in your defenses against it Address performance concerns in stored procedures and dynamic SQL Troubleshoot and debug dynamic SQL to ensure correct results Automate your administration of features within SQL Server Who This Book is For Developers and database administrators looking to hone and build their T-SQL coding skills. The book is ideal for developers wanting to plumb the depths of application flexibility and troubleshoot performance issues involving dynamic SQL. The book is also ideal for programmers wanting to learn what dynamic SQL is about and how it can help them deliver competitive advantage to their organizations.
What sets Laravel apart from other PHP web frameworks? Speed and simplicity, for starters. This rapid application development framework and its ecosystem of tools let you quickly build new sites and applications with clean, readable code. Fully updated to cover Laravel 5.8, the second edition of this practical guide provides the definitive introduction to one of today's mostpopular web frameworks. Matt Stauffer, a leading teacher and developer in the Laravel community, delivers a high-level overview and concrete examples to help experienced PHP web developers get started with this framework right away. This updated edition also covers Laravel Dusk and Horizon and provides information about community resources and other noncore Laravel packages. Dive into features, including: Blade, Laravel's powerful custom templating tool Tools for gathering, validating, normalizing, and filtering user-provideddata The Eloquent ORM for working with application databases The role of the Illuminate request object in the application lifecycle PHPUnit, Mockery, and Dusk for testing your PHP code Tools for writing JSON and RESTful APIs Interfaces for filesystem access, sessions, cookies, caches, and search Tools for implementing queues, jobs, events, and WebSocket event publishing
Learn to build custom SSIS tasks using Visual Studio Community Edition and Visual Basic. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you've already spent on licensing SQL Server. If you already have a license for SQL Server, then you do not need to spend more money to extend SSIS with custom tasks and components. Why are custom components necessary? Because even though the SSIS catalog of built-in tasks and components is a marvel of engineering, there do remain gaps in the functionality that is provided. These gaps are especially relevant to enterprises practicing Data Integration Lifecycle Management (DILMS) and/or DevOps. One of the gaps is a limitation of the SSIS Execute Package task. Developers using the stock version of that task are unable to select SSIS packages from other projects. Yet it's useful to be able to select and execute tasks across projects, and the example used throughout this book will help you to create an Execute Catalog Package task that does in fact allow you to execute a task from another project. Building on the example's pattern, you can create any task that you like, custom tailored to your specific, data integration and ETL needs. What You Will Learn Configure and execute Visual Studio in the way that best supports SSIS task development Create a class library as the basis for an SSIS task, and reference the needed SSIS assemblies Properly sign assemblies that you create in order to invoke them from your task Implement source code control via Visual Studio Team Services, or your own favorite tool set Code not only your tasks themselves, but also the associated task editors Troubleshoot and then execute your custom tasks as part of your own project Who This Book Is For Database administrators and developers who are involved in ETL projects built around SQL Server Integration Services (SSIS). Readers should have a background in programming along with a desire to optimize their ETL efforts by creating custom-tailored tasks for execution from SSIS packages.
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. UPGRADE TO THE NEW GENERATION OF DATABASE SOFTWARE FOR THE ERA OF BIG DATA!If big data is an untapped natural resource, how do you find the gold hidden within? Leaders realize that big data means all data, and are moving quickly to extract more value from both structured and unstructured application data. However, analyzing this data can prove costly and complex, especially while protecting the availability,performance and reliability of essential business applications. In the new era of big data, businesses require data systems that can blend always-available transactions with speed-of-thought analytics. DB2 10.5 with BLU Acceleration provides this speed, simplicity, andaffordability while making it easier to build next-generation applications with NoSQL features, such as a mongo-styled JSON document store, a graph store, and more. Dynamic in-memory columnar processing and other innovations deliver faster insights from more data, and enhanced pureScale clustering technology delivers high-availability transactions with application-transparent scalability for business continuity. With this book, you'll learn about the power and flexibility of multiworkload, multi-platform database software. Use the comprehensive knowledge from a team of DB2 developers and experts to get started with the latest DB2 trial version you can download at ibm.com/developerworks/downloads/im/db2/. Stay up to date on DB2 by visiting ibm.com/db2/.
Introducing SQL Server is a fast and easy introduction to SQL Server and the world of relational databases. You'll learn how databases work and how to use the T-SQL language by practicing on one of the most widely-used and powerful database engines in the corporate world: Microsoft SQL Server. Do you quake at the sight of a SELECT statement? Start to shiver when people start talking about tables and rows? Fear not, Introducing SQL Server is here to rescue you. The book focuses on the knowledge and skills needed to begin your journey toward becoming a solid and competent SQL Server professional and database programmer. You'll learn the core concepts of SQL Server, from installing the software to executing and profiling queries. Introducing SQL Server is aimed at SQL Server newcomers as well as at those wanting to improve their database skills. You'll put a comprehensive database together as you work through the book. You will create tables and learn to use constraints; create reusable functions and stored procedures; and even learn how indexes work and what they bring in terms of increased performance. Introducing SQL Server shows you that databases don't need to be difficult. * Teaches you how to build a SQL Server database from scratch * Takes a tutorial-based approach, with each chapter building on the last * Covers what you need to know for common SQL Server development tasks
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Get Started on Microsoft SQL Server 2008 in No Time Learn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner's Guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Performance tuning, Database Engine security, Business Intelligence, and XML are also covered. Set up, configure, and maintain SQL Server 2008 Build and manage database objects using Transact-SQL statements Create stored procedures and user-defined functions Optimize database performance, availability, and reliability Implement solid security using authentication, encryption, and authorization Automate tasks using SQL Server Agent Create reliable data backups and perform flawless system restores Use all-new SQL Server 2008 Business Intelligence, development, and administration tools Learn in detail the SQL Server XML technology (SQLXML)
Pro Freeware and Open Source Solutions for Business is a practical guide for the small business owner seeking viable alternative to expensive commercial software packages and subscriptions. This comprehensive look at the powerful alternatives to expensive proprietary software provides an illustrated overview of no-cost software solutions. In this book you will find free and open source solutions for office productivity, PDF creation, accounting, image editing and graphic design, desktop publishing, 3D design, CAD, audio and video editing, website and blog creation, customer relationship management, point of sale, networking and security, and alternatives to the Windows and Macintosh operating systems. This guide helps free the cost-conscious business owner from the bonds of expensive proprietary software by exploring the free and powerful alternatives that exist. You can save a substantial sums of money by replacing just a few commercial software titles with free and open source solutions. Learn how with Pro Freeware and Open Source Solutions for Business today.
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Your One-Stop Guide to Enterprise Reporting with Crystal Reports 2008 Transform disconnected corporate data into compelling, interactive business intelligence using all of the powerful tools available in Crystal Reports 2008. Through detailed explanations, real-world examples, and expert advice, this comprehensive guide shows you how to create, maintain, and distribute dynamic, visually appealing enterprise database reports. Crystal Reports 2008: The Complete Reference explains how to select and gather pertinent business data, organize it into manageable groups, and assemble it into user-friendly business reports. You will learn how to improve report interactivity with sort controls and the parameter panel; solve complex reporting problems with cross-tabs and subreports; integrate Crystal Xcelsius dashboards; reduce development time; and publish your results to Web and Windows applications. Integrate pictures, multimedia files, graphs, and charts Allow user-controlled report sorting with new sort controls Develop sophisticated formulas and custom functions with the Formula Workshop Embed Flash files, including Xcelsius 2008 interactive dashboards Create complex cross-tab reports with new derived rows and columns Export reports into Word, Excel, Acrobat, and updated XML formats Enhance Web interactivity with the new parameter panel and optional parameter fields Work with SQL databases, OLAP cubes, and proprietary systems Centralize design elements and auto-update reports using the repository Schedule and distribute reports with the latest BusinessObjects Enterprise XI 3.0 Embed reports in Web and Windows applications using Visual Studio 2008
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Your Hands-On Guide to SAP ERP Sales & Distribution Written by senior SAP consultant Glynn Williams, Implementing SAP ERP Sales & Distribution is packed with tested, time-saving tips and advice. Learn how to use SAP ERP Central Component 5.0 and 6.0 to create sales documents and contracts, control material and customer master data, schedule deliveries, and automate billing. You'll also find out how to deliver robust financial and transactional reports, track customer and credit information, and interoperate with other SAP modules. Configure and manage the SAP ERP SD module Track sales, shipping, and payment status using master records Create multi-level sales documents and item proposals Develop contracts and rebate agreements Deliver materials and services requirements to the supply chain Plan deliveries, routes, and packaging using Logistics Execution Perform resource-related, collective, and self billing Generate pricing reports, incompletion logs, and hierarchies Handle credit limits, payment guarantees, and customer blocks Integrate user exits, third-party add-ons, and data sharing Configure pricing procedures and complex pricing condition types
This third edition capitalizes on the success of the previous editions and leverages the important advancements in visualization, data analysis, and sharing capabilities that have emerged in recent years. It serves as an accelerated guide to decision support designs for consultants, service professionals and students. This 'fast track' enables a ramping up of skills in Excel for those who may have never used it to reach a level of mastery that will allow them to integrate Excel with widely available associated applications, make use of intelligent data visualization and analysis techniques, automate activity through basic VBA designs, and develop easy-to-use interfaces for customizing use. The content of this edition has been completely restructured and revised, with updates that correspond with the latest versions of software and references to contemporary add-in development across platforms. It also features best practices in design and analytical consideration, including methodical discussions of problem structuring and evaluation, as well as numerous case examples from practice.
Book-and-video package gets novices up to speed on Microsoft SQL Server 2012
If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book-and-video package from authority Brian Knight is the perfect solution. Each lesson includes three major components: a description of how each SSIS feature or process works, a tutorial that walks you through the process or technique, and an accompanying video lesson. It's a complete learning package that will give you the confidence you need to start your first SSIS project. Guides novice database administrators and developers who are learning Microsoft SQL Server 2012 and SQL Server Integration Services (SSIS) Provides expert instruction from leading SQL Server authority and author, Brian KnightIncludes a book and a video, complete instruction that includes lessons, hands-on tutorials, and video demonstrations by the authorCovers the very latest changes and updates in the SQL Server 2012 release
"Microsoft SQL Server 2012 Integration Services 24-Hour Trainer" makes SQL Server 2012 and SSIS much less intimidating.
Note: CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.
Develop RESTful web services using the Flask micro-framework and integrate them using MySQL. Use Flask to develop, deploy, and manage REST APIs with easy-to-read and understand Python code. Solve your problem from a choice of libraries. Learn to use MySQL as the web services database for your Flask API using SQLAlchemy ORM. Building REST APIs with Flask provides a primer on Flask, RESTful services, and working with pip to set up your virtual environment. The key differences between NoSQL and SQL are covered, and you are taught how to connect MySQL and Flask using SQLAlchemy. Author Kunal Relan presents best practices for creating REST APIs and guides you in structuring your app and testing REST endpoints. He teaches you how to set up authentication and render HTML using views. You learn how to write unit tests for your REST APIs, and understand mocks, assertions, and integration testing. You will know how to document your REST APIs, deploy your Flask application on all of the major cloud platforms, and debug and monitor your Flask application. What You'll Learn Use MySQL to create Flask REST APIs Test REST endpoints Create CRUD endpoints with Flask and MySQL Deploy Flask on all of the major cloud platforms Monitor your Flask application Who This Book Is For Python developers interested in REST API development using Flask and web developers with basic programming knowledge who want to learn how Python and REST APIs work together. Readers should be familiar with Python (command line, or at least pip) and MySQL.
Cutting-edge information on databases for research and clinical practice in neuropathy! Quantitative Electroencephalographic Analysis (QEEG) Databases for Neurotherapy: Description, Validation, and Application examines the strengths and limitations of QEEG databases as a tool for the diagnosis of neurological and psychiatric disorders. This book is written by experts who have had considerable experience in either the development of databases or in working with them. This text can improve your ability to fine-tune existing protocols and develop new ones leading to better treatment, better long-term outcome, and fewer training sessions. Quantitative Electroencephalographic Analysis (QEEG) Databases for Neurotherapy can help you differentiate cognitive states, clinical disorders, and EEG changes throughout the lifespan of a patient. This book also reveals the latest technological developments and methodological practices, and comparisons are made between EEG databases to help you determine what is best for your needs. Several controversies involving quantitative EEGs are discussed, including ethical concerns and early criticisms against the use of these methods for diagnostic purposes. This book addresses important topics such as: the development of methodology for estimating the deviance from the database norms to determine abnormal brain functioning the most widely used QEEG databases their construction and application as well as a comparison and contrast of their features the creation of a universal set of standards for determining which database is suitable for a researcher's or practitioner's needs the use of quantitative EEG and normative databases for clinical purposes ethical concerns, advantages and limitations, and the proposal for a new clinical approach for neurotherapy the comparison of QEEG reference databases in analysis and in the evaluation of Adult Attention Deficit Hyperactivity Disorder Quantitative Electroencephalographic Analysis (QEEG) Databases for Neurotherapy is supplemented with case studies, tables, figures, and graphs to support the experts' most recent findings. Furthermore, several chapters contain topographic maps to show the effects of these databases in clinical practice. This volume will be helpful to both novice and advanced neurotherapists in professions such as medicine, psychiatry, psychology, social work, nursing, and biofeedback.
Pro SQL Server 2008 Failover Clustering is dedicated to the planning, implementation, and administration of clustered SQL Server 2008 implementations. Whether deploying a singleinstance, twonode cluster or a multiplenode, manyinstance cluster for consolidation, this book will detail all of the considerations and pitfalls that may be encountered along the way. Clustering and highavailability expert Allan Hirt shares his many years of wisdom and experience, showing how to put together the right combination of people, processes, technology, and best practices to create and manage worldclass, highly available SQL Server 2008 failover clusters.Provides a comprehensive look at SQL Server 2008 failover clustering from the first steps of planning to daily administration Goes beyond just SQL Server 2008 and also covers Windows Server 2008 clustering in depth with a SQL Server focus Covers how and where virtualization can be used with failover clusters Addresses the needs of enterpriseclass, 24/7 SQL Server 2008 implementations Written by the leading expert on SQL Server failover clustering What you'll learn Understand what failover clustering is, how it works, and how it can benefit SQL Server deployments. Configure disk subsystems to support failover clustering implementations. Plan, implement, and administer Windows Server 2008 clustering for use with SQL Server 2008. Plan, implement, and administer new SQL Server 2008 failover clustering instances. Upgrade existing SQL Server 2000 and SQL Server 2005 failover clustering instances to SQL Server 2008. Create virtualized clusters for use in test and development environments. Who this book is for
This book is for IT administrators and database administrators who are faced with implementing and administering clustered SQL Server 2008 instances. This book is also for those who will be upgrading existing SQL Server 2000 or SQL Server 2005 failover clustering instances to SQL Server 2008. Table of Contents Failover Clustering Basics Preparing to Cluster Windows Clustering Windows Server 2008 Part 1: Preparing Windows Clustering Windows Server 2008 Part 2: Clustering Windows Preparing to Cluster SQL Server 2008 Installing a New SQL Server 2008 Failover Clustering Instance Upgrading to SQL Server 2008 Failover Clustering Administering a SQL Server 2008 Failover Cluster Virtualization and Failover Clustering
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.
You may like...
MySQL Workbench: Data Modeling…
Michael McLaughlin Paperback
PeopleSoft PeopleTools Data Management…
Paula Dean, Jim Marion Paperback
Microsoft SQL Server 2012 Master Data…
Tyler Graham Paperback
Effective MySQL Replication Techniques…
Ronald Bradford, Chris Schneider Paperback
FileMaker Pro Design and Scripting For…
Timothy Trimble Paperback
Effective MySQL Backup and Recovery
Ronald Bradford Paperback
Beginning PHP and MySQL - From Novice to…
Frank M. Kromann Paperback
Expert SQL Server Transactions and…
Dmitri Korotkevitch Paperback
SQL Antipatterns - Avoiding the Pitfalls…
Bill Karwin Paperback
Murach's MySQL, 3rd Edition
Joel Murach Paperback