(Sanjay Shetty) Standard applications, of course, use a database, but if you’ve ever investigated the idea of building an application using only XML files as a data store, you know that it has been rather challenging. The .NET Framework 1.x lacked some basic XML-enabling features, which made it diff
Other News
Performance tuning freebies to add to your favorites
(Jeremy Kadlec) I recently spoke on SQL Server performance tuning at CFUNITED, a conference focusing on Cold Fusion, where I found a large number of developers who use SQL Server every day. In my presentation, I offered a variety of free tuning tools that attendees were not aware of. Here I’ll share
Introduction to SQL Server Report Builder
(Mike Gunderloy) By now you probably know that there are a lot of fancy new high-end features coming in Microsoft SQL Server 2005. But in its quest to conquer the data center, Microsoft hasn’t forgotten the end user. In fact, there are more new features for desktop users and business analysts than e
Performance tuning: The limits and limitlessness of time
(Craig Shallahamer) Oracle performance analysis has come a long way in the last 20 years. First there was the “just add more resources” approach, then came ratio analysis, and finally, wait event analysis emerged. But those approaches were not complete or broad enough, so in 2001 I published a paper
Database Projects in Visual Studio .NET
(Scott Mitchell) I’ve been using Visual Studio .NET for years developing ASP.NET applications, however it wasn’t until about two years ago that I learned about Database projects in Visual Studio .NET. With a Database project you can manage all of your database’s objects’ creation scripts – stored pr
Easily utilize Microsoft Word functionality in your .NET application
(Tony Patton) Developers often think they need they need to reinvent the wheel, when all they really need to do for certain tasks is make use of existing applications. A good example is utilizing one or more applications in the Microsoft Office suite of products. For instance, you may want to ut
The Configuration API in .NET 2.0
(scott) The configuration API in .NET 2.0 gives us the ability to read and update configuration files, including web.config and machine.config files. You can read and write configuration files for your application, for another application on the same machine, or even an application on a different se
The Full Text resource fails when you install a new clustered instance after you apply SQL Server 2000 Service Pack 4 to an existing clustered instance
After you apply Microsoft SQL Server 2000 (64-bit) Service Pack 4 (SP4) to an existing clustered instance of SQL Server 2000 (64-bit), the Full Text resource fails when you install a new clustered instance of SQL Server 2000 (64-bit). This problem occurs in both the default instance and the named in
Select records based upon numerous criteria
(Kent Milligan) Within SQL, I need to select records based upon numerous criteria, but the one criteria that is leaving me scratching my head is select a record is a 9 byte alphanumeric field is strictly numeric (000000000 through 999999999). Using a range of ‘000000000’ through ‘999999999’ does NOT
XML Editor and Code Snippets
(Stan Kitsis) How many times in your coding life have you had to write or copy-paste code that was almost identical to something that you’d done before?