Home > Authors

Buck Woody

Buck Woody has been working with technology for over twenty-five years, beginning as an administrator and trainer and moving to programming and database administration.

He has worked for the U.S. Air Force, at an IBM reseller, and for NASA and U.S. Space Command. He has been a DBA and Database Developer on everything from an Oracle system running on a VAX to SQL Server and DB2 installations. Buck has a business degree and several industry certifications, including MCSE, MCDBA and Brainbench DBA, has led database classes at the University of Washington, and is the author of over 300 SQL Server articles and four published SQL Server books.

He was awarded the Microsoft MVP Award in 2006 for SQL Server and started work in the SQL Server Team at Microsoft a year later. He is currently a SQL Server Technical Specialist at Microsoft and can be reached at woodyb@hotmail.com.

RSS Feed Subscribe  RSS details

Careful with those NULLs
October 13, 2010   Comments
Topics: SQL Server, Databases
The true value of conferences
October 5, 2010   Comments
Topics: SQL Server, Databases
Finding Big Data
September 16, 2010   Comments
Topics: SQL Server, Databases
"What's Microsoft Got Coming out That's Cool"
September 14, 2010   Comments
Topics: Information Technology
Databases are the longest-lived component
September 9, 2010   Comments
Topics: SQL Server, Databases
SQL Server 101 Back to Basics at SQL Bits
September 7, 2010   Comments
Topics: SQL Server, Databases
Dealing with Data Defining the Components to Tune
September 2, 2010   Comments
Topics: SQL Server, Databases
Work Swarms
August 24, 2010   Comments
Topics: SQL Server, Databases
A combination of crowdsourcing, people helping people, and the best technical community there is
August 19, 2010   Comments
Topics: SQL Server, Databases
Direct Contact with SQL Servers Future
August 17, 2010   Comments
Topics: SQL Server, Databases
Watch those clustered indexes
August 12, 2010   Comments
Topics: SQL Server, Databases
ISV Applications versus In House Applications
August 10, 2010   Comments
Topics: SQL Server, Databases
Workstations for the Data Professional
August 9, 2010   Comments
Topics: SQL Server, Databases
Permanent storage - a myth or a requirement
August 5, 2010   Comments
Topics: SQL Server, Databases
PowerShell for the DBA Search the Windows Event Logs for Errors
August 4, 2010   Comments
Topics: SQL Server, Databases
Schemas as Security Boundaries
August 3, 2010   Comments
Topics: SQL Server, Databases
Don't mess with the system databases in SQL Server or you might get Error 916
August 2, 2010   Comments
Topics: SQL Server, Databases
Just how permanent does that data need to be
July 29, 2010   Comments
Topics: SQL Server, Databases
The Microsoft IT Showcase
July 28, 2010   Comments
Topics: SQL Server, Databases
The TechNet Wiki and Updated Security Checklists
July 27, 2010   Comments
Topics: SQL Server, Databases
Exploration and Understanding
July 26, 2010   Comments
Topics: SQL Server, Databases
When you're asking for help, make sure you explain what you're trying to accomplish
July 22, 2010   Comments
Topics: SQL Server, Databases
PowerShell and Extended Properties
July 20, 2010   Comments
Topics: SQL Server, Databases
Performance Monitor and Wait Events Presentation with Quest
July 19, 2010   Comments
Topics: SQL Server, Databases
Side-By-Side Installations - What gets changed?
July 15, 2010   Comments
Topics: SQL Server, Databases
Designing Dashboards
July 14, 2010   Comments
Topics: SQL Server, Databases
Cross-Pollination
July 13, 2010   Comments
Topics: SQL Server, Databases
SQL Server Best Practices problem with this Windows Installer Package
July 12, 2010   Comments
Topics: SQL Server, Databases
The SQL Server Best Practices Analyzer and Policy Based Management
July 8, 2010   Comments
Topics: SQL Server, Databases
There is No Perfect Information
July 7, 2010   Comments
Topics: SQL Server, Databases
The "D" in HADR
July 6, 2010   Comments
Topics: SQL Server, Databases
My Performance Tuning Methodology
July 1, 2010   Comments
Topics: SQL Server, Databases
Check Script
June 30, 2010   Comments
Topics: SQL Server, Databases
The Windows Page File and SQL Server
June 29, 2010   Comments
Topics: SQL Server, Databases
What can a week in a cabin without a computer teach you about databases?
June 28, 2010   Comments
Topics: SQL Server, Databases
Is the Internet Making us Smarter or Not?
June 17, 2010   Comments
Topics: SQL Server, Databases
It's nice to be important, but it's more important to be nice
June 16, 2010   Comments
Topics: SQL Server, Databases
Never Bet Against the Impossible
June 15, 2010   Comments
Topics: SQL Server, Databases
SQL Saturday 43 (Redmond, WA) Review
June 14, 2010   Comments
Topics: SQL Server, Databases
Seek first to understand, then to be understood
June 2, 2010   Comments
Topics: SQL Server, Databases
Find Rules and Defaults using the PowerShell for SQL Server 2008 Provider
June 1, 2010   Comments
Topics: SQL Server, Databases
Data-tier Applications in SQL Server 2008 R2
May 25, 2010   Comments
Topics: SQL Server, Databases
SQL Saturday 27 (Portland, Oregon)
May 24, 2010   Comments
Topics: SQL Server, Databases
More than one way to skin an Audit
May 20, 2010   Comments
Topics: SQL Server, Databases
More Tables or More Databases?
May 19, 2010   Comments
Topics: SQL Server, Databases
Use Those Schemas, People
May 18, 2010   Comments
Topics: SQL Server, Databases
The SQL Server Setup Portal
May 17, 2010   Comments
Topics: SQL Server, Databases
Do you have a data roadmap?
May 13, 2010   Comments
Topics: SQL Server, Databases
What 5 things should SQL Server get rid of?
May 12, 2010   Comments
Topics: SQL Server, Databases
Performance-Driven Development
May 11, 2010   Comments
Topics: SQL Server, Databases
SQL Server PowerShell Provider And PowerShell Version 2 Get-Command Issue
May 10, 2010   Comments
Topics: SQL Server, Databases
Book review: Microsoft System Center Enterprise Suite Unleashed
May 6, 2010   Comments
Topics: SQL Server, Databases
SQL Server PowerShell Provider follows the Version of PowerShell on the Host and other errata
May 5, 2010   Comments
Topics: SQL Server, Databases
Testing and Validation? You Really Do Have The Time
May 4, 2010   Comments
Topics: SQL Server, Databases
But what version is the database now
May 3, 2010   Comments
Topics: SQL Server, Databases
Vendors: Partners or Salespeople?
April 29, 2010   Comments
Topics: SQL Server, Databases
SQL Server for the Oracle DBA Links
April 28, 2010   Comments
Topics: SQL Server, Databases
Data Movement and the Decision Matrix
April 27, 2010   Comments
Topics: SQL Server, Databases
Security Goes Underground
April 22, 2010   Comments
Topics: SQL Server, Databases
Which Edition of SQL Server 2008 R2 should you use?
April 21, 2010   Comments
Topics: SQL Server, Databases
Backup those keys, citizen
April 20, 2010   Comments
Topics: SQL Server, Databases
When you're on a high, start something big
April 19, 2010   Comments
Topics: SQL Server, Databases
Create and Track Your Own License Keys with PowerShell
April 15, 2010   Comments
Topics: SQL Server, Databases
With Choice Comes Complexity
April 14, 2010   Comments
Topics: SQL Server, Databases
Do you need all that data?
April 13, 2010   Comments
Topics: SQL Server, Databases
Agile isn't always Agile
April 12, 2010   Comments
Topics: SQL Server, Databases
PowerShell PowerPack Download
April 7, 2010   Comments
Topics: SQL Server, Databases
Process Improvement and the Data Professional
April 6, 2010   Comments
Topics: SQL Server, Databases
Your Next IT Job
April 5, 2010   Comments
Topics: SQL Server, Databases
Geek it Up
April 1, 2010   Comments
Topics: SQL Server, Databases
List SQL Server Instances using the Registry
March 31, 2010   Comments
Topics: SQL Server, Databases
Backup Meta-Data
March 30, 2010   Comments
Topics: SQL Server, Databases
Open the SQL Server Error Log with PowerShell
March 29, 2010   Comments
Topics: SQL Server, Databases
Cluster Nodes as RAID Drives
March 25, 2010   Comments
Topics: SQL Server, Databases
Today I talk about you
March 24, 2010   Comments
Topics: SQL Server, Databases
PowerShell ? Show a Notification Balloon
March 23, 2010   Comments
Topics: SQL Server, Databases
Great Example of a Simple Cost-Benefit Analysis
March 22, 2010   Comments
Topics: SQL Server, Databases
PowerShell: Read Excel to Create Inserts
March 18, 2010   Comments
Topics: SQL Server, Databases
Challenge: Learn One New Thing Today
March 17, 2010   Comments
Topics: SQL Server, Databases
Using linked servers, OPENROWSET and OPENQUERY
March 16, 2010   Comments
Topics: SQL Server, Databases
What to leave when you're leaving
March 15, 2010   Comments
Topics: SQL Server, Databases
System Variables, Stored Procedures or Functions for Meta Data
March 11, 2010   Comments
Topics: SQL Server, Databases
Create Outlook Appointments from PowerShell
March 10, 2010   Comments
Topics: SQL Server, Databases
Consolidation Strategy References
March 9, 2010   Comments
Topics: SQL Server, Databases
It?s OK to take a Shortcut Sometimes
March 8, 2010   Comments
Topics: SQL Server, Databases
ROI and the DBA
March 4, 2010   Comments
Topics: SQL Server, Databases
No Certainties, Including That One
March 3, 2010   Comments
Topics: SQL Server, Databases
Did that change really fix the problem?
March 2, 2010   Comments
Topics: SQL Server, Databases
Have you backed up your keys lately?
March 1, 2010   Comments
Topics: Databases
If it's Free it's for Me
January 26, 2009   Comments
Topics: SQL Server, Databases
Not stressing about the job
January 10, 2009   Comments
Topics: SQL Server, Databases
Cost Cutting and the DBA
December 19, 2008   Comments
Topics: SQL Server, Databases
Working with multiple platforms
December 18, 2008   Comments
Topics: SQL Server, Databases
Monitoring the Spaghetti
December 16, 2008   Comments
Topics: SQL Server, Databases
SQL Server Forensics
December 8, 2008   Comments
Topics: SQL Server, Databases
Conferences and Alternatives
November 24, 2008   Comments
Topics: SQL Server, Databases
So help me Codd
November 5, 2008   Comments
Topics: SQL Server, Databases
PowerShell and SQL Server
October 31, 2008   Comments
Topics: SQL Server, Databases
Gaps in the DBA
October 20, 2008   Comments
Topics: SQL Server, Databases
Do DBAs have to know SQL?
October 11, 2008   Comments
Topics: SQL Server, Databases
Data Modeling
October 4, 2008   Comments
Topics: SQL Server, Databases
Another reminder about keeping your job in tough economic times
September 30, 2008   Comments
Topics: SQL Server, Databases
DBAs and Admins
September 22, 2008   Comments
Topics: SQL Server, Databases
Did you know that the + sign is Unicode? Me either...
September 8, 2008   Comments
Topics: SQL Server, Databases
Social Networking for the DBA/Developer
September 1, 2008   Comments
Topics: SQL Server, Databases
More to read on LINQ
August 28, 2008   Comments
Topics: Programming, SQL Server, Windows Programming, Databases
The CLR in SQL Server
August 20, 2008   Comments
Topics: SQL Server, Databases
UNIQUE versus PRIMARY KEY contstraints
August 18, 2008   Comments
Topics: Databases
SQL Server 2008 is here!
August 6, 2008   Comments
Topics: Databases
Systems Management
August 4, 2008   Comments
Topics: Databases
Other SQL Server 2008 Downloads
July 28, 2008   Comments
Topics: Databases
Clean Code
July 19, 2008   Comments
Topics: Databases
Virtualization is everywhere
July 16, 2008   Comments
Topics: Databases
Tuning starts with design
July 14, 2008   Comments
Topics: Databases
Learning the Basics
July 3, 2008   Comments
Topics: Databases
New things to learn
June 30, 2008   Comments
Topics: Databases
ER Diagraming tools
June 23, 2008   Comments
Topics: Databases
ERD Design
June 17, 2008   Comments
Topics: Databases
Virtual Machines are a big old deal
June 10, 2008   Comments
Topics: Databases
Heading to Teched
June 6, 2008   Comments
Topics: Databases
check your security
June 4, 2008   Comments
Topics: Databases
SQL Server Injection Attacks and what you can do about them
June 2, 2008   Comments
Topics: Databases
Getting Better at Transact-SQL
May 26, 2008   Comments
Topics: Databases
Watch your code!
May 21, 2008   Comments
Topics: Databases
Using Consultants
May 19, 2008   Comments
Topics: Databases
Timing Your Recovery
May 14, 2008   Comments
Topics: Databases
Virtually SQL
May 13, 2008   Comments
Topics: Databases
Database Engine Tuning Advisor
May 6, 2008   Comments
Topics: Databases
Multi-Vendor Shops
April 30, 2008   Comments
Topics: Databases
Storage Providers and SQL Server
April 28, 2008   Comments
Topics: Databases
New Support Mechanism
April 25, 2008   Comments
Topics: Databases
The Mesh is Here
April 23, 2008   Comments
Topics: Databases
Service Pack 3 for SQL Server 2005 is Announced
April 16, 2008   Comments
Topics: Databases
Backups - Native or Not?
April 14, 2008   Comments
Topics: Databases
Open Source Databases and The Web
April 2, 2008   Comments
Topics: Databases
DBAs as a Service
March 31, 2008   Comments
Topics: Databases
Scripting saves the day
March 26, 2008   Comments
Topics: Databases
How much middleware do you have to know
March 24, 2008   Comments
Topics: Databases
Compliance and Databases
March 19, 2008   Comments
Topics: Databases
Jobs are still looking up...for some
March 17, 2008   Comments
Topics: Databases
Using Windows CE
March 14, 2008   Comments
Topics: Databases
Time to Update Your Baselines
March 10, 2008   Comments
Topics: Databases
Uptime is always important
March 6, 2008   Comments
Topics: Databases
Have you Benchmarked Today?
February 25, 2008   Comments
Topics: Databases
Free e-book on SQL Server 2008
February 11, 2008   Comments
Topics: Databases
Do you want a web interface?
February 1, 2008   Comments
Topics: Databases
Databases - The enterprise Junk-Drawer
January 28, 2008   Comments
Topics: Databases
Free SQL Server 2005 Performance Reports
January 25, 2008   Comments
Topics: Databases
It's about time to check those DR solutions you put in...
January 24, 2008   Comments
Topics: Databases
Sun buys MySQL
January 16, 2008   Comments
Topics: Databases
Multiple Tools For a Single Task
January 14, 2008   Comments
Topics: Databases
Where have all the samples gone?
January 11, 2008   Comments
Topics: Databases
Refactoring your code
January 7, 2008   Comments
Topics: Databases
Microsoft changes Windows Web Server Licensing
January 4, 2008   Comments
Topics: Databases
Minimizing SQL Server Downtime
January 2, 2008   Comments
Topics: Databases
Is 2008 the year of SOA
December 31, 2007   Comments
Topics: Databases
The variety of the DBA job
December 28, 2007   Comments
Topics: Databases
Is 2008 really the year of Business Intelligence?
December 26, 2007   Comments
Topics: Databases
Company Consolidation
December 24, 2007   Comments
Topics: Databases
Express versus Trial - What's the difference?
December 19, 2007   Comments
Topics: Databases
SQL Server 2008? Or SQL Server 2005?
December 17, 2007   Comments
Topics: Databases
Better than it has to be
December 10, 2007   Comments
Topics: Databases
Books Online 2005 September Update is available
November 30, 2007   Comments
Topics: Databases
PowerShell HTML Converter
November 28, 2007   Comments
Topics: Databases
Using what you have
November 26, 2007   Comments
Topics: Databases
Longhorn Server and SQL Server
November 16, 2007   Comments
Topics: Databases
Keeping to the basics
November 14, 2007   Comments
Topics: Databases
IBM Buys Cognos
November 12, 2007   Comments
Topics: Databases
Deprecated Features - Article Pointer
November 9, 2007   Comments
Topics: Databases
Soft Processes and Hard Software
November 7, 2007   Comments
Topics: Databases
More new versions
November 5, 2007   Comments
Topics: Databases
Cycling Error Logs
November 3, 2007   Comments
Topics: Databases
Google Trends for SQL Server 2K
October 31, 2007   Comments
Topics: Databases
How many times does it take?
October 29, 2007   Comments
Topics: Databases
SQL Server and HyperThreading
October 24, 2007   Comments
Topics: Databases
Webcast: What I wish every Developer knew...
October 22, 2007   Comments
Topics: Databases
They don't make em like they used to
October 19, 2007   Comments
Topics: Databases
Speed up SSMS
October 17, 2007   Comments
Topics: Databases
Free Training
October 15, 2007   Comments
Topics: Databases
SQL Server Performance Tuning
October 12, 2007   Comments
Topics: Databases
Time Zone Tool
October 11, 2007   Comments
Topics: Databases
SQL Server Books Online is now Web Searchable
October 10, 2007   Comments
Topics: Databases
Really cool use of Service Broker
October 10, 2007   Comments
Topics: Databases
New Service Model For SQL Server
October 10, 2007   Comments
Topics: Databases
Rebuilding my test systems
October 10, 2007   Comments
Topics: Databases
Script out your Report Definition Language (RDL) files
October 10, 2007   Comments
Topics: Databases
Katmai - er, I mean SQL Server 2008 is available
October 10, 2007   Comments
Topics: Databases
And that's why you craft your queries very carefully
October 10, 2007   Comments
Topics: Databases
Ouch
October 10, 2007   Comments
Topics: Databases
Free Poster! w00t!
October 6, 2007   Comments
Topics: Databases
SQL Server on Vista
October 3, 2007   Comments
Topics: Databases
Want to play with SQL Server but don't want to install it?
October 1, 2007   Comments
Topics: Databases
Dogs and Cats, Living together!
September 28, 2007   Comments
Topics: Databases
SQL Server Best Practices
September 26, 2007   Comments
Topics: Databases
Argh! Where is the Service Pack Number?
September 24, 2007   Comments
Topics: Databases
Free Database Class
September 21, 2007   Comments
Topics: Databases
Should you AutoShrink your databases?
September 19, 2007   Comments
Topics: Databases
Where in the Registry is that?
September 17, 2007   Comments
Topics: Databases
Web Applications and SQL Server
September 14, 2007   Comments
Topics: Databases
Online Free Labs for SQL Server
September 12, 2007   Comments
Topics: Databases
Sometimes it's more than the data
September 7, 2007   Comments
Topics: SQL Server, Databases
I want the TaskPad Back!
August 27, 2007   Comments
Topics: Databases
Don't ignore the 101
August 21, 2007   Comments
Topics: SQL Server, Databases

Buck Woody