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.

Visual Studio 2012 and SQL Server 2012 Reporting Services—Still Out of Sync 3
In SQL Server 2012, little was done to bring SQL Server Reporting Services (SSRS) in sync with Visual Studio 2012.
SSRS How-To: Create Reports by User to Protect Sensitive Data
In SQL Server Reporting Services (SSRS), you can create reports that automatically morph based on who is viewing them.
global language listed on a blue background
Morphing Reports to Accommodate the User’s Native Language
When working with reports that will be accessed from all over the world, you have to judiciously adapt the reports to meet the language requirements of the host browser (and the user). SQL Server Reporting Services (SSRS) makes these adaptations fairly easy.
A Candid Look at Report Builder 3.0 1
Report Builder 3.0 includes many new features, but it has the same goal as its predecessors: providing end users with an easy-to-use alternative to the report-authoring tools in Business Intelligence Development Studio (BIDS). Find out whether Report Builder 3.0 meets this goal.
Managing Multi-Select Parameters in SSRS
You can let users choose more than one option in a report's pick list even when the report uses a parameter-driven query. Improvements to the SQL Server Reporting Services (SSRS) Report Processor make it easy.
Adding Custom Maps to Visual Studio 2008 R2 BI Tools
There's seemingly no limit to the number of different map data files available on the web, but BIDS can most easily consume Environmental Systems Research Institute (ESRI) shapefiles.
Sidebar: Other Strategies for Report Performance

The time it takes for SQL Server Reporting Services (SSRS) to deliver a finished report can be broken down into several sequential operations, summarized and simplified here:

Maximizing Report Performance with Parameter-Driven Expressions
Learn about the inner workings of the SQL Server Reporting Services (SSRS) engine and how the report processor handles requests for reports.
Managing TableAdapter Timeouts 3
There are plenty of reasons you might need to set your own timeout values for your Fill methods, but for now, it isn't too easy. Learn how to work around current limitations.
Passing NULL Parameters 2
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.
Importing Access Reports into SQL Server Reporting Services 1
Learn how to convert your Access reports into SQL Server Reporting Services–supported RDL.
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.
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.
Exporting SSRS Reports—For Free
A free utility, Reporting Services Scripter, can help you export SQL Server Reporting Services 2008 reports.
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.

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
Jul 17, 2017

How Inferred Linking in Matched Records Digs Deeper into Your Data

Duplicate records clutter databases and render the data within them unclear. This kind of problem is very common, and it’s the main reason that deduping software exists. But there’s another benefit to deduplication software: the ability to infer connections between individual records from various data sets....More
May 22, 2017

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face....More
May 12, 2017

5 Common Challenges to Building BI in the Cloud

After spending 20 years building analytics, BI and database solutions, I've focused on Cloud data solutions over the past 2 years. I've chosen 5 common challenges that I face every day with Cloud migrations and that you'll face in your Cloud BI projects....More

Sponsored Introduction Continue on to (or wait seconds) ×