Featured Article(s) Loading image files from a directory using SQL 2005 The following procedure uses the new BULK in OPENROWSET set function in order to load all image files from a given directory location to a table inside SQL Server , If the table does not exist, the procedure creates it. The table structure is an identity column, the file […]
Other News
The Big Deal About Making Things Smaller: DB2 Compression
(Willie Favero) This article covers the basics of DB2 compression, including why sometimes you’re told to avoid compression, table space compression, and index compression. (pdf)
Designing an Interactive Voice Response System Using VoiceXML and CCXML
(Ponkumar and Sujata De) Voice interaction is by far the most natural choice of interaction for humans. When it comes to communicating with computers, interaction by voice brings in flexibility and ease of use to the consumer. The caller does not need to type in any information and can be on the mov
Jacquard: a methodology for Web publishing
(Uche Ogbuji) Learn about Jacquard, a software development methodology specialized for Web projects, and especially for Web development among diverse teams. Jacquard looks to align the work and goals of business interest personnel, Web designers, programmers, project managers, database analysts, and
U2.NET — Develop a native MultiValue style master-detail application
(Gopakumar Padmanabhan) This tutorial introduces IBM UniData and UniVerse (U2) MultiValue add-ins for Visual Studio (U2.NET), IBM’s new development tool for U2 MultiValue .NET applications. Develop a U2 MultiValue style master-detail application in C# in Visual Studio 2005. U2.NET’s Visual Studio in
XML Tools in Visual Studio 2008
(Stan Kitsis) XML is everywhere from XML Web Services to databases to config files to Office documents. This article will show you tooling support offered in Visual Studio 2008 that will make working with XML easier. It will cover editing XML files, working with XML schemas, debugging XSLT style she
Ten common SQL Server security vulnerabilities you may be overlooking
(Kevin Beaver) Plenty of malicious outsiders would love to get into our databases. To block them, we simply put up a firewall and make sure no externally facing Web apps allow SQL injections. Instantly, all’s well in Databaseland. Right? As long as we don’t have any unknown entry points into the net
Store Indexes In A Larger Block Tablespace: Height Reduction 1/2 Myth (Five Foot One)
(Richard Foote) A common misconception with using a larger block tablespace specifically for indexes is that this will result in a reduction in the height of indexes and hence ”flatten” index structures.
11g Really Does Support Case Insensitive Passwords
(Lewis Cunningham) This one is an oopsy. I am playing with 11g again. Having fun too. I’ll be writing up some of my experiences shortly. One of the things I have been playing with is Heterogeneous Services. Oracle makes connecting to remote databases (of a non-Oracle persuasion) incredibly easy.
New Log Reporting, Database Management, and other cool admin modules for IIS 7
(Scott Guthrie) One of the core priorities we focused on when building IIS 7 was to enable a rich .NET extensibility model that provides developers with the hooks to easily plug-in and extend the web server.