Browse by Tags

• Analysis Services
• Array-Based Snapshot
• ASLB
• Availability
• backup
• Backup Compression
• Configuration
• Data Compression
• Database
• Disaster Recovery
• Encryption
• I/O
• Log
• OLAP
• Performance
• Replication
• Scalability
• TDE
• Transaction Log
• Transactional Replication
• Transparent Data Encryption
• Upgrade

• Top 10 Hidden Gems in SQL 2008 R2

  With all the new features in SQL 2008 R2, here are the major ones getting all the press: PowerPivot Parallel Data Warehouse Application and Multi-Server... Posted May 07 2010, 03:50 PM by KevinCox with | with 3 comment(s) Filed under: Upgrade, SQL Server

• 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

• Initializing a Transactional Replication Subscriber from an Array-Based Snapshot

  Author: Benjamin Wright-Jones Contributors: Ken England, Prem Mehra, Mike Ruthruff, Greg Yvkoff, Qun Guo and Gopal Ashok Technical Reviewers: Joseph Sack... Posted May 04 2009, 04:46 PM by premmehra with | with 5 comment(s) Filed under: Scalability, SQL Server, Transaction Log, Array-Based Snapshot, Replication, Transactional Replication

• 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

• The Many Benefits of Money…Data Type!

  Authors: Denny Lee, Thomas Kejser, Matt Neerincx Contributors / Reviewers: Peter Carlin, Brandon Berg, Eric Jacobsen, Burzin Patel Background Our initial... Posted Sep 25 2008, 02:20 PM by admin with | with 4 comment(s) Filed under: Database, Performance, SQL Server

• 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

• Tuning the Performance of Backup Compression in SQL Server 2008

  Authors: Mike Ruthruff, Sanjay Mishra Contributor: Steve Schmidt Technical Reviewers: Kevin Farlee, Sunil Agarwal, Burzin Patel, Lindsey Allen, Mark Souza... Posted Apr 21 2008, 03:37 PM by SanjayMishra with | with 16 comment(s) Filed under: Database, Availability, Performance, I/O, SQL Server, backup, Backup Compression

• 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