Whitepapers You Have Activated
No Whitepapers found.

Other Available Whitepapers
White PaperDate
How to Meet Best Practices for Protecting Information in AWS

Protecting your information when using cloud-based services can be very challenging. The need to encrypt and protect information includes many variables and considerations. When you add compliance, best practices and various regulations into the mix, the overall goals and requirements are substantial. This whitepaper explores the practical needs, the items that require evaluation and different approaches to best practices to make sure your information is secure.

SQL Server Query Tuning: A 12-Step Program

In this white paper, Thomas LaRock, Technical Evangelist and SQL Server MVP, demystifies query tuning by providing a rigorous 12-step process that database professionals at any level can use to systematically assess and adjust query performance, starting from the basics and moving to more advanced query tuning techniques like indexing. When you apply this process from start to finish, you will improve query performance in a measurable way, and you will know that you have optimized the query as much as is possible.

Why Your Data Sucks-The Surprisingly Short Half-Life of Data

Your data is radioactive – just as a chunk of plutonium will break down in measured time (its half-life) – so does your data. We developed a formula to determine the actual half-life of data and analyzed thousands of customers’ databases. The results are eye-opening.

Also, if you deal with contact data in a SQL Server environment, this new magazine is a must-read. We’ll also highlight the pros and cons of various procedures to call data quality operations using SQL Server. In this issue:
  • Review our half-life findings and learn how to fight “truth decay”
  • Discover free data quality tools to drive better insight into your data
  • How AirNet improved data ROI using a SQL Server solution

Six Steps to Managing Data Quality with SQL Server Integration Services

Overcoming the challenges of data quality doesn’t have to be costly or difficult to do. Organizations can take advantage of the integration capabilities inherent in Microsoft’s SQL Server Integration Services (SSIS) to implement a Total Data Quality strategy needed for successful MDM, data warehousing and data quality projects. This white paper describes a six-step plan to managing data quality using SSIS. In this new white paper learn:
  • How to deliver clean, consistent data that can be distributed and confidently used across the enterprise, regardless of business application and system.
  • How to resolve incomplete or missing customer profile information, such as blank phone numbers or addresses.

Managing Third Party Databases and Building Your Data Warehouse

Companies are continually faced with managing a growing and sometimes disparate suite of third party applications and tools and the underlying databases that support them. Good data is especially important if you’ve been tasked with building out and maintaining your organization’s data warehouse. This white paper addresses how to handle challenges in building a data warehouse from third party application databases.

SQL Server In Simple Words

DBAs face many challenges working with SQL Server. A lot of time is spent managing and troubleshooting this tool and there is not enough time to appreciate or explore what the tool has to offer. In this whitepaper, Pinal Dave shares some of his tips and techniques that utilize some of the capabilities available with SQL Server Management Studio (SSMS) that can help you enhance your productivity.

About Pinal Dave
Pinal Dave is a Developer Evangelist. He has authored 11 SQL Server database books, 14 Pluralsight courses and has written over 2900 articles on the database technology on his blog at Along with 10+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ.

Azure Encryption

As soon as you have data stored for later reference, you are faced with the challenge of protecting that data. This essentially includes every piece of information - certainly those that are personally identifiable or relate to activities that require compliance and protection of information. That’s quite a wide array of information, and it’s important to make sure you’re doing the important work of protecting information in a way that works both with your applications and with the regulations, agencies and compliance requirements that impact you.

SQL KeyManagement

ORGANIZATIONS CONTINUE TO EXPERIENCE DAMAGING LOSSES DUE to data breaches. These losses include legal costs, costs to reimburse customers and employees, lost stakeholder value, and reduction of goodwill. The estimate of these financial losses range into the billions of dollars every year. This paper discusses compliance regulations, standards for protecting data with encryption, and how Microsoft provides for the encryption of sensitive data in its flagship SQL Server database system. Townsend Security’s Alliance Key Manager provides a cost effective, easy-to-deploy, and compliant solution for Microsoft customers whether their data is in the Cloud, VMware, or a traditional IT data center.

Industry Must Haves Key Management

DATA SECURITY HAS COME A LONG WAY within just the past few years. Organizations no longer have to continue to maintain current patchwork methods because there are no available, cost-effective, or interoperable solutions that easily solve their problems. Encryption and encryption key management are now industry standards and work across both legacy and newer business systems, multi-platform and multi-tenant networks, remote access workstations, geographical offices, data centers, and thirdparty business partners.