(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
Other News
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.
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
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
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
Optimizing Microsoft SQL Server Analysis Services: MDX Optimization Techniques: Considering DISTINCT COUNT
(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
Using Hibernate to Persist Your Java Objects to IBM DB2 Universal Database
(Javid Jamae and Kulvir Singh Bhogal) Hibernate, an open source application, provides a way to easily persist your Java objects to DB2 Universal Database without writing a single line of SQL code. Our authors show you how.
The State of Python-XML in 2004
(Uche Ogbuji) The table below lists the currently available Python-XML software that I judge to be significant. It is not a list of every bit of software in Python that has anything to do with XML. For example, I do not list pyglade (part of PyGTK), which is software for generating user interfaces i
DB Change Management: An Automated Approach – Part 3
(Darren Fuller) In part 2 Darren Fuller examined an automated approach to database change management and outlined the essential elements of an automated methodology. In this third article of a 4 part series, he lists the requirements to implement an automated approach and highlights some of the bene
Retrieving Identity or Autonumber Values into Datasets
You can set a column in a DataTable to be an auto-incrementing primary key in order to ensure a unique value for each row in the table. However, you may have multiple clients for your application, and each of those clients can be working with a separate instance of the DataTable. In this case, y