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
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.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Man deciding which door to choose
Aug 15, 2014
Sponsored

Choosing the Right Health Check

For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More
SQL Server Management Studip Options screenshot
Aug 5, 2014
blog

SQL Server Management Studio’s Ugly ANSI_PADDING Bug

Learn more about the problem with SQL Server Management Studio's generation of scripts with ANSI_PADDING OFF along with a helpful solution....More
Save money red computer keyboard key
Jul 30, 2014
blog

When More Expensive Processors Actually Cost Less

Smart organizations are always looking for ways to cut costs when it comes to licensing SQL Server. Here are two ideas, or options, to save money....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) ×