Configuring Oracle as a Data Source for SQL Server2/08 Discover what happens
within SQL Server during and after configuring Oracle as a data source. Quite a
few objects are created, including a system-level database, numerous jobs
running under the SQL Server agent, and flat files created on the file system.
Read on to learn more.
Tips for Simplifying Crosstab Query Statements2/05 Rob Gravelle takes a
complex SQL statement and shows you several ways to re-write it that both
simplifies and shortens it, while still yielding the same results.
When Tuning Oracle is not an Option2/04 Before you start monitoring your Oracle database, make sure you understand some of the
behind-the-scenes issues of using Oracle monitoring.
Sybase to merge with Aleri
With the complete deal to be announced February 8th, Sybase and Aleri go forward with merger.
Big Data Summit 2010 San Francisco; Registration is FREE
Learn about the convergence of traditional data warehousing, in-database analytics and transformations, cloud computing, and new parallel-processing approaches like MapReduce and Hadoop.
Right Tool for the Job
As a Data Analyst, you need to be able to retrieve data in order to analyze it. If your SQL skills are lacking this might be a difficult task, as well as the code you might write might be very inefficient. Quest software has a tool that will help you write efficient SQL code.
Securing Patient Data
What are you doing to make your electronic medical records more security? Maybe you should consider best practices and an access management system to make sure you are adequately protecting your patient data.
Achieve High-Availability with SQL Server 2008
Keeping your database up and running is the lifeblood of every organization. Find out which features in SQL Server 2008 can be used to meet your high-availability requirements.
Building an affordable, and scalable Oracle Data Warehouse
Developing a vision for how to scale your Oracle data warehouse is important. Leveraging your IT dollars today by deploying an environment that can be scaled to meet your future requirements is smart planning.
Improving your ETL load Time
Is your batch window for loading your data warehouse shrinking or are your load processes running longer than planned? If so, then possibly there are other third party tools that can help you optimize your company's resource-intensive and time-consuming ETL processing.
Storage Choices for Your Virtual Server Environment
Picking a storage solution for your virtual environment can make or break your virtualization effort. Make sure you review all the storage options, prior to selecting the storage architecture for your virtual server environment.
PHP & JavaScript Using JSON By Jason Gilmore
Published February 4, 2010
Build powerful AJAX-driven Web applications by passing databetween the client and server using PHP, JavaScript and the JSON data format.
Master & Detail Lists in SharePoint 2010 By Joe Mack
Published January 19, 2010
Learn how to make a solid user interface using the master and detail lists in Microsoft Sharepoint 2010.
Implementing SOA using WCF By Joydip Kanjilal
Published January 7, 2010
Learn how to implement Service Oriented Architecture in your WCF (Windows Communication Foundation) Applications.
App Logging with MS Ent. Library By Dan Rigsby
Published December 22, 2009
A look at application logging and tracing, why it's important,and how to accomplish it with Enterprise Library Logging.