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

Buck Woody