MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter






























Microsoft SQL Server Articles, Tutorials, News, Tips & Tricks




How to Fix Failed to decrypt protected XML node DTSassword with error 0x8009000B in SSIS

This article describes the steps to fix Failed to decrypt protected XML node DTSassword with error 0x8009000B? error in SSIS.

How to Identify CPU Bottlenecks in SQL Server Using Performance Counters

This article describes How to Identify CPU Bottlenecks in SQL Server Using Performance Counters.

Time required to complete database backup and restore in SQL Server

This article includes the script to identify the time required to complete database backup and restore in SQL Server

How to Export records from SQL Server to Text File using BCP

This article demonstrates How to Export records from SQL Server to Text File using BCP

How to Enable and Disable XP_CMDSHELL using SP_CONFIGURE

In this tip we will take a look at the step to follow to enable or disable XP_CMDSHELL using SP_CONFIGURE system stored procedure.

Update Statistics for all databases in SQL Server

This article mentions Script to Update Statistics for all databases in SQL Server.


Different ways to retrieve System and SQL Server Information

In this article we will take a look at different ways in which a DBA to retrieve System and SQL Server Information.

How to configure SQL Server Agent to Restart SQL Server and SQL Server Agent Services Automatically

In this tip we will take a look at how to configure SQL Server Agent to restart SQL Server & SQL Server Agent Services automatically if they end up stopping unexpectedly.

How to connect to a named instance of SQL Server?

This article explains some of the reason because of which you won’t be able to connect to a named instance of SQL Server and how to resolve them.

Fix Index cannot be reorganized because page level locking is disabled error in SQL Server

This article explains how to fix Index cannot be reorganized because page level locking is disabled error in SQL Server.

Grant Access to DMVs in SQL Server for Non Admin

This article outlines the steps a database administrator can follow to grant access to DMVs in SQL Server for non administrators.

How to Improve SQL Server Replication Performance

This article outlines some of the optimization techniques which a database administrator can follow to improve the performance of SQL Server Replication.

Download SQL Server 2012 System Views Map

Microsoft SQL Server 2012 System Views Map shows the key system views included in SQL Server 2012, and the relationships between them.

Unable to create or open SSIS projects or maintenance plans in SQL Server 2012

This article explains the steps to troubleshoot “Unable to create or open SSIS projects or maintenance plans in SQL Server 2012”.

Troubleshooting The remote procedure call failed. [0x800706be] WMI Error in SQL Server 2012

This article explains the steps to troubleshoot “The remote procedure call failed. [0x800706be] WMI Error in SQL Server 2012”.

Mirrored Database Backup Feature in SQL Server

This article illustrates how to use mirrored database backup feature in SQL Server along with its advantages, disadvantages and best practices.



Share this Article





Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips



Latest SQL Server Tips