buck.woody

LinkedIn | FaceBook | Twitter

Resume Professional Blog Personal Blog Podcasts Articles University of Washington

This is my list of articles from the writing I do on InformIT.com.

You'll find this easy to navigate, and if you press CTRL-F in your browser you should be able to search for any terms you're interested in:

Year Posted

Main Topic

Article Title and Link

2009

SQL Server Reference Guide Overview

2008

Microsoft SQL Server Defined

2008

SQL Server Editions

2008

SQL Server Access

2009

Microsoft SQL Server Features

2009

SQL Server Books Online

2009

Clustering Services

2007

Data Transformation Services (DTS) Overview

2010

Replication Services

2010

Database Mirroring

2003

Natural Language Processing (NLP)

2007

Analysis Services

2010

Microsoft SQL Server Reporting Services

2008

XML Overview

2004

Notification Services for the DBA

2006

Full-Text Search

2006

SQL Server 2005 - Service Broker

2010

SQL Server Web Services

2010

SQL Server Encryption Options Overview

2008

SQL Server 2008 Overview

2010

SQL Server 2008 R2 Overview

2010

SQL Azure

2010

The Utility Control Point and Data Application Component, Part 1

2010

The Utility Control Point and Data Application Component, Part 2

2008

Microsoft SQL Server Administration

2011

DBA Survival Guide: The 10 Minute SQL Server Overview

2009

Preparing (or Tuning) a Windows System for SQL Server, Part 1

2009

Preparing (or Tuning) a Windows System for SQL Server, Part 2

2009

Installing SQL Server

2010

Upgrading SQL Server

2005

SQL Server 2000 Management Tools

2005

SQL Server 2005 Management Tools

2008

SQL Server 2008 Management Tools

2011

SQL Azure Tools

2007

Automating Tasks with SQL Server Agent

2007

Automating Operating System Tasks with SQL Server Agent and PowerShell

2010

Automating Tasks without SQL Server Agent

2009

Storage- SQL Server I/O

2010

Service Packs, Hotfixes and Cumulative Upgrades

2011

Tracking SQL Server Information with Error and Event Logs

2007

Change Management

2008

SQL Server Metadata, Part One

2008

SQL Server Meta-Data, Part Two

2005

Monitoring - SQL Server 2005 Dynamic Views and Functions

2003

Monitoring - Performance Monitor

2005

Unattended Performance Monitoring for SQL Server

2006

Monitoring - User-Defined Performance Counters

2008

Monitoring: SQL Server Activity Monitor

2009

SQL Server Instances

2007

DBCC Commands

2007

SQL Server and Mail

2007

Database Maintenance

2010

The Maintenance Wizard- SQL Server 2000

2010

The Maintenance Wizard- SQL Server 2005

2007

The Web Assistant Wizard

2008

Creating Web Pages from SQL Server

2003

SQL Server Security

2011

Securing the SQL Server Platform Part One

2011

Securing the Platform Part Two

2011

SQL Server Security - Users and other Principals

2006

SQL Server Security - Roles

2006

2010

Security: Using the Command Line

2007

SQL Server Security - Encrypting Connections

2007

SQL Server Security - Encrypting Data

2010

SQL Server Security Audit

2009

High Availability - SQL Server Clustering

2010

SQL Server Configuration: Part 1

2010

SQL Server Configuration: Part 2

2008

Database Configuration Options

2007

32- vs 64-bit Computing for SQL Server

2007

SQL Server and Memory

2003

Performance Tuning: Introduction to Indexes

2007

Statistical Indexes

2007

Backup and Recovery

2008

Backup and Recovery Examples, Part One

2010

Backup and Recovery Examples, Part Two: Transferring Databases to Another System (Even Without Backups)

2003

SQL Profiler - Reverse Engineering An Application

2007

SQL Trace

2007

SQL Server Alerts

2009

2007

Partitioning

2005

Full-Text Indexes

2007

Read-Only Data

2007

SQL Server Locks

2007

Monitoring Locking and Deadlocking

2007

Controlling Locks in SQL Server

2009

SQL Server Policy-Based Management, Part One

2009

SQL Server Policy-Based Management, Part Two

2009

SQL Server Policy-Based Management, Part Three

2008

Microsoft SQL Server Programming

2006

An Outline for Development

2004

Database

2004

Database Services

2008

Database Objects: Databases

2003

Database Objects: Tables

2003

Database Objects: Table Relationships

