White Papers

Click any title below to view a white paper.

Migrating Oracle on Sun platform to Microsoft SQL Server 2012 on HP ProLiant DL980

This document is intended for IT architects, data base administrators, system administrators, and developers who want to migrate from Oracle on Sun platforms to SQL Server on standards based platforms. This paper will provide information as to how SQL Server on standards based scale up servers has been highly optimized, improving throughput, security and availability driving maximum ROI and minimum TCO. It includes comparisons on competing solutions and specific SQL Server and standards based platform features as well as capabilities that are implemented in a system-wide approach to optimize performance, improved reliability, security and costeffectiveness. This paper also provides detailed comparisons between Oracle and Microsoft SQL Server 2012 on total cost of ownership, new features in SQL Server 2012, customer migration success stories, migration path from Oracle databases to SQL Server 2012 and the challenges associated with the migration.

Continue reading this white paper

Business Intelligence: How to Unleash the Real Power of Microsoft’s Fast Track and PDW Appliances

Microsoft’s Fast Track program and PDW Appliances are a great advancement; however the fact remains that if you do not have the right BI system in place to fully optimize and unleash the power of the appliance it is just another piece of hardware. This paper will give you information, advice and insight on how to get the greatest advantage and performance from a Fast Track Appliance. The benefits are significant and if implemented correctly as part of an overall BI solution, it can give you a real competitive advantage.

Continue reading this white paper

SQL Server Consolidation Strategies on the HP ProLiant DL980

Regardless of your approach — native SQL Instance Stacking, Virtualization, or a combination thereof — the HP ProLiant DL980 Server provides a scalable database platform that is ideally suited for SQL Server consolidation. Every organization is unique, with its own challenges, and the HP DL980 is reliable, scalable, and flexible enough to fit the business needs of any organization. This paper discusses the various SQL Server consolidation approaches, their benefits, as well as recommendations to help you determine which approach or combination of approaches best suits your business needs.

Continue reading this white paper

Top Ten Data Management Trends

This paper will introduce you to the top ten data management trends Scalability Experts is seeing in the market that will be important in 2012 and beyond. If you are an IT manager or CIO, you should familiarize yourself with these technologies. In today's fast paced data-rich environment, you need to take advantage of every opportunity to gain a competitive advantage. By leveraging the latest trends, you will be able to make more insightful business decisions, reduce your IT costs and make your environment more responsive, available and scalable.

Continue reading this white paper

Database as a Cloud Service

On-demand or pay-as-you-use computing services delivered through a Cloud solution can provide significant benefits of greater scalability, manageability and lower operational costs. However, there are also risks to consider related to control, security, governance and regulatory compliance. Depending on your business, it can be a challenging decision to determine what is the best way to take advantage of this new technology. In this paper Scalability Experts will discuss the value of a database in a Cloud environment and some of the pros and cons of the Cloud related to data management.

Continue reading this white paper

Enterprise Performance Tuning: Best Practices with SQL Server 2008 Analysis Services

The release of SQL Server 2008 has inspired the compilation of some Best Practices guides for the deployment of SQL Server 2008 Analysis Services. Analysis Services provides many architectural enhancements that provide better Cube processing and query performance when compared to SQL Server 2005 Analysis Services. This whitepaper focuses on tips and best practices that help when deploying a large data warehouse.

Continue reading this white paper

Understanding and Using PowerShell Support in SQL Server 2008

In this paper we’ll walk through an introduction to Windows PowerShell and its key elements. We’ll then look at the special PowerShell executable program provided with SQL Server 2008, sqlps.exe. Sqlps.exe incorporated a set of cmdlets specific to using PowerShell with SQL Server, and adds a PowerShell drive (PSDrive) allowing us to navigate SQL Server as though it were a filesystem. We’ll explore these features, then look at some scripts we can use to administer SQL Server as well as to extract data as needed.

Continue reading this white paper