(shodan) Just had an interesting issue with an encoding mess on a column containing non-ASCII (Russian) text. The solution was not immediately obvious so I decided it’s worth sharing.
Other News
SQL Server encryption vs. hashing for data security
(Denny Cherry) Choosing between ata encryption and data hashing is a fairly new concept for the SQL Server database administrator and developer. Yet, network and software engineers have been dealing with data encryption at the network level and from the Web server to the client for many years. While
Split a String
(Brian Eye) The following splits up the values returned from a string.
OMIGOSH III (Attacking A SQL Server Issue)
Do You Have Your Free 90 Day SSWUG Membership Yet? You can get it quickly just by registering for the conference. By registering before 12/31/2007, you will receive a complimentary 90 day membership to the site. It’s easy to register and the conference will feature more than 36 technical tracks, exhibits, no sales info in the tech tracks, and much […]
Remote Data Piping into DB2 for z/OS
(Ben Budiman, Joe Kidd and Johannes Schuetzner) With multi-tiered applications, there are often topologies with DB2 for z/OS as database backend and the application logic running on another platform like AIX, Linux or Windows. Using the DRDA protocol, the application remotely accesses DB2. An exampl
Intel Aims To Boost SOA With XML Solutions
(Kurt Mackie) Intel Corp. released a new software product suite that is designed to enhance the performance of XML in service-oriented architecture (SOA) environments, or other environments where XML handling needs optimization. Intel XML Software Suite 1.0, which was announced earlier this month, p
A user-defined function for culturally correct collation in DB2 UDB
(Doug Doole) Learn about the user-defined function (UDF) for IBM DB2 Universal Database for Linux, UNIX, and Windows (DB2 UDB) that provides culturally correct collation for Unicode databases. The UDF can be used to order query results in a culturally sensitive manner. It can also be used to provide
Push RSS to new limits
(Jonathan Levin) This tutorial presents an innovative use of the well-known Really Simple Syndication (RSS) format’s associative properties to emulate the functionality of a simple relational database. It demonstrates using RSS channels to store contact information and meeting information—much as a
Case Study: ASP.NET Deadlock calling WebServices
(Tess Fernandez) Lately, no matter where you turn there are LINQ presentations and Silverlight demos. A couple of years back the hot new stuff was webservices and XML.
ADO.Net & OPENXML to Perform Bulk Database Operations
(mfmaneef) Last week at my work I had to write a tool to process few hundreds of thousand email files and insert their details to the MS SQL Server 2005 database. Doing it in traditional way might require much connectivity to the database and will consume many resources. I was wondering what if I co