SQL Server Hardware Choices Made Easy

Free eBook “SQL Server Hardware Choices Made Easy” from Red Gate software. Relational databases place heavy demands on their underlying hardware. Many databases are mission-critical resources for multiple applications, where performance bottlenecks are immediately noticeable and often very costly to the business. Despite this, many database administrators are not very knowledgeable about server hardware.
Description
The idea behind this eBook is to provide a quick “heads up” to the issues that I have found to be most important when choosing and configuring hardware for use with SQL Server, by providing a series of specific tips or pieces of advice. In 30 short tips, it provide advice on how to: choose a processor, and related hardware, for database servers, and the factors that will influence that choice, choose a processor for test and development systems, provision and configure your disk subsystem.
Contents

• Server processors and related hardware
• Desktop and laptop processors and related hardware
• Configuring the disk subsystem
• Recommended Intel and AMD processors

Download: SQL Server Hardware Choices

Physical Modeling in MATLAB

Most books that use MATLAB are aimed at readers who know how to program. “Physical Modeling in MATLAB” is an introductory textbook for people who have not programmed before. It covers basic MATLAB programming with emphasis on modeling and simulation of physical systems. You can download this free book as a pdf file or read it online.
Description
Written for beginners, this book provides an introduction to programming in MATLAB and simulation of physical systems. The book begins with scalar values and gradually works up to vectors and matrices. Topics covered include variables and values, scripts, loops, ordinary differential equations, vectors, and functions. MATLAB is used throughout the book to solve many end-of-chapter exercises. Most books that use MATLAB are aimed at readers who know how to program. This book is for people who have never programmed before.
Contents

• Variables and values
• Scripts
• Loops
• Vectors
• Functions
• Zero-finding
• Functions of vectors
• Ordinary Differential Equations
• Systems of ODEs
• Second-order systems
• Optimization and Interpolation
• Vectors as vectors

Download : Modelling in Matlab

SQL Server DMV Starter Pack

Free eBook “SQL Server DMV Starter Pack” from Red Gate. The Dynamic Management Views booklet offers an introduction to DMVs and de-mystifies the process of collecting the information you need to troubleshoot SQL Server problems.
Description
The SQL Server DMV Starter Pack also contains more than 30 sample scripts that you can use to diagnose common SQL Server performance problems.
The Dynamic Management Views booklet offers an introduction to DMVs and de-mystifies the process of collecting the information you need to troubleshoot SQL Server problems. Dynamic Management Objects (DMOs) are a set of SQL Server objects, stored in the system schema, which provide the SQL Server DBA with a window into the activities being performed on their SQL Server instances, and the resources that this activity is consuming.
Contents

• Introducing Dynamic Management Objects
• Connections, Sessions, Requests, Queries
• Transactions
• Databases and Indexes
• Disk I/O
• Operating System
• Other Useful DMVs

Download: SQL Server DMV

Getting started with DB2 application development

Free eBook “Getting started with DB2 application development”, written by Raul F. Chong, Xiqiang Ji, Priyanka Joshi, Vineet Mishra and Min Wei Yao from IBM. This book is intended for anyone who works with or intends to develop database applications such as application developers, consultants, software architects, instructors, and students. It is a good reference as well for database administrators (DBAs) and product managers.
Description
This book is closely related to the eBook Getting Started with DB2 Express-C; it expands the application development chapters covered in that book.
Contents

• Introduction to DB2 application development
• DB2 pureXML
• Stored procedures, UDFs, triggers, and data Web services
• Application development with Java
• Application development with C/C++
• Application Development with .NET
• Application development with Ruby on Rails
• Application development with PHP
• Application development with Perl
• Application development with Python
• Solutions to the review questions
• Troubleshooting

Download: Getting started with DB2

Database fundamentals

Free eBook “Database fundamentals” from IBM. Get the fundamentals to learn about databases.
Description
Read this free ebook to: Learn relational database theory, Understand different information models, Learn logical and physical database design, Get the basics of the SQL language and XML, Practice using hands-on exercises.
This book is tailored for new database enthusiasts, application developers, database administrators, and anyone with an interest in the subject and looking to get exposure such as university students and new graduates.
Contents

• Databases and information models
• The relational data model
• The conceptual data model
• Relational Database Design
• Introduction to SQL
• Stored procedures and functions
• Using SQL in an application
• Query languages for XML
• Database Security
• Technology trends and databases

Download:  Database Fundamentals

Troubleshooting SQL Server: A Guide for the Accidental DBA

