Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Loading
Inside the SQL Server Query Optimizer
Inside the SQL Server Query Optimizer

The SQL Server Query Optimizer is perceived by many to be a magic black box, transforming SQL queries into high performance execution plans in the blink of an eye through some unknowable process. The truth is that, while the Query Optimizer is indeed the highly-complex result of decades of research, learning how it works its magic is not only...

Exchange 2010 - A Practical Approach
Exchange 2010 - A Practical Approach

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...

Troubleshooting SQL Server - A Guide for the Accidental DBA
Troubleshooting SQL Server - A Guide for the Accidental DBA
I've spent much of the last six years of my working life trying to help people solve SQL Server-related performance problems, either hands-on, at client sites in my capacity as a consultant, or on various online community forums, answering people's questions.

Over that time I've been exposed to a few weird
...
.NET Performance Testing and Optimization - The Complete Guide
.NET Performance Testing and Optimization - The Complete Guide

There is a huge amount of information available on the how's and why's of performance testing .NET applications, but it is often fairly subjective, narrow in scope, or doesn't quite cover everything you were hoping to learn. The Complete Guide to Performance Testing and Optimizing .NET Applications (by Paul Glavich and Chris...

How to Become an Exceptional DBA, 2nd Edition
How to Become an Exceptional DBA, 2nd Edition

I have worked with database applications for most of my career, and have been a SQL Server DBA for the last thirteen years. I started with the computer industry in 1981, the year the first IBM Personal Computer, running DOS 1.0, was released. In fact, I owned one of the first models off the production line.

My first exposure to a...

The Art of XSD - SQL Server XML schemas
The Art of XSD - SQL Server XML schemas

When information is exchanged in XML format, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. An XSD (XML Schema Definition Language) Schema can be used to enforce this contract and validate the XML data being exchanged and, given that a lot of applications exchange...

SQL Server Tacklebox Essential tools and scripts for the day-to-day DBA
SQL Server Tacklebox Essential tools and scripts for the day-to-day DBA

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...

Protecting SQL Server Data
Protecting SQL Server Data

For as long as there has been something to communicate between two persons there has been data. Today, vast volumes of it are gathered about almost every individual and business. It is the information that we provide when we sign up for an account at our favorite website, fill out a job application, or apply for a mortgage.

These...

The Red Gate Guide to SQL Server Team-based Development
The Red Gate Guide to SQL Server Team-based Development

Only small projects, relevant to very few people, are built by the sweat and toil of a lone developer. Larger projects, affecting whole organizations, will invariably require a team of people to design and develop the application and its storage layer, or database.

In some cases, this will mean some developers and one or two DBAs,...

Defensive Database Programming with SQL Server
Defensive Database Programming with SQL Server

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment. Too often as...

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

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...

Confessions of an IT Manager
Confessions of an IT Manager

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...

Result Page: 1 
©2017 LearnIT (support@pdfchm.net) - Privacy Policy