2003

Database Objects: Keys

2010

Database Objects: Constraints

2009

Database Objects: Data Types

2004

Database Objects: Views

2011

Database Objects: Stored Procedures

2007

Database Objects: Indexes

2004

Database Objects: User Defined Functions

2004

Database Objects: Triggers

2004

Database Design: Requirements, Entities, and Attributes

2003

Database Design: Finalizing Requirements and Defining Relationships

2010

Business Process Model Notation (BPMN) for the Data Professional

2010

Business Questions for Database Design, Part One

2010

Business Questions for Database Design, Part Two

2003

Database Objects: Entity Relationship Diagrams

2004

Database Design: The Logical ERD

2004

Database Design: Adjusting The Model

2011

Database Design: Normalizing the Model

2004

Database Design: Creating The Physical Model

2007

Database Design: Changing Attributes to Columns

2004

Database Design: Creating The Physical Database

2011

Database Design Example: Curriculum Vitae

2006

NULLs

2008

The SQL Server Sample Databases

2008

The SQL Server Sample Databases - pubs

2008

The SQL Server Sample Databases - NorthWind

2011

The SQL Server Sample Databases - AdventureWorks

2008

The SQL Server Sample Databases - Adventureworks Derivatives

2008

UniversalDB 1

2009

UniversalDB 2

2009

UniversalDB 3

2009

UniversalDB 4

2009

Getting Started with Transact-SQL

2004

Transact-SQL: DDL Statements

2004

Transact-SQL: Limiting Results

2004

Transact-SQL: More Operators

2004

Transact-SQL: Ordering and Aggregating Data

2004

2009

Transact-SQL: Joins

2008

Transact-SQL: Complex Joins - Building a View with Multiple JOINs

2011

Transact-SQL: Inserts, Updates, and Deletes

2006

An Introduction to the CLR in SQL Server 2005

2010

Design Elements Part 1: Programming Flow Overview, Code Format and Commenting your Code

2010

Design Elements Part 2: Server-Side Code and Transactions

2011

Design Elements Part 3: Error Handling

2009

Design Elements Part 4: Variables

2004

Design Elements Part 5: Where Does The Code Live?

2004

Design Elements Part 6: Math Operators and Functions

2004

Design Elements Part 7: Statistical Functions

2004

Design Elements Part 8: Summarization Statistical Algorithms

2004

Design Elements Part 9:Representing Data with Statistical Algorithms Part 2

2004

Design Elements Part 10: Interpreting the Data-Regression

2009

Design Elements Part 11: String Manipulation

2004

Design Elements Part 12: Loops

2004

Design Elements Part 13: Recursion

2004

Design Elements Part 14: Arrays

2004

Design Elements Part 15: Event-Driven Programming Vs. Scheduled Processes

2004

Design Elements Part 16: Event-Driven Programming

2004

Design Elements Part 17: Program Flow

2004

Forming Queries Part 1: Design

2004

Forming Queries Part 2: Query Basics

2004

Forming Queries Part 3: Query Optimization

2007

Forming Queries Part 4: SET Options

2008

Forming Queries Part 5: Table Optimization Hints

2006

Using SQL Server Templates

2008

Transact-SQL Unit Testing

2005

Index Tuning Wizard

2008

Unicode and SQL Server

2009

SQL Server Development Tools

2010

The SQL Server Transact-SQL Debugger

2010

The Transact-SQL Debugger, Part 2

2010

Basic Troubleshooting for Transact-SQL Code

2010

Performance Tuning

2011

Performance Tuning SQL Server - Tools and Processes

2011

Performance Tuning SQL Server - Tools Overview

2006

Creating a Performance Tuning Audit - Defining Components

2006

Creating a Performance Tuning Audit - Evaluation Part One

2006

Creating a Performance Tuning Audit - Evaluation Part Two

2006

Creating a Performance Tuning Audit - Interpretation

2006

Creating a Performance Tuning Audit - Developing an Action Plan

2007

Understanding SQL Server Query Plans

2007

Performance Tuning: Implementing Indexes

2006

Performance Monitoring Tools: Windows System Monitor

2006

Performance Monitoring Tools: Logging with System Monitor

2010

Performance Monitoring Tools: User Defined Counters

2008

General Transact-SQL (T-SQL) Performance Tuning, Part 1

2008

General Transact-SQL (T-SQL) Performance Tuning, Part 2

2008

