This book will help you learn and use XML Schema collections in SQL Server. Prior knowledge of XSD is not required to start with this book, although any experience with XSD will make your learning process easier. This book starts with the basics of XML schemas and then walks you through everything you need to know, with examples and labs, in order to build powerful XML schemas in SQL Server.

The Art of XSD - SQL Server XML schemas

Computers & Technology

Sebastian, Jacob

Programming Languages

Red gate books

Phil Factor is a legend in his own runtime. Scurrilous, absurd, confessional and scathing by turns, Confessions of an IT Manager targets the idiocy, incompetence and overreach of the IT management industry from vantage point all the way up and down the greasy pole. Phil Factor (real name witheld to protest the guilty) has over 20 years experience in the IT industry, specializing in database-intensive applications. For withering insight into the human weaknesses and farcical levels of ineptitude that bring IT projects to their knees, plus occasional escapes into burnished pastiche and cock-a-leg doggerel there is no funnier, more illuminating commentary on the IT crowd.

Confessions of an IT Manager

Business & Money

Factor, Phil

Management & Leadership

For the day-to-day DBA, there are dangers around every corner; monsters waiting to strike down the unsuspecting database with a resource-hungry query, an inefficient data load, or even outright data corruption. When the worst happens, and SQL Server is down, or performance is suffering, customers are quick to complain. During such difficult periods, you, the DBA, are the centre of attention. Suddenly, three or four people crowd your desk, laser beam focused on your every action, fully expecting you to solve the problem quickly. The success of your career as a DBA depends largely on how well-prepared you are to deal with such situations. Without verified backups, sound server documentation, and a ready supply of tried-and tested troubleshooting tools, there is no safe place to hide when the monster rears up. All you can do is buy some time, patch things up as best you can and then duck away into your cubicle, which, if you lost any data in the process, may soon be empty. However, with the tools and techniques provided in the SQL Server Tacklebox, you will be fully-equipped to fight back. Inside, you'll find scripts that will allow you to automate and standardize SQL Server installation, document and report on your servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending danger, secure access to your servers and fight off data corruption. In short, you'll be able to respond quickly and professionally to the many issues that blight the waking, and often sleeping, hours of the DBA. Then, one day, who knows? That cubicle may turn into an executive office with wall-to-wall tinted windows revealing a flowing brook outside, where no monsters live.

SQL Server Tacklebox Essential Tools and Scripts for the Day-To-Day DBA

Landrum, Rodney

Editorial Review As the backbone to so many commercial communications infrastructures, Microsoft's Exchange Server technology has become a critical component in many an IT department. With the latest incarnation of Exchange Server on the horizon, and indeed almost upon us, it is becoming increasingly urgent that SysAdmins get to grips with this latest-and-greatest technology. What's new? What's gone? What's easier or harder? Jaap touches upon all these essentials. As a practical field-guide to Exchange Server 2010, this book will tell you exactly what you need to know to get started with upgrading, installing, configuring and managing your new Exchange Server. If you need to get to grips with Exchange Server 2010 fast, or want a short, to-the-point, practical guide to Microsoft's latest offering, then you should read this book. Table of Contents * Chapter 01: Introduction to Exchange Server 2010 * Chapter 02: Installing Exchange Server 2010 * Chapter 03: Exchange Server 2010 Coexistence * Chapter 04: Managing Exchange Server 2010 * Chapter 05: High Availability in Exchange Server 2010 About the Author Jaap Wesselius is a senior Exchange consultant for DM Consultants (http://www.dm-consultants.nl/), a Microsoft Gold Partner with a strong focus on messaging and collaboration solutions. Prior to working for DM Consultants Jaap worked for 8 years for Microsoft Services in The Netherlands, specializing in Exchange Server. Jaap is a BSc, MCSE, MCITP, and MCT and was awarded the Microsoft MVP Award (Exchange Server) for his contributions to the Dutch messaging and collaboration community. Besides Exchange Server, Jaap is also very active in virtualization and is a founder of the Dutch Hyper-V community. You can reach Jaap at J.Wesselius@dm-consultants.nl or Jaap@hyper-v.nu

Exchange 2010 - A Practical Approach

Wesselius, Jaap

Networking & Cloud Computing

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.

Brad's Sure Guide to SQL Server Maintenance Plans (DBA Handbooks)

