Consider the following scenario. You try to filter non-Unicode data columns for records from a table in Microsoft SQL Server 2000. You use the NOT LIKE clause in a Transact-SQL query statement. You use the “%” wildcard character in the search pattern. In this scenario, SQL Server incorrectly returns
Author: SSWUG Research
Kewl DB2 for z/OS Version 8 Feature Part 2a: Multi-row INSERT & FETCH
(Willie Favero) And finally, some actual detail about a DB2 for z/OS Version 8 feature. My first detailed entry will introduce you to multi-row INSERT and FETCH. This Version 8 SQL enhancement does exactly what you would expect. It allows you for the first time, to insert multiple rows or fetch mult
ADO.Net 2.0 in 5 minutes
(george.p.alexander) Or ten. But here’s a condensed look at some of the changes and new features we would want to encounter while migrating from ADO.Net v1.x. Earlier we had a look at what’s in store for us C# 1.x developers jumping onto the C# v2.0 bandwagon. I’ve so far just scratched the surface
XML Security Suite: Increasing the Security of E-Business
(Doug Tidwell) As more and more companies use XML to transmit structured data across the Web, the security of documents becomes increasingly important. The World Wide Web Consortium (W3C) and the Internet Engineering Task Force (IETF) are currently defining an XML vocabulary for digital signatures.
Learn The ABCs Of Programming Windows Communication Foundation
(Aaron Skonnard) Windows Communication Foundation (WCF), formerly code-named “Indigo,” is about to radically change the face of distributed programming for developers using the Microsoft .NET Framework. WCF unifies the existing suite of .NET distributed technologies into a single programming model t
Reserved Resource Database in SQL Server 2005
(Vinod Kumar) Also called as RDB this is a new concept in SQL Server 2005 which I thought was worth taking a look at. In previous version of SQL Server 2000 whenever we had to upgrade a system defined object we had to drop and recreate. And rollback of the same was also something that we as DBA’s ha
Improving Performance with SQL Server 2005 Indexed Views
(Eric Hanson, Gail Erickson, Lubor Kollar and Jason Ward) This document describes the improved indexed views capability of SQL Server 2005 Enterprise Edition. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.
Oracle halfway to Fusion
(Alorie Gilbert) Oracle executives took the stage in San Francisco to rally support for the company’s development plans after a run of recent acquisitions that has left Wall Street lukewarm on the firm.
Using Visual Studio 2005’s WSAT to configure your web application
(Ludmal Suranga De Silva) Configuration is one of ASP.NET’s powerful features. Although it can be used in production sites by simply editing the web.config XML file, we tend to forget how to add impersonation or custom error pages to the configuration file, or we are unaware of XML’s case sensitivit
Create and Share Your Own Code Snippets
(Josh Fitzgerald) One of the most intriguing new features of VB 2005 is IntelliSense Code Snippets. Code snippets make it easy to insert commonly used pieces of code into your project. They are also great for very valuable pieces of code whose syntax you never get the quite right without consulting