(Bob Watkins) In a previous tip, I described how a column’s data could be masked (hidden) using Oracle 10g’s Virtual Private Database (VPD) feature. TechRepublic member BrooklynPennyPincher suggested I write a comparison of VPD with relational views.
Other News
Overview of the Wizard Control in ASP.NET 2.0
(Curtis Dicken) The Wizard control is an extremely powerful and timesaving tool with over 200 properties and events. Leverage the power of this tool for all types of practical uses such as user account creation, customer registration, application set-up and just about anything you can dream up. (v
Zip Code Distance Calculations in MySQL and UDB
(John A. Marsh) I am currently involved in a project where the program I am writing is supposed to return a list of the 10 doctors nearest to a visitor’s zip code. Note that this is not the same as doctors in a given radius (say 10 miles), but it does use the same basic formula. This article will be
Enforce text case with Custom Controls
(Scott Lysle) This article shall describe the construction of three custom controls; each is used to format its text content to be either all upper case, all lower case, title case, or normal (as typed) case regardless of the format of the input. Such controls may be useful if it is necessary to loa
SQL Server Backup I/O Performance
(Linchi Shea) I had always thought that: –SQL Server backup reads/writes sequentially, and –SQL Server backup could fully utilize the throughput of the I/O path
Mimicking ROWNUM in DB2
(Craig Mullins) I was going through the many random files stored on my PC when I came across this useful nugget. A year or so ago a reader sent me this code. He and his supervisor had come up with a way to simulate the Oracle rownum feature in DB2 and wanted to share it with the world. I think, […]
Microsoft Queuing Frameworks: SQL Service Broker vs. MSMQ
(Michael Jones) Microsoft offers two queuing frameworks to its ‘brand’ of developers: MSMQ and SQL Service Broker. These two frameworks offer many of the same features, but differ in some important areas that might affect which you choose for your queuing project. MSMQ is a time-tested technology, w
Turn AUTO_SHRINK off!!
(Paul Randal) This week’s topic is data file shrinking. I’ve seen lots of mis-information in the last few weeks and I’ve had a bunch of questions about it. First up is auto-shrink.
Customizing and Managing Your Site’s Appearance with ASP.NET 2.0 Tools
(Randy Connolly) The previous chapters introduced many of the standard Web server controls. This section returns to the coverage of Web server controls by demonstrating how to more fully customize the appearance of these controls. The chapter does so in two ways. The first way uses common formatting
Calling Web Services Asynchronously with ASP.NET
(Dan Wahlin) This video tutorial walks you through the fundamentals of calling Web Services asynchronously from an ASP.NET page using the .NET 2.0 event driven model exposed by Web Service proxy objects. There are several different options for calling Web Services asynchronously including polling, c