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.

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
Apr 21, 2016
blog

Turning Global Addresses into your Biggest Asset

Sponsored Blog Are you dealing with national and international records? The more expansive your records are in territory, the more problems you will face when it comes to verifying addresses. Not only are you dealing with language differences, but you are also dealing with different address formatting for different countries....More
Mar 14, 2016
blog

Building Your Business with Quality Data

Your contact data is valuable, but is it up to its full potential? Without the proper maintenance, the quality of your data quickly decreases--so quickly that 50% of databases deteriorate after only two years. It is an absolute necessity to maintain your data in order to decrease costs and increase profits....More
Feb 12, 2016
blog

Your Data’s Rate of Decay

Did you know that data has a half-life? That is the amount of time it takes for the information in your database to go bad. How? Because contact data is always changing....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) ×