MSSQLCity.Com - All about MS SQL
     
 About Us  
 SSWUG Articles  
 Articles  
 FAQ  
 Scripts  
 Tips  
 Test Exams  
 Advertise  
 Download  
 History  
 Search  
 Traffic  
 Related Links  
     
Your button logo
Add to Favorites
 
     
 

SSWUG Articles

Associating Style Sheets with XML documents 1.0
This document allows style sheets to be associated with an XML document by including one or more processing instructions with a target of xml-stylesheet in the document's prolog.


SQL SERVER – Business Intelligence – Aligning Business Metrics
(Pinalkumar Dave) Today, executive management and managers need the latest information to drive intelligent decisions for business success. More informed decisions mean more revenue, less risk, decrea


XSLT with Optional Extension Object
(Warlock) Extension objects provide a convenient way to allow an XSL transform to interact with the outside world. They can also be used to offload computations that are difficult to express in XSL.


xml syntax highlighting in Silverlight
(Nick Kramer) Several years back I posted a XML tokenizer for syntax highlighting. At the time I didn't post a complete app, since it was part of a larger project; if someone recently asked me for a l


Declaring Anonymous Types in VB
(Paul Kimmel) Using an anonymous type means that the compiler will code generate a class for you based on context and named initializers. This article introduces you to anonymous types and explores so


Ensuring Correlated Partition Exclusion
(Martin Widlake) I’ve posted a couple of times recently about a tuning method with partition exclusion where you infer a relationship between the value you want to limit a query on and the partition k


DB2 LUW Security -- Looking at DB2LOOK
(Rebecca Bond) Do you ever try to look at things from a different perspective just to take them out of the “normal”? I do too and I think that’s a great way to approach “some” security considerations.


IsNull() vs. IsDefined() For ColdFusion 9 Scope Detection
(Ben Nadel) I just spent an hour trying to debug a ColdFusion 9 problem when I realized that the root of the problem was the fact that ColdFusion 9's new IsNull() method and the previously existing Is


Live Data Binding in ASP.NET AJAX 4.0
(Dino Esposito) Recently I moved into a new office and went through the extremely pleasant and gratifying experience of packing up all the programming books I had collected in more than 10 years.


Don’t Worry About Cloud Security
(Steve Hanna) With its ability to provide users dynamically scalable, shared resources over the Internet and avoid large upfront fixed costs, cloud computing promises to change the future of computing


Practical SQL: Monitor Changes by Accessing Journals with SQL
(Joe Pluta) Journaling has been an integral part of the DB2 database since long before it was called the DB2 database. In fact, journaling predates the IBM i and even the AS/400; journaling was introd


Performance Features in DB2 V9 for z/OS – Part 11
(Dave Beulke) While talking with clients and friends at the recent conferences, I noticed that everyone seemed to like the blog entries I’ve done about the performance features of DB2 v9 for z/OS. Som


Benefits of DB2 9 & looking forward to DB2 X
(Julian Stuhler) Despite several key performance enhancements delivered in DB2 version 8, some new customers saw little or no overall improvement due to the overheads inherent in the move to 64-bit ar


Query Active Directory Data from SQL Server using T-SQL
(Muthusamy Anantha Kumar) Active Directory Service Interfaces, also known as ADSI, is a set of COM interfaces used to access the directory services to retrieve data. Though it is predominantly used by


Patch a Thousand Databases, Using Oracle Enterprise Manager Grid Control
(Porus Homi Havewala) Patching has always been one of the many joys (or dreads) of Oracle DBAs. Ever since the initial days of Oracle, patches have been published by Oracle Support, downloaded by DBAs


Access Path Scientific Analysis Part III
(Chris Foot) Now that we have an understanding of how we can influence access paths using hints and session parameter changes, let’s continue our discussion by reviewing the various types of indexes a


Types and Tuples in .NET 4
(Bill McCarthy) The Microsoft .NET Framework 4 library includes new generic tuple classes. Tuples are a group of properties that provide a means for you to easily group pieces of data together without


Performance Comparison between Data Type Conversion Techniques in SSIS 2008
(Sedat Yogurtcuoglu and Thomas Kejser) Data type conversion is one of the most common ETL tasks used in Microsoft SQL Server Integration Services packages. There are several ways to perform these conv


DB2: DPSI Do, or DPSI Don't?
(Robert Catterall) One of the more interesting features delivered in recent years for DB2 for z/OS is the data-partitioned secondary index, or DPSI (pronounced "DIP-see").


ORA-01427: single-row subquery returns more than one row
(Kellyn Pedersen) A developer friend of mine sent me an email today frustrated that none of the DBA's he worked with could explain this error to him and sent it onto me. I thought I would get a post o



 

 
Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators.

(c) 1997, 2010 Bits on the Wire, Inc