McGehee, Brad M.

SQLServerCentral.com brings you a variety of articles on all aspects of SQL Server from administration to XML and everything in between. Our articles are written by real DBAs and developers, based on the articles and scripts they use in their daily work. And this book is a collection of the best articles we've seen from the past year from over 50 authors.

The Best of SQLServerCentral.com, Vol.7

How do you price your software? Is it art, science or magic? How much attention should you pay to your competitors? This short handbook will provide you with the theory, practical advice and case studies you need to stop yourself from reaching for the dice. Table of Contents Chapter 01: Some - but not too much - Economics Chapter 02: Pricing Psychology: What is your product worth? Chapter 03: Pricing Pitfalls Chapter 04: Advanced Pricing Chapter 05: What your price says about you (and how to change it) Why read this book? "At Business of Software 2007 Michael Pryor held an impromptu session on how to price your software. So many people turned up, and so many people kept on arriving, that by the time they’d introduced themselves there was no time left to talk about software pricing. I’ve had similar experiences; in fact, “How do I price my software?” is probably the most common question I’m asked by software entrepreneurs and product managers. This handbook is an attempt to answer that question." Neil Davidson, Author. About the Author Neil Davidson is co-founder and joint CEO of Red Gate Software. Red Gate was founded in 1999 and now employs some 150 people. It was Cambridge News business of the year in 2006 and has been in the Sunday Times top 100 companies to work for three years running. It was founded with no VC money and little debt. Neil is also founder of the annual Business of Software conference and runs the Business of Software social network.

Don't Just Roll the Dice - A Usefully Short Guide to Software Pricing

Davidson Ph., Neil

Industries

In the Complete Guide .NET Performance and Optimization, Paul Glavich and Chris Farrell offer a comprehensive and essential handbook to anybody looking to set up a .NET testing environment and get the best results out of it, or just learn effective techniques for testing and optimizing their .NET applications.

.Net Performance Testing and Optimization - The Complete Guide

Farrell, Chris

Glavich, Paul

Programming

Defensive Database Programming with SQL Server

Kuznetsov, Alex

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions. Why, then, aren't all DBAs using them? Why do many DBAs continue to ignore them in favour of "tried and trusted" tools such as sp_who2, DBCC OPENTRAN, and so on, or make do with the "ready made" reports built into SSMS? Why do even those that do use the DMVs speak wistfully about "good old sysprocesses"? There seem to be two main factors at work. Firstly, some DBAs are simply unaware of the depth and breadth of the information that is available from the DMvs, or how it might help them troubleshoot common issues. This book investigates all of the DMVs that are most frequently useful to the DBA in investigating query execution, index usage, session and transaction activity, disk IO, and how SQL Server is using or abusing the operating system. Secondly, the DMVs have a reputation of being difficult to use. In the process of exposing as much useful data as possible, sysprocesses has been de-normalized, and many new views and columns have been added. This fact, coupled with the initially-baffling choices of what columns will be exposed where, has lead to some DBAs to liken querying DMVs to "collecting mystic spells". In fact, however, once you start to write your own scripts, you'll see the same tricks, and similar join patterns, being used time and again. As such, a relatively small core set of scripts can be readily adapted to suit any requirement. This book is here to de-mystify the process of collecting the information you need to troubleshoot SQL Server problems. It will highlight the core techniques and "patterns" that you need to master, and will provide a core set of scripts that you can use and adapt for your own systems, including how to: * Root out the queries that are causing memory or CPU pressure on your system * Investigate caching, and query plan reuse * Identify index usage patterns * Track fragmentation in clustered indexes and heaps * Get full details on blocking and blocked transactions, including the exact commands being executed, and by whom. * Find out where SQL Server is spending time waiting for resources to be released, before proceeding * Monitor usage and growth of tempdb The DMVs don't make existing, built-in, performance tools obsolete. On the contrary, they complement these tools, and offer a flexibility, richness and granularity that are simply not available elsewhere. Furthermore, you don't need to master a new GUI, or a new language in order to use them; it's all done in a language all DBAs know and mostly love: T-SQL.

Performance Tuning with SQL Server Dynamic Management Views (High Performance SQL Server)

Davidson, Louis

Ford, Tim

See the best price to sell, buy or rent books by the Red gate books publisher. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Red gate books