(William Pearson, III) In this article, we will introduce the concept of distinct counts, discussing why they are useful (and often required) within the design of any robust analysis effort. Throughout this article, we will describe some of the challenges that are inherent in distinct counts, and th
Author: SSWUG Research
Introducing the ASP.NET XmlDocument() Object
Over the years, XML has become an important technology, because of its unrivalled ability to mark up content and make it more useful. Almost all modern development platforms now provide some kind of native support to read and parse XML documents. This includes ASP.NET, which comes with a handy XmlDo
How to: Read and Write BLOB Data to a Database Table Through an Anonymous PL/SQL Block
After reading this how-to document you should be able to: –Execute an Anonymous PL/SQL block using ODP.NET –Save Image data from a file to database –Write Image data to a file from database
Where XML goes astray…
(Derek Denny-Brown) It seems like every programmer and their brother has picked up XML and is using it as the proverbial hammer to nail some solution. Sometimes it works, sometimes it doesn’t. A lot of people have written about how XML doesn’t scale, how XML isn’t the right solution for problem X, b
Managing .NET Code Access Security (CAS) Policy
CAS security is based on the identity of managed code. The need for CAS arose out of the constant execution and threat of malicious code on the Internet. A quick look at what has been done up to now in the way of security can help set perspective on the value of CAS.
Creating Triggers Using Managed Code in SQL Server 2005
(Thiru Thangarathinam) One of the excellent features provided by SQL Server 2005 (code named Yukon) is its integration with the .NET CLR which makes it possible for us to author triggers, stored procedures, user defined functions, and create other database objects using a managed language such as VB
Oracle Tip: Use the correct looping control in PL/SQL
When you process an index-by table in PL/SQL, there are times when you cannot be sure of the indices that exist on the table, so you can’t use the most obvious form of the FOR loop to loop through values. (R)
Object-Relational Programming with DB2 (Sample Chapter)
(Susan Lawson) Explore some of the more powerful features of DB2’s SQL language. Learn about the extended programming features, User-Defined Functions (UDFs), table functions, triggers, and user-defined data types (UDTs).
Database Management for DB2 Universal Database – zOS and OS/390
SmartDBA solutions optimize performance of your DB2 UDB for z/OS and OS/390 databases by providing a comprehensive solution for monitoring and managing your environment through a single, integrated console. You can reclaim space and proactively prevent outages as well as analyze, diagnose, and tune
Protecting Your Data Integrity with Transactions in ADO.NET
(Christa Carpentiere) Transactions are a key feature for maintaining data integrity when modifying data. Get an overview of transactions and their importance, then learn how to use them to protect data in your .NET applications.