|
Books > Computing & IT > Computer software packages > Database software
In his new book, Brad's Sure Guide to SQL Server Maintenance Plans,
Brad McGehee takes you on a comprehensive tour of two SQL Server
tools designed to help DBAs ensure that a "required minimum" level
of maintenance takes place on their SQL Server instances: the
Maintenance Plan Wizard and the Maintenance Plan Designer. Table of
Contents * Chapter 01: Why is Database Maintenance Important?
Chapter 02: Before you Create any Maintenance Plans Chapter 03:
Getting Started with the Maintenance Plan Wizard Chapter 04: Task
Scheduling Chapter 05: Check database Integrity Task Chapter 06:
Shrink Database Task Chapter 07: Rebuild Index Task Chapter 08:
Reorganize Index Task Chapter 09: Update Statistics Task Chapter
10: Execute SQL Server Agent Job Task Chapter 11: History Cleanup
Task Chapter 12: Define Back Up Database (Full) Task Chapter 13:
Define Back Up Database (Differential) Task Chapter 14: Back Up
Database (Transaction Log) Task Chapter 15: Maintenance Cleanup
Task Chapter 16: Using the Maintenance Plan Designer Why read this
book? Millions of SQL Server instances run in the offices of small
and medium-sized organizations and there are many "accidental" DBAs
out there whose job it is to maintain them. Often, they find that
they don't have the knowledge, experience, or critically the time,
to perform the correct level of maintenance on their SQL Server
databases, much as they might like to. This can mean poor
performance and reduced availability. Regardless of the size of
your organization, if your mission critical data becomes
unavailable, then business will suffer greatly. The Maintenance
Plan Wizard and Designer allow you to configure and schedule eleven
core database maintenance tasks, ranging from integrity checks, to
database backups, to index reorganizations and rebuilds. Brad walks
through every one of these tasks covering: * The intent of each
task and why it's important * How to configure each task and what
all the options mean * Scheduling considerations: when and how
often should you run the task? * Customizing and extended your
Maintenance Plans using the Designer Used carefully, these
Maintenance Plan tools represent powerful time-saving devices for
any DBA. At each stage of the book, Brad explains clearly the
correct and incorrect uses for the tool, and indicates where more
advanced solutions, using T-SQL or PowerShell scripting, would be
more appropriate.
The duties and responsibilitie:s of a Database Administrator (DBA)
make for long and dynamically changing list, ranging from offering
query tuning advice, to cutting stored procedures, all the way
through to system process design and implementation for high
availability. A DBA's tasks, from day-to-day, are rarely constant;
with one exception: the need to ensure each and every day that any
database in their charge can be restored and recovered, in the
event of error of disaster. This means that if a database, for
whatever reason, gets corrupted, dropped, or otherwise becomes
unusable, then it is the DBA's responsibility to restore that
database to the state it was in before the problem occurred, or as
close as is possible. Of course, this doesn't mean that a DBA is
required to restore a database each and every day, just that if
disaster does strike the DBA must be prepared to deal with it,
regardless of when or why it occurs. If a DBA isn't prepared, and
significant data is lost, or databases become unavailable to end
users for long periods of time, then that DBA probably won't be in
their job for too long. This is why a good, and tested, SQL Server
backup and restore plan must be on the top of every administrative
DBA's list of tasks. In this book, you'll discover how to perform
each of these backup and restore operations using SQL Server
Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL
Backup tool. Capturing backups using SSMS or simple scripts is
perfectly fine for one-off backup operations, but any backups that
form part of the recovery strategy for any given database must be
automated and you'll also want to build in some checks that, for
example, alert the responsible DBA immediately if a problem arises.
The tool of choice in this book for backup automation is Red Gate
SQL Backup. Building your own automated solution will take a lot of
work, but we do offer some advice on possible options, such as
PowerShell scripting, T-SQL scripts and SQL Server Agent jobs.
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. Master
Application Development in a Mixed-Platform EnvironmentBuild
powerful database applications in a mixed environment using the
detailed information in this Oracle Press guide. Oracle Database
11g & MySQL 5.6 Developer Handbook lays out programming
strategies and best practices for seamlessly operating between the
two platforms. Find out how to migrate databases, port SQL
dialects, work with Oracle MySQL databases, and configure effective
queries. Security, monitoring, and tuning techniques are also
covered in this comprehensive volume. Understand Oracle Database
11g and MySQL 5.6 architecture Convert databases between platforms
and ensure transactional integrity Create tables, sequences,
indexes, views, and user accounts Build and debug PL/SQL, SQL*Plus,
SQL/PSM, and MySQL Monitor scripts Execute complex queries and
handle numeric and date mathematics Merge data from source tables
and set up virtual directories
This book is written in a simple, easy to understand format with
lots of screenshots and step-by-step explanations. If you are an
IDAM or database administrator looking to carry out administration
tasks right that begin with installation,and configuration, then
this guide is for you. You need not have any prior administration
skills to get started with this book.
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. Link
and Embed Oracle CRM On Demand ReportsIntegrate business
intelligence directly into day-to-day business processes by
presenting analytic reports to end users in applications. Oracle
CRM On Demand Embedded Analytics shows you how to link and embed
reports throughout Oracle CRM On Demand. This Oracle Press guide
explains how to plan, design, and develop reports; make them
available through hyperlinks; and embed reports in a variety of
locations easily accessible to end users. Real-world examples and
time-saving tips are included throughout this practical resource.
Navigate the report development environment within Oracle CRM On
Demand Configure administrative settings to access report
development and embedding tools Design reports for linking and
embedding in applications Format columns, filter data, and add and
edit views, including pivot tables and pivot charts Add link
functionality to Oracle CRM On Demand and your reports Embed
reports using HTML and URL encoding Display reports inside
dashboards and on home page screens Embed reports inside other
reports Add reports and dashboards to custom Web tabs and desktop
applications Include external sites in reports
There are many ways of configuring and using Oracle EBS R12
Financials. This cookbook demonstrates how to use EBS R12
Financials in a way that will enable you to understand the core
functionalities of the main financials modules. Each recipe is
presented as part of a scenario-based chapter that details typical
business scenarios. This book is for EBS Financials specialists who
want a broader understanding of particular areas of the financials
modules. Businesses can use this book to identify key
functionalities of the financial modules, and very quickly
demonstrate a pilot to obtain the core requirements. If you are a
Business Analyst, Functional Consultant, Technical Consultant,
Project Sponsor, Project Manager, Project Team Member, System
Accountant or Solution Designer, Testing Team Member, Training Team
Member or Support Team Member, then this book is for you. This book
assumes that you have basic navigation skills and you understand
the key Oracle EBS terminology, novice EBS professionals will also
gain from the expert content of this book.
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. Master
Oracle Business Process Management Suite 11gWritten by Oracle
business process management experts, Oracle Business Process
Management Suite 11g Handbook is a balanced combination of
essential BPM concepts, best practices, and a detailed treatment of
all the powerful features and functionalities of Oracle BPM Suite
11g. The book explains how to plan, develop, and deploy
process-based business applications and enable enterprise-wide
continuous process improvement. Implement successful BPM projects
with help from this Oracle Press guide. Understand the architecture
and functionalities of Oracle BPM Suite 11g Master BPMN 2.0 for
business process modeling and implementation Address agility,
business control, and transparency requirements with Oracle
Business Rules 11g Develop rich interfaces with Oracle Application
Development Framework (Oracle ADF) Work with the human task
component of Oracle BPM 11g Plan a BPM initiative using the Oracle
roadmap approach Apply the Oracle process engineering method to
identify, select, define, and refine appropriate processes
Implement a business process application using proven technical
design and project delivery strategies
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. Master
Oracle Streams 11g ReplicationEnable real-time information access
and data sharing across your distributed framework using the expert
information in this Oracle Press guide. Oracle Streams 11g Data
Replication explains how to set up and administer a unified
enterprise data sharing infrastructure. Learn how to capture,
propagate, and apply database changes, transform data, and handle
data conflicts. Monitoring, optimizing, and troubleshooting
techniques are also covered in this comprehensive volume.
Understand Oracle Streams components and architecture Gain in-depth
knowledge about capturing, propagating, and applying data
manipulation language (DML) and data definition language (DDL)
changes Learn how to access and modify the contents of Logical
Change Records Build custom procedures for data transformations
Configure Oracle Streams replication for the database, schemas, and
tables Tune Oracle Streams performance for improved throughput
Manage and monitor Oracle Streams using Oracle Enterprise Manager
Grid Control Learn from several practical examples and scripts
This cookbook presents solutions to problems in the form of
recipes. Each recipe provides the reader with easy step-by-step
descriptions of the actions necessary to accomplish a specific
task. Example values and code samples are used throughout the
recipes, which makes adaptation for individual needs easy. This
book is for ambitious MySQL users as well as professional data
center database administrators. Beginners as well as experienced
administrators will benefit from this cookbook and get fresh ideas
to improve their MySQL environments. Detailed background
information will enable them to widen their MySQL horizon. It does
not cover SQL basics, how to install MySQL servers, or how to
design a relational database schema. Readers are expected to have a
basic understanding of the SQL language and database concepts in
general.
This is a practical, tutorial-style book that includes many
examples to demonstrate the full potential of MySQL for Python.
Every chapter starts with an explanation of the various areas for
using MySQL for Python and ends with work on a sample application
using the programming calls just learned. All complicated concepts
are broken down to be very easy to understand. Everything in the
book is designed to help you learn and use MySQL for Python to
address your programming needs in the fastest way possible. This
book is meant for intermediate users of Python who want hassle-free
access to their MySQL database through Python. If you are a Python
programmer who wants database-support in your Python applications,
then this book is for you. This book is a must-read for every
focused user of the MySQL for Python library who wants real-world
applications using this powerful combination of Python and MySQL.
A practical, focused tutorial, this book will show you how to use
Oracle Enterprise Manager Grid Control 11g R1 to deliver Business
Service Management (BSM). Best practices cutting across multiple
product verticals like Database, Middleware, Packaged Applications,
and Custom Business Services are also covered. If you are a System
Administrator or Application Administrator who is responsible for
Business Service Management (BSM) using Oracle Enterprise Manager
Grid Control 11g R1, then this book is for you. You need basic
knowledge of Middleware/Application Servers, Business Service
Management, and Oracle Enterprise Manager Grid Control.
This book is a comprehensive guide that shows developers how to
design and develop business processes in BPEL efficiently.
Throughout the book, the authors discuss important concepts and
show real-world examples covering Oracle SOA Suite 11g and related
products. This book is aimed at SOA architects and developers
involved in the design, implementation, and integration of
composite applications and end-to-end business processes. The book
provides comprehensive coverage of WS-BPEL 2.0 for implementing
business processes and developing SCA composite application,
dealing with the issues of composition, orchestration,
transactions, coordination, and security. This book uses Oracle SOA
Suite 11g and related Oracle products. To follow this book you need
to have basic knowledge of XML, web services, and Java EE.
We spend much of our working life trying to help people solve SQL
Server-related performance problems, either hands-on, during
consulting, or on various online community forums. Over the years,
we've been exposed to a few weird-and-wonderful SQL Server issues
but, mainly, we've seen the same problems and the same
misconceptions about how SQL Server works crop up time-and-again.
This book is our attempt to describe, diagnose, and solve some of
the most common problems associated with the currently-supported
versions of SQL Server: SQL Server 2005, 2008, and 2008 R2.
This book provides a practical, hands-on experience. Chapter by
chapter, a Siebel CRM self-study environment is created which can
be used to follow the examples described in the book to explore the
Siebel functionality. The book ensures that you understand what you
are doing and why you are doing it. It contains clear step-by-step
instructions, explanatory tables, screenshots, and precise
diagrams. This book is for administrators who want to develop and
strengthen their Siebel CRM skills in the areas of installation and
system management. Whether you are a novice or a more experienced
user, this book will teach you something new in many ways and by
the end of the book, you will be ready to install and manage Siebel
CRM in a real-world environment.
This book is a comprehensive guide, split into three sections. The
initial section of the book provides an introduction to the Oracle
SOA Suite and its various components, and will give you an in-depth
fast-paced hands-on introduction to each of the key components. The
next section provides an in-depth best-practice guide to applying
the various components of the SOA Suite to implement a real-world
SOA-based solution; it illustrates this through the development of
an auction site (oBay). The final section covers other
considerations such as the packaging, deployment, testing,
security, and administration of SOA applications. If you are a
developer or a technical architect who works in the SOA domain,
this book is for you. The primary purpose of the book is to provide
you with a hands-on practical guide to using and applying the
Oracle SOA Suite in the delivery of real-world composite
applications. You need basic understanding of the concepts of SOA,
as well as some of the key standards in this field, including web
services (SOAP, WSDL), XML Schemas, and XSLT (and XPath).
This book uses the approach of a cookbook. Each recipe provides the
reader with easy step-by-step descriptions of the actions necessary
to accomplish a specific task. It is designed to present what often
appear as extremely complicated techniques as a series of
simple-to-follow recipes, allowing readers to achieve high uptimes
on their MySQL servers. This book is targeted at system
administrators or database administrators who have basic
familiarity with Linux, the shell, and MySQL. The typical user will
be able to get MySQL installed and working, but needs practical
guidance to make it highly available.
This Book, Written For Readers Who Have Little Or No Previous
Experience With Databases, SQL, Or SQL Server, Provides A Very
Systematic Approach To Learning SQL Using SQL Server. Each Chapter
Is Written In A Step-By-Step Manner And Has Examples That Can Be
Run Using SQL Server. Using The Sample Tables And Data Provided,
The Reader Of This Book Will Be Able To Do All The Examples To
Experience Hands-On SQL Programming In SQL Server. The Book Also
Presents A Series Of Exercises At The End Of The Chapters To Help
Readers Gain Proficiency With SQL. With This Book You Will Learn
Beginning SQL Commands - How To Retrieve And Manipulate Data Using
The Simple SELECT Statement; How To Customize SQL Server 2008'S
Settings And About SQL Server 2008'S Functions; How To Create,
Alter, Populate And Delete Tables; About Joins, A Common Database
Mechanism For Combining Tables; Query Development, The Use Of Views
And Other Derived Structures; Simple Set Operations; About
Aggregate Functions; How To Write Subqueries And Correlated
Subqueries; How To Create And Use Indexes And Constraints;
Transaction Processing.
Improving database performance requires an equal mix of
understanding theoretical concepts and working through hands-on
examples. You'll find both here. Many of the examples given will be
immediately useful for monitoring and improving your PostgreSQL
deployments, providing insight into hard-to-obtain information
about your database. This book is aimed at intermediate to advanced
database administrators using or planning to use PostgreSQL.
Portions will also interest systems administrators looking to build
or monitor a PostgreSQL installation, as well as developers
interested in advanced database internals that impact application
design.
This is a hands-on walkthrough, from gathering information to
creating a report to the presentation sections. It helps you to get
accustomed to the software and gives an in-depth understanding of
how to easily unleash the powerful functionality of the software.
As a result you will be able to use the powerful functionalities of
Oracle Hyperion Interactive Reporting 11 to drive important
business decisions. The style of the book allows you to use it as a
guide to walk through each chapter or as reference material while
you work with the software. This book is for all Oracle Hyperion
Interactive reporting users from novice to advanced. If you find
yourself struggling while using this tool or you are new to the
tool, this book will guide you through and make the learning
process incremental.
|
You may like...
A Guide To SQL
Philip Pratt, Hassan Afyouni, …
Paperback
R1,253
R1,119
Discovery Miles 11 190
Pro Oracle Spatial
Ravikanth Kothuri, Euro Beinat, …
Hardcover
R1,540
R1,291
Discovery Miles 12 910
Promethean Oracle
Sophia Shultz, Mark Cogan
Miscellaneous printed matter
R1,014
R788
Discovery Miles 7 880
|