Stored Procedures

Solution Search:
Oracle Compatibility Developers Guide for Postgres Plus Advanced Server by EnterpriseDB Corporation
This guide describes the Oracle compatibility features of Postgres Plus Advanced Server. Oracle compatibility means that an application runs in an Oracle...
Idera SQL diagnostic manager - SQL Server performance monitoring and alerting by Idera
administrator's fingertips, such as worst-performing stored procedures, long-running queries, frequently run queries, and blocking or blocked sessions.

Download size: 56.6Mb

Terms of Trial License: Full...
7-Eleven Stores Ring up Better Backups with ExaGrid by ExaGrid Systems, Inc.
in an effort to streamline its nightly data protection procedures and to increase the amount of data the company could back up each night. 7-Eleven Stores began looking for a disk-based backup...
Achieving PCI Compliance at the Point Of Sale Using Bit9 Parity™ to Protect Cardholder Data by Bit9, Inc.
theft.

By following the standardized, industry-wide procedures of PCI DSS, organizations can:

  • Protect their customers' personal data.
  • Boost customer confidence through a higher level of data
...
Achieving PCI DSS v1.2 Compliance with Lumension by Lumension
The PCI DSS foundation consists of 12 fundamental Requirements® organized into 6 major functional areas. This Whitepaper gives you a quick overview of all 12...
Email Archiving: A Proactive Approach to e-Discovery by Proofpoint, Inc.
required to deal with them. Email and other electronically stored documents are now routinely presented as evidence in courts of law. To ensure litigation readiness, both legal and IT departments...
Replay AppImage Helps The Villiage Restore Any Exchange Object With a Few Simple Clicks of a Mouse by AppAssure Software
This case study illustrates how Replay is saving a large property management company a tremendous amount of time and money by enhancing the backup process so it...
Storage Landscape 2009: Best Practices Unveiled to Help You Store More for Less. by Iron Mountain Digital
This webcast will explore ways in which an organization can achieve greater efficiencies in their storage infrastructure and make suggestions how to plan for...
Simplifying Disaster Recovery (DR): One-Button Replication for Combined Physical/Virtual Data Centers by FalconStor Software
this the hard way, when a disaster caught them unprepared. DR procedures have always been complicated for the physical server infrastructure, and the introduction of server virtualization has only...
Meeting Compliance Objectives in SharePoint® by AvePoint, Inc.
obligations, reviewing both the out-of-the-box tools and the procedures by which administrators can implement these tools to meet compliance demands. To help elucidate these procedures, we will walk...
REI: Workforce Optimization and Management by Infor
REI implemented Workbrain for Retail, a centralized, web-based workforce management solution as it is specifically designed to meet the complex...
IBM® Lotus® Domino® Server Performance on Red Hat® Enterprise Linux® 5 by Red Hat
concepts and methodology. It will also outline the detailed procedures for running the Server Load Utility with the N8Mail Workload. Finally, it presents the performance results of Lotus Domino Server...
Disaster Recovery Planning for BlackBerry Enterprise Server for Microsoft Exchange by BlackBerry
prepare for the design and delivery of disaster recovery procedures for the BlackBerry environment. This document provides an overview of BlackBerry® Enterprise Server components and is...
Podcast: 10 Things Small Businesses Must do to Protect & Secure Data by Symantec Corporation
critical information. In addition, SMBs can learn more about procedures to put in place to be prepared not only for disasters, but to be compliant as well. Small businesses are coming under more and more...
MySQL Guide For Sun Storage 7000 Unified Storage System by Sun Microsystems, Inc. and Microsoft
a Sun Storage 7000 Unified Storage System. Configuration procedures are included, describing how to configure both the Sun Storage 7000 Unified Storage System and the MySQL database servers for NFS...
Configuring Microsoft Windows Server 2008 Hyper-V on Sun Fire X64 Servers by Sun Microsystems, Inc. and Microsoft
The paper describes the procedures used to install and configure Hyper-V on a Sun Fire X4150 server. It gives an example configuration that also used a Sun Storage J4200...
SPSS Text Analysis for Surveys 3.0: Get the Most Out of Open-Ended Text Responses by SPSS Inc. Worldwide Headquarters
to make it far more powerful than typical text-coding procedures. It allows you to categorize hundreds - even thousands - of responses in a fraction of the time it would take to do so manually. It's...
Avoiding the Disk Bottleneck in the Data Domain Deduplication File System by Data Domain
system that cannot afford enough RAM to store an index of the stored segments and may be forced to access an on-disk index for every input segment.

This paper describes three techniques employed in the...
Developing an Analytics-Driven Retail Sales Forecasting System by Wipro Technologies
This paper describes the analytics process involved in development of a statistical model-driven, business knowledge based sales forecasting system for...
Quantum DXi-Series: Deduplicated Backup and Remote Replication Solutions by Quantum Corporation
Watch this illuminating video to learn more about data deduplication as well as how the Quantum DXi-Series disk backup and replication solutions leverage data...
Legal Aid: How IT Can Be the Difference Between Litigating or Settling by StoredIQ
at many organizations. The focus is on electronically-stored information (ESI), with records management joining the discussion. When it comes to production of records for legal cases, IT is being...
Heinz Uses Wireless Technology to Gain Retail Advantage by BlackBerry
Heinz wanted to speed up and improve the quality of scorecard information they gathered about Heinz brands in retail stores; so they used the Electronic Retail...
GFI MailArchiver - Low cost Email Archiving for SMBs by GFI Software Ltd.
reducing dependency on cumbersome PST files. All email is stored in a central location that is easily accessible through Outlook, or a web browser. Offline access of email archives is also...
Optimizing Oracle RMAN and ASM Environments with FalconStor VTL and Integrated Deduplication by FalconStor Software
consistent Oracle high availability - backup and DR procedures have become complex and costly.

FalconStor® Virtual Tape Library (VTL) with integrated Single Instance Repository (SIR...
SQL Server Resource Center
The keys to database backup protection for SQL Server
restore your backups to another server without using anything that is stored on your production server. This means keeping the encryption keys stored in a... More...
Jun 22, 2009
The short course on how SQL Server really works
of text. The real data can then be spread across multiple pages, or even stored in a file (that's the special FILESTREAM type which we'll discuss later). SQL Server... More...
Jun 10, 2009
Understanding transparent data encryption in SQL Server 2008
is a feature of SQL Server 2008 where varbinary columns can be stored in the file system and asynchronously streamed to the client.

Read-only file groups... More...
Jun 9, 2009
Working with sparse columns in SQL Server 2008
and SellEndDate columns as sparse. As a result, null values will be stored more efficiently in these columns (note that the source data contains a... More...
Jun 2, 2009
SQL Related Articles
Saying yes, no or maybe to stored procedures by Jack Vaughan, Site Editor
that occurred just a few years before they started their careers.

Take stored procedures. Middle-tier specialists tried mightily to avoid these rolled up bits of logic placed in the database. They did that because the... More...

Aug 16, 2006
SQL Server vs. MySQL: Syntax differences, similar GUIs by MiMi Yeh, Assistant Editor
only within the routine. In either case, variable assignments in MySQL stored procedures use the SET or SELECT...INTO statements. Building dynamic queries requires use of a user variable, rather than a local variable, along... More...
Aug 2, 2006