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
Aug 27, 2015

A Replacement for Maintenance Plan Backups

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

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
Jul 28, 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 29: Practical Implementation Tips

My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs – and call out how there is virtually no guidance from Microsoft on this front and then detail some of the pitfalls and options available for tackling this problem domain. I initially expected this series of posts to have between 25 and 30 posts – according to some of the early outlines I created ‘way back when’....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) ×