(Soyuj Kumar Sahoo) As I discussed in my previous article, CLR is the heart of Microsoft .Net framework. In SQL Server 2005 we can create a database object inside an instance of SQL Server that programmed in an assembly created by .Net framework. Assemblies are DLL files used in an instance of SQL S
Other News
Using a Web User Control inside the GridView control
(Michael Livshitz) Developing some web site we often should use some control in the GridView control. In this case we have to create the GridView control with TemplateField columns and use some special methods to access needed data. Inside the GridView control we can use both standard server control
Using the ElementPath Capability in SQL Reporting Service 2005
(Jayadev D) When you use an XML data provider as a data source in SSRS, the query text generally consists of mainly of SOAPAction or MethodName tags. This also allows you to add an ElementPath tag which precisely filters the data you need to build a report.
Put VB.NET events in the hands of AddHandler
(Bruce D. Neiger) A simple conundrum posed by Visual Basic 6 — how to trap and handle events from objects that are not assigned to an individual variable — was solved by the earliest versions of VB.NET. The solution is the AddHandler command. (R)
User Authentication and PHP Security
(Leidago) So far we have covered security vulnerabilities that involve form data, databases and file systems. In this article we are going to look at authentication and the security issues around it. We will also look at some of the most common attacks in this field.
Integrating ASP.NET AJAX with SharePoint
(Mike Ammerlaan) Ok, so now that this blog is going, now for a common topic I’ve been asked a bit about recently. How does Microsoft ASP.NET AJAX integrate with SharePoint? Here are some notes I’ve collected on this.
XML and Java technology: What’s XML really good for?
(Brett D. McLaughlin, Sr.) It’s no secret that XML continues to be one of the most popular technologies that’s shown up in the last ten years. But what is XML really good for? Is it useful for configuration data? For data exchange? As a medium for data storage? What is XML really good for? This arti
Developing with Apache Derby — Hitting the Trifecta: Java database development with Apache Derby, Part 3
(Robert J. Brunner) Learn how to modify an Apache Derby database from a Java program. This article builds on the previous two articles in this series to demonstrate how to create and drop tables as well as how to insert, update, and delete data in an Apache Derby database from within your Java appli
Some V8 migration reading material from IDUG
(Willie Favero) I was just cruising the online version of IDUG’s Solution Journal and came across a very well written article on a DB2 migration to Version 8… written from a customers point of view and written by that customer. Very cool… very well done.
SQL Server Security- The Crib Sheet
(Robyn Page) In a production database, any access to data and processes must be restricted to just those people who require it. Generally, the DBA will also want to know who did what within the system, at any point in time.