Welcome to the SSWUG.ORG White Paper Center

Understanding Business Intelligence: ETL Best Practices This paper is about building powerful data marts that require minimal administration and are simple to change. This may seem like an impossible goal t... [More] Sponsored by iQ4bis

SQL SERVER ADVANCED PROTECTION AND FAST RECOVERY WITH Auto Snapshot Manager This white paper discusses the advanced data protection and fast recovery of Microsoft SQL Server available with the Dell EqualLogic Auto Snaphot Man... [More] Sponsored by Dell EqualLogic

Deploying Microsoft SQL Server in an iSCSI SAN This Technical Report describes how to deploy SQL Server in an iSCSI SAN with PS Series storage arrays. It provides configuration and management re... [More] Sponsored by Dell EqualLogic

Microsoft SQL Server and Dell EqualLogic PS Series Solution Brief This Solutions Brief discusses storage considerations for Microsoft SQL Server and the Dell EqualLogic PS Series capability. ... [More] Sponsored by Dell EqualLogic

Microsoft SQL Server 2005 Deployment and Tests in an iSCSI SAN iSCSI SANs offer an alternative for building Storage Area Networks. Consolidating storage in a SAN offers storage management and scaling benefits for ... [More] Sponsored by Dell EqualLogic

SQL Server Data Protection with Auto Snapshot Manager This Technical Report describes using Dell EqualLogic Auto-Snapshot Manager V3.0, PS Series groups, and Microsoft SQL Server to perform online Smart ... [More] Sponsored by Dell EqualLogic

Making Databases Explorable This paper looks at common difficulties encountered when maintaining a large number of databases and how the products in the SQL Prompt Bundle can hel... [More] Sponsored by Red Gate

Transforming Enterprise Backups: How Using a Third-Party Tool Can Improve Backup Strategies The backup and restore facilities in native SQL Server are robust, and once a backup routine is established, the DBA needs to do little more than make... [More] Sponsored by Red Gate

Get in the Groove With SQL Server Consolidation Is your business a victim of SQL Server sprawl? In Quests new white paper, Get in the Groove With SQL Server Consolidation, SQL Server MVP Hilary Cott... [More] Sponsored by Quest Software

EMC Solutions for Microsoft SQL Server 2005: EMC CLARiiON CX3 Series Physical iSCSI With increasing demands and limited resources, today’s midsize enterprises face challenges similar to their larger counterparts. Learn how the Microso... [More] Sponsored by EMC

Overcoming the Barriers to Business Intelligence Success Read this EMC Perspective, Overcoming the Barriers to Business Intelligence Success, and learn how to create complete Business Intelligence solutions ... [More] Sponsored by EMC

EMC Solutions for Microsoft SQL Server 2005 EMC CLARiiON CX3 Series FCP Applied Best Practices Read the EMC CLARiiON CX3 Series FCP Applied Best Practices Guide, which describes the architecture of an EMC industry solution built and tested at th... [More] Sponsored by EMC

EMC Long Distance Recovery for SQL Server 2005 Reference Architecture Read Long Distance Recovery for SQL Server 2005 and learn about this data recovery solution which was developed in partnership with Microsoft and its ... [More] Sponsored by EMC

EMC Metropolitan Recovery for SQL Server 2005 Reference Architecture Learn about EMC's Metropolitan Recovery for SQL Server 2005 solution in this Reference Architecture guide. See how you can use an EMC CLARiiON CX-80 s... [More] Sponsored by EMC

EMC CLARiiON Data Replication Options for Microsoft SQL Server Deployments Technology Concepts and Business Considerations Read this white paper, EMC CLARiiON Data Replication Options for Microsoft SQL Server Deployments, and discover how EMC RecoverPoint and EMC CLARiiON ... [More] Sponsored by EMC

Protecting SQL Server Applications and Data Against Common SQL Failures Microsoft SQL Server has emerged as the database of choice for mission critical applications for small and mid-sized companies. SQL applications drive... [More] Sponsored by Asempra

Choosing a Remote DBA Instead of a Full-time Consultant Relational databases like SQL Server and Oracle grow 3x to 5x in size every three years and present organizations with significant challenges to manag... [More] Sponsored by Ntirety

SQL Server Virtualization Management Virtualization is becoming the popular practice in many environments, allowing organizations of all sizes to utilize resources more efficiently. SQL S... [More] Sponsored by SQL Sentry

Windows Server 2008: What To Expect When people hear that a new version of Windows Server is coming out, they often ask, "How different is it?" "Is this a quantum leap or more of a small... [More] Sponsored by Global Knowledge

Windows PowerShell: Why Developers Should Care Windows PowerShell is Microsoft's next generation scripting and shell tool. Find out more about this tool and why its important to developers.... [More] Sponsored by Global Knowledge

