stored procedures
RSS stored proceduresWeb 2.0 prompts love for open source
News The effort of rewriting stored procedures, applications and queries also adds to the complexity of migration, he wrote. The market for open-source databases is booming due to new workloads such as RFID projects, rich web applications and small... [24 Jul 2008]
Privacy chief fights UK-wide database
News A database of all calls, emails and internet traffic, to be stored by the Home Office for at least 12 months, is thought to be included under proposals for "modifying procedures for acquiring communications data" in the draft Communications Data... [15 Jul 2008]
MSDN Webcast: Securing Applications With SQL Server 2000 - Level 300
White Paper The attendee will learn how to use views, stored procedures and the native security mechanism in SQL Server to secure the information stored in the organization's data-centric enterprise applications. [10 Jul 2008]
MSDN Webcast: Defending the Database: Making the Right Design Choices (Level 200)
White Paper The attendee will learn about secure connections, .exp files, managed stored procedures, alerts, and monitors. After analyzing the infamous SQL Injection attack in the first webcast, the presenter discusses secure database design in this second... [05 Jul 2008]
Email-Related Sarbanes-Oxley Compliance
White Paper The documents to be preserved can be stored in both hard copy and electronic formats. The Act established a list of criminal penalties and fines for companies that violate the procedures or legal requirements it sets forth, carrying fines of up to... [03 Jul 2008]
MSDN Webcast: 24 Hours of SQL Server 2008: Streamline Data Access With SQL Server 2008 (Level 100)
White Paper The webcast explores the new features in SQL Server 2008 that the developers are excited about and focuses on T-SQL improvements, such as MERGE, the Table Valued Parameters feature that lets data rows be passed as parameters to stored procedures... [30 May 2008]
E-Discovery Lessons From Case Law: Five Steps to Help You Prepare for Litigation
White Paper In addition to developing policies and procedures for addressing preservation, organizations should investigate technology solutions that will help to ensure that information can be stored and managed in a way that ensures its integrity and long... [16 May 2008]
PCI Security Audit Procedures
White Paper For service providers required to undergo an annual onsite review, compliance validation must be performed on all system components where cardholder data is processed, stored, or transmitted, unless otherwise specified. [23 Apr 2008]
Data Access Tools Speed Development 500 Percent for Healthcare Software Vendor
White Paper It chose to use Microsoft Visual Studio Team System 2008 Development Edition and replace stored procedures and dynamic SQL statements with the Language Integrated Query functionality in Microsoft .NET Framework 3.5. [16 Apr 2008]
Use XML in DB2 SQL Stored Procedures: Access XML Data With Procedural Logic in DB2 9 for Linux, UNIX, and Windows
White Paper This paper discusses the use of XML in SQL stored procedures. Now, one can build indexes over XML data, and perform shredding using a call to a stored procedure. IBM DB2 9 for Linux, UNIX, and Windows adds major new XML functionality over and above... [09 Apr 2008]
Programming With XML for DB2, Part 4: Integrate Data From Different Data Sources in Your Web-Based DB2 Application
White Paper Learn how to expose the database stored procedures as Web services so that they can be accessed through SOAP calls. Walk through the steps for creating a sample IBM DB2 application that uses the XML model to integrate data from different data sources. [09 Apr 2008]
Develop Java Applications for DB2 XML Data
White Paper One will see how to insert, query, update, and delete XML data, how to create stored procedures that access XML data, and more. Writing Java applications that access XML data stored natively in DB2 Viper isn't much different from writing Java... [09 Apr 2008]
Use DB2 Native XML With PHP: Leverage DB2 Native XML Functionality and PHP to Simplify Apps Using XML Data
White Paper This paper looks at the impact of schema evolution on the application and walks the reader through a usage scenario to illustrate the ease of setting up a PHP environment; the ease of integrating DB2 native XML functionality with PHP applications... [09 Apr 2008]
More on Oracle Database 11g
White Paper In Oracle6, there were no stored procedures, no packages, and no triggers. PL/SQL is Oracle's procedural extension to SQL, and it is a true 3GL programming language. It was first introduced way back in version 6 of the database, giving the ability... [28 Mar 2008]
MSDN Webcast: ASP.NET Soup to Nuts: Auction Site Database (Level 200)
White Paper The attendee will also learn about developing stored procedures to support the auction site and configuring the auction site application so it can securely connect to the database by limiting the access to just the required privileges. [27 Feb 2008]
