William Vaughn

William Vaughn is an expert on Visual Studio, SQL Server, Reporting Services, and data access interfaces. He’s coauthor of the Hitchhiker’s Guide series, including Hitchhiker’s Guide to Visual Studio and SQL Server, 7th ed. (Addison-Wesley).
Email:billva@betav.com

My Latest Articles
My Latest Comments

Author Articles

January, 2010
Report Builder 2.0
This reincarnated tool is easy to use but creates certain security risks when users modify reports.
Windows IT Pro

January, 2010
Report Builder vs. ReportViewer

Windows IT Pro

January, 2010
Report Builder 2.0 Security

Windows IT Pro

January, 2010
Are You Ready for Report Builder 2.0?

Windows IT Pro

November, 2009
Passing NULL Parameters
Have you ever had a stored procedure that could accept a NULL value as a parameter but didn't seem to work correctly when you did so? Here's what might have gone wrong.
SQL Server Magazine

July, 2009
Importing Access Reports into SQL Server Reporting Services
Learn how to convert your Access reports into SQL Server Reporting Services–supported RDL.
SQL Server Magazine

February, 2009
Unlock the Secrets of SQL Server 2008 Reporting Services
See what Microsoft changed in SQL Server Reporting Services 2008 and how these new features will affect you.
SQL Server Magazine

February, 2009
What’s New for SQL Developers in Visual Studio 2008 SP1
Visual Studio 2008 SP1 enables many features that didn’t make the cut in the initial Visual Studio 2008 release to manufacturing (RTM). Learn about SP1 reporting and data caching features that developers and architects can leverage in their applications.
SQL Server Magazine

February, 2009
Exporting SSRS Reports—For Free
A free utility, Reporting Services Scripter, can help you export SQL Server Reporting Services 2008 reports.
SQL Server Magazine

February, 2009
Navigating Microsoft’s Report Designer Maze
A confusing array of Report Designers is available to SQL Server Reporting Services developers. Here's a list of the versions and what they support.
SQL Server Magazine

August, 2008
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.
SQL Server Magazine

August, 2008
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.
SQL Server Magazine

August, 2008
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.
SQL Server Magazine

July, 2008
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.
SQL Server Magazine

June, 2008
Generate a Clickthrough Report using Visual Studio ReportViewer
See how you can set up a clickthrough report without using SQL Server Reporting Services (SSRS).
SQL Server Magazine

February, 2008
Managing Hierarchical Rowsets
Build a sample application in Visual Studio that can be used to manage hierarchical rowsets populated by stored procedures.
SQL Server Magazine

February, 2008
Additional Features
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.
SQL Server Magazine

May, 2007
Managing ReportViewer Parameters
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.
SQL Server Magazine

May, 2007
Query vs. Report Parameters
What you need to understand the distinction between query and report parameters.
SQL Server Magazine

September, 2005
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.
SQL Server Magazine

GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS