March 2008
Build a sample application in Visual Studio that can
be used to manage hierarchical rowsets populated by
stored procedures.
February 27, 2008
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.
June 2007
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.
June 2007
What you need to understand the distinction between
query and report parameters.
October 2005
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.
October 2005
In Visual Studio 2005, Microsoft has hidden some
commonly used features. Here's how to get back the
features you're used to.
October 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.
July 2005
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.
October 2004
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!
July 2004
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.
July 2004
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.
July 2004
Use this short list to see how you match T-SQL data
types to data types that the SqlClient.SqlTypes
namespace exposes.
May 2004
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.
April 20, 2004
Learn the magic key for enabling cross-process
debugging.
April 2, 2004
Sometimes, T-SQL stored procedures are too large to
manage. Often, using multiple shorter stored procedures
is better than using one long stored procedure.
July 2003
ADO.NET connection pooling improves the performance
of .NET applications, but a busy application can
sometimes accumulate connections, overflowing the pool
and sinking performance. Here's how you can keep a
watchful eye on your connection pools.
May 2003
If you’re diving into ADO.NET, you might be wondering
how you can use connection pooling to improve your
applications’ performance. Here are some basic
connection-pooling concepts you’ll need to know when
you’re ready to get your feet wet.
February 2003
Developers need to know how to test for and set NULL
values in their applications. Here are some
tried-and-true techniques you can use in Visual Basic
and Visual Basic .NET.
February 2003
Here's how to use the IsNULL() function in T-SQL to
avoid returning NULL values from your queries.
November 2002
When you write a query, sometimes you want only a yes
or no answer. In these cases, instead of using SELECT to
return a rowset, you can execute an ADO.NET action
command to get the specific information you need
quickly.
