This article focuses on the security mechanisms common to all databases that implement the Structured Query Language (or SQL). Together, we'll walk through the process of strengthening data access controls and ensuring the safety of your data.
Other News
Octopus Extends Its Meta Applications Arm
Using standards such as XML and J2EE (Java 2 Platform, Enterprise Edition), the Meta Application grabs information from predetermined databases and news sources like internet.com (Nasdaq: INTM), Yahoo! (Nasdaq: YHOO) and CNET Networks.
Produce dynamic Web pages with Java and XSLT
By Pramod Kankure – This article discusses two ways to produce dynamic Web pages with Java and XSLT by passing user-request parameters from a Java backend program to an XSLT style sheet used to render the Web page. The sample code demonstrates the use of the XSLTProcessor method and a custom method,
Math and XSLT
by Bob DuCharme – XSLT's full support of XPath's math capabilities lets you do all the basic kinds of arithmetic and a little more. Let's look at a stylesheet that demonstrates these capabilities by using the values from this document:
FMS, Inc – Total SQL Analyzer – Now Shipping
FMS, Inc. announced the immediate availability of Total SQL Analyzer™, the first comprehensive documentation and analysis solution for Microsoft SQL Server. Providing comprehensive documentation of all objects, properties, and settings available in SQL Server, Total SQL Analyzer allows developers an
SQL Fundamentals
The Structured Query Language (SQL) comprises one of the fundamental building blocks of modern database architecture. SQL defines the methods used to create and manipulate relational databases on all major platforms. At first glance, the language may seem intimidating and complex but it's real
Namespace Nuances
by John E. Simpson – Q: I can't validate a document using namespaces, can I? I'm trying to validate an XML file. It uses XML namespaces, but I can't figure out how to express them inside the DTD. Here's a sample XML document:
Applications Everywhere: A WML Primer
by Wei Meng Lee – Developers interested in programming for wireless devices such as mobile phones and personal digital assistants must use the Wireless Application Protocol (WAP). To develop WAP applications, Wireless Markup Language (WML), which is based on XML, is designed to display content on mo
XML data management: Setting some matters straight, Part I
By Fabian Pascal – In my article Managing data with XML: Forward to the past? in this series, I questioned the use of XML for data management. I received a critical reaction from Rick Jelliffe, who claims to be a contributor to XML. Following a brief email exchange, I wrote a three-part article as a
Professional SQL Server 7.0 Development Using SQL-DMO, SQL-NS, and DTS
The book goes into a lot of detail about how SQL Server 7.0 works under the covers and how you go about using those features within your applications. Most of the book uses Visual Basic and VBScript samples, but there is a chapter for C++ programmers at the end.