Browse by Tags

• Analysis Services
• ASLB
• Availability
• backup
• Backup Compression
• Data Compression
• Database
• Disaster Recovery
• Encryption
• I/O
• Log
• OLAP
• Performance
• Scalability
• SQL Server
• TDE
• Transaction Log
• Transparent Data Encryption

• Microsoft SQL Server 2008 Analysis Services Consolidation Best Practices

  Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson, Steve Pontello, Thomas Kejser This technical... Posted Feb 08 2010, 08:21 PM by CarlRabeler with | with 11 comment(s) Filed under: Analysis Services, Availability, Performance, Scalability, OLAP, SQL Server, Configuration, Disaster Recovery, ASLB

• Tuning Backup Compression Part 2

  Authors : Sanjay Mishra, Mike Ruthruff Technical Reviewers : Steve Schmidt, Mike Purtell, Mark Souza, Juergen Thomas, Peter Scharlock, Burzin Patel, Prem... Posted Feb 16 2009, 01:24 PM by SanjayMishra with | with 4 comment(s) Filed under: Database, Performance, I/O, SQL Server, Configuration, backup, Backup Compression, Log, Transaction Log, Transparent Data Encryption, Encryption, Data Compression, TDE

• SQL Server Service Broker: Maintaining Identity Uniqueness Across Database Copies

  Author: Michael Thomassy Technical Reviewers: Sanjay Mishra, Burzin Patel, Stuart Ozer A Deployment Method: Copying Databases When dealing with many large... Posted Aug 12 2008, 10:53 PM by MichaelThomassy with | with 2 comment(s) Filed under: Database, SQL Server, Configuration

• How many files should a database have? - Part 1: OLAP workloads

  The question in the title of this blog comes up a lot. This Tech Note described tradeoffs for file allocation in OLAP systems... Posted Mar 07 2008, 11:28 AM by tkejser with | with 9 comment(s) Filed under: I/O, OLAP, SQL Server, Configuration