William Vaughn
|
|
William Vaughn is an industry-recognized author, mentor, and subject-matter expert on Visual Studio, SQL Server, Reporting Services, and data access interfaces. He is also the author of the critically acclaimed “Hitchhiker’s Guide” series.
Email address: billva@betav.com
Web site: http://www.betav.com
|
32 results found for William Vaughn, displaying items 1 - 20
|
 |
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
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
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
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
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
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
Managing Hierarchical Rowsets
Windows IT Pro
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
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
Query vs. Report Parameters
What you need to understand the distinction between query and report parameters.
SQL Server Magazine
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
Putting Back Missing Visual Studio 2003 Features
In Visual Studio 2005, Microsoft has hidden some commonly used features. Here's how to get back the features you're used to.
SQL Server Magazine
Smarter T-SQL Debugging in Visual Studio 2005
T-SQL debugging in earlier versions of Visual Studio required creative workarounds. In Visual Studio 2005, the problems are fixed--and new features make debugging easier.
SQL Server Magazine
Reporting Services Tip: Resolving 403.9 Errors on Windows XP
Here's a handy workaround to help you avoid errors that cause Microsoft IIS to lock up when when you're working with SQL Server 2000 Reporting Services on Windows XP.
SQL Server Magazine
MSDE Reborn
Microsoft has introduced SQL Server 2005 Express Edition to replace Microsoft SQL Server Desktop Engine (MSDE). Find out what’s changed and what’s remained the same!
SQL Server Magazine
Beyond T-SQL: Digging into the CLR
Creating this sample credit card encryption application can teach you a lot about the realities of building, testing, and deploying CLR-based stored procedures--and about how the CLR provides functionality that T-SQL can't.
SQL Server Magazine
.NET Safety Settings
Microsoft provides three security permission settings as part of SQL Server 2005's protection layer. Here's a quick primer on what the three settings mean.
SQL Server Magazine
Mapping T-SQL Data Types to SqlTypes
Use this short list to see how you match T-SQL data types to data types that the SqlClient.SqlTypes namespace exposes.
SQL Server Magazine
Developing CLR-Based Stored Procedures
See how Common Language Runtime (CLR) stored procedures work and how they fit into the larger scheme of a high-performance database system by walking through a CLR assembly project that captures and encrypts credit card information.
SQL Server Magazine
|
April 20, 2004 |
|
T-SQL and SQL CLR Debugging
Learn the magic key for enabling cross-process debugging.
SQL Server Magazine
|
|
Register
