Top 10 Tips for Optimizing SQL Server Performance
SQL Server performance management requires serious time and energy. In this new white paper by Kevin Kline, discover detailed guidance on the issues you can relate to—from cache trashing to bad T-SQL that can return to haunt your applications. See how to maximize database scalability and efficiency with ease. Read the white paper today.
|
2/2/2012
|
THE SQL SERVER SECURITY THREAT — IT’S CLOSER THAN YOU THINK
Written by: Kevin Beaver
Kevin Beaver, CISSP, is an independent information security consultant, author, expert witness and professional speaker with Atlanta, GA-based Principle Logic, LLC. He has over two decades of experience in IT and specializes in performing information security assessments revolving around compliance and minimizing business risks.
As we’ve see over the past decade, database-related security breaches can’t be taken lightly. One of the greatest threats to databases is insiders with ill intent. This whitepaper discusses the information security and compliance issues associated with Microsoft SQL Server database systems. Whether you’re a CSO, IT manager, internal auditor, or database administrator, read on. You’ll learn about the database security threat, how compliance fits into the overall picture, and what you need to be doing to minimize your business risks.
|
2/1/2012
|
Encryption & Key Management for Microsoft SQL Server 2008
Written by Townsend Security
Simplify encryption and key management on your SQL Server. Data thieves are targeting SMB companies because of their inadequate security practices. The estimate of these financial losses range into the billions of dollars every year. The most critical barrier SMB companies face is access to compliance solutions that are affordable. 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. It also introduces Townsend Security’s Alliance Key Manager HSM which provides a cost effective, easy-to-deploy, and compliant solution for Microsoft customers.
|
2/1/2012
|
Optimize SharePoint Storage with BLOB Externalization
Written by AvePoint
This document is intended to provide a comprehensive and balanced examination of SharePoint storage concepts and issues, and to equip you to fully understand, communicate and make informed decisions about the role of BLOB externalization in your storage architecture.
|
2/1/2012
|
All-At-Once Operations
Written by Itzik Ben-Gan with SolidQ
SQL supports a concept called all-at-once operations, which means that all expressions that appear in the same logical query processing phase are evaluated as if at the same point in time.
|
10/19/2011
|