BitLocker: Is It Really Secure? What is BitLocker? How does it work? Is it a truly safe way to protect your data and applications, hard drive, and operation system? Find out the answ... [More] Sponsored by Global Knowledge

Bust a Move With Your SSIS - Passing Package Variables Explore the creation of sample development data using one of the most basic features in this new interface. Integration Services (SSIS) as the next g... [More] Sponsored by Global Knowledge

SQL Server 2005 - Major New Features This white paper highlights the new features of SQL Server 2005, including the user interface and the architecture changes, and compares this latest v... [More] Sponsored by Global Knowledge

7 Ways to Improve Your Database Server's Performance by 60%-80% Sql Power Tools White Paper reviews 7 steps you can take to improve your database server's performance. With production databases executing 10 to 50 m... [More] Sponsored by SQL Power

MS SQL Server - An Overview Whether you’re running a small business that’s ready to take the next step in its growth or an SMB that’s ready to “grow into” an enterprise with data... [More] Sponsored by Acronis

The Keys to Recoverability, from ESG ESG Analyst, Lauren Whitehouse, discusses Double-Take Software’s concept of “recoverability” – which involves layers of protection that not only mitig... [More] Sponsored by Double-Take Software

Protecting Microsoft SQL Server Although SQL Server offers options for database protection and recovery, none of them is intended to provide a complete disaster recovery solution. Ma... [More] Sponsored by Double-Take Software

Whole Server Protection from a Single Solution The complexity of traditional recovery solutions compounds an already difficult situation, and heightens the opportunity for human error. Speed and qu... [More] Sponsored by Double-Take Software

SQL Server Fragmentation Explained As the data in Microsoft SQL Server tables changes, their indexes change. Over time, these indexes become fragmented. This fragmentation will adversel... [More] Sponsored by Idera

Optimizing your SQL Server Infrastructure: Good Ideas, Bad Ideas In the first chapter of the eBook SQL Server Infrastructure Optimization, “Traditional Challenges and Their Impact,” the author determined that SQL Se... [More] Sponsored by Hewlett-Packard

The Shortcut Guide to SQL Server Infrastructure Optimization In The Shortcut Guide to SQL Server Infrastructure Optimization, the new eBook from Realtime Publishers, leading IT author Don Jones explores the mana... [More] Sponsored by Hewlett-Packard

SQL Server Data Recovery Made Easy with Idera SQLsafe When a database goes down due to hardware or software failure, data corruption, or any number of other causes, every minute of downtime can mean seri... [More] Sponsored by Idera

Selecting the Right Change Management Solution Frequent application updates, data migrations, service level requirements, and new compliance mandates mean your company needs a solid, reliable datab... [More] Sponsored by Embarcadero

The Database Utility for SQL Server: A Highly Available, Flexible, Simple Approach to SQL Server Consolidation The success of SQL Server in recent years has produced a phenomenon of SQL Server sprawl -- the uncoordinated deployment of tens, hundreds or even tho... [More] Sponsored by Hewlett-Packard

ESG Lab Validation Report of the HP PolyServe Database Utility for SQL Server ESG Lab, the testing facility of industry analyst firm Enterprise Strategy Group, reports its comprehensive testing of HP's solution for SQL Server co... [More] Sponsored by Hewlett-Packard

Easing the Migration to Microsoft SQL Server 2005 Many companies are eager to take advantage of Microsoft SQL Server 2005 and its notable business and technology benefits such as more efficient data m... [More] Sponsored by Hewlett-Packard

Top Ten Steps to Secure Your SQL Server In most organizations today, business critical and confidential data increasingly resides in Microsoft SQL Server databases. As a result, SQL Server ... [More] Sponsored by Idera

Structuring the Unstructured: How to Dimensionalize Semi-Structured Business Data The Business Intelligence industry is paying more and more attention to the ever-growing heap of unstructured and semi-structured business data. Howe... [More] Sponsored by DataDefractor

Are AJAX Applications Vulnerable to Hack Attacks? This paper reviews AJAX technologies with specific reference to JavaScript and briefly documents the kinds of vulnerability classes that should raise ... [More] Sponsored by Acunetix

How to Deal with managing jobs and job failures in Multiple Data Centers As a SQL Server DBA, I have often found myself stretched pretty thin trying to monitor SQL Server Agent across a plethora of systems in our develo... [More] Sponsored by SQL Sentry

Migrate, Manage, Monitor: Top 10 Tips for a Successful Move to SQL Server 2005 Effective planning and management enables a smooth migration and ensures that your new SQL Server 2005 environment will be running at optimum performa... [More] Sponsored by IDERA

7 Steps to Successful SQL Server Auditing This easy-to-read guide will explain and simplify the basic steps associated with successful SQL Server auditing & give you tips on how to reduce the ... [More] Sponsored by Idera