Red Gate Software is offering another free eBook. This time “Troubleshooting SQL Server: A Guide for the Accidental DBA”, written by Jonathan Kehayias and Ted Krueger can be downloaded in pdf format along with a free trial version of SQL Monitor software.
Description
This book will help you understand how to approach troubleshooting and the essential tools you need. And explore the areas where problems regularly arise and the tools you can use to diagnose them. Also you can get practical solutions to remove the root causes of issues.
The primary audience for this book is anyone who has found themselves in charge of SQL Server “by accident;” in other words, the accidental/involuntary DBAs and system administrators who have had guardianship of SQL Server databases added to their roles, because there is a SQL Server in their environment, and someone has got to look after it.
However, the troubleshooting concepts and methodologies covered in this book can be applied by anyone, including seasoned database administrators, to identify and resolve common problems and learn new tricks for managing and maintaining SQL Server.
Contents

• A Performance Troubleshooting Methodology
• Disk I/O Configuration
• High CPU Utilization
• Memory Management
• Missing Indexes
• Blocking
• Handling Deadlocks
• Large or Full Transaction Log
• Truncated Tables, Dropped Objects and Other Accidents Waiting to Happen

Download :  Troubleshooting SQL Sever

Oracle Essentials 4th Edition

Red Gate software is offering the eBook version of “Oracle Essentials 4th Edition: Oracle Database 11g”, published by O’Reilly Media, free of charge for a limited period. Download this 408 page book in pdf format.
Description
We wrote this book for people possessing all levels of Oracle expertise. Our target audiences include DBAs who spend most of their workday managing Oracle, application developers who build their systems on the data available in an Oracle database, and system administrators who are concerned with how Oracle will affect their computing environments.
Contents

• Introducing Oracle
• Oracle Architecture
• Installing and Running Oracle
• Oracle Data Structures
• Managing Oracle
• Oracle Security, Auditing, and Compliance
• Oracle Performance
• Oracle Multiuser Concurrency
• Oracle and Transaction Processing
• Oracle Data Warehousing and Business Intelligence
• Oracle and High Availability
• Oracle and Hardware Architecture
• Oracle Distributed Databases and Distributed Data
• Oracle Extended Datatypes
• Beyond the Oracle Database

Download:  Oracle Essentials

Java Fundamentals

Free online book “Java Fundamentals: A entry level textbook on the Java programming language” by Gary Marrer.
Description
In this eBook, we will actually develop three different kinds of Java programs. We will start by creating what’s called a console application. This console application is executed from the Windows (or Linux or Apple, or Palm or etc.) command line or what is more commonly called the DOS prompt. This application is one which will look very crude and unsophisticated as compared to what we’re used to seeing in a Windows, Macintosh or Linux environment. The next type of application which will develop is one that was more familiar with.
Contents

• History of Java
• What makes Java, Java
• Design Tools (Modeling Program Logic)
• Program Documentation
• Identifiers: Variables and Constants
• Structured Programming
• Using Repetition Structures
• Arrays 101
• Introduction to Object Orientated Programming
• Inheritance Expanded
• AWT versus Swing Packages
• Arrays Revisited
• Adding data persistence to programs

Download: Java Fundamentals

Building Hybrid Applications in the Cloud on Windows Azure

Building Hybrid Applications in the Cloud on Windows Azure” is the 3rd release of Windows Azure Guidance from Microsoft. This guide provides in-depth guidance on how to architect and build hybrid solutions on and with the Windows Azure platform.
Description
This guide focuses on the common issues you will encounter when building applications that run partly in the cloud and partly on-premises, or when you decide to migrate some or all elements of an existing on-premises application to the cloud. It focuses on using Windows Azure as the host environment, and shows how you can take advantage of the many features of this platform, together with SQL Azure, to simplify and speed the development of these kinds of applications.
This guide is intended for architects, developers, and information technology (IT) professionals who design, build, or operate applications and services that run on or interact with the cloud. Although applications do not need to be based on the Microsoft® Windows® operating system to operate in Windows Azure, this book is written for people who work with Windows-based systems. You should be familiar with the Microsoft .NET Framework, the Microsoft Visual Studio® development system, ASP.NET MVC, and the Microsoft Visual C#® development language.
Contents

• The Trey Research Scenario
• Deploying the Orders Application and Data in the Cloud
• Authenticating Users in the Orders Application
• Implementing Reliable Messaging and Communications with the Cloud
• Processing Orders in the Trey Research Scenario
• Maximizing Scalability, Availability, and Performance in the Orders Application
• Monitoring and Managing the Orders Application
• Replicating, Distributing, and Synchronizing Data
• Authenticating Users and Authorizing Requests
• Implementing Cross-Boundary Communication
• Implementing Business Logic and Message Routing
• Maximizing Scalability, Availability, and Performance
• Monitoring and Managing Hybrid Applications

Download: Building Hybrid Applications in the Cloud