(Lauren Walker) With less than a month to go before the first major SQL Server upgrade in five years, users seem to be divided into two camps: those who are going into production as fast as they can and those who will upgrade sometime in the next couple of years. (R)
Other News
Compress SQL Server backups using WinZip – Part I
(Muthusamy Anantha Kumar) SQL Server Database Administrators often run out of space due to huge backup files that have been retained on the disk. This article illustrates how to take full and transaction log backups and compress the backup files using the reasonably priced WinZip.
V8 CM – To Bind or Not to Bind, that is THE question!
(Willie Favero) And rest assured, it is a decision you will eventually have to make once you begin your migration to V8 compatibility mode. While running in compatibility mode, there could be overhead that you did not experience when you were on Version 7. In fact, there is always some degree
The VS.NET 2003 DateTimePicker Control’s Default Value
(Boris Eligulashvili) In some cases, the results of the use of the DateTimePicker control can be confused—implicitly initialized. This tip describes what you can do to avoid confusion.
Incorporate SQL Server UDFs in your .NET applications
(Tony Patton) Database interaction is a standard feature of most .NET applications, with SQL Server as the popular choice for the data tier. Consequently, .NET developers often find themselves developing T-SQL code within their applications or stored procedures on the database server.
Oracle Tip: The wrap utility and code obfuscation
(Scott Stephens) Oracle PL/SQL is loaded into the database in one of two ways. The primary way is to apply the PL/SQL code against the database directly in a SQL script from source code. But, if you’re shipping the code to an external customer, you run the risk of someone taking your source code, co
Tip: Computing word count in XML documents
(Uche Ogbuji) One of the best things about XML is that it’s just text, and you can use many general-purpose text processing tools to work with it. Occasionally, however, this doesn’t work so well because the tags get in the way. As an author for developerWorks I have to submit my work in an XML temp
Looking at Partial Classes
(Thom Robbins) The .NET Framework 2.0 introduces a variety of features and enhancements. One of these is the addition of Partial Classes. This new Framework features enables a single class definition that can be split across multiple physical files. During the compilation process, these separate fil
The Power of Insight
(Janet Perna and Andrew Warzecha) Businesses are facing a formidable challenge: the pressure to grow revenue, contain costs, respond more quickly to changes, and increase efficiency. These big goals demand that people and processes have access to the right information at the right time to take the a
Generic Architecture for Caching Table Data: Supercharge Your Cache
(Mark Vilrokx) In the first part of this series we started of by putting the basic structures in place for a cache and wrote some code to manage the cache. In this next part, we will extend the functionality of our cache.