SQL Research
-
Implementing Database Security and Auditing: Using Granular Access Control
Sponsored by: Guardium, an IBM CompanyIn this white paper you’ll see that granular access control can only be achieved through aligning the application user model with the database security system.
-
RedBook: Oracle to DB2 Conversion Guide - Compatibility Made Easy
Sponsored by: IBMNew IBM DB2 features make compatibility easy. In this guide, you’ll learn about native support for PL/SQL, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQL*Plus, data movement tools, best practices and more—all designed to improve your ability to run applications on both DB2 and Oracle platforms
-
SQL Compatibility in DB2 9.7-- From triggers to object enhancements: A demonstration of the new PL/SQL compatibility features
Sponsored by: IBMThis article overviews the new PL/SQL compatibility features in IBM DB2 software version 9.7, making it easier to adopt and allowing you to take advantage of its autonomic and high-performance characteristics.
-
Demo: Protecting Microsoft SQL Server 2008 Using FalconStor CDP
Sponsored by: FalconStor SoftwareWatch this video demonstration to see exactly how FalconStor Continuous Data Protector is used to protect and recover your Microsoft SQL Server data.
-
Microsoft SQL Server in a VMware Environment on Dell PowerEdge R810 Servers and Dell EqualLogic Storage
Sponsored by: Dell and Microsoft SQLRead this paper for a description of the benefits and performance of the latest Dell™ PowerEdge™ R810 running Microsoft® SQL Server® in VMware® vSphere™ 4.0 Update 1 (U1) and EqualLogic™ PS6000XV iSCSI storage arrays.
-
What You Need to Know About SQL Server 2008 Community Technology Preview 5
Sponsored by: Dell and Microsoft SQLRead this paper for a discussion of the Community Technology Preview (CTP) process, and the CTP5 incarnation specifically. This paper examines mission-critical features, enterprise management features, database data and programmability, and new business intelligence features.
-
Guide to Consolidating SQL Server 2000 and SQL Server 2005 Databases to SQL Server 2008
Sponsored by: Dell and Microsoft SQLRead this paper for an informative guide to helping you consolidate your Microsoft® SQL Server® 2000 and SQL Server 2005 databases from multiple machines onto a single SQL Server 2008 server system.
-
Virtualize Microsoft SQL Server For Improved Performance With PowerEdge 11th Generation
Sponsored by: Dell and Microsoft SQLThis white paper describes the benefits and performance of the latest Dell PowerEdge R810 running Microsoft SQL Server in VMware vSphere 4.0 Update 1 (U1) and EqualLogic PS6000XV iSCSI storage arrays.
-
SQL Server 2008 R2: Licensing Quick Reference Guide
Sponsored by: Dell and Microsoft SQLThis Quick Reference Guide is for people who need to understand the basics of how Microsoft SQL Server 2008 R2 is licensed and sold. This guide does not supersede or replace any of the legal documentation covering SQL Server use rights.
-
How the Right Infrastructure Delivers Real SQL Database Virtualization Benefits
Sponsored by: Dell, Microsoft and AMDConsolidating and/or virtualizing SQL Server databases can improve data center efficiency and enable you to tackle database sprawl, achieve high availability, and boost agility. Beginning with the value 4 processor (4P) capabilities of the AMD Opteron™ 6000 Series platform, the AMD/Dell/Microsoft combination can help produce substantial savings.
-
Postgres Plus® Technical Evaluation Guide
Sponsored by: EnterpriseDB CorporationThis guide outlines the common steps that people go through when they are interested in evaluating an open source database (e.g. one or both of the Postgres Plus products). This guide will also provide links to other documents/collateral that will help you accomplish each step. Read on to learn about these common steps in evaluation in more detail.
-
Heterogeneous Data Replication: Cost-Effective Information Leverage
Sponsored by: Sybase, an SAP companyData is the lifeblood of organizations but few organizations take an asset-based, comprehensive approach to it. It drives too much cost because of redundant proliferation, poor synchronization across applications and lack of comprehensive availability policies. Read this paper to learn how effective data integration strategies can help.
-
IBM DB2 E-Kit for Database Professionals
Sponsored by: IBMIf you're a DBA or database developer working with Oracle or another relational database management system, learn how easy it is to get trained and certified for IBM DB2 for Linux, UNIX, and Windows. Expand your skills portfolio, or extend your DBMS vendor support to include DB2. Download this e-kit and learn more!
-
Ultimate SQL Tune-Off
Sponsored by: Embarcadero Technologies, Inc.According to Jonathan Lewis, there is a basic strategy to writing efficient SQL, but it requires knowledge of the data, the metadata, and the intent of the query. Kyle Hailey, though, will discuss his own approach to Visual SQL Tuning (VST) with some ringside support from DB Optimizer XE. Be sure to check out this exciting debate!
-
Technology Audit: Imperva SecureSphere Data Security Suite
Sponsored by: ImpervaAny organization delivering services or products via the Web should consider SecureSphere as a “must-have” piece of its IT protection infrastructure. The product set makes a strong case for itself as a leading contender in this market space. Read this paper to read more.
-
Presentation Transcript: Developing a Business Intelligence Strategy, From the Ground Up
Sponsored by: Tableau SoftwareConfused about BI? This presentation transcript breaks down the basics of business intelligence and outlines the key features for Microsoft SQL Server. Discover the advantages of BI and find out how to get started with a business intelligence strategy to enhance your organization.
-
Data Loss Prevention for IBM i
Sponsored by: Innovatum, Inc.Open system technology has introduced real threats to data; making loss—whether from theft, malicious manipulation or inadvertent misuse—easier than before. The IBM i has exceptional audit capabilities making it one of the most secure technology platforms. Read this white paper to learn how the IBM i might be a good solution for your organization.
-
SQL Server Insider E-Zine - Volume 1: Is Self-service BI the Answer?
Sponsored by: Dell, Inc. and Intel®Business intelligence is a hot topic in 2010, especially with the upcoming release of Microsoft's SQL Server 2008 R2 being dubbed as the "BI release." In this e-zine, one SQL Server expert breaks down exactly what goes into self-service BI, where it works and where it falls short.
-
Constellation Energy Leverages DocAve® to Migrate Business-Critical SharePoint® Data
Sponsored by: AvePoint, Inc.Constellation Energy is the largest wholesale power seller in the United States. When they needed a granular, full fidelity data migration from WSSv2 to WSSv3 platforms, they turned to DocAve SharePoint Migrator. Read this case study to learn how AvePoint's migration solution helped them to achieve their migration goals.
-
Reduce CPU Usage with 'SMART' SQL
Sponsored by: BMC Software, Inc.This paper discusses how and why to design SQL that will reduce the number of times calls are made to DB2. We'll look at how to write SMART applications rather than writing applications that act like generic I/O modules to DB2, properly tune SMART SQL, and how to exploit SQL and application features in DB2 on z/OS version 8 and 9.
-
Presentation Transcript: Data Warehousing Basics for SQL Server Analysis Services
Sponsored by: Flowerfire, Inc.In this transcript of the "Data Warehousing Basics for SQL Server Analysis Services" webcast, learn how to build your data warehouse for your SQL Server environment. Discover the necessary steps involved and learn about major concepts, including relational data warehousing and supported SQL Server Analysis Services (SSAS) storage formats.
-
Techfocus SQL Server 2008 Migration: Evaluate the Value of a SQL Server Upgrade
Sponsored by: SHI International CorporationSQL Server 2008 has many compelling features, but not all of them are necessary. See what's a good fit for your enterprise and what can wait.
-
Anatomy of a Database Attack
Sponsored by: ImpervaCorporate databases are in constant danger. Outside criminals can exploit web applications and employees with malicious intent present an even greater threat. This webcast traces the steps involved in breaking into a database and presents a reference architecture and checklist for implementing iron-clad database security measures.
-
Adobe ColdFusion 9
Sponsored by: AdobeAdobe ColdFusion 9 software enables developers to rapidly build robust Internet applications by condensing complex business logic into fewer lines of code.
-
Hitachi NAS Platform 3080 and 3090: Storage Consolidation and Intelligent Tiering for Microsoft® SharePoint® Server Environments
Sponsored by: Hitachi VantaraMicrosoft SharePoint Server is a powerful platform for collaboration and content management built upon the firm foundation of Microsoft SQL Server® technology. It provides simplified storage provisioning and management for SharePoint with performance and scalability that supports enterprise-wide content consolidation.
