William Vaughn

William
Vaughn

William (Bill) Vaughn is an industry-recognized author, mentor, trainer, and subject-matter expert on Visual Studio, SQL Server, and ADO.NET. He’s worked in the computer industry for more than 30 years, including 14 years at Microsoft. He's available for mentoring and custom training (see Beta V Corporation or William Vaughn's Musings for more information). He’s written seven editions of the Hitchhiker’s Guide to Visual Basic and SQL Server (Microsoft Press)—the 7th edition is on Visual Studio—and three editions of ADO.NET and ADO Examples and Best Practices (Apress). Bill and Peter Blackburn also wrote the best-selling Hitchhiker’s Guide to SQL Server 2000 Reporting Services (Addison-Wesley Professional). More recently, he’s written The Owl Wrangler and Guardians of the Sacred Seven (Beta V Corporation), the first two books in his fantasy fiction trilogy.

Articles
Q: How can I create unique primary keys that are easy for customers to use?
Learn how to create unique primary keys for customer use.
Q: How can I extract reports from a data source for field agents to access while on the road?
Learn how to use Visual Studio’s Microsoft ReportViewer to extract reports.
Q: What's the best way to keep client data on a SQL Server Compact Edition database in sync?
Learn how to use ADO.NET 3.5 Synchronization Services classes to keep data in sync.
Visual Studio .NEXT Wish List
Love Visual Studio 2008? Hardly. The author points out where Microsoft needs to fix VS 2008's shortcomings such as the inability to access the new SQL Server data types of ADO.NET features.
touch-screen computer tablet with rainbow on screen
Generate a Clickthrough Report using Visual Studio ReportViewer 2
See how you can set up a clickthrough report without using SQL Server Reporting Services (SSRS).
Managing Hierarchical Rowsets 3
Build a sample application in Visual Studio that can be used to manage hierarchical rowsets populated by stored procedures.
Additional Features 2
To make the sample TableAdapter application more useful as a general demonstration, I added several features that illustrate a few tricky technical points, including how to import a picture, handle new row initialization, and provide a list of addresses.
Query vs. Report Parameters
What you need to understand the distinction between query and report parameters.
Managing ReportViewer Parameters 3
How do you filter a Reporting Services report at runtime? Stumped? SQL Server guru William Vaughn explains how you can use the ReportViewer control in server mode to collect, validate, and pass parameters to Reporting Services.
Smarter T-SQL Debugging in Visual Studio 2005
T-SQL debugging in earlier versions of Visual Studio required creative workarounds. In Visual Studio 2005, the problems are fixed--and new features make debugging easier.
ADO.NET 2.0: Smarter, Faster, Better
The latest release of Microsoft’s data-access tool, ADO.NET 2.0, has a slew of new features designed to solve specific developer problems. Get an overview of what the new release can do to solve your development dilemmas.
Putting Back Missing Visual Studio 2003 Features
In Visual Studio 2005, Microsoft has hidden some commonly used features. Here's how to get back the features you're used to.
Reporting Services Tip: Resolving 403.9 Errors on Windows XP
Here's a handy workaround to help you avoid errors that cause Microsoft IIS to lock up when when you're working with SQL Server 2000 Reporting Services on Windows XP.
MSDE Reborn
Microsoft has introduced SQL Server 2005 Express Edition to replace Microsoft SQL Server Desktop Engine (MSDE). Find out what’s changed and what’s remained the same!
.NET Safety Settings
Microsoft provides three security permission settings as part of SQL Server 2005's protection layer. Here's a quick primer on what the three settings mean.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Sep 1, 2015
blog

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...More
Aug 27, 2015
blog

A Replacement for Maintenance Plan Backups 1

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
Aug 19, 2015
blog

Looking forward to Containers

Virtualization has long been a staple when it comes to computing. In essence, virtualization is really just the use of abstraction to make things either easier to manage or more fault-tolerant. Disks, for example, have long been virtualized in the sense that a single, physical, can easily be divided up into multiple logical (or virtual) volumes (or drives) just as easily as a number of discreet physical disks can also be virtualized into a single drive (via RAID) – which can further be partitioned into volumes, LUNs, and so....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×