Browse by Tags

• Availability
• backup
• Backup Compression
• Configuration
• Consolidation
• Data Compression
• Database Mirroring
• Encryption
• I/O
• Log
• Mirroring
• Partitions
• Performance
• Reporting Services
• Scalability
• Snapshots
• SQL Server
• TDE
• Transaction Log
• Transparent Data Encryption
• Upgrade

• Mirroring a Large Number of Databases in a Single SQL Server Instance

  Authors : Sanjay Mishra, Prem Mehra Technical Reviewers : Lubor Kollar, Michael Thomassy, Lindsey Allen, Mike Ruthruff, Kaloian Manassiev, Kevin Cox, Thomas... Posted Feb 10 2010, 06:14 PM by SanjayMishra with | with 17 comment(s) Filed under: Database, Availability, Database Mirroring, Mirroring, Consolidation

• 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

• Scaling Up Reporting Services 2008 vs. Reporting Services 2005: Lessons Learned

  Author: Carl Rabeler Test Contributers: Jim Carroll, David Raskino, Bill Emmert, Dan Manrique, Jim Dugan Technical Reviewers: Robert Bruckner, David Raskino... Posted Jul 09 2008, 04:24 PM by CarlRabeler with | with 20 comment(s) Filed under: Database, Performance, Scalability, Reporting Services

• 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

• Precision Performance for Microsoft SQL Server using RML Utilities 9.0

  Author: Robert Dorr, Keith Elmore, Lindsey Allen Introduction Have you ever asked the question: “If I upgrade or apply a fix how will it affect my... Posted Feb 01 2008, 11:46 PM by Lindsey.allen with | with 9 comment(s) Filed under: Database, Performance, Upgrade

• Asynchronous Database Mirroring with Log Compression in SQL Server 2008

  Author: Sanjay Mishra Reviewers: Prem Mehra, Mike Ruthruff, Michael Thomassy, Peter Byrne, Kaloian Manassiev, Burzin Patel, Juergen Thomas, Tom Davidson... Posted Dec 17 2007, 06:37 PM by SanjayMishra with | with 9 comment(s) Filed under: Database, Availability

• Database Mirroring Log Compression in SQL Server 2008 Improves Throughput

  Author: Sanjay Mishra Reviewers: Peter Byrne, Don Vilen, Kaloian Manassiev, Burzin Patel, Eric Jacobsen Overview Database mirroring works by transferring... Posted Sep 17 2007, 02:18 AM by SanjayMishra with | with 21 comment(s) Filed under: Database, Availability, Performance

• Distributed Partitioned Views / Federated Databases: Lessons Learned

  Authors: Kevin Cox, Teodoro Marinucci, Silvia Bevilacqua (also thanks to Stefano Stefani, Gargi Sur and Rakesh Gujjula from the SQL Product Team) Updated... Posted Sep 11 2007, 07:51 PM by admin with | with 3 comment(s) Filed under: Partitions, Database

• Querying a Database Snapshot

  Authors: Sanjay Mishra, Michael Thomassy, Peter Byrne Updated by Denny Lee Database Snapshots ( http://msdn2.microsoft.com/en-us/library/ms175158.aspx... Posted Sep 11 2007, 07:50 PM by admin with | with 4 comment(s) Filed under: Database, Snapshots