General Transact-SQL (T-SQL) Performance Tuning, Part 3

2006

Performance Monitoring Tools: An Introduction to SQL Profiler

2009

Performance Tuning: Introduction to Indexes

2010

Performance Monitoring Tools: Windows 2008 (and Higher) Server Utilities, Part 1

2010

Performance Monitoring Tools: Windows 2008 (and Higher) Server Utilities, Part2

2006

Performance Monitoring Tools: SQL Server 2000 Index Tuning Wizard

2008

Performance Monitoring Tools: SQL Server 2005 Database TuningAdvisor

2006

Performance Monitoring Tools: SQL Server Management Studio Reports

2009

Performance Monitoring Tools: SQL Server 2008 Activity Monitor

2008

The SQL Server 2008 Management Data Warehouse and Data Collector

2010

Performance Monitoring Tools: Evaluating Wait States with PowerShell and Excel

2008

Practical Applications

2011

Choosing the Back End

2007

The DBA's Toolbox, Part 1

2007

The DBA's Toolbox, Part 2

2007

Scripting Solutions for SQL Server

2007

Building a SQL Server Lab

2004

Using Graphics Files with SQL Server

2004

Enterprise Resource Planning

2004

Customer Relationship Management (CRM)

2007

Building a Reporting Data Server

2004

Building a Database Documenter, Part 1

2004

Building a Database Documenter, Part 2

2004

Data Management Objects

2004

Data Management Objects: The Server Object

2004

Data Management Objects: Server Object Methods

2005

Data Management Objects: Collections and the Database Object

2005

Data Management Objects: Database Information

2005

Data Management Objects: Database Control

2005

Data Management Objects: Database Maintenance

2005

Data Management Objects: Logging the Process

2005

Data Management Objects: Running SQL Statements

2005

Data Management Objects: Multiple Row Returns

2005

Data Management Objects: Other Database Objects

2005

Data Management Objects: Security

2005

Data Management Objects: Scripting

2007

Powershell and SQL Server - Overview

2007

PowerShell and SQL Server - Objects and Providers

2007

Powershell and SQL Server - A Script Framework

2007

Powershell and SQL Server - Logging the Process

2007

Powershell and SQL Server - Reading a Control File

2007

Powershell and SQL Server - SQL Server Access

2007

Powershell and SQL Server - Web Pages from a SQL Query

2008

Powershell and SQL Server - Scrubbing the Event Logs

2008

SQL Server 2008 PowerShell Provider

2010

SQL Server I/O: Importing and Exporting Data

2005

SQL Server I/O: XML in Database Terms

2005

SQL Server I/O: Creating XML Output

2005

SQL Server I/O: Reading XML Documents

2005

SQL Server I/O: Using XML Control Mechanisms

2005

SQL Server I/O: Creating Hierarchies

2005

SQL Server I/O: Using HTTP with SQL Server XML

2005

SQL Server I/O: Using HTTP with SQL Server XML Templates

2005

SQL Server I/O: Remote Queries

2005

SQL Server I/O: Working with Text Files

2005

Using Microsoft SQL Server on Handheld Devices

2005

Front-Ends 101: Microsoft Access

2006

Comparing Two SQL Server Databases

2006

English Query - Part 1

2006

English Query - Part 2

2006

English Query - Part 3

2006

English Query - Part 4

2006

English Query - Part 5

2006

RSS Feeds from SQL Server

2007

Using SQL Server Agent to Monitor Backups

2008

Reporting Services - Creating a Maintenance Report

2009

SQL Server Chargeback Strategies, Part 1

2009

SQL Server Chargeback Strategies, Part 2

2009

SQL Server Replication Example

2009

Creating a Master Agent and Alert Server

2009

The SQL Server Central Management System: Definition

2009

The SQL Server Central Management System: Base Tables

2009

The SQL Server Central Management System: Execution of Server Information (Part 1)

2009

The SQL Server Central Management System: Execution of Server Information (Part 2)

2009

The SQL Server Central Management System: Collecting Performance Metrics

2009

The SQL Server Central Management System: Centralizing Agent Jobs, Events and Scripts

2009

The SQL Server Central Management System: Reporting the Data and Project Summary

2010

Time Tracking for SQL Server Operations

2010

Migrating Departmental Data Stores to SQL Server

2010

Migrating Departmental Data Stores to SQL Server: Model the System

2010

Migrating Departmental Data Stores to SQL Server: Model the System, Continued

2010

Migrating Departmental Data Stores to SQL Server: Decide on the Destination

2010

Migrating Departmental Data Stores to SQL Server: Design the ETL

2010

Migrating Departmental Data Stores to SQL Server: Design the ETL, Continued

2010

Migrating Departmental Data Stores to SQL Server: Attach the Front End, Test, and Monitor

2010

Tracking SQL Server Timed Events, Part 1

2010

Tracking SQL Server Timed Events, Part 2

2010

Patterns and Practices for the Data Professional

2010

Consolidation Options

2010

Managing Vendor Databases

2010

Connecting to a SQL Azure Database from Microsoft Access

2011

SharePoint 2007 and SQL Server - Part One

2011

SharePoint 2007 and SQL Server - Part Two

2011

SharePoint 2007 and SQL Server - Part Three

2011

Querying Multiple Data Sources from a Single Location (Distributed Queries)

2011

Importing and Exporting Data for SQL Azure

2008

Professional Development

2007

Becoming a DBA

2004

Certification

2004

DBA Levels

2008

Becoming a Data Professional

2010

SQL Server Professional Development Plan, Part 1

2010

SQL Server Professional Development Plan, Part 2

2010

SQL Server Professional Development Plan, Part 3

2010

Evaluating Technical Options

2008

System Sizing

2005

Creating a Disaster Recovery Plan

2009

Anatomy of a Disaster (Response Plan)

2005

Database Troubleshooting

2006

Conducting an Effective Code Review

2006

Developing an Exit Strategy

2006

Data Retention Strategy

2008

Keeping Your DBA/Developer Job in Troubled Times

2008

2008

Creating and Maintaining a SQL Server Configuration History, Part 1

2008

Creating and Maintaining a SQL Server Configuration History, Part 2

2009

Creating an Application Profile, Part 1

2009

Creating an Application Profile, Part 2

2009

How to Attend a Technical Conference

2010

Tips for Maximizing Your IT Budget This Year

2010

The Importance of Blue-Sky Planning

2010

Application Architecture Assessments

2011 Transact-SQL Code Reviews, Part One
2011 Transact-SQL Code Reviews, Part Two
2011 Distributed (Cloud) Computing
2011 NoSQL for the SQL Server Professional - Part One
2011 NoSQL for the SQL Server Professional - Part Two
2011 Object-Role Modeling (ORM) for the Database Professional
2011 Working in Distributed Teams

2008

Business Intelligence

2005

BI Explained

2005

Creating a Data Dictionary

2005

BI Security

2005

Gathering BI Requirements

2005

Source System Extracts and Transforms

2005

ETL Mechanisms

2005

Business Intelligence Landscapes

2005

Business Intelligence Layouts and the Build or Buy Decision

2007

A Single Version of the Truth

2005

The Operational Data Store (ODS)

2005

Data Marts - Combining and Transforming Data

2005

Designing Data Elements

2005

The Enterprise Data Warehouse - Aggregations and the Star Schema

2005

On-Line Analytical Processing (OLAP)

2005

Data Mining

2005

Key Performance Indicators

2006

BI Presentation - Client Tools

2006

BI Presentation - Portals

2007

Implementing ETL - Introduction to SQL Server 2005 Integration Services

2009

Building a Business Intelligence Solution, Part 1

2009

Building a Business Intelligence Solution, Part 2

2009

Building a Business Intelligence Solution, Part 3

2009

Tips and Troubleshooting

2010

SQL Server and Microsoft Excel Integration

2008

Tips for the SQL Server Tools: SQL Server 2000

2008

Tips for the SQL Server Tools - SQL Server 2005

2007

Transaction Log Troubles

2009

SQL Server Connection Problems

2009

Orphaned Database Users

2010

Tools and Downloads

2004

Utilities (Free)

2009

2006

Aqua Data Studio

2006

Microsoft SQL Server Best Practices Analyzer

2004

Utilities (Cost)

2004

Quest Software's TOAD for SQL Server

2004

Quest Software's Spotlight on SQL Server

2009

SQL Server on Microsoft's Virtual PC

2004

Red Gate SQL Bundle

2004

Microsoft's Visio for Database Folks

2006

Quest Capacity Manager

2004

SQL Server Help

2006

Visual Studio Team Edition for Database Professionals

2009

Microsoft Assessment and Planning Solution Accelerator

2009

Aggregating Server Data from the MAPS Tool