- Data Warehouse Consulting Services
- Database Availability Solutions
- Database Backup and Recovery Strategies
- Database Clustering and Mirroring
- Database Deployment and Upgrade Projects
- Database Performance Tuning and Monitoring Tools
- Relational Database Management Systems
- Data Mining, Analytics and Business Intelligence Consulting
-
Business intelligence as a managed service
Business intelligence (BI) managed services providers must be prepared to scale services to meet end customer needs and make BI offerings portable.Tip
-
Database reliabilty during the holiday season
Retail systems performance during the holiday season can make or break the relationship VARs have with their retail customers. As the peak season approaches, there are certain aspects of the system that should be fine tuned. Once the season hits VARs should leave them alone.Ask the Expert
-
Oracle database management client concerns
Oracle database management poses many challenges for end users attempting to assess performance problems, decipher error messages and determine solutions. Get a heads-up on some of the questions asked of sister site SearchOracle.com's experts, so you're ready to respond to your customer's next Oracle dilemma.Interview | 17 Jan 2007
-
Plan your remote DBA services
Start organizing a customer's sprawling database environment by providing remote DBA services.Tip
-
Becoming a remote DBA services provider
Now is the time to take advantage of a growing trend: database administration outsourcing. Learn how you can begin offering remote DBA services to help customers with database monitoring, security and more.Tip
-
Data integration is a process
Data quality issues are difficult to address -- so many companies don't bother. Find out how you can help address data quality and integration concerns.Executive Briefing
-
Supporting real-time BI with real-time ETL
Companies are looking to invest in real-time ETL for several reasons. Find out what they are in this Q&A before pitching real-time ETL to a customer.Executive Briefing
-
Enterprise Information Integration's pros and cons
Understand the differences between Enterprise Information Integration and a data warehouse before tackling an EII project.Executive Briefing
-
FAQ: How to offer high-availability solutions with SQL Server 2008
Expert Ross Mistry discusses the different ways that SQL Server 2008 can provide high-availability solutions in this FAQ podcast.Podcast
-
High-availability options in SQL Server 2008
SQL Server 2008's high-availability options can address all of your customers' high-availability needs. Learn about using failover clustering, database mirroring, log shipping and replication to keep a database accessible to users.Tip
-
Three low-cost approaches to high-availability databases
High-availability databases can be an expensive proposition. But if your customers don't have the budget for a high-end system, there are cheaper options. Here we examine the pros and cons of log shipping, replication and database mirroring.Tip
-
What are the best SMB databases?
Discover the best basic SMB database -- and learn when it's time for your SMB clients to upgrade.Ask the Expert
-
How can I help clients meet service-level requirements?
Learn how to help your clients meet their service-level requirements in the face of a difficult budgetary situation.Ask the Expert
-
What skill sets do I need to support a fault-tolerant, high-availability system?
Learn about the skill sets your staff needs to be able to install and maintain your client's high-availability systems.Ask the Expert
-
Oracle, system integrator develop new HR product
Oracle and system integrator BearingPoint's jointly-developed application shows how vendors and SIs build new applications. The product, which aims to streamline the new-hire process, is built with Oracle's Fusion middleware SOA.Article | 26 Jun 2007
-
Providing database services: The initial client meeting
Remote database services provider Hilary Cotter outlines his own best practices for establishing successful client relationships -- which he says begins with the first client meeting.Tip
-
Database mirroring best practices for VARs
Database mirroring with Microsoft SQL Server can allow VARs to build a fail safe into customers infrastructure in order to keep data highly available at all times.Ask the Expert
-
Controlling Microsoft SQL Server sprawl
Consolidating Microsoft SQL Server will result in better management and availability of the database for your customers.Ask the Expert
- VIEW MORE ON : Database Availability Solutions
-
What data storage solutions can help with increases in data-transfer volumes and bottlenecks?
It's important to implement data storage solutions for transfer volumes and bottlenecks as data continues to increase. Our virtualization expert Harley Stagner offers advice.Ask the Expert
-
Oracle DBA trends: Beyond basics
Oracle DBA trends point towards a focus on specialty areas like compliance, applications and business intelligence. This tip excerpted from our sister site SearchOracle.com, outlines current trends and offers advice to current DBA.s and those who are interested in becoming a DBA.Tip
-
Database clustering secures data
Database clustering is a good tool for you to use to keep a client's data safe and available constantly.Ask the Expert
-
Database mirroring best practices for VARs
Database mirroring with Microsoft SQL Server can allow VARs to build a fail safe into customers infrastructure in order to keep data highly available at all times.Ask the Expert
-
SQL Server 2005 Practical Troubleshooting: Data recovery
SQL Server's 2005 data recovery troubleshooting tactics will help protect valuable data for your customers. Get the tools in this excerpt from "SQL Server 2005 Practical Troublshooing."Book Excerpt
-
SQL Server 2005 Practical Troubleshooting: Data recovery best practices
Learn SQL Server 2005's data recovery best practices and problem avoidance strategies, as illustrated in this excerpt from "SQL Server 2005 Practical Troubleshooting" through case studies.Book Excerpt
-
SQL Server 2005 Practical Troubleshooting: Product enhancements
Discover SQL Server 2005's product enhancements ranging from BACKUP/RESTORE and DBCC CHECKDB to emergency mode repair in this book excerpt.Book Excerpt
-
SQL Server 2005 Practical Troubleshooting: Fundamentals
Build up your SQL Server 2005 fundamental data recovery knowledge-base and leverage that knowledge to protect your customer's data in this excerpt from SQL "Server 2005 Practical Troubleshooting."Book Excerpt
-
SQL Server 2005 practical troubleshooting: Introduction
Learn about SQL Server 2005's primary data recovery mechanism and protect your customers' most important asset -- their data. This excerpt from "SQL Server 2005 Practical Troubleshooting" gives you the tools.Book Excerpt
-
SQL Server 2005 Practical Troubleshooting: User database inaccessible
Learn SQL Server 2005 tools that allow access to an inaccessible database. This excerpt from "SQL Server 2005" provides the toolbox.Book Excerpt
- VIEW MORE ON : Database Backup and Recovery Strategies
-
FAQ: SQL Server 2008 high-availability services
Microsoft MVP Ross Mistry answers frequently asked questions about using SQL Server 2008 to offer high-availability services to customers.Project FAQs
-
Oracle RAC troubleshooting advice and application migration tips
Your customers running Oracle databases can simplify the path to database consolidation using Oracle Real Application Clusters, or RAC. Learn best practices for migrating applications to Oracle RAC and get a head start on troubleshooting problems.Tip
-
What skill sets do I need to support a fault-tolerant, high-availability system?
Learn about the skill sets your staff needs to be able to install and maintain your client's high-availability systems.Ask the Expert
-
Oracle RAC: ON and OFF
Disabling Oracle's RAC options may be necessary when testing the Oracle Database 10g. Steps are outlined in this excerpt from "Oracle Database 10g: Real Application Clusters Handbook."Chapter Excerpt
-
Oracle RAC: Debugging CRS and GSD using DTRACING
Oracle RAC tracing facility can be enabled to provide additional screen output in Oracle 10g. The steps are outlined in this excerpt from "Oracle Database 10g: Real Application Clusters Handbook."Chapter Excerpt
-
Oracle RAC and the Lamport algorithm
In Oracle's RAC, the Lamport algorithm works with system change numbers (SCN) and the distributed lock manager (DLM) to control and lock management and conflict resolution; read more in this excerpt from "Oracle Database 10g: Real Application Clusters Handbook."Chapter Excerpt
-
Oracle RAC: Log directory structure in Oracle RDBMS
Oracle 10g RAC installations include log files that provide diagnostic and bug-repairing tools. Learn more in this excerpt from "Oracle Database 10g: Real Application Clusters Handbook."Chapter Excerpt
-
Oracle RAC: Log directory structure in cluster ready services
When diagnosing Oracle 10g problems in cluster ready services do what Oracle support does -- examine installation log files and respective directories. Learn more in this book excerpt from "Oracle Database 10g: Real Application Clusters Handbook."Chapter Excerpt
-
Oracle RAC: Member voting
Use Oracle RAC's member voting to check member validity in Oracle database 10g. Learn how in this excerpt from "Oracle Database 10g: Real Application Clusters Handbook."Chapter Excerpt
-
Oracle RAC: Debugging node eviction issues
Oracle RAC's node eviction root cause analysis (RCA) is common and complex. This excerpt from "Oracle Database 10g: Real Applications Clusters Handbook" shows you how to recover from a communication failure in Oracle 10g.Chapter Excerpt
- VIEW MORE ON : Database Clustering and Mirroring
-
The changing database consolidation landscape
Changes to Windows, SQL Server and processor design are combining to make virtualization a more attractive goal for database consolidation. Find out what the options are for database consolidation and how to put virtualization to good use.Tip
-
Maintaining performance after a database consolidation
Database consolidation can solve a number of nagging problems for customers, but if the new system doesn't put a priority on uptime, you could end up with performance issues. Learn how to avoid them with a tiered structure and clustering and load-balancing techniques.Feature
-
Refining plans for database consolidation
Database consolidation can bring a number of benefits to your clients, such as lower licensing costs, easier maintenance and a reduced risk of server failure. But there are times when it makes more sense not to consolidate a server. This installment of our Database Consolidation Services Hot Spot Tutorial lays out the process for helping your customers choose which servers should be consolidated, and which should be left alone.Feature
-
Cleaning up with database consolidation services
Learn how database consolidation can benefit your customers, how server sprawl happens and how to identify potential candidates for database consolidation.Feature
-
Oracle Database 11g innovations: Get ahead of the game
Oracle Database 11g offers a slew of new innovations, but typically organizations avoid post-pone first-release bugs by delaying deployment until the second release. Learn more about why in this excerpt from our sister site SearchOracle.com.Tip
-
Remote DBA services: Overcoming sales hurdles
Winning remote DBA service contracts are largely based on resellers' abilities to resolve problems quickly. Resellers need to have a strong, experienced staff and understand the limitations of offering DBA services while still meeting customer needs to establish a reputation for reliability.Tip
-
Computer information systems for small and midsized businesses (SMBs)
Computer information systems opportunities for value-added resellers and systems integrators can be found in this chapter from our Small and Midsized Business Technology Project Guide.All-in-One Guide
-
DBA services can make VARs money
Create contractual, reoccurring revenue streams with DBA services, based on everything from hosting an RDBMS to acting as a virtual DBA.Ask the Expert
-
Web-based database support
Finding the right Web-based application for the job can make database support easier for VARs.Ask the Expert
-
Architectural solutions to Web-based applications with large datasets for VARs
Rather than throwing hardware to configure a database to support web-based applications with large dynamic datasets, VARs can use architectural solutions to solve problems.Ask the Expert
- VIEW MORE ON : Database Deployment and Upgrade Projects
-
Active Directory management services: cleanup and optimization
If you think there’s no demand for Active Directory management services, think again. Active Directory cleanup and optimization services can be valuable to your customers.Tip
-
Channel Explained: Federated databases
Learn about heterogeneous and homogeneous federated databases and the pros and cons of each.Video
-
Oracle Partner Program Checklist
Peruse the benefits database management vendor Oracle offers its reseller partners in this standardized partner program checklist.Partner Program Checklist
-
BMC Software Partner Program Checklist
Partner Program Checklist
-
Maintaining performance after a database consolidation
Database consolidation can solve a number of nagging problems for customers, but if the new system doesn't put a priority on uptime, you could end up with performance issues. Learn how to avoid them with a tiered structure and clustering and load-balancing techniques.Feature
-
Refining plans for database consolidation
Database consolidation can bring a number of benefits to your clients, such as lower licensing costs, easier maintenance and a reduced risk of server failure. But there are times when it makes more sense not to consolidate a server. This installment of our Database Consolidation Services Hot Spot Tutorial lays out the process for helping your customers choose which servers should be consolidated, and which should be left alone.Feature
-
Cleaning up with database consolidation services
Learn how database consolidation can benefit your customers, how server sprawl happens and how to identify potential candidates for database consolidation.Feature
-
How to diagnose and troubleshoot database performance problems
Database performance problems can wreak havoc with Web site performance and cost your customers lots of money. Diagnosing problems is much easier when you rely on this systematic approach.Tip
-
RDBMS performance monitoring tools
Offer RDBMS performance monitoring services to your clients; catch performance problems early and become a trusted advisor.Tip
-
Remote DBA services: Overcoming sales hurdles
Winning remote DBA service contracts are largely based on resellers' abilities to resolve problems quickly. Resellers need to have a strong, experienced staff and understand the limitations of offering DBA services while still meeting customer needs to establish a reputation for reliability.Tip
- VIEW MORE ON : Database Performance Tuning and Monitoring Tools
-
Quick steps for implementing Master Data Services
VARs can follow a few basic steps to implement Master Data Services for their customers. Learn the different ways to migrate customer data into the model.Tip
-
Grow your margins with SQL Server Master Data Services
Implementing SQL Server Master Data Services is only one of the many opportunities, such as managing master data and setting up alerts, that VARs have available to increase their margins using this tool.Tip
-
How the SQL Server Utility can make solutions providers money
For customers hesitant to upgrade to SQL Server 2008 R2, the SQL Server Utility may be the remedy. Learn how to use the tool and explain to your customers how it can save them on management costs.Tip
-
SQL Server 2008 R2 Master Data Services implementation
Solution providers can create business revenue by convincing customers plagued by inconsistent data to use SQL Server 2008 R2 Master Data Services.Tip
-
SQL Server 2008 R2 editions, requirements: Top 10 resources
SQL Server 2008 R2 editions offer different things to specific types of customers, learn about them and about the SQL Server 2008 R2 requirements.Top 10
-
Parallel processing: Using parallel SQL effectively
Using parallel processing only makes sense for your customers in specific situations. Find out when to use parallel SQL with the Oracle databse to avoid excessive usage.Chapter Excerpt
-
Using parallel SQL to improve Oracle database performance
Enhance your customers' Oracle database performance by learning how to use parallel SQL to enable a SQL statement to be processed by multiple threads or processes at once.Chapter Excerpt
-
Parallel execution: Determining SQL suitability, benefits
When deciding whether SQL is suitable for parallel execution, consider the factors listed in this chapter excerpt, such as the execution time needed for SQL statements.Chapter Excerpt
-
High-availability solutions for SQL Server 2008 R2
Find out how to implement SQL Server 2008 R2 high-availability solutions, including failover clustering, database mirroring and log shipping, and learn how they affect a database.Tip
-
FAQ: Using Resource Governor in SQL Server 2008 R2 to allocate resources
Ensure your customer's SQL Server 2008 R2 environment has the proper resources by determining workload group requirements with Resource Governor and classifying server requests.Project FAQs
- VIEW MORE ON : Relational Database Management Systems
-
Using SQL Azure Reporting Services to offer data analysis services
By adding Azure Reporting Services to your line card, you can provide customers with easy data analysis services. SQL Azure Reporting information can benefit your company, too.Tip
-
Business intelligence software immune to recession
A survey by Forrester Research reveals that companies have no intention of slowing down adoption of business intelligence software.Article | 21 Aug 2009
-
How to work with business intelligence vendors
Working with business intelligence vendors presents a different set of issues than working with many other types of technology vendors. Find out about the differences and learn how a vendor-neutral approach compares with a vendor-specific approach.Feature
-
Introduction to business intelligence tools and reporting
As businesses grow and accumulate more data, the role of business intelligence reporting grows and becomes more complicated. Learn about the business intelligence tools and approaches VARs use to grow their businesses and stay ahead of the competition.Feature
-
Bridging the IT/business gap in business intelligence projects
When deploying a business intelligence project for your customers, there is often a gap between the IT department and the business department. Learn how to bridge that gap by getting the right people involved in the project and following established best practices.Tip
-
Business intelligence consulting: Problems and solutions
The basic problem for those involved in business intelligence consulting is the need for an integrated system to manage project components such as project management, collaboration and SDLC tools. Without a technological solution to the problem, BI consultants need to incorporate best practices to get projects successfully off the ground.Tip
-
Data Synchronization
This section of the chapter excerpt tackles synchronizing data in the data hub.Chapter Excerpt
-
Overview of Business Rules Engines
This section of the chapter excerpt provides an overview of business rules engines.Chapter Excerpt
-
Managing Data in the Data Hub
This section of the chapter excerpt deals with acquiring, rationalizing, cleansing, transforming, and loading data into the Data Hub.Chapter Excerpt
-
Data Quality
This section of the chapter excerpt explores data quality, one of the key components of data strategy and governance and one of the core requirements for Master Data Management.Chapter Excerpt
- VIEW MORE ON : Data Mining, Analytics and Business Intelligence Consulting
Vendor Management Strategies for